SQL SERVER Developer Course Contents
Duration: 15 Days
Description: SQL SERVER Developer
- Introduction to SQL SERVER
- SQL SERVER Installation
- Verification of SQL SERVER
- Different Types Of SQL Connectivity
- Database Creation
- Different type of Files in Database
- File group Basics
- Introduction to T-SQL
- Creating Tables
- DML Operations
- Inserting Data
- Updating Data
- Deleting Data
- Introduction to Table Constraints
- NOT NULL Constraint
- Primary Key Constraint
- Foreign Key Constraint
- Default Constraint
- Check Constraint
- Query Optimizer Techniques
- Indexes Concepts
- Non-Clustered Indexes
- Clustered Indexes
- Columnstore Indexes
- Creating View
- Difference between Table and View
- Advantages of View
- Issues with Views
- SCHEMABINDING
- Stored Procedures
- Advantages of Stored Procedures
- System Stored Procedures
- Dynamic SQL
- Different types of Functions
- Scaler Value Functions
- Table Value Functions
- System Functions
- Difference Between Cast () and Convert()
- Usage of Cast() and Convert()
- Joins
- Inner Joins
- Outer Joins
- Introduction to Triggers
- DML Triggers
- DDL Triggers
- Magic Tables
- Cursors
- Transactions
- Explicit Transactions
- Implicit Transactions
- Auto Commit Transactions
- Locking Concepts
- Isolation Levels
- Partition Mechanism
- Row Level Security
- Always on Encryption
- Graph Database
- Hands on Graph Database