1. Introduction
2. SQL
Different roles of SQL
3. Features
Enterprise Data Management
Developer Productivity
Business Intelligence
4. Data types
5. Database
SQL Server System Databases
6.Tables
Keys and Constraints
Relationship between the tables
Types of Relationships
Table Creation
7. Clauses
Select
Distinct
Into
Where
Group By
Having
Order By
8. Joins
Types of joins
9. Views
10. Triggers
The need and the usage
Types of trigger events
11. Cursors
Types of cursors
Drawbacks of Cursors
12. CASE Statements
13. Temporary tables
14. Table variables
Disadvantages of table variable over temporary table
15.Stored Procedure
Benefits of Stored Procedure
16. Functions
User Defined Functions
Split function
17. Locking in SQL server
18. Index
Types
Index Architecture
Index implementations
Index Optimization Tips
19. Query Optimization Tips
20. SQL Syntax
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Control Language (DCL)
2. SQL
Different roles of SQL
3. Features
Enterprise Data Management
Developer Productivity
Business Intelligence
4. Data types
5. Database
SQL Server System Databases
6.Tables
Keys and Constraints
Relationship between the tables
Types of Relationships
Table Creation
7. Clauses
Select
Distinct
Into
Where
Group By
Having
Order By
8. Joins
Types of joins
9. Views
10. Triggers
The need and the usage
Types of trigger events
11. Cursors
Types of cursors
Drawbacks of Cursors
12. CASE Statements
13. Temporary tables
14. Table variables
Disadvantages of table variable over temporary table
15.Stored Procedure
Benefits of Stored Procedure
16. Functions
User Defined Functions
Split function
17. Locking in SQL server
18. Index
Types
Index Architecture
Index implementations
Index Optimization Tips
19. Query Optimization Tips
20. SQL Syntax
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Control Language (DCL)
0 comments:
Post a Comment