SQL Server 2022 Database Administration Essential Training

Focused View

Emar Morrison

2:08:32

93 View

1 - Introduction

1 - Introduction.mp4

01:26

2 - What is SQL Server.mp4

01:58

2 - Setting Up Your Environment

3 - SQL Server Editions.mp4

01:37

4 - Installing SQL Server 2022.mp4

05:35

5 - Installing Management Studio.mp4

01:58

6 - SQL Server Configuration Manager.mp4

03:03

7 - Working With SQL Server in Docker.mp4

05:15

3 - Database Creation Configuration

8 - SQL Server System Databases.mp4

04:14

9 - Database Storage strategies.mp4

03:03

10 - Capacity and growth considerations.mp4

02:52

11 - Configuring Model Database.mp4

03:40

12 - Creating a Database.mp4

02:33

13 - SQL Server contained database.mp4

04:12

4 - Securing Your SQL Server

14 - Managing Users Login.mp4

02:03

15 - Demo Managing Users Logins.mp4

06:37

16 - Managing Contained Users.mp4

02:25

17 - Implementing InstanceLevel Security.mp4

03:21

18 - Implementing DatabaseLevel Security.mp4

03:51

19 - SQL Server Audit Specifications.mp4

02:22

20 - Configuring Server and Database Audit.mp4

07:17

21 - Data Discovery Classification.mp4

02:00

22 - SQL Vulnerability Assessment.mp4

03:12

5 - Backup Restore

23 - Introduction.mp4

00:42

24 - Understanding Recovery Models.mp4

04:03

25 - How to Perform Full Backups.mp4

03:38

26 - How to Perform Differential Backup.mp4

03:53

27 - Transaction log backups.mp4

02:46

28 - Performing Recovery.mp4

13:15

29 - Backup Strategies.mp4

03:55

6 - Automating Maintenance Routines

30 - What is SQL Server Job Agent.mp4

03:05

31 - Automating Processes with SQL Server Agent.mp4

05:00

32 - Configuring and Sending Database Mail.mp4

03:33

33 - Automating Database Backups.mp4

04:26

7 - Performance Monitoring

34 - Reviewing SQL Server Logs.mp4

02:12

35 - Understanding how Dynamic Management Views Works.mp4

03:30

Description

Microsoft SQL Server 2022 Database Administration Full Course

What You'll Learn?

How to install and configure SQL Server on a server as well in a docker container
How to manage instance level and database level security.
How to perform backups and restores
How to perform point-in-time restores
How to automate repetitive task with SQL Server Agent
How to perform vulnerability assessment
Troubleshooting and monitoring using logs and DMVs
How to migrate databases to cloud platforms

Who is this for?

Developer

Database Administrator

I.T and Computer Science graduates

Aspiring Database Administrators

More details

Description
This course has been designed to give you the knowledge and skill to become an expert SQL Server Database Administrator.
If you want to become SQL database administrator, then this is the course for YOU.

Here is the course outline:
Section 1 - Introduction
Introduction
What is SQL Server
Section 2 - Setting Up Your Environment
SQL Server Editions
Installing SQL Server 2022
Install Management Studio
SQL Server Configuration Manager
Working With SQL Server in Docker
Section 3 - Database Creation & Configuration
SQL Server System Databases
Database Storage Strategies
Capacity and growth considerations
Configuring Model Database
Creating a Database
SQL Server contained database
Section 4 - Securing Your SQL Server
Managing Users & Login
Managing Contained Users
Implementing Instance-Level Security
Implementing Database-Level Security
SQL Server Audit Specifications
Configuring Server and Database Audit
Data Discovery & Classification
SQL Vulnerability Assessment
Section 5: Backup & Restore
Introduction to Backup and Restore
Understanding Recovery Models
How to Perform Full Backups
How to Perform Differential Backup
Transaction log backups
Performing Recovery
Backup Strategies
Section 6: Automating Maintenance Routines
What is SQL Server Job Agent
Automating Processes with SQL Server Agent
Configuring and Sending Database Mail
Automating Database Backups
Section 7: Performance & Monitoring
Reviewing Server Logs
Exposing Dynamic Management Views (DMVs)
Database Console Commands for SQL Server
SQL Server Activity Moniter
Indexes for performance tuning
Introduction to SQL Server Query Store
Section 7: Migrate & Import Data
Introduction
Migrating Databases to Amazon Web Services (AWS)
Detaching and Attaching Databases to an Instance
Migrating to Azure & Docker using bacpac archive
Importing and Exporting Data

Who this course is for:
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
College students looking to pursue database administration
IT Infrastructure Professionals
Who this course is for:
Developer
Database Administrator
I.T and Computer Science graduates
Aspiring Database Administrators

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Emar Morrison

Instructor's Courses

Emar J. Morrison is a 30-year-old investor with a love for personal finance and investment. For the past four years, he has been investing in the stock market. In 2016, he bought his first stocks with little idea what he was doing. He was, nevertheless, completely enthralled, and he buried himself in it.He read a lot of books and researched investors like RULE 1 Investing’s Phil Town, Peter Lynch, Michael Lee-Chin, and, of course, Warren Buffet over the next few years. He has read George S. Clason’s The Richest Man in Babylon, Benjamin Graham’s The Intelligent Investor, Money Master The Game, and Tony Robbins’ The Unshakable.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.