Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Udemy Full MS SQL Server with Backup, Recovery and Cluster

Video Introducing this tutorial


What is database? :
RDBMS(Relational Database Management System)
What is SQL/Query?

Database Normalization :
Normalization
Normal Forms (NF)

Installation :
Install Lab

Downloading Required Programs :
Download VirtualBox
Download Windows Server 2019
Download Microsoft SQL Server 2019
Download SQL Server Management Studio

Install VirtualBox :
Install VirtualBox

Install Virtual Machine :
Add And Install AD-SRV
Add And Install SQL-Server1
Add And Install SQL-Server2

Virtual Machine Network Settings Section :
Create NAT Network
AD-SRV Network Setting
SQL-SRV1 Network Setting
SQL-SRV2 Network Setting

Check in-1 :
Check in-1

Configurations :
Create Active Directory, SQL Server OU, Admin User
Add SQL-SRV1&SQL-SRV2 Active Directory
Create Shared Disk System
SQL-SRV1 Share Disk Connections
SQL-SRV2 Share Disk Connections
Check in-2
Check in-2
What is a cluster? What is it used for?
What is a cluster? What is it used for?

Create Fail Over Cluster Services And Clusting :
Sample cluster network configuration
SQLSRV-1 Install Fail Over Cluster Services
SQLSRV-2 Install Fail Over Cluster Services
Create Cluster

Install SQL Server Database Program :
Install Microsoft SQL Server for SRV-1
Install Microsoft SQL Server for SRV-2

Instal SQL Server Management Studio :
Install SQL Server Management Studio SQLSRV-1&SQLSRV-2

Starting SSMS :
Starting To SSMS (SQL Server Management Studio)
Create, Alter and Drop Database
Create, Rename and Drop Table
Data Types and Constraints
Foreign Key Constraint
Unique & Check Constraint

Manipulating Data :
Insert Data to Table
Update Data in A Table
Delete Data and AdventureWorks

Basic Select Statement :
Select Statement and Alias
Where Clause and Operators

Sorting and Grouping Data :
Sorting and Grouping Data

Wilcard Operations :
Like Clause

IF-THEN Statement :
Case Function
Why should we take backup?
What is Backup and Backup Types?(Full, Differential,Transaction Log Backup)
Check in-3
Check in-3

What Is Recovery Model? :
What Is Recovery Model And Types?(Full, Bulk Logged, Simple)
What Should Be The Backup Strategy?
What Should Be The Backup Strategy?

Full Recovery Model-.bak File :
Let's Do The First Backup(Full Recovery Model - Full Backup With .bak File)
Differential Backup With .bak File
Transaction Log Backup With .bak File

Restored Full Recovery Model-.bak File :
Restore Full Backup With .bak File
Restore Differential Backup With .bak File
Restore Transaction Log Backup With .bak File

Full Recovery Model-Backup Device :
Full Backup With .bak File
Differential Backup With .bak File
Transaction Log Backup With .bak File
Check in-4
Check in-4

Restored Full Recovery Model-Backup Device :
Restore Full Backup With Backup Device
Restore Differential Backup With Backup Device
Restore Transaction Log Backup With Backup Device

Create And Load Sample Database :
Create and Load Sample Databases&Data

Testing Section :
Test Cluster - Down SQLSRV-1
Test Cluster - Down SQLSRV-2
Check in-5
Check in-5
BONUS
BONUS