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 Queries, Transactions and Query Tuning Operations 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 | PLAN D | |
---|---|---|---|---|
Applicable For | Data Analysts | SQL Dev (0-1 yrs) | SQL Dev (1-2 yrs) | SQL Dev (2+ yrs) |
Course Duration | 2.5 Weeks | 3.5 Weeks | 4.5 Weeks | 5.5 Weeks |
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 | ![]() |
![]() |
![]() |
![]() |
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 | ![]() |
![]() |
![]() |
![]() |
DB Deployments, MCSA 70-762 | ![]() |
![]() |
![]() |
![]() |
Total Course Fee | INR 5000/- USD 75 |
INR 7000/- USD 100 |
INR 10000/- USD 150 |
INR 14000/- USD 200 |
Schedule (IST) | Start Date | ||
---|---|---|---|
1 | 6:30 AM to 7:30 AM | March 6th | Register |
2 | 10:15 AM to 11:15 AM | Mar 13th | Register |
3 | 11:30 AM to 12:30 PM | Feb 26th | Register |
4 | 7:30 PM to 8:30 PM | Feb 19th | Register |
SQL Server T-SQL Training Highlights
✔ Queries, Joins | ✔ Dynamic SQL |
✔ Query Tuning | ✔ CTEs, TVPs |
✔ Excel Imports | ✔ In-Memory Tables |
✔ Excel Pivot Charts | ✔ Azure SQL Migration |
✔ Complex joins | ✔ Azure Elastic Queries |
✔ Linked Servers | ✔ Azure DB Tuning |
Module I: SQL Basics, SQL Server ConceptsApplicable for Plan A, B, C, D |
Module II: T-SQL Queries & Programming BasicsApplicable for Plan A, B, C, D |
Module III: T-SQL Programming & Real-time ProjectApplicable for Plan B, C, D |
DAY 1: INTRO, INSTALLATION BASICS
|
DAY 7: JOINS AND QUERIES - Level 1
|
DAY 13: STORED PROCEDURES - Level 2
|
DAY 2: INSTALLATIONS & FIREWALL
|
DAY 8: SUB QUERIES, JOINS - Level 2
|
DAY 14: STORED PROCEDURES - Level 3
|
DAY 3: BASIC SQL QUERIES - Level 1
|
DAY 9: INDEXES, VIEWS QUERIES
|
DAY 15: Constraints, Functions - Level 2
|
DAY 4: BASIC SQL QUERIES - Level 2
|
DAY 10: Functions, Procedures - 1
|
DAY 16 - 18: REAL-TIME PROJECT
This
SQL Server
T-SQL Course
includes a Real-world BANKING Project.
The project includes about 2500 Lines of Code with basic to complex Stored Procedures,
Join Queries, Triggers, Transactions and Lock Hints.
(COMPLETELY SOLVED).
Phase 1: DATABASE DESIGN
Phase 2: QUERY DESIGN
Phase 3: PROGRAMMING
|
DAY 5: SERVER, DB ARCHITECTURE
|
DAY 11: TRIGGERS, TRANSACTIONS
|
|
DAY 6 : CONSTRAINTS Level 1
|
DAY 12: REMOTE JOINS, EXCEL PIVOT CHARTS
|
Module IV: Performance Tuning & MCSA - 70 761Applicable for Plan C, D |
Module V: Azure SQL Database Development & MCSA - 70 762Applicable for Plan D |
DAY 19: QUERY TUNING 1 - QUERY AUDITS, PARTITIONS
|
Day 24: AZURE CLOUD & AZURE SQL DATABASE
|
Day 20: QUERY TUNING 2 - FULL TEXT SEARCH, TABLE TYPES
|
DAY 25: DTU ARCHITECTURE, ELASTIC QUERIES
|
Day 21: QUERY TUNING 3 - INDEX MANAGEMENT, LOCKS
|
DAY 26 : AZURE SQL DB MIGRATIONS, AZURE DATA STUDIO
|
Day 22: QUERY TUNING 4 - TUNING TOOLS, PERFMON
|
DAY 27: Azure SQL DATABASE TUNING, AZURE SEARCH
|
DAY 23: EXECUTION PLAN ANALYSIS and RESOURCES
|
DAY 28: AZURE SQL DATABASE VERSUS ON-PREMISE
|
Real-time Case Study for Performance TuningThis Real-time Case Study includes:
|
DAY 29: STRETCH DATABASES, MANAGED INSTANCES
|
MCSA - 70 761 Exam : Complete Guidance & Material |
MCSA - 70 762 Exam : Complete Guidance & Material |
Above Course Curriculum is applicable for registrations from Jan 26th, 2019