| |
|
Chapter 1
| |
| What is SQL Server |
| Architecture of SQL Server |
| SQL Server Editions |
| Installing SQL Server |
| Sql Server Instances |
| Internals of Sql Server Database |
| MDF & LDF Files |
| Introducing SQL Server Management Studio |
| Creating a Database |
|
|
Chapter 2
| |
| Data Types |
| Designing Table Model |
| DDL Commands |
| Creating Tables |
| Alteration of Table Design |
| Add New Column, Drop Column |
| Drop Table |
|
|
Chapter 3
| |
| DML STATEMENTS |
| INSERT,UPDATE,DELETE,TRUNCATE |
| SELECT CLAUSE |
| WHERE CLAUSE |
| Mathematical Operator |
| Conditional Operators |
| AND , OR Operators |
| Like Operators |
| ORDER BY Clause |
| TOP N and TOP N PERCENT |
| Aggregate Functions |
| String Functions |
| Date Functions |
| GROUP BY and HAVING |
|
|
Chapter 4
| |
| What is Constraint |
| Adding constraints to columns in Tables |
| Primary Key Constraints |
| Unique Constraints |
| Check Constraints |
| Default Constraints |
| Alter Constraints |
| Drop Constraints in Tables |
| Introduction to RDBMS |
| Normalization |
| Denormalization |
| Advantages of Relational Model |
| Master Table & Child Tables |
| Introduction to Foreign Key |
| Creating Relations between tables |
|
|
Chapter 5
| |
| Introduction to Joins |
| Types of Joins |
| Inner Join |
| Left Outer Join |
| Right Outer Join |
| Full Outer Join |
| Writing Joins queries |
| Self-Join, Cross Join |
| APPLYING CLAUSES USING JOINS |
|