This impeccable Microsoft SQL Server Training Course is exclusively designed for aspiring Data Analysts, Business Analysts, Data Scientists, MSBI, Power BI, Data Engineers and SQL Database Developers. This Database Course is applicable for both starters as well as for experienced professionals. Includes required for Data Analysts and Business Analysts.
This course includes SQL Basics, T-SQL Queries, Query Writing, Remote Queries and Normal Forms needs for everyone. This course includes Basic to Advanced Stored Procedures, User Defined Functions (UDFs), Detailed Database Design, Complex Joins, Common Table Expressions (CTEs), Triggers and Transactions for SQL Developers. Also includes Query Tuning Operations with Tuning Tools, Execution Plans, Partitions, Indexes, Statistics, Locks & Isolation Levels, Azure SQL Database Development, Deployments, Cloud Migrations, Azure SQL DB Tuning, Working with XML, BLOB and JSON.
With Concept wise mock tests and Realtime Case Studies we ASSURE you 100% Hands-On Training with detailed explaination of one Realtime Project in a Banking Domain that contains 2000+ Lines of Code involving various phases of Design, Coding, Testing and Deployment which will be surely helpful for your Job Work and Interviews.
Practice Material, Certification, Resume & Interview Guidance are included in this SQL Server T-SQL Course.
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
Applicable For | SQL Server TSQL Queries |
TSQL Queries TSQL Programming |
TSQL Queries TSQL Programming Tuning, AzureSQL Dev |
Course Duration | 3 Weeks | 4 Weeks | 7 Weeks |
Course Content | Ch 1 to 12 | Ch 1 to 20 | Ch 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] | ❌ | ✔ | ✔ |
Query Audits, Query Store | ❌ | ❌ | ✔ |
Indexes & QUery Tuning | ❌ | ❌ | ✔ |
Performance Tools, Locks | ❌ | ❌ | ✔ |
Execution Plans, Query Analysis | ❌ | ❌ | ✔ |
Azure SQL Database (Cloud) | ❌ | ❌ | ✔ |
Azure SQL Database Deployments | ❌ | ❌ | ✔ |
Azure SQL Database Migrations | ❌ | ❌ | ✔ |
Azure SQL Database Tuning | ❌ | ❌ | ✔ |
Total Course Fee* | INR 5000 USD 80 |
INR 8000 USD 100 |
INR 13000 USD 150 |
SQL Server & T-SQL Schedules | |||
S No | Time (IST, Mon - Fri) | Start Date | |
---|---|---|---|
1 | 6 AM - 7 AM | Dec 5th | Register |
2 | 8 AM - 9 AM | Dec 13th | Register |
3 | 6 PM - 7 PM | Jan 3rd | Register |
4 | 8 PM - 9 PM | Jan 22nd | Register |
5 | 9 PM - 10 PM | Dec 19th | 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 |
✔ Complex SPs | ✔ Azure DB Tuning |
✔ Tuning Tools | ✔ Azure DB Deployments |
Ch 1: DATABASE INTRODUCTION
|
Ch 5: SQL Basics - 3, TSQL INTRO
|
Ch 9: Functions, Procedures Basics
|
Ch 2: SQL SERVER INSTALLATION
|
Ch 6: Constraints, Index Basics
|
Ch 10: TRIGGERS & TRANSACTIONS
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 7: Joins Basics, TSQL Queries
|
Ch 11: Normal Forms, Cursors
|
Ch 4: SQL BASICS - 2
|
Ch 8: Group By, Views & Excel
|
Ch 12: TSQL Merge, Cursors
|
Case Study 1: Database Design with Tables, Constraints, Keys & Relations |
Case Study 2: Joins with Group By, Sub Queries, Views, Excel Analytics |
Ch 13: DB Architecture,Memory Concept
|
Ch 16: FUNCTIONS - Level 2
|
|
Ch 14: STORED PROCEDURES - Level 2
|
Ch 17 - 20: REAL-TIME PROJECT (BANKING) Includes 2500 Lines of Code (SOLVED). Phase 1: DATABASE DESIGN
Project Solution Explanation
| |
Ch 15: TRIGGERS & TRANSACTIONS
|
Ch 21: TUNING 1 - DB ARCH & AUDITS
|
Ch 25: TUNING 5 - LOCK MANAGEMENT
|
Ch 29: AZURE SQL DATABASE TUNING
|
Ch 22: TUNING 2 - INDEXES, STATS
|
Ch 26: CLOUD, AZURE CONFIG
|
Ch 30: Functions, Procedures in Azure
|
Ch 23: TUNING 3 - INDEX MANAGEMENT
|
Ch 27: AZURE SQL SERVER CONFIG
|
Azure SQL Developer Banking ProjectExtention to the Project Implemented in Chapters : 19 to 22. Includes Cloud Migrations, Azure SQL DBA Tuning [PaaS] Using CAST and CONVERT with SPs |
Ch 24: TUNING 4 - EXECUTION PLANS
|
Ch 28: ELASTIC DTUs, DB MIGRATION
|
Above Course Curriculum is applicable for registrations from Aug 1st, 2022