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) |
No Of Videos | 20 Videos | 25 Videos | 30 Videos |
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 |
Video 1: SQL SERVER INTRODUCTION
|
Video 7: JOINS, T-SQL Queries : Level 1
|
Video 13: STORED PROCEDURES Level 2
|
Video 2: SQL SERVER INSTALLATIONS
|
Video 8: Group By, T-SQL Queries Level 2
|
Video 14: STORED PROCEDURES - Level 3
|
Video 3: SSMS Tool, SQL BASICS - 1
|
Video 9: JOINS, T-SQL QUERIES Level 3
|
Video 15: STORED PROCEDURES - Level 4
|
Video 4: SQL BASICS - 2
|
Video 10: View, SPs, Function Basics
|
Video 16: XML,BLOB,FUNCTIONS Level 2
|
Video 5: SQL Basics - 3, T-SQL INTRO
|
Video 11: Triggers & Transactions
|
Video 17: Server, DB Architecture
|
Video 6 : CONSTRAINTS,INDEXES BASICS
|
Video 12 : ER MODELS, NORMAL FORMS
|
Video 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 |
Video 21: QUERY TUNING 1 - AUDITS, INDEXES
|
Video 26: AZURE CLOUD INTRO, CONFIGURATION
|
Video 22: QUERY TUNING 2 - PARTITIONS, INDEX MANAGEMENT
|
Video 27 : DTU, ELASITC QUERIES, MIGRATIONS
|
Video 23: QUERY TUNING 3 - TUNING TOOLS, LOCK MANAGEMENT
|
Video 28 : AZURE SQL DATABASE TUNING
|
Video 24: QUERY TUNING 4 - FULL TEXT SEARCH, MOT TABLES
|
Video 29 : XEL GRAPHS, STRETCH DATABASES
|
Video 25 : MCSA 70 761 Exam Pattern, Examples, Guidance |
Video 30 : MCSA - 70 762 Exam Pattern, Examples, Guidance |
Above Course Curriculum is applicable for registrations from Feb 9th, 2020