Master SQL Server DBA from scratch to advanced with real-time scenarios!
This playlist covers everything: Starting with Sql Server, Overview ; Installation and Configuration of Sql Server; Post - requisites of Installation of Sql Server; Working with the Databases; Backup and Restoration; Security with Sql Server and the Advances level.
?? Perfect for beginners + experienced professionals preparing for DBA interviews
?? Watch in sequence for best learning
?? Subscribe for daily DBA content
Aulas do Curso
(43 vídeos)
0 de 43 aulas concluídas
0%
Progresso salvo somente neste navegador.
0
Sql Dba Introduction 1A
In this video, I explain the basic introduction of Microsoft SQL Server and the role of a SQL DBA (Database Administrato…
1
SQL DBA Introduction 1 B
In this video, I explain the basic introduction of Microsoft SQL Server and the role of a SQL DBA (Database Administrato…
2
Sql Server Installation
In this video, I explain how to install Microsoft SQL Server 2017 in Window OS 2012 R2 step by step in a simple and easy…
3
SSMS Installation : Sql Server Management Studio
SQL Server Management Studio (SSMS) – Installation.
In this video, I have explained SQL Server Management Studio (SSMS)…
4
Database Creation in Sql Server
In this video, you will learn how to create a database in SQL Server step by step using SQL Server Management Studio (SS…
5
How To Create Table in Sql Server Database | Sql Dba Basics
In this video, you will learn how to create a table in SQL Server database
using CREATE TABLE statement with a real-tim…
6
DELETE vs TRUNCATE vs DROP ? Many DBAs Get This Wrong
Confused between DELETE, TRUNCATE and DROP?
This short explains the difference in under 1 minute with script command in …
7
System Database Explained With Demo | Master, Model, Msdb, Tempdb and Resources DB.
In this video we will understand SQL Server System Databases in detail.
We will cover :
Master Databases
Model Databas…
8
Sql Server Services and Startup Parameters Explained | Post Sql Server Installation , PART-1
In this video, we will configure SQL Server Services and Startup Parameters as part of Post SQL Server Installation (Par…
9
Configure Data & Log File Path Explained | Post Sql Server Installation (Part -2)
After installing Microsoft SQL Server, most people forget one critical configuration — setting the default Data and Log …
10
Configuration Of Minimum and Maximum Memory Of SQL Server | Post Sql Server Installation (Part -3)
In Part 3 of the Post SQL Server Installation Series, we configure Min and Max Server Memory in SQL Server.
Why is this…
11
Enable Remote Connection And Configuration Window Firewall | Part (4 & 5)
You installed SQL Server… but remote connection is not working? ??
In this video, I explain step-by-step:
? How to Enabl…
12
SQL Server Default Backup Path Configuration | Post Installation Part 6 (Final)
In this video, we will configure the Default Backup Path in SQL Server as part of our Post SQL Server Installation Confi…
13
Default Instance vs Named Instance in SQL Server | Complete Beginner Guide
In this video, we clearly explain the difference between Default Instance and Named Instance in Microsoft SQL Server.
Y…
14
SQL SERVER ARCHITECTURE PART -1 | Protocol Layer & Relational Engine|
In this video, we explore SQL Server Architecture Part 1 focusing on the Protocol Layer and Relational Engine components…
15
SQL SERVER ARCHITECTURE PART -2 | Buffer Manager, Access Methods & Transaction Manager Explained |
SQL SERVER ARCHITECTURE – PART 2
In this video, we dive deep into the core components of SQL Server Architecture:
? Bu…
16
How to Add Data File & Log File in Database (Step-by-Step Guide)
In this video, I have explained how to add additional Data File (.mdf / .ndf) and Log File (.ldf) in SQL Server database…
17
SQL Server Log File Shrink FULL Tutorial ??| LDF Issue & Log Reuse Wait NOTHING, ACTIVE, REPLICATION
In this detailed tutorial, I have explained how to shrink the SQL Server transaction log file (LDF) step by step with re…
18
TempDB Full? ?? Fix & Shrink Without Restart | SQL Server DBA Real-Time Solution
TEMPDB FULL Issue in SQL Server? Don’t Panic!
In this video, I will show you how to analyze, troubleshoot, and shrink T…
19
Recovery Models in SQL Server Explained || Full || Bulk Logged || Simple || Pseudo Recovery Model |
Want to master SQL Server Recovery Models? In this complete 16-minute tutorial, I have explained everything in detail ab…
20
Backup and its Types | SQL Server Backup Tutorial | All 11 Types of Backup Explained for Beginners
Learn everything about Backup in SQL Server in this complete tutorial!
In this video, I explained:
? What is Backup in …
21
Full Backup in Sql Server | Explained Step by Step | Real-Time DBA Tutorial
Learn SQL Server Full Backup from Scratch with Real-Time Practical Demo
In this video, I explain EVERYTHING about Full …
22
Differential Backup in SQL Server | Complete DBA Tutorial with Real-Time Demo.
Learn Differential Backup in SQL Server with a complete real-time practical demo in this DBA training video.
In this vi…
23
Transaction Log Backup in SQL Server | Full Practical Demo for DBAs |
In this video, I have explained Transaction Log Backup in SQL Server with a complete real-time production scenario.
You…
24
How to Recover Crashed Database in SQL Server | Real Time DBA Scenario |
DATABASE CRASHED AT 10 PM THURSDAY!
How will a DBA recover the database using:
? Full Backup
? Differential Backup
? T…
25
Copy Only Backup & Tail Log Backup Backup in SQL Server | Full Practical Demo for SQL DBA
In this video, I have explained Copy-Only Backup and Tail-Log Backup in SQL Server with complete theory, practical demo,…
26
Filegroup Backup & Split Backup in SQL Server | Full Practical Demo | SQL DBA Course
Welcome to the SQL DBA Course Series!
In this video, you will learn Filegroup Backup and Split Backup in SQL Server wit…
27
How to Recover Crashed Database in SQL Server Part -3 | Real Time DBA Scenario | Contant-9007855728|
DATABASE CRASHED AT 1:15 PM WEDNESDAY!
How can a DBA recover the database using:
? Full Backup
? Differential Backup
?…
28
How to Take TABLE BACKUP in SQL Server | 2 Methods with Real-Time Practical Demo | SQL DBA Course
n this video, you will learn How to Take TABLE BACKUP in SQL Server using 2 different methods with a complete real-time …
29
Database Restore from One Server to Another | DBA Real-Time Scenario | SQL DBA Course |
In this SQL DBA Course video, I have demonstrated a complete practical scenario of restoring a database from one SQL Ser…
30
DB Refresh in SQL Server Step by Step | Production to UAT Refresh Complete Demo | SQL DBA Course |
Learn how SQL Server DB Refresh is performed in a real production environment.
In this SQL DBA Course video, I have dem…
31
95% DBAs Get This Wrong! DB Restore vs DB Refresh Explained | | Real Production DBA Scenario |
Confused between Database Restore and Database Refresh in SQL Server?
In this video, I explain the complete difference …
32
Issue Related With Backup & Restore in SQL Server | Causes & Solutions | SQL DBA Course |
SQL Server DBA Course – Backup & Restore Troubleshooting
Backup and Restore are among the most critical responsibilitie…
33
SQL Server Authentication Explained for Beginners | Windows vs SQL Login | SQL DBA Course |
Welcome to DBA Guardians SQL Server DBA Course.
In this video, you will learn one of the most important SQL Server DBA …
34
How to Create Windows Login and SQL Login in SQL Server | Complete SSMS Tutorial | SQL DBA Course |
SQL Server Authentication Explained with Practical Demo
In this video, I have demonstrated how to create Windows Login …
35
SQL Server Group Logins Explained | Windows Group Login | SQL Server Security | SQL DBA Course
Welcome to the SQL Server DBA Course!
In this video, you'll learn everything about Group Logins in SQL Server using a r…
36
How to Grant Database Access to Any User in SQL Server | Database Access to Sql logins |
How do you give a user access to a database in SQL Server? In this video, you'll learn the complete process of granting …
37
SQL Server Server Roles Explained in 15 Minutes | SQL DBA Full Course |
SQL Server Server Roles Explained | SQL DBA Full Course | DBA GUARDIANS
Welcome to another lecture of the SQL DBA Full …
38
SQL Server Database Roles Explained | db_owner, db_datareader, db_datawriter | SQL DBA Full Course
Learn SQL Server Database Roles from scratch with practical examples!
In this video, you'll understand how Database Rol…
39
How SQL DBAs Give Database Access in Real Time | db_owner Permission Process | SQL DBA Course
In this video, you'll learn how SQL DBAs provide database access in real-time production environments.
This is NOT just…
40
SQL DBA ALERT | SQL Server Performance Issue? Step-by-Step Troubleshooting Guide |
Received a SQL Server alert in Production? Don't panic!
In this video, I demonstrate the real-time troubleshooting appr…
41
How to Export a Table from One Database to Another in SQL Server | SSMS Practical | SQL DBA Course |
Learn how to export a table from one database to another database in SQL Server using SQL Server Management Studio (SSMS…
42
SQL Server Patching | Complete Guide + Pre-Requisites Every DBA Must Know |
SQL Server Patching is one of the most important activities for every SQL Server DBA, especially in production environme…
