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 course is applicable 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.
| 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 | |
|
|
SQL Server T-SQL Training Highlights
| ✔ In-depth Tuning | ✔ HA - DR Issues |
| ✔ 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 |
All Session Are Completely Practical & Real Time
