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 | SQL Dev + Azure Dev |
SQL Dev + Azure Dev + Azure DevOps |
No of Videos | Videos 21 to 30 | Videos 1 to 30 | Videos 1 to 48 |
Completely Real-time, Practical | ✔ | ✔ | ✔ |
Mock Interviews, Case Studies | ✔ | ✔ | ✔ |
In-depth Query Tuning | ✔ | ✔ | ✔ |
Performance Tools, Locks | ✔ | ✔ | ✔ |
Complex SPs, MCSA - 70 761 | ✔ | ✔ | ✔ |
Azure SQL Database (Cloud) | ✔ | ✔ | ✔ |
Azure SQL Database Migrations | ✔ | ✔ | ✔ |
Stretch Databases, MCSA 70-762 | ✔ | ✔ | ✔ |
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] | ❌ | ✔ | ✔ |
Azure DevOps Benefits | ❌ | ❌ | ✔ |
SDLC, Dev & Operations, DevOps | ❌ | ❌ | ✔ |
DevOps Tools, Git & GitHub | ❌ | ❌ | ✔ |
Docker, Kubernetes, AzureDevOps | ❌ | ❌ | ✔ |
Azure Boards, Azure Repos | ❌ | ❌ | ✔ |
Azure Testing, Azure Artifacts | ❌ | ❌ | ✔ |
Azure Pipelines (CI, CD) | ❌ | ❌ | ✔ |
Total Course Fee* | INR 8000 USD 109 |
INR 13000 USD 176 |
INR 25000 USD 338 |
Trainer: Mr. Sai Phanindra T
All Session Are Completely Practical & Real Time
Register today for Azure SQL Database Video Training
All Trainings are completely Practical, Real-Time. Register Today
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 |
Real-time, Practical Training Videos, accessible 24x7. Study, Practice Material and Lab Work for every video. Trainer available for doubts clarifications and support.
Video 1: SQL SERVER INTRODUCTION
|
Video 7: JOINS, T-SQL Queries : Level 1
|
Video 13: STORED PROCEDURES Level 2
|
Video 2: SQL SERVER INSTALLATIONS
|
Video 8: Group By, T-SQL Queries Level 2
|
Video 14: STORED PROCEDURES - Level 3
|
Video 3: SSMS Tool, SQL BASICS - 1
|
Video 9: JOINS, T-SQL QUERIES Level 3
|
Video 15: STORED PROCEDURES - Level 4
|
Video 4: SQL BASICS - 2
|
Video 10: View, SPs, Function Basics
|
Video 16: XML,BLOB,FUNCTIONS Level 2
|
Video 5: SQL Basics - 3, T-SQL INTRO
|
Video 11: Triggers & Transactions
|
Video 17: Server, DB Architecture
|
Video 6 : CONSTRAINTS,INDEXES BASICS
|
Video 12 : ER MODELS, NORMAL FORMS
|
Video 18 - 20: REAL-TIME PROJECT (BANKING) Includes 2500 Lines of Code (SOLVED). Phase 1: DATABASE DESIGN
|
Real-time Case Study - 1 (Sales & Retail) Objective : DB Design, Table Design, Relations Involves Purchases, Products, Customers and Time Data with Various Data Types. |
Real-time Case Study - 2 (Sales & Retail) Objective : Query Writing, Excel Integration Excel Pivot Tables, Pivot Charts, Data Formatting, ODC Connections & Labelling |
Module II: Performance Tuning & MCSA - 70 761Applicable for Plans A, B, C |
Module III: Azure SQL Database Development & MCSA - 70 762Applicable for Plan C |
Video 21: QUERY TUNING 1 - AUDITS, INDEXES
|
Video 26: AZURE CLOUD INTRO, CONFIGURATION
|
Video 22: QUERY TUNING 2 - PARTITIONS, INDEX MANAGEMENT
|
Video 27 : DTU, ELASITC QUERIES, MIGRATIONS
|
Video 23: QUERY TUNING 3 - TUNING TOOLS, LOCK MANAGEMENT
|
Video 28 : AZURE SQL DATABASE TUNING
|
Video 24: QUERY TUNING 4 - FULL TEXT SEARCH, MOT TABLES
|
Video 29 : XEL GRAPHS, STRETCH DATABASES
|
Video 25 : MCSA 70 761 Exam Pattern, Examples, Guidance |
Video 30 : MCSA - 70 762 Exam Pattern, Examples, Guidance |
Module I: Azure Funda & DevOps Basics |
Module II: Azure DevOps Service - 1 |
Azure DevOps Service - 2
|
Video 1. Azure Fundamentals
|
Video 7: Organizations & Projects
|
Video 13: Azure Functions, App Service, Alerts
|
Video 2. Azure Services, Configurations
|
Video 8: Azure Boards
|
Video 14: Azure DevOps Resources in Portal
|
Video 3. Azure Active Directory, Monitoring
|
Video 9: Azure Repos
|
Video 15: Azure DevOps Strarter, App Insights
|
Video 4. SDLC, Dev & Operations, DevOps
|
Video 10: Azure Pipelines For CI/CD - 1
|
Video 16: Power Shell & Azure DevOps
|
Video 5. DevOps Tools, Git & GitHub
|
Video 11: Azure Pipelines For CI/CD - 2
|
Video 17: DevOps Server - Configurations
|
Video 6. Docker, Kubernetes, AzureDevOps
|
Video 12: Azure Testing & Artefacts
|
Video 18: DevOps Server & Visual Tools
|