Complete Real-time and Practical Azure SQL Database Training with Real-time Scenarios. This course includes complete practical approach to every detail of Azure SQL Database Development activities including On-premise to Azure Azure Database Migrations, Schema Migrations, Assessments, In-depth Query Tuning, Stretch Databases, Azure Shell, Power Shell, In - Memory Tables, Azure Search, Sharding, Application Connections and Azure CLI. This Azure SQL Database course also includes One Real-time Project on On-Premise to Azure Migration using DMA Tools.
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
Applicable For | Azure SQL Dev | Query Tuning + Azure SQL |
SQL Dev + Query Tuning + Azure SQL |
No of Videos | 4 Videos | 10 Videos | 30 Videos |
Completely Real-time, Practical | ✔ | ✔ | ✔ |
Mock Interviews, Case Studies | ✔ | ✔ | ✔ |
Azure SQL Database (Cloud) | ✔ | ✔ | ✔ |
Azure SQL Database Migrations | ✔ | ✔ | ✔ |
Stretch Databases, MCSA 70-762 | ✔ | ✔ | ✔ |
In-depth Query Tuning | ❌ | ✔ | ✔ |
Performance Tools, Locks | ❌ | ✔ | ✔ |
Complex SPs in T-SQL | ❌ | ✔ | ✔ |
SQL Basics and Query Writing | ❌ | ❌ | ✔ |
SQL DB Design, Table Design | ❌ | ❌ | ✔ |
Normal Forms, Joins, Queries | ❌ | ❌ | ✔ |
Indexes, Stored Procedures | ❌ | ❌ | ✔ |
Excel Integration, Pivot Charts | ❌ | ❌ | ✔ |
Advanced Stored Procedures | ❌ | ❌ | ✔ |
CTE, PIVOT, XML and BLOB Data | ❌ | ❌ | ✔ |
Real-time Project [Banking] | ❌ | ✔ | ✔ |
Total Course Fee* | INR 6000 USD 80 |
INR 11000 USD 140 |
INR 18000 USD 250 |
Trainer: Mr. Sai Phanindra T
All Session Are Completely Practical & Real Time
Azure SQL Database - TRAINING HIGHLIGHTS :
✔ In-depth Tuning | ✔ Migration Issues | ✔ In-Memory Data |
✔ Schema Migrations | ✔ Stretch Database | ✔ DB Documenation |
✔ Memory Tables | ✔ Temporal Tables | ✔ App Connections |
✔ CTEs and TVPs | ✔ Excel Imports | ✔ Excel Pivots |
✔ BLOB Storage | ✔ Power Shell | ✔ Azure CLI |
Ch 1: DATABASE INTRODUCTION
|
Ch 7: JOINS & LINKED SERVERS
|
Ch 13: STORED PROCEDURES & TVP
|
Ch 2: SQL SERVER INSTALLATIONS
|
Ch 8: VIEW, SPs, FUNCTIONS BASICS
|
Ch 14: STORED PROCEDURES & Triggers
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 9: Triggers & Transactions
|
Ch 15: STORED PROCEDURES & Cursors
|
Ch 4: SQL BASICS - 2
|
Ch 10: DB Architecture & Group By
|
Ch 16: STORED PROCEDURES & CTEs
|
Ch 5: SQL Basics - 3, T-SQL INTRO
|
Ch 11: TSQL Queries: Group By, Joins
|
Ch 17: FUNCTIONS Level 2, XML & JSON
|
Ch 6 : CONSTRAINTS, INDEXES
|
Ch 12 : ER MODELS, NORMAL FORMS
|
Ch 18 - 20: REAL-TIME PROJECT (BANKING) Includes 2500 Lines of Code (SOLVED). Phase 1: DATABASE DESIGN
|
Case Study 1 - For Database, Table Design (Constraints, Keys) |
Case Study 2 - For Query Writing + Window Functions (Rank, RowNumber) |
Module II: Performance TuningApplicable for Plans B, C |
Module III: Azure SQL Database DevelopmentApplicable for Plan C |
Ch 21: Tuning 1 - Audits, Indexes
|
Ch 26: CLOUD, AZURE CONFIG
|
Ch 22: Tuning 2: Index Management
|
Ch 27: AZURE SQL SERVER CONFIG
|
Ch 23: Tuning 3 - Tuning Tools
|
Ch 28: ELASTIC DTUs, DB MIGRATION
|
Ch 24: Tuning 4 - Lock Management
|
Ch 29: AZURE SQL DATABASE TUNING
|
Ch 25: FULL TEXT SEARCH, MOT
|
Ch 30: Real-time Project - 2
|