Udemy – SQL Server Administration Part 1/2/3

Description

SQL Server Administration is the name of a video tutorial on SQL server management. In this educational series, an attempt has been made to provide the necessary training to students with a specific purpose. In this tutorial you will learn how to set up and manage an SQL server. In this tutorial you will also learn how to back up your data.

In the SQL Server Administration training suite, you will also master security and configuration issues. This educational set consists of three parts. In this article, all three parts of this collection have been prepared for you. By viewing all three sections of this tutorial, you will become a professional in managing SQL Servers.

SQL Server Administration course feature

With this video tutorial, which is dedicated to managing SQL servers, you will learn to manage your server completely and flawlessly. In this training course, you, dear students, will have 59 training sessions in front of you.

It should be noted that if you want to follow the SQL Server management professionally, you will need to view the next sections of this tutorial. Below you can access the other two sections of this collection.

SQL Server Administration course information

Publisher: Udemy

Instructor: Raphael Asghar

Level: Basic to Advanced

Duration: 28:52:16

Number of lessons: 147 lessons

English language

SQL Server Administration Headings

SQL Server Administration Part 1

What is a Domain

07:12

Software to download and install

08:03

POST ADDENDUM

08:11

APPS NEEDED

07:34

CREATE VM

18:22

INSTALL SQL SERVER 2017

09:43

ADVENTUREWORKS 2017 DB

08:13

COMPARISON OF SQL 2014 VS 2017

02:38

Create Virtual Machine Domain Controller

06:00

Promote Domain Controller to Active Directory

15:06

Create Vm for SQL Server 2012 Install Part1

10:29

Create Vm for SQL Server 2012 Install Part 2

13:46

Install SQL On Separate Drive with Service Accounts Part 1

11:13

Install SQL On Separate Drive with Service Accounts Part 2

13:23

Installing Service Packs and Fixes SP2

09:20

Touring SQL Server Management Studio

10:28

Introduction to System Databases

13:32

SQL Server Data and Log Files

08:21

Detail Transaction log ATM Example

07:35

Auto Growth and sizing of transaction log

16:11

Types of Recovery Models

12:15

Function fn_dblog to view inside a transaction log

07:18

What is virtual log file VLF

11:22

Create a SQL database

14:06

The importance of Tempdb

13:24

Attach and detach a database

08:28

Introduction to Backups

13:45

Full Database Backup

10:59

Transactional Log Backups

10:56

Differential Backups

08:16

Introduction to Restore

05:19

Restore database with GUI

11:39

Restore database using differential

09:11

Recovery mode with tail log backup

11:56

Backup using Maintenance plan

11:11

Backup database using Maintenance plan

10:33

Maintenance Plan Tasks

05:45

Dont shrink a database

15:43

The importance of using SQL Server Agent

07:58

Create a simple backup job using SQL Server Agent

05:20

The importance of DBCC CheckDB

09:38

Using SQL Server Agent with multiple steps

05:59

Setting up SQL Database Mail

10:58

Setting up SQL Database Mail Part2

05:16

Setting up alerts Severity Errors from 17 to 25

14:23

Central Management with SQL Server Agent

00:52

Central Management with SQL Server Agent

12:21

Installing free VMware Pro Player for virtualization

17:44

Introduction to SQL Server Security

13:44

Demonstration of Users Logins Roles

11:43

Managing security with T SQL

06:27

Selecting Authentication or Mixed Mode security

13:19

Accessing SQL Server using SQL Login

12:46

Understanding SQL Server Roles

11:45

Managing SQL Server Roles via TSQL

05:57

SQL Server Roles Demonstration

12:59

Managing SQL Server Permissions

14:38

Best SQL Server Practice Security

13:22

SQL ADMINISTRATION PART 2 TABLE OF CONTENT

00:53

SQL Server Administration Part 2

Introduction

06:28

Install SQL Server 214

14:40

Install SQL Suite

11:20

POST ADDENDUM

08:11

APPS NEEDED

