Rating: 5 · 7452 votes-
Introduction to SQL
-
Various types of databases
-
Introduction to Structured Query Language
-
Distinction between client server and file server databases
-
Understanding SQL Server Management Studio
-
SQL Table basics
-
Data types and functions
-
Transaction-SQL
-
Authentication for Windows
-
Data control language
-
The identification of the keywords in T-SQL, such as Drop Table
-
-
Database Normalization and Entity Relationship Model
-
SQL Operators
-
Working with SQL: Join, Tables, and Variables
-
Deep Dive into SQL Functions
-
Working with Subqueries
-
SQL Views, Functions, and Stored Procedures
-
Deep Dive into User defined Functions
-
SQL Optimization and Performance
-
Advanced Topics
-
Managing Database Concurrency
-
Practice Session
-
Creating Transact-SQL queries
-
Querying multiple tables using joins
-
Implementing functions and aggregating data
-
Modifying data
-
Determining the results of DDL statements on supplied tables and data
-
Constructing DML statements using the output statement
-
Querying data using subqueries and APPLY
-
Querying data using table expressions
-
Grouping and pivoting data using queries
-
Querying temporal data and non-relational data
-
Constructing recursive table expressions to meet business requirements
-
Using windowing functions to group
-
Rank the results of a query
-
Creating database programmability objects by using T-SQL
-
Implementing error handling and transactions
-
Implementing transaction control in conjunction with error handling in stored procedures
-
Implementing data types and NULL
-
Designing and implementing relational database schema
-
Designing and implementing indexes
-
Learning to compare between indexed and included columns
-
Implementing clustered index
-
Designing and deploying views
-
Column store views
-
Explaining foreign key constraints
-
Using T-SQL statements
-
Usage of Data Manipulation Language (DML)
-
Designing the components of stored procedures
-
Implementing input and output parameters
-
Applying error handling
-
Executing control logic in stored procedures
-
Designing trigger logic, DDL triggers, etc.
-
Accuracy of statistics
-
Formulating statistics maintenance tasks
-
Dynamic management objects management
-
Identifying missing indexes
-
Examining and troubleshooting query plan
-
Consolidating the overlapping indexes
-
The performance management of database instances
-
SQL server performance monitoring
-
-
Microsoft Courses: Study Material
