In this course you will learn all about Microsoft’s standard Transact-SQL language. Through a blend of hands-on labs and interactive lectures, you will learn about both querying and modifying data in relational databases that are hosted in Microsoft Azure SQL Database.
Target Audience:
Data Analyst
Data Engineer
Data Scientist
Database administrator
Database Developer
After completing this course, you will be able to:
In this course you will learn all about Microsoft’s standard SQL language: Transact-SQL.
Through a blend of hands-on labs and interactive lectures, you will learn about both querying and modifying data in relational databases that are hosted in Microsoft Azure SQL Database.
Target Audience:
Data Analyst
Data Engineer
Data Scientist
Database administrator
Database Developer
After completing this course, you will be able to:
Describe key capabilities and components of SQL Server.
Describe T-SQL, sets, and predicate logic.
Write a single table SELECT statement.
Write a multi-table SELECT statement.
Write SELECT statements with filtering and sorting.
Use built-in functions to returned data values
Create groups of data and aggregate the results
Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE
Write subqueries.
Create and implement views and table-valued functions.
Write queries that use window ranking, offset, and aggregate functions.
Create and implement stored procedures.
Add programming constructs such as variables, conditions, and loops to T-SQL code.
Complete Course Curriculum:
Database Concept
Relational Database Management System (RDBMS)
Normalization
Entity Relationship Diagram
Under the hood of a SQL Server database Engine.
T-SQL Foundation Concepts
Database Objects
Table, Views, Synonyms
Creating Indexes
Altering an Index
Dropping an Index
Index Fragmentation
Using the Database Tuning Advisor
Materialize view
Variables and data types
Assignment expressions
Null handling
Stored Procedures Transact-SQL or T-SQL
Creating and maintaining stored procedures
Variables
Parameters
Error handling
Cursors Basic syntax
Cursor types
Cursor options
User-Defined Functions User-defined
Functions vs. stored procedures
Views and stored procedures
Transactions overview
Triggers, Triggers Types
Complete SQL Query for Developers
Elements of the SELECT statement
Optional clauses
JOINS
UNION queries
GROUP BY queries
Sub-queries
Data Manipulation Statements Insert statements
Update statements
Delete statements
Manipulation over JOINS
Calling a view
Calling Stored Procedures and Functions Calling a procedure for effect versus data
Using parameters
Calling a user-defined function
Task-Oriented Queries Finding un
matched or missing records
Finding duplicates
Calculating running sums
Changing a primary key