+ View more
Course overview
This training course will provide you all the necessary professional skills you need to be a successful database administrator. Plus, this course will prepare you for the SQL Server MCSA certification.
What will I learn?
- You will learn 150+ SQL queries
- You will be able to troubleshoot everyday SQL related issues
- You will manage SQL servers in a corporate environment
- You will write basic to advance SQL queries
Requirements
- A PC or Laptop with at least 4-8G of RAM
Curriculum for this course
87 Lessons
00:00:00 Hours
Introduction
5 Lessons
00:00:00 Hours
-
Introduction to Database
.
-
RDBMS
.
-
What is SQL?
.
-
Introduction to MS SQL Server
.
-
Different Editions of MS SQL
.
Download, Install and Configure Windows
7 Lessons
00:00:00 Hours
-
MS SQL Server Prerequisite
.
-
Lab SetUp
.
-
What is Virtualisation?
.
-
Download and Install VMWare Workstation Player
.
-
Optional - Download and Install Oracle Virtualbox
.
-
Create a Virtual Machine
.
-
Virtual Machine Management
.
Download, Install and Configure MS SQL Server
5 Lessons
00:00:00 Hours
-
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
.
Database Fundamentals and Design
10 Lessons
00:00:00 Hours
-
What is Data and Database?
.
-
How is Data Stored
.
-
How is Data Stored
.
-
What is a Table, Column and Row
.
-
What is a Primary Key, Unique key, foreign key etc.
.
-
What is Relational Database and Relational Database Management System (RDBMS)?
.
-
What is a Transaction and ACID properties?
.
-
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…
.
Introduction to SQL Commands
4 Lessons
00:00:00 Hours
-
Welcome to Basic SQL Commands
.
-
What is a SQL Statement and types of SQL statements
.
-
DML Statement with examples
.
-
TCL Statement with examples
.
Query and Manipulation of Data using SQL
15 Lessons
00:00:00 Hours
-
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
.
-
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
.
-
Configuring user Database
.
-
Full and differential backups
.
Microsoft SQL Database Administration
5 Lessons
00:00:00 Hours
-
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?
.
Deep Dive into MSSQL Working
5 Lessons
00:00:00 Hours
-
What are Pages , Extents, Page Architecture and PFS?
.
-
MSSQL Architecture
.
-
MSSQL Database Architecture
.
-
Operation and working of transaction log
.
-
Best practices while creating user Database
.
MSSQL Backup and Restore
11 Lessons
00:00:00 Hours
-
Backup of a Database, Importance for DBA and Different Media used for Backups
.
-
Recovery Models in MSSQL and how that impact backups an restore
.
-
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.
.
MSSQL User Management
7 Lessons
00:00:00 Hours
-
MSSQL Security Model
.
-
MSSQL Server Authentication Modes
.
-
Server Logins
.
-
Server Roles
.
-
Database Users
.
-
Database Roles
.
-
Permissions (GRANT , DENY, and REVOKE)
.
MSSQL Server Agent Management
6 Lessons
00:00:00 Hours
-
SQL Server Agent Introduction
.
-
SQL Server Agent Jobs and Schedules
.
-
Agent Alerts
.
-
Operators
.
-
Database Mail
.
-
Activity Monitor
.
Advanced SQL Server Administration Topics
6 Lessons
00:00:00 Hours
-
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
.
Course Re-cap
1 Lessons
00:00:00 Hours
-
Commands we have learned
.
+ View more
Other related courses
About instructor
OraDMT Digital Marketing Training
OraDMT offers digital marketing training programmes across all platforms. Digital Marketing training gives participants the understanding of one's brand online. Get empowered learn SEO, SMM,
Digital Marketing Training SEO Social Media Marketing Email Marketing Bulk SMS
Student feedback
Write a public review