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 (0-2 yrs) |
SQL Dev (2+ yrs) |
SQL Dev (2.5+ yrs) |
Course Duration | 4 Weeks | 5 Weeks | 6 Weeks |
Course Content | Chapters 1 to 20 | Chapters 1 to 25 | Chapters 1 to 30 |
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 | ❌ | ❌ | ✔ |
Total Course Fee* | INR 6000 USD 81 |
INR 9000 USD 122 |
INR 13000 USD 176 |
Trainer: Mr. Sai Phanindra T
All Session Are Completely Practical & Real Time
SQL Server & T-SQL Schedules [Chapters 1 to 20] | |||
S No | Timings (IST) | Start Date | |
---|---|---|---|
Regular Schedules [Mon - Fri] | |||
1 | 6 AM - 7 AM | May 24th | Register |
2 | 8 AM - 9 AM | July 5th | Register |
3 | 6 PM - 7 PM | June 27th | Register |
4 | 8 PM - 9 PM | June 7th | Register |
5 | 9 PM - 10 PM | June 13th | Register |
Query Tuning & Azure SQL Schedules [Chapters 21 to 30] | ||||
S No | Timings (IST) | Start Date | ||
---|---|---|---|---|
Weekend Schedules [Sat & Sun] | ||||
6 | 6 AM - 8 AM | May 21st | Register | |
7 | 8 PM - 10 PM | June 11th | 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 |
Above Course Curriculum is applicable for registrations from Dec 2nd, 2020