Training
I Train new SQL DBAs. Please find details below
COURSE MODULE
I have three different modules divided by skillsets & experience
Beginner DBA
Work Experience 0-2 years
Course Content:
Architecture
Installation On-Premise SQL Server
Understanding Tools – SSMS
Services explanation
Cloud setup
Best Practices with configuration
Role of System DBs
Backup and Restore
Basic Security
Basic Maintenance Jobs
Fees: 7K INR PER PERSON
Mid-Senior DBA
Experience: 2-6 years
Course Content
How to configure advance maintenance jobs
DB Corruption issues, database repair and database restore
Configuring Always On and Log shipping
Introduction to Firstresponderkit and sp_humanevents
SQL Profiler
Migration to Azure from On-Premise SQL Server
Hands on with Azure SQL Database and Azure SQL Managed Instance
How to run jobs on Azure SQL Databases and Azure SQL Managed Instances
Advance Security tips
SQL Server Audits
Plus some real life scenarios and techniques regarding administration
FEES 12K INR PER PERSON
Senior DBA with performance tuning
This is the most advance course and we discuss in-depth techniques of performance tuning
Experience: 7+ years
Course Content
1. How SQL Server Processes query
2. How Indexes can help
3. Finding right index for a query
4. Understanding Execution plan
5. When to use CTE, Temp Tables and Table Variables
6. Server configuration with respect to performance
7. TSQL Query tuning with lab
8. Understanding parameter sniffing
9. Advance understanding for Firstresponderkit
10. Working on a performance emergency