Close

SQL

SQL Server runs on T-SQL (Transact -SQL), a set of programming extensions from Sybase and Microsoft that add several features to standard SQL, including transaction control, exception and error handling, row processing, and declared variables.


  • Enhanced in-memory performance provides up to 30x faster transactions, more than 100x faster queries than disk-based relational databases and real-time operational analytics.
  • New Always Encrypted technology helps protect your data at rest and in motion, on-premises and in the cloud, with master keys sitting with the application, without application changes.

Length : 30 Hours

SQL

1. Introduction Database

2. Database Models

3. SQL Statements

4. Operators

5. SQL Functions

6. Clauses

7. Constraints

8. Joins

9. Creating duplicate tables

10. Set Operators

11. Subqueries

12. Views

TSQL

Database Objects

Procedures

Cursors

Triggers

Transactions

Indexes