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 Dev | SQL Dev Query Tuning |
SQL Dev Query Tuning Azure SQL Dev |
No of Videos | Videos 1 to 20 | Videos 1 to 25 | Videos 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 7000 USD 100 |
INR 12000 USD 150 |
INR 18000 USD 250 |
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 7: JOINS & LINKED SERVERS
|
Ch 13: DB Architecture,Memory Concept
|
Ch 2: SQL SERVER INSTALLATIONS
|
Ch 8: VIEW, SPs, FUNCTIONS BASICS
|
Ch 14: STORED PROCEDURES - Level 2
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 9: Triggers & Transactions
|
Ch 15: STORED PROCEDURES - Level 3
|
Ch 4: SQL BASICS - 2
|
Ch 10: DB Architecture & Group By
|
Ch 16: FUNCTIONS - Level 2
|
Ch 5: SQL Basics - 3, T-SQL INTRO
|
Ch 11: TSQL Queries: Group By, Joins
|
Ch 17 - 20: REAL-TIME PROJECT (BANKING) Includes 2500 Lines of Code (SOLVED). Phase 1: DATABASE DESIGN
Project Solution Explanation
|
Ch 6 : CONSTRAINTS, INDEXES
|
Ch 12 : ER MODELS, NORMAL FORMS
|
|
Case Study 1 - For Database, Table Design (Constraints, Keys) |
Case Study 2 - For Query Writing + Window Functions (Rank, RowNumber) |
Ch 21: TUNING 1 - DB ARCH & AUDITS
|
Ch 23: TUNING 3 - INDEX MANAGEMENT
|
Ch 25: TUNING 5 - LOCK MANAGEMENT
|
Ch 22: TUNING 2 - INDEXES, STATS
|
Ch 24: TUNING 4 - EXECUTION PLANS
|
REAL-TIME CASE STUDY
|
Ch 26: CLOUD, AZURE CONFIG
|
Ch 28: ELASTIC DTUs, DB MIGRATION
|
Functions, Procedures in Azure
|
Ch 27: AZURE SQL SERVER CONFIG
|
Ch 29: AZURE SQL DATABASE TUNING
|
Azure SQL Developer Banking ProjectExtention to the Project Implemented in Chapters : 18 to 20. Includes Cloud Migrations, Azure SQL DBA Tuning [PaaS] Using CAST and CONVERT with SPs |