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, DO's and DONT's 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!

Menu