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 |
Course Duration | 2 Weeks | 6 Weeks | 10 Weeks |
Course Content | Chapters 21 to 30 | Chapters 1 to 30 | Chapters 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
Azure SQL Dev Training Highlights
✔ Queries, Joins | ✔ Dynamic SQL |
✔ Query Tuning | ✔ CTEs, TVPs |
✔ Excel Imports | ✔ In-Memory Tables |
✔ Excel Pivots | ✔ Azure SQL Concepts |
✔ Complex joins | ✔ Azure DB Migrations |
Ch 1: SQL SERVER INTRODUCTION
|
Ch 7: JOINS, T-SQL Queries : Level 1
|
Ch 13: STORED PROCEDURES Level 2
|
Ch 2: SQL SERVER INSTALLATIONS
|
Ch 8: Group By, T-SQL Queries Level 2
|
Ch 14: STORED PROCEDURES - Level 3
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 9: JOINS, T-SQL QUERIES Level 3
|
Ch 15: STORED PROCEDURES - Level 4
|
Ch 4: SQL BASICS - 2
|
Ch 10: View, SPs, Function Basics
|
Ch 16: XML,BLOB,FUNCTIONS Level 2
|
Ch 5: SQL Basics - 3, T-SQL INTRO
|
Ch 11: Triggers & Transactions
|
Ch 17: Server, DB Architecture
|
Ch 6 : CONSTRAINTS,INDEXES BASICS
|
Ch 12 : ER MODELS, NORMAL FORMS
|
Ch 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 B, C |
Module III: Azure SQL Database Development & MCSA - 70 762Applicable for Plan C |
Ch 21: QUERY TUNING 1 - AUDITS, INDEXES
|
Ch 26: AZURE CLOUD INTRO, CONFIGURATION
|
Ch 22: QUERY TUNING 2 - PARTITIONS, INDEX MANAGEMENT
|
Ch 27 : DTU, ELASITC QUERIES, MIGRATIONS
|
Ch 23: QUERY TUNING 3 - TUNING TOOLS, LOCK MANAGEMENT
|
Ch 28 : AZURE SQL DATABASE TUNING
|
Ch 24: QUERY TUNING 4 - FULL TEXT SEARCH, MOT TABLES
|
Ch 29 : XEL GRAPHS, STRETCH DATABASES
|
Ch 25 : MCSA 70 761 Exam Pattern, Examples, Guidance |
Ch 30 : MCSA - 70 762 Exam Pattern, Examples, Guidance |
Module I: Azure Funda & DevOps Basics |
Module II: Azure DevOps Service - 1 |
Azure DevOps Service - 2
|
Ch 1. Azure Fundamentals
|
Ch 7: Organizations & Projects
|
Ch 13: Azure Functions, App Service, Alerts
|
Ch 2. Azure Services, Configurations
|
Ch 8: Azure Boards
|
Ch 14: Azure DevOps Resources in Portal
|
Ch 3. Azure Active Directory, Monitoring
|
Ch 9: Azure Repos
|
Ch 15: Azure DevOps Strarter, App Insights
|
Ch 4. SDLC, Dev & Operations, DevOps
|
Ch 10: Azure Pipelines For CI/CD - 1
|
Ch 16: Power Shell & Azure DevOps
|
Ch 5. DevOps Tools, Git & GitHub
|
Ch 11: Azure Pipelines For CI/CD - 2
|
Ch 17: DevOps Server - Configurations
|
Ch 6. Docker, Kubernetes, AzureDevOps
|
Ch 12: Azure Testing & Artefacts
|
Ch 18: DevOps Server & Visual Tools
|
Above Course Curriculum is applicable for registrations from Dec 2nd, 2020