SQL DBA Job Ready Training Recorded Videos

Whatsapp: 

Who this course is for:

• Anyone who wants to start a career in SQL database administration
• Anyone who wants to have SQL database admin training to get a job in IT
• Anyone who wants to advance his/her career
• College students
• Add Skill to your Skill set for IT professionals

Why SQL Server Database

Demand for Data and Database Administrators

Unitil data is there,Database administrators are required.

About Me:

10+ Years of Experience into SQL DBA and Cloud

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 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 3 – MS SQL Server Architecture

• SQL Server Architecture

Section 4 – Frequently Used 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

Section 5 – Query and Manipulation of Data using SQL

• Create TABLE(s)
• What Is a View?
• SELECT Statement 
• Operators, Expressions and Conditions
• WHERE Clause, ORDER BY, HAVING BY, GROUP BY Clause
• INSERT, UPDATE, DELETE and Truncate Statements

Section 6 – 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, tempdb, msdb ,resource db and other system databases?

Section 7 – 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 8 – MSSQL Backup and Restore

• Creating user database and best practice.
• Recovery Models in MSSQL and how that impact backups an restore.
• Backup of a Database, Importance for DBA and Different Media used for Backups
• Full and differential backups
• Transaction Log Backups, Log Backup Chain(LSN) 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
• MS SQL Server DBCC CHECKDB command
• DB Recovery using Full Backups
• Creating Maintenance Plan Backups/Re-indexing etc.
• DB Migration In-place vs side-side migration

Section 9 – MSSQL User Management

• MSSQL Security Model
• MSSQL Server Authentication Modes
• Server Logins
• Server Roles
• Database Users
• Database Roles
• Permissions (GRANT , DENY, and REVOKE)

Section 10 – MSSQL Server Agent Management

• SQL Server Agent Introduction
• SQL Server Agent Jobs and Schedules
• Agent Alerts
• Operators
• Database Mail
• Activity Monitor

Section 11 – Advanced SQL Server Administration Topics

• High Availability and its Types
• Log Shipping and Log Shipping Configuration
• Database Mirroring and Configuration
• What Is Replication and Transactional Replication
• Transactional Replication Setup (LAB)
• Always On Configuration
• SQL Server Encryption and Encryption Types
• Transparent Data Encryption (TDE) and configuration
  
  

Section 13 – Additional Support

• Concept-wise Interview Questions
• Classroom Recordings
• Resume Preparation
• Mock Interviews

Section14 – Cloud Database Administrator

Azure SQL

AWS RDS