Features of SQL Azure Development training
- Complete Course Material with Real Time Projects
- Real time Experienced Trainers
- Flexible Timings
- Lab facility
- System Based Training
Azure SQL vs On-Premise SQL Server
- Users
- Groups
- Data Masking
- Resource
- Resource Group
- Azure SQL Server
- Access Control
Azure SQL DB
- Data Masking
- T-SQL
- Data Types
- Table Type
- Operators
- DML - SELECT, UPDATE, DELETE, MERGE, INSERT
- DDL - CREATE, ALTER, TRUNCATE
- Joins
- Null Handling
- Aggregations (Sum, Min, Max, Count)
- Rank, Row_Number, Dense_Rank
- Constraints
- Temporary Table
- Global Temp Table
- Index
- Clustered
- Non Clustered
- Covering
- ColumnStore
- Execution Plans
- Defragmentation
- Logical Reads
- Physical Reads
- IO vs CPU time
- Views
- Isolation Levels
- Procedure
- 5 Use Cases
Database Project
- PreDeployment
- PostDeployment
- Schema Compare
Git Integration,Interview Questions