English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 120 lectures (32h 15m) | 11.00 GB
Become SQL database certified (MCSA and MTA certification)
Microsoft SQL Server continues to be one of the world’s most popular and top databases. Database is a heart of IT which is needed to stored all critical data and information.
If you want to become SQL database administrator then this is the course for YOU.
This training course will provide you all the necessary skills you need to be a successful database administrator. Plus, this course will prepare you for the SQL Server MCSA certification.
Here is the course outline:
Section 1 – Introduction
- Introduction to Database
- RDBMS
- What is SQL?
- Top 5 RDBMS
- Introduction to MS SQL Server
- Different editions of MS SQL
Section 2 – Download, Install and Configure Windows
- MS SQL Server prerequisite
- Lab setup
- What is virtualization?
- Download and Install VMWare Workstation Player
- Optional – Download and Install Oracle Virtualbox
- Create a Virtual Machine
- Download and Install Windows Server
- Virtual Machine Management
Section 3 – Download, Install and Configure MS SQL Server
- Prerequisites for MSSQL Installation
- Download MSSQL and SQL Server Management Studio
- Install and Configure MSSQL
- Install SQL Server Management Studio
- Download and Install AdventureWorks Database
Section 4 – Database Fundamentals and Design
- What is Data and Database?
- How is data stored?
- What is a Table, COLUMN and ROW ?
- What is a key? primary, foreign, unique keys etc.
- What is Relational Database and Relational Database Management System (RDBMS)?
- What is a Transaction and ACID properties?
- Database Normalization AND Different forms of Database Normalization
- Create your first Database, Table and Populate table with data…
Section 5 – Introduction to SQL Commands
- Welcome to Basic SQL Commands
- What is a SQL Statement and types of SQL statements
- DML Statement with examples
- DDL Statements with examples
- DCL Statement with examples
- TCL Statement with examples
Section 6 – Query and Manipulation of Data using SQL
- Create TABLE(s) and Temp Table(s)
- What Is a View?
- SELECT Statement in detail
- Operators, Expressions and Conditions
- WHERE Clause, ORDER BY, HAVING BY, GROUP BY Clause
- Select from two tables – JOINS
- Different Types of JOINS
- What is a Sub Query?
- INSERT, UPDATE, DELETE and Truncate Statements
- What is a Store Procedure?
- Function, Trigger and INDEX
- Clustered ,Non-clustered Indexes and Index Design considerations
- Index Fragmentation and Lab for Index
Section 7 – Microsoft SQL Database Administration
- Overview of MSSQL Management Tools
- Exploring SQL Server Management Studio (SSMS)
- Exploring SQL Server Configuration Manager
- MSSQL System Databases, DO’s and DONT’s of System databases
- What is master, etmpdb, msdb and other system databases?
Section 8 – Deep Dive into MSSQL Working
- What are Pages , Extents, Page Architecture and PFS?
- MSSQL Architecture
- MSSQL Database Architecture
- Operation and working of transaction log
- Configuring user Database
- Best practices while creating user Database
Section 9 – MSSQL Backup and Restore
- Backup of a Database, Importance for DBA and Different Media used for Backups
- Recovery Models in MSSQL and how that impact backups an restore
- Full and differential backups
- Transaction Log Backups, Log Backup Chain and Tail-log Backup
- Lab for Full, Differential and Transaction Log Backups
- Restore and Recovery Overview
- Full, Differential and Transaction Log database restore
- Point in time restore of a database
- Complete Backup , Restore and Restore in Time Lab
- MS SQL Server DBCC CHECKDB command
- Page Level Restore / Recovery using Full Backups
- Creating Maintenance Plan Backups/Re-indexing etc.
Section 10 – MSSQL User Management
- MSSQL Security Model
- MSSQL Server Authentication Modes
- Server Logins
- Server Roles
- Database Users
- Database Roles
- Permissions (GRANT , DENY, and REVOKE)
Section 11 – MSSQL Server Agent Management
- SQL Server Agent Introduction
- SQL Server Agent Jobs and Schedules
- Agent Alerts
- Operators
- Database Mail
- Activity Monitor
Section 12 – Advanced SQL Server Administration Topics
- High Availability and its Types
- What Is Replication and Transactional Replication
- Transactional Replication Setup (LAB)
- Log Shipping and Configuring Log Shipping
- SQL Server Encryption and Encryption Types
- Transparent Data Encryption (TDE) and configuration
Table of Contents
Introduction
1 Introduction
2 Course overview
3 Introduction to Database
4 What is RDBMS
5 What is SQL
6 Top 5 RDBMS using SQL
7 Introduction to Microsoft SQL Server
8 Different Editions of Microsoft SQL
Download, Install and Configure Windows
9 Welcome to Download, Install and Configure Windows
10 MS SQL Server Pre-requisite
11 Lab Setup
12 What is Virtualization
13 Download and Install VMWare Workstation Player
14 Optional – Download and Install Oracle Virtualbox
15 Create a Virtual Machine
16 Download and Install Windows Server (2016)
17 Download and Install Windows Server (2019)
18 Virtual Machine Management
Download, Install and Configure MS SQL Server
19 Welcome to Download, Install and Configure Microsoft SQL
20 Prerequisites for MSSQL 2016 Installation
21 Prerequisites for MSSQL 2022 Installation
22 Download and Install Chrome Browser
23 Download MSSQL and SQL Server Management Studio
24 Install and Configure MSSQL 2016
25 Install and Configure MSSQL 2019
26 Download and Install MSSQL 2022
27 Install 2016 SQL Server Management Studio
28 Install 2018 SQL Server Management Studio
29 Install 2019 SQL Server Management Studio
30 Download and Install AdventureWorks Database
Database Fundamentals and Design
31 Welcome to Database Fundamentals and Design
32 What is Data
33 What is Database
34 How Data is Stored
35 What is a Table, COLUMN and ROW
36 What is a Key
37 What is Primary Key , Foreign Key, Unique Key etc
38 What is Relational Database and Relational Database Management System (RDBMS)
39 What is a Transaction and ACID properties
40 Database Normalization AND Different forms of Database Normalization
41 Create your first Database, Table and Populate table with data
Introduction to SQL Commands
42 Welcome to Basic SQL Commands
43 What is a SQL Statement and types of SQL statements
44 DML Statement with examples
45 DDL Statements with examples
46 DCL Statement with examples
47 TCL Statement with examples
Query and Manipulation of Data using SQL
48 Welcome to Query and Manipulation of Data using SQL Commands
49 Create TABLE(s) and Temp Table(s)
50 What Is a View
51 SELECT Statement in detail
52 Operators, Expressions and Conditions
53 WHERE Clause, ORDER BY Clause , HAVING By Clause, GROUP BY Clause
54 Select from two tables – JOINS
55 Different Types of JOINS
56 What is a Sub Query
57 INSERT Statement in detail
58 UPDATE Statement in detail
59 DELETE Statement in detail
60 Difference between DELETE and Truncate Statement
61 What is a Stored Procedure
62 What is a Function
63 What is a Trigger
64 What is an INDEX
65 Clustered ,NonClustered Indexes and Index Design considerations
66 Index Fragmentation and Lab for Index
Microsoft SQL Database Administration and System databases
67 Welcome to Microsoft SQL Database Administration and System Databases
68 Overview of MSSQL Management Tools
69 Exploring SQL Server Management Studio (SSMS) (part -1)
70 Exploring SQL Server Management Studio (SSMS) (part -2)
71 Exploring SQL Server Configuration Manager
72 MSSQL System Databases, DO’s and DONT’s of System databases
73 What is master Database
74 What is tempdb Database
75 What is msdb Database
76 Other system Databases (model,distribution)
Deep Dive into MSSQL Working
77 Welcome to Deep Dive into MSSQL working
78 What are Pages , Extents, Page Architecture and PFS
79 MSSQL Architecture
80 MSSQL Database Architecture
81 Operation and working of transaction log
MSSQL Backup and Restore
82 Welcome to MSSQL Backup and Restore
83 Backup of a Database, Importance for DBA and Different Media’s used for Backups
84 Recovery Models in MSSQL and how that impact backups and restore
85 Full Backups
86 Differential Backups
87 Transaction Log Backups, Log Backup Chain and Tail-log Backup
88 Lab for Full, Differential and Transaction Log Backups
89 Restore and Recovery Overview
90 Full, Differential and Transaction Log database restore
91 Point in time restore of a database
92 Complete Backup , Restore and Restore in Time Lab
93 MS SQL Server DBCC CHECKDB command
94 Page Level Restore Recovery using Full Backups
95 Restore Master Database
96 Creating Maintenance Plan Backups Re indexing etc
MSSQL User Management
97 Welcome to MS SQL User Management
98 MSSQL Security Model
99 MSSQL Server Authentication Modes
100 Principals (Part-1) Server Logins, Server Roles
101 Principals (Part-2) Database Users, Database Roles
102 Permissions (GRANT , DENY , REVOKE)
MSSQL Server Agent Management
103 Welcome to Overview of MSSQL Server Agent
104 SQL Server Agent Introduction
105 SQL Server Agent Jobs and Schedules
106 Agent Alerts ,Operators , Database Mail and Activity Monitor
Advanced SQL Server Administration Topics
107 Introduction to Advanced Topics in MSSQL Server Administration
108 High Availability and its Types
109 What Is Replication and Transactional Replication Setup
110 Transactional Replication Setup (LAB)
111 Log Shipping and Configuring Log Shipping
112 SQL Server Query Tuning
113 Query Optimization Lab
114 SQL Server Encryption and Encryption Types
115 Transparent Data Encryption (TDE) , Configuration and Restore of TDE Databases
Course Recap
116 SQL Queries We Have Learned
117 Congratulations
118 Don’t Give Up!
119 Bonus Lecture
Resolve the captcha to access the links!