Complete Microsoft SQL Server Database Administration Course

Become SQL database certified (MCSA and MTA certification)
Complete Microsoft SQL Server Database Administration Course
File Size :
11.24 GB
Total length :
32h 6m

Category

Instructor

Imran Afzal

Language

Last update

5/2023

Ratings

4.4/5

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

Complete Microsoft SQL Server Database Administration Course

Requirements

Positive attitude and desire to learn
Passion to become SQL database administrator
A PC or MAC with at least 4-8G of RAM

Description

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

Overview

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

Course Information:

Udemy | English | 32h 6m | 11.24 GB
Created by: Imran Afzal

You Can See More Courses in the IT & Software >> Greetings from CourseDown.com

New Courses

Scroll to Top