07:34

CREATE VM

18:22

INSTALL SQL SERVER 2017

09:43

ADVENTUREWORKS 2017 DB

08:13

COMPARISON SQL SERVER 2014 VS 2017

02:38

Clustered Index

16:59

Create non cluster index

12:07

Composite Index

18:06

Use or not use indexes

11:20

Deciding factors in creating indexes

20:09

Using sql profler for indexes

19:41

Reorganize and Rebuild Indexes

15:47

Into To SQL Profiler

17:57

SQL Profiler longest running query

13:37

Audit logins

12:11

SQL Profile with Index Tuning

10:40

SQL Profiler Best Practice

05:24

SQL Server Side Trace

16:31

Database Engine Tuning Advisor

12:10

Statistics

11:44

Activity Monitor

14:01

SQL Performance Monitor

16:24

SQL Performance hardware issues

12:49

SQL Performance Monitoring Hardware CPU

16:47

SQL Performance Monitoring Hardware memory

10:10

SQL Performance Monitoring Hardware disks

08:46

23 SQL Perfmon scehdule

08:51

DMV

13:53

Block and Locks

13:15

BLOCKING

10:45

Deadlock

04:45

Extended Events

18:20

Extended Events via TSQL

11:59

Database Snapshots

15:12

Import Export Data

10:01

BCP

12:59

Partition

19:51

Partition part 2

19:51

Partition 3

12:46

Contained datababase Part 1

11:47

Contained datababase Part 2

10:12

Policy Based Management

18:46

Linked Servers

08:20

SQL server and agent logs

05:24

SQL ADMINISTRATION PART 3

05:32

SQL Server Administration Part 3

Getting A SQL DBA Job

06:35

VMware Workstation 12 and Domain Controller Part 1

19:59

POST ADDENDUM

08:11

APPS NEEDED

07:34

CREATE VM

18:22

INSTALL SQL SERVER 2017

09:43

ADVENTUREWORKS 2017 DB

08:13

COMPARISON SQL 2014 VS 2017

02:38

VMware Workstation 12 and Domain Controller Part 2

19:50

Server1 installation part 1

11:15

Server1 installation part 2

09:34

Server 2 installation part 1

13:35

Server 2 installation part 2

13:25

Server 2 installation part 3

15:00

Server 2 installation part 4

15:34

Log Shipping Part 1

15:33

Log Shipping Part 2

18:32

Log Shipping Part 3

17:06

Log shipping Manual Failover part 1

12:11

Log shipping Manual Failover part 2

10:48

Orphans

18:29

Monitoring Log Shipping

14:16

Database Mirroring

18:43

Database Mirroring using GUI part 1

12:31

Database Mirroring using GUI part 2

13:11

Database Mirroring Monitoring part 1

12:40

Database Mirroring Monitoring part 2

09:55

Replication

12:43

Transactional Replication part 1

11:15

Transactional Replication part 2

12:35

Peer to Peer Replication part 1

11:14

Peer to Peer Replication part 2

12:44

Always On

17:19

Always On Requisite part 1

09:53

Always On Requisite part 2

12:16

Always On Setup Cluster

14:40

Always On Demo part 1

14:50

Always On Demo part 2

18:15

Backup Replicas

13:23

Prerequisites

Part1: While not ‘mandatory’, it is highly recommended that the student take my first course T-SQL – and have access to a desktop or laptop. All software, scripts, documentation will be provided

Part2: All the student needs is a laptop or a desktop. All material where appropriate will be downloaded via internet. Plus, you will need as a pre-requisite SQL Administration Part 1. All scripts and documentation will be provided by me to the student via zip file.

Part3: It is strongly advised that students take SQL Administration Part 1 and SQL Administration Part 2 first before taking this course as this builds upon the concepts taught and discussed in those courses. Also, Learn T-SQL course is highly recommended. All the material and software that the students needs will be downloaded and the SQL scripts will be provided by me where applicable.

Installation

After Extract, watch with your favorite Player.