Complete Microsoft SQL Server Database Administration Course

Complete Microsoft SQL Server Database Administration Course, available at $94.99, has an average rating of 4.48, with 121 lectures, 11 quizzes, based on 7298 reviews, and has 53692 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone who wants to start a career in SQL database administration or Anyone who wants to have complete SQL database training to get a job in IT or Anyone who wants to advance his/her career or Anyone who wants to master the SQL command line skills or College students or IT professionals or Teachers and instructors It is particularly useful for Anyone who wants to start a career in SQL database administration or Anyone who wants to have complete SQL database training to get a job in IT or Anyone who wants to advance his/her career or Anyone who wants to master the SQL command line skills or College students or IT professionals or Teachers and instructors.

Enroll now: Complete Microsoft SQL Server Database Administration Course

Summary

Title: Complete Microsoft SQL Server Database Administration Course

Price: $94.99

Average Rating: 4.48

Number of Lectures: 121

Number of Quizzes: 11

Number of Published Lectures: 121

Number of Published Quizzes: 11

Number of Curriculum Items: 132

Number of Published Curriculum Objects: 132

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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 PERFECT course for YOU. This training course will provide you all the necessary skills you need to be a successful database administrator.  The “Complete Microsoft SQL Server Database Administration Course” is designed to provide a comprehensive understanding of database administration using Microsoft SQL Server. This course is ideal for IT professionals, database administrators, and anyone interested in learning about SQL Server infrastructure. It covers key aspects such as installation, configuration, maintenance, security, and performance tuning of SQL Server databases

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

Section 13 – Course Re-cap

Commands we have learned

Course Curriculum

Chapter 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

Chapter 2: Download, Install and Configure Windows

Lecture 1: Welcome to Download, Install and Configure Windows

Lecture 2: MS SQL Server Pre-requisite

Lecture 3: Lab Setup

Lecture 4: What is Virtualization?

Lecture 5: Download and Install VMWare Workstation Player

Lecture 6: Optional – Download and Install Oracle Virtualbox

Lecture 7: Create a Virtual Machine

Lecture 8: Download and Install Windows Server (2016)

Lecture 9: Fix EFI Network Time out error for VM Player

Lecture 10: Download and Install Windows Server (2019)

Lecture 11: Virtual Machine Management

Chapter 3: Download, Install and Configure MS SQL Server

Lecture 1: Welcome to Download, Install and Configure Microsoft SQL

Lecture 2: Which Version Of SQL Server to Install ?

Lecture 3: Prerequisites for MSSQL 2016 Installation

Lecture 4: Prerequisites for MSSQL 2022 Installation

Lecture 5: Download and Install Chrome Browser

Lecture 6: Download MSSQL and SQL Server Management Studio

Lecture 7: Install and Configure MSSQL 2016

Lecture 8: Install and Configure MSSQL 2019

Lecture 9: Download and Install MSSQL 2022

Lecture 10: Install 2016 SQL Server Management Studio

Lecture 11: Install 2018 SQL Server Management Studio

Lecture 12: Install 2019 SQL Server Management Studio

Lecture 13: Download and Install AdventureWorks Database

Chapter 4: Database Fundamentals and Design

Lecture 1: Welcome to Database Fundamentals and Design

Lecture 2: What is Data?

Lecture 3: What is Database?

Lecture 4: How Data is Stored ?

Lecture 5: What is a Table, COLUMN and ROW ?

Lecture 6: What is a Key ?

Lecture 7: What is Primary Key , Foreign Key, Unique Key etc ?

Lecture 8: What is Relational Database and Relational Database Management System (RDBMS) ?

Lecture 9: What is a Transaction and ACID properties ?

Lecture 10: Database Normalization AND Different forms of Database Normalization

Lecture 11: Create your first Database, Table and Populate table with data

Chapter 5: Introduction to SQL Commands

Lecture 1: Welcome to Basic SQL Commands

Lecture 2: What is a SQL Statement and types of SQL statements

Lecture 3: DML Statement with examples

Lecture 4: DDL Statements with examples

Lecture 5: DCL Statement with examples

Lecture 6: TCL Statement with examples

Chapter 6: Query and Manipulation of Data using SQL

Lecture 1: Welcome to Query and Manipulation of Data using SQL Commands

Lecture 2: Create TABLE(s) and Temp Table(s)

Lecture 3: What Is a View?

Lecture 4: SELECT Statement in detail

Lecture 5: Operators, Expressions and Conditions

Lecture 6: WHERE Clause, ORDER BY Clause , HAVING By Clause, GROUP BY Clause

Lecture 7: Select from two tables – JOINS

Lecture 8: Different Types of JOINS

Lecture 9: What is a Sub Query?

Lecture 10: INSERT Statement in detail

Lecture 11: UPDATE Statement in detail

Lecture 12: DELETE Statement in detail

Lecture 13: Difference between DELETE and Truncate Statement

Lecture 14: What is a Stored Procedure

Lecture 15: What is a Function

Lecture 16: What is a Trigger

Lecture 17: What is an INDEX

Lecture 18: Clustered ,NonClustered Indexes and Index Design considerations

Lecture 19: Index Fragmentation and Lab for Index

Chapter 7: Microsoft SQL Database Administration and System databases

Lecture 1: Welcome to Microsoft SQL Database Administration and System Databases

Lecture 2: Overview of MSSQL Management Tools

Lecture 3: Exploring SQL Server Management Studio (SSMS) (part -1)

Lecture 4: Exploring SQL Server Management Studio (SSMS) (part -2)

Lecture 5: Exploring SQL Server Configuration Manager

Lecture 6: MSSQL System Databases, DOs and DONTs of System databases

Lecture 7: What is master Database?

Lecture 8: What is tempdb Database ?

Lecture 9: What is msdb Database ?

Lecture 10: Other system Databases (model,distribution)

Chapter 8: Deep Dive into MSSQL Working

Lecture 1: Welcome to Deep Dive into MSSQL working

Lecture 2: What are Pages , Extents, Page Architecture and PFS ?

Lecture 3: MSSQL Architecture

Lecture 4: MSSQL Database Architecture

Lecture 5: Operation and working of transaction log

Chapter 9: MSSQL Backup and Restore

Lecture 1: Welcome to MSSQL Backup and Restore

Instructors

Imran Afzal
Best Selling Instructor with a million+ students worldwide

Abbas Mehmood
Sr DBA at Everyday Health

Rating Distribution

1 stars: 96 votes

2 stars: 121 votes

3 stars: 687 votes

4 stars: 2470 votes

5 stars: 3924 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!