This impeccable Microsoft SQL Server Training Course is exclusively designed for aspiring Data Analysts, Business Analysts, Data Scientists, MSBI / Power BI Engineers and SQL Database Developers. This SQL Server and T-SQL Training Course is designed for both starters as well as for experienced professionals. This course includes SQL Basics, T-SQL Queries, Query Writing and Query Understanding required for Data Analysts and Business Analysts. This course also includes Programming, Tuning and Azure SQL (Cloud) concepts required for BI Developers and SQL Database Developers. One Real-time project is included in this SQL Server and T-SQL Training Course addressing Basic to Advanced SQL Queries, Detailed Database Design, Complex Joins, Common Table Expressions (CTEs), Complex Stored Procedures, Triggers, Remote Joins, Transactions and Query Tuning with XML, BLOB and JSON Data Sources with complete guidance to MCSA 70-761 and MCSA 70-762 Microsoft Certification Exams.
Practice Material, Certification, Resume & Interview Guidance are included in this SQL Server T-SQL Course.
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
Applicable For | SQL Dev | SQL Dev + Azure Dev |
SQL Dev + Azure Dev + Azure DevOps |
Course Duration | 4 Weeks | 6 Weeks | 10 Weeks |
Course Content | Chapters 1 to 20 | Chapters 1 to 30 | Chapters 1 to 48 |
Completely Real-time, Practical | ✔ | ✔ | ✔ |
Mock Interviews, Case Studies | ✔ | ✔ | ✔ |
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] | ✔ | ✔ | ✔ |
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 | ❌ | ✔ | ✔ |
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 6000 USD 81 |
INR 13000 USD 176 |
INR 25000 USD 338 |
Trainer: Mr. Sai Phanindra T
All Session Are Completely Practical & Real Time
Schedules for SQL Server & T-SQL | |||
S No | Timings (IST) | Start Date | |
---|---|---|---|
Regular Schedules [Mon - Fri] | |||
1 | 6 AM - 7 AM | Mar 23rd | Register |
2 | 8 AM - 9 AM | Apr 6th | Register |
3 | 6 PM - 7 PM | Mar 15th | Register |
4 | 8 PM - 9 PM | Mar 3rd | Register |
5 | 9 PM - 10 PM | Apr 19th | Register |
Azure DevOps Training Schedules | ||||
S No | Timings (IST) | Start Date | ||
---|---|---|---|---|
Regular Schedules [Mon - Fri] | ||||
1 | 9 PM - 10 PM | May 18th | Register | |
Weekend Schedules [Sat & Sun] | ||||
2 | 6 AM - 8 AM | Mar 13th | Register |
SQL Server T-SQL 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