Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Full MS SQL Server with Backup, Recovery and Cluster
What is database?
RDBMS (Relational Database Management System) (2:24)
What is SQL/Query? (2:49)
Project Files and Course Documents
Database Normalization
Normalization (2:58)
Normal Forms (NF) (7:56)
Installation
Install Lab (2:41)
quiz
Downloading Required Programs
Download VirtualBox (1:22)
Download Windows Server 2019 (1:09)
Download Microsoft SQL Server 2019 (2:03)
Download SQL Server Management Studio (1:50)
Install VirtualBox
Install VirtualBox (1:40)
Install Virtual Machine
Add And Install AD-SRV (9:41)
Add And Install SQL-Server1 (8:18)
Virtual Machine Network Settings Section
Create NAT Network (1:20)
AD-SRV Network Setting (5:34)
SQL-SRV1 Network Setting (5:03)
SQL-SRV2 Network Setting (4:54)
Check in-1
Check in-1 (0:44)
Configurations
Create Active Directory, SQL Server OU, Admin User (11:00)
Add SQL-SRV1&SQL-SRV2 Active Directory (5:41)
Create Shared Disk System (17:32)
SQL-SRV1 Share Disk Connections (3:57)
SQL-SRV2 Share Disk Connections (3:50)
quiz
Check in-2
Check in-2 (1:07)
What is a cluster? What is it used for?
What is a cluster? What is it used for? (2:08)
quiz
Create Fail Over Cluster Services And Clusting
Sample cluster network configuration (2:25)
SQLSRV-1 Install Fail Over Cluster Services (3:54)
SQLSRV-2 Install Fail Over Cluster Services (3:59)
Create Cluster (10:30)
quiz
Install SQL Server Database Program
Install Microsoft SQL Server for SRV-1 (16:28)
Install Microsoft SQL Server for SRV-2 (3:40)
Instal SQL Server Management Studio
Install SQL Server Management Studio SQLSRV-1&SQLSRV-2 (10:50)
Starting SSMS
Starting To SSMS (SQL Server Management Studio) (5:08)
Create, Alter and Drop Database (8:46)
Create, Rename and Drop Table (13:42)
Data Types and Constraints (5:52)
Foreign Key Constraint (5:14)
Unique & Check Constraint (5:31)
quiz
Manipulating Data
Insert Data to Table (10:05)
Update Data in A Table (5:42)
Delete Data and AdventureWorks (6:17)
Basic Select Statement
Select Statement and Alias (7:09)
Where Clause and Operators (10:49)
Sorting and Grouping Data
Sorting and Grouping Data, (13:28)
Wilcard Operations
Like Clause (8:03)
IF-THEN Statement
Case Function (4:37)
Why should we take backup?
What is Backup and Backup Types?(Full, Differential,Transaction Log Backup) (5:23)
Check in-3
Check in-3 (0:58)
What Is Recovery Model?
What Is Recovery Model And Types?(Full, Bulk Logged, Simple) (8:47)
What Should Be The Backup Strategy?
What Should Be The Backup Strategy? (1:09)
Full Recovery Model-.bak File
Let's Do The First Backup(Full Recovery Model - Full Backup With .bak File) (6:02)
Differential Backup With .bak File (7:40)
Transaction Log Backup With .bak File (5:43)
Restored Full Recovery Model-.bak File
Restore Full Backup With .bak File (4:54)
Restore Differential Backup With .bak File (1:53)
Restore Transaction Log Backup With .bak File (4:18)
Full Recovery Model-Backup Device
Full Backup With .bak File (3:31)
Differential Backup With .bak File (3:34)
Transaction Log Backup With .bak File (4:58)
Check in-4
Check in-4 (1:05)
Restored Full Recovery Model-Backup Device
Restore Full Backup With Backup Device (3:40)
Restore Differential Backup With Backup Device (2:26)
Restore Transaction Log Backup With Backup Device (2:47)
Create And Load Sample Database
Create and Load Sample Databases&Data (3:41)
Testing Section
Test Cluster - Down SQLSRV-1 (2:59)
Test Cluster - Down SQLSRV-2 (3:02)
Check in-5
Check in-5 (1:04)
Create and Load Sample Databases&Data
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock