SQL Server Course Contents

1. SQL Overview

2. RDBMS Concepts

3. The Foundation Statements of T-SQL

4. Started with SELECT Statement

5. Adding Data with the INSERT Statement

6. SQL Commands

  • DDL
  • DML
  • DCL
  • DQL

7. SQL Data Types

8. Basic Commands

  • Create Statement
  • Create Database
  • Create Table
  • Alter Statement
  • Alter Database
  • Alter Table
  • Drop Statement
  • Delete Statement
  • Update Statement

9. SQL Operators

  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators

10. Normalization

  • 1NF
  • 2NF
  • 3NF

11. JOINS

  • INNER Join
  • LEFT Join
  • RIGHT Join
  • FULL Join
  • SELF Join
  • CARTESIAN Join

12. SQL Constraints

  • PRIMARY KEY Constraints
  • FOREIGN KEY Constraints
  • UNIQUE Constraints
  • CHECK Constraints
  • DEFAULT Constraints
  • NULL Constraints

13. SQL Clauses

  • WHERE Clause
  • ORDER BY Clause
  • GROUP BY Clause
  • HAVING Clause
  • TOP Clause
  • LIKE Clause
  • UNION Clause
  • UNION ALL Clause

14. Adding More to Our Queries

  • What Is a Sub-Query?
  • Building a Nested Sub-Query
  • Correlated Sub-Queries
  • How Correlated Sub-Queries Work Correlated Sub-Queries in the WHERE Clause

15. The EXISTS Operator

16. Using EXISTS in Other Ways

17. System Defined Functions:

  • AVERAGE
  • COUNT
  • MAX
  • MIN
  • SUM
  • SQRT
  • RAND
  • CONCAT
  • GROUP BY
  • HAVING
  • TRIM
  • LENGTH
  • UPPER
  • LOWER
  • REPLACE
  • REVERSE
  • SUBSTRING
  • STUFF
  • DATEADD(day,10,@date)
  • DATEDIFF (day,exp1,exp2)
  • DATEPART(day,exp)
  • GETDATE
  • CONVERT
  • FORMAT
  • ISNULL
  • Top

18. UDF (User Defined Functions)

  • Scalar Functions
  • Table-valued Functions

19. Understanding Indexes

  • How Data Is Accessed in SQL Server
  • Creating, Altering, and Dropping Indexes
  • The CREATE INDEX Statement

20. Views

  • Simple Views
  • Views as Filters
  • More Complex Views
  • Dropping Views

21. Stored Procedures

  • Basic Syntax
  • Changing Stored Procedures with ALTER
  • Dropping Stored Procedures
  • Handling Errors

22. Transactions

  • Properties of Transactions
  • Commit
  • Rollback
  • Save point

23. Using Sequences

  • Auto Increment (Identity Field)

24. Triggers

  • Auto Generated Tables (INSERTED / DELETED)

Map Location

Quick Enquiry