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 | 8 Weeks |
Course Content | Chapters 1 to 20 | Chapters 1 to 26 | Chapters 1 to 38 |
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 10000 USD 136 |
INR 19000 USD 257 |
Trainer: Mr. Sai Phanindra (17+ Yrs of Experience)
All Session Are Completely Practical & Real Time
Trainer : Mr. Sai Phanindra (17+ Yrs of Experience)
SQL Server & T-SQL Schedules [Chapters 1 to 20] | |||
S No | Timings (IST) | Start Date | |
---|---|---|---|
Regular Schedules [Mon - Fri] | |||
1 | 6 AM - 7 AM | Aug 18th | Register |
2 | 8 AM - 9 AM | Sep 6th | Register |
3 | 10 AM - 11 AM | Nov 2nd | Register |
4 | 6 PM - 7 PM | Aug 22nd | Register |
5 | 8 PM - 9 PM | Aug 30th | Register |
6 | 9 PM - 10 PM | Oct 3rd | Register |
Query Tuning Schedules [Chapters 21 to 26] | ||||
S No | Timings (IST) | Start Date | ||
---|---|---|---|---|
Weekend Schedules [Sat & Sun] | ||||
7 | 7:30 AM - 9 AM | Oct 8th | Register | |
8 | 7:30 PM - 9 PM | Sep 3rd | Register |
Azure SQL Dev Schedules [Chapters 27 to 38] | ||||
S No | Timings (IST) | Start Date | ||
---|---|---|---|---|
Weekend Schedules [Sat & Sun] | ||||
9 | 7:30 AM - 9 AM | Oct 22nd | Register | |
10 | 7:30 PM - 9 PM | Sep 17th | 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 |
Ch 1: Basic Tuning & Auditting
|
Ch 3: Statistics and Partitions FTS
|
Ch 5: Tuning Tools & Query Optimization
|
Ch 2: Indexes & Query Tuning
|
Ch 4: Full Text Search Indexes, Tables
|
Ch 6: Locks & Isolation Levels
|
Azure Fundamentals |
Azure SQL Dev |
Ch 1: Cloud Introduction & Azure
|
Ch 7: Azure SQL Server, Database
|
Ch 2: Azure Cloud Concepts
|
Ch 8: TSQL Differences with Azure
|
Ch 3: Azure Storage & Explorer Tool
|
Ch 9: Azure SQL DB Migration
|
Ch 4: Azure Active Directory & Pricing
|
Ch 10: AZURE SQL DATABASE TUNING
|
Ch 5: Azure Monitor & Metrics
|
Ch 11: Azure SQL Server in VM
|
Ch 6: Azure Vitual Machine (VM)
|
Ch 12: Real-time Project @ Banking
|
Above Course Curriculum is applicable for registrations from Aug 1st, 2022