Curriculum
- 5 Sections
- 53 Lessons
- 4 Weeks
Expand all sectionsCollapse all sections
- Introduction To SQL Server5
- TSQL (Transact-Structured Query Language)14
- 2.1Introduction To TSQL
- 2.2· Data Definition Language (DDL)
- 2.3· Data Manipulation Language (DML)
- 2.4· Data Query Language (DQL)
- 2.5· Database
- 2.6· Creating Database
- 2.7· Altering Database
- 2.8· Deleting Database
- 2.9· Constrains’
- 2.10· Primary Key and Referential Integrity or foreign key constraints
- 2.11· Data Types In TSQL
- 2.12· Table
- 2.13· Altering Table
- 2.14· Deleting Table
- Data Manipulation Language8
- Data Query Language (DQL)9
- Built In Functions17
- 5.1· Aggregate Functions
- 5.2· Group By and Having Clauses
- 5.3· Over(partition by …) Clause
- 5.4· Ranking Functions
- 5.5· Common Table Expressions (CTE)
- 5.6Top n Clause
- 5.7SQL Operators’
- 5.8Sub queries
- 5.9Set Operators
- 5.10Joins
- 5.11Indexes
- 5.12Views
- 5.13TSQL Programming
- 5.14Cursors
- 5.15Stored Procedures
- 5.16User Defined Functions
- 5.17Triggers
User Defined Functions
Prev