SQL Server Database Administration Full Course 2022 | Udemy


SQL Server Database Administration Full Course 2022 | Udemy
English | Size: 1.25 GB
Genre: eLearning

Microsoft SQL Server 2022 Database Administration

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

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

nitroflare.com/view/2285B13BD540BBE/UD-Microsoft-SQL-Server-2022-Database-Administration.part1.rar
nitroflare.com/view/2A56D9B858F16B2/UD-Microsoft-SQL-Server-2022-Database-Administration.part2.rar

rapidgator.net/file/447fd8beba5ce496405fadf8ce1db32a/UD-Microsoft-SQL-Server-2022-Database-Administration.part1.rar.html
rapidgator.net/file/727c986fbf4079e87ef92da03f78107c/UD-Microsoft-SQL-Server-2022-Database-Administration.part2.rar.html

If any links die or problem unrar, send request to
forms.gle/e557HbjJ5vatekDV9

Leave a Comment