Description
SQL Server Administration , is the name of the video training series in the field of SQL server management. In this training series, it has been tried to provide the necessary training to the students with a specific purpose. In this training series, you will learn to prepare and manage a SQL server for yourself. In this tutorial, you will also learn how to backup your data.
In the SQL Server Administration training series, you will also master security and configuration issues. This training series consists of three parts. In this article, all three parts of this series have been prepared for you. You will become a professional in the field of managing SQL servers by viewing all three parts of this training series.
SQL Server Administration course feature
You will learn to manage your server in a complete and perfect way by using this video training series that is specific to managing SQL servers. In this training course, dear students, you will have 59 training sessions in front of you.
It should be noted that if you want to follow the management of SQL servers in a professional way, you will need to see the next parts of this educational series. You can access the other two parts of this series below.
Specifications of the SQL Server Administration training course:
- Publisher: Udemy
- Lecturer: Raphael Asghar
- Level: Introductory to Advanced
- Duration: 28:52:16
- Number of lessons: 147 lessons
- English language
SQL Server Administration topics
SQL Server Administration Part 1
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
Don’t 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 CONTENTS
00:53
SQL Server Administration Part 2
06:28
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 profiler for indexes
19:41
Reorganize and Rebuild Indexes
15:47
Into 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 Practices
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
Blocks 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 database Part 1
11:47
Contained database 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
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 p.m
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:
Part 1: 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
Part 2: 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.
Part 3: 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 need will be downloaded and the SQL scripts will be provided by me where applicable.
Pictures
Installation guide
After extracting, watch with your favorite player.
Be the first to comment