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)