Complete Microsoft SQL Server Database Administration Course
What you’ll learn
By the end of this course you will be a professional SQL database administrator and be able to apply for SQL jobs
Administration of SQL database through Microsoft Windows
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
Troubleshoot everyday SQL database related issues
Know how to answer specific business questions by using SQL’s aggregate functions
Students will be able to run reports for management so they can make financial decisions
Positive attitude and desire to learn
Passion to become SQL database administrator
A PC or MAC with at least 4-8G of RAM
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 – IntroductionIntroduction to DatabaseRDBMSWhat is SQL?Top 5 RDBMSIntroduction to MS SQL ServerDifferent editions of MS SQLSection 2 – Download, Install and Configure WindowsMS SQL Server prerequisiteLab setupWhat is virtualization?Download and Install VMWare Workstation PlayerOptional – Download and Install Oracle VirtualboxCreate a Virtual MachineDownload and Install Windows ServerVirtual Machine ManagementSection 3 – Download, Install and Configure MS SQL ServerPrerequisites for MSSQL InstallationDownload MSSQL and SQL Server Management StudioInstall and Configure MSSQLInstall SQL Server Management StudioDownload and Install AdventureWorks DatabaseSection 4 – Database Fundamentals and DesignWhat 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 NormalizationCreate your first Database, Table and Populate table with data…Section 5 – Introduction to SQL CommandsWelcome to Basic SQL CommandsWhat is a SQL Statement and types of SQL statementsDML Statement with examplesDDL Statements with examplesDCL Statement with examplesTCL Statement with examplesSection 6 – Query and Manipulation of Data using SQLCreate TABLE(s) and Temp Table(s)What Is a View?SELECT Statement in detailOperators, Expressions and ConditionsWHERE Clause, ORDER BY, HAVING BY, GROUP BY ClauseSelect from two tables – JOINSDifferent Types of JOINSWhat is a Sub Query?INSERT, UPDATE, DELETE and Truncate StatementsWhat is a Store Procedure?Function, Trigger and INDEXClustered ,Non-clustered Indexes and Index Design considerationsIndex Fragmentation and Lab for IndexSection 7 – Microsoft SQL Database AdministrationOverview of MSSQL Management ToolsExploring SQL Server Management Studio (SSMS)Exploring SQL Server Configuration ManagerMSSQL System Databases, DO’s and DONT’s of System databasesWhat is master, etmpdb, msdb and other system databases?Section 8 – Deep Dive into MSSQL WorkingWhat are Pages , Extents, Page Architecture and PFS?MSSQL ArchitectureMSSQL Database ArchitectureOperation and working of transaction logConfiguring user DatabaseBest practices while creating user DatabaseSection 9 – MSSQL Backup and RestoreBackup of a Database, Importance for DBA and Different Media used for BackupsRecovery Models in MSSQL and how that impact backups an restoreFull and differential backupsTransaction Log Backups, Log Backup Chain and Tail-log BackupLab for Full, Differential and Transaction Log BackupsRestore and Recovery OverviewFull, Differential and Transaction Log database restorePoint in time restore of a databaseComplete Backup , Restore and Restore in Time LabMS SQL Server DBCC CHECKDB commandPage Level Restore / Recovery using Full BackupsCreating Maintenance Plan Backups/Re-indexing etc.Section 10 – MSSQL User ManagementMSSQL Security ModelMSSQL Server Authentication ModesServer LoginsServer RolesDatabase UsersDatabase RolesPermissions (GRANT , DENY, and REVOKE)Section 11 – MSSQL Server Agent ManagementSQL Server Agent IntroductionSQL Server Agent Jobs and SchedulesAgent AlertsOperatorsDatabase MailActivity MonitorSection 12 – Advanced SQL Server Administration TopicsHigh Availability and its TypesWhat Is Replication and Transactional ReplicationTransactional Replication Setup (LAB)Log Shipping and Configuring Log ShippingSQL Server Encryption and Encryption TypesTransparent Data Encryption (TDE) and configurationSection 13 – Course Re-capCommands we have learned
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Course overview
Lecture 3 Introduction to Database
Lecture 4 What is RDBMS ?
Lecture 5 What is SQL ?
Lecture 6 Top 5 RDBMS using SQL
Lecture 7 Introduction to Microsoft SQL Server
Lecture 8 Different Editions of Microsoft SQL
Section 2: Download, Install and Configure Windows
Lecture 9 Welcome to Download, Install and Configure Windows
Lecture 10 MS SQL Server Pre-requisite
Lecture 11 Lab Setup
Lecture 12 What is Virtualization?
Lecture 13 Download and Install VMWare Workstation Player
Lecture 14 Optional – Download and Install Oracle Virtualbox
Lecture 15 Create a Virtual Machine
Lecture 16 Download and Install Windows Server (2016)
Lecture 17 Download and Install Windows Server (2019)
Lecture 18 Virtual Machine Management
Section 3: Download, Install and Configure MS SQL Server
Lecture 19 Welcome to Download, Install and Configure Microsoft SQL
Lecture 20 Prerequisites for MSSQL 2016 Installation
Lecture 21 Prerequisites for MSSQL 2022 Installation
Lecture 22 Download and Install Chrome Browser
Lecture 23 Download MSSQL and SQL Server Management Studio
Lecture 24 Install and Configure MSSQL 2016
Lecture 25 Install and Configure MSSQL 2019
Lecture 26 Download and Install MSSQL 2022
Lecture 27 Install 2016 SQL Server Management Studio
Lecture 28 Install 2018 SQL Server Management Studio
Lecture 29 Install 2019 SQL Server Management Studio
Lecture 30 Download and Install AdventureWorks Database
Section 4: Database Fundamentals and Design
Lecture 31 Welcome to Database Fundamentals and Design
Lecture 32 What is Data?
Lecture 33 What is Database?
Lecture 34 How Data is Stored ?
Lecture 35 What is a Table, COLUMN and ROW ?
Lecture 36 What is a Key ?
Lecture 37 What is Primary Key , Foreign Key, Unique Key etc ?
Lecture 38 What is Relational Database and Relational Database Management System (RDBMS) ?
Lecture 39 What is a Transaction and ACID properties ?
Lecture 40 Database Normalization AND Different forms of Database Normalization
Lecture 41 Create your first Database, Table and Populate table with data
Section 5: Introduction to SQL Commands
Lecture 42 Welcome to Basic SQL Commands
Lecture 43 What is a SQL Statement and types of SQL statements
Lecture 44 DML Statement with examples
Lecture 45 DDL Statements with examples
Lecture 46 DCL Statement with examples
Lecture 47 TCL Statement with examples
Section 6: Query and Manipulation of Data using SQL
Lecture 48 Welcome to Query and Manipulation of Data using SQL Commands
Lecture 49 Create TABLE(s) and Temp Table(s)
Lecture 50 What Is a View?
Lecture 51 SELECT Statement in detail
Lecture 52 Operators, Expressions and Conditions
Lecture 53 WHERE Clause, ORDER BY Clause , HAVING By Clause, GROUP BY Clause
Lecture 54 Select from two tables – JOINS
Lecture 55 Different Types of JOINS
Lecture 56 What is a Sub Query?
Lecture 57 INSERT Statement in detail
Lecture 58 UPDATE Statement in detail
Lecture 59 DELETE Statement in detail
Lecture 60 Difference between DELETE and Truncate Statement
Lecture 61 What is a Stored Procedure
Lecture 62 What is a Function
Lecture 63 What is a Trigger
Lecture 64 What is an INDEX
Lecture 65 Clustered ,NonClustered Indexes and Index Design considerations
Lecture 66 Index Fragmentation and Lab for Index
Section 7: Microsoft SQL Database Administration and System databases
Lecture 67 Welcome to Microsoft SQL Database Administration and System Databases
Lecture 68 Overview of MSSQL Management Tools
Lecture 69 Exploring SQL Server Management Studio (SSMS) (part -1)
Lecture 70 Exploring SQL Server Management Studio (SSMS) (part -2)
Lecture 71 Exploring SQL Server Configuration Manager
Lecture 72 MSSQL System Databases, DO’s and DONT’s of System databases
Lecture 73 What is master Database?
Lecture 74 What is tempdb Database ?
Lecture 75 What is msdb Database ?
Lecture 76 Other system Databases (model,distribution)
Section 8: Deep Dive into MSSQL Working
Lecture 77 Welcome to Deep Dive into MSSQL working
Lecture 78 What are Pages , Extents, Page Architecture and PFS ?
Lecture 79 MSSQL Architecture
Lecture 80 MSSQL Database Architecture
Lecture 81 Operation and working of transaction log
Section 9: MSSQL Backup and Restore
Lecture 82 Welcome to MSSQL Backup and Restore
Lecture 83 Backup of a Database, Importance for DBA and Different Media’s used for Backups
Lecture 84 Recovery Models in MSSQL and how that impact backups and restore
Lecture 85 Full Backups
Lecture 86 Differential Backups
Lecture 87 Transaction Log Backups, Log Backup Chain and Tail-log Backup
Lecture 88 Lab for Full, Differential and Transaction Log Backups
Lecture 89 Restore and Recovery Overview
Lecture 90 Full, Differential and Transaction Log database restore
Lecture 91 Point in time restore of a database
Lecture 92 Complete Backup , Restore and Restore in Time Lab
Lecture 93 MS SQL Server DBCC CHECKDB command
Lecture 94 Page Level Restore / Recovery using Full Backups
Lecture 95 Restore Master Database
Lecture 96 Creating Maintenance Plan Backups / Re indexing etc.
Section 10: MSSQL User Management
Lecture 97 Welcome to MS SQL User Management
Lecture 98 MSSQL Security Model
Lecture 99 MSSQL Server Authentication Modes
Lecture 100 Principals (Part-1) : Server Logins, Server Roles
Lecture 101 Principals (Part-2) : Database Users, Database Roles
Lecture 102 Permissions (GRANT , DENY , REVOKE)
Section 11: MSSQL Server Agent Management
Lecture 103 Welcome to Overview of MSSQL Server Agent
Lecture 104 SQL Server Agent Introduction
Lecture 105 SQL Server Agent Jobs and Schedules
Lecture 106 Agent Alerts ,Operators , Database Mail and Activity Monitor
Section 12: Advanced SQL Server Administration Topics
Lecture 107 Introduction to Advanced Topics in MSSQL Server Administration
Lecture 108 High Availability and its Types
Lecture 109 What Is Replication and Transactional Replication Setup
Lecture 110 Transactional Replication Setup (LAB)
Lecture 111 Log Shipping and Configuring Log Shipping
Lecture 112 SQL Server Query Tuning
Lecture 113 Query Optimization Lab
Lecture 114 SQL Server Encryption and Encryption Types
Lecture 115 Transparent Data Encryption (TDE) , Configuration and Restore of TDE Databases
Section 13: Course Recap
Lecture 116 SQL Queries We Have Learned
Lecture 117 Congratulations
Lecture 118 Don’t Give Up!
Anyone who wants to start a career in SQL database administration,Anyone who wants to have complete SQL database training to get a job in IT,Anyone who wants to advance his/her career,Anyone who wants to master the SQL command line skills,College students,IT professionals,Teachers and instructors,Anyone who want to get certified in MCSA and MTA certification
Udemy | English | 32h 6m | 11.24 GB
Created by: Imran Afzal