Published on: 2020-03-22 16:08:27
Categories: 28
Share:
SQL Server Administration is the name of a video tutorial on SQL Server management. This course aims to provide students with the specific purpose of providing the necessary training. You will learn in this tutorial how to set up and manage an SQL server for yourself. In this tutorial you will also learn how to back up your data.
In the SQL Server Administration training suite, you\’ll also tackle security and configuration issues. This training set consists of three sections. In this post all three sections of this series are prepared for you. By viewing all three sections of this tutorial you will become a professional in SQL Server management.
With this tutorial you will learn how to manage SQL servers to manage your server perfectly. In this course you will have 59 students in front of you.
It should be noted that if you want to professionally manage SQL Server management, you will need to view the next sections of this tutorial. At the bottom you can access the other two parts of this collection.
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 a 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 Database Systems
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
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 Severity Errors alerts 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
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 a 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
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 Data Export
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 2
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
18:29
Log Shipping Monitoring
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
Part1: While not \’mandatory\’, it is highly recommended that students take my first T-SQL course – 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 the internet. Plus, you\’ll need a pre-requisite SQL Administration Part 1. All scripts and documentation will be provided by the student to me via zip file.
Part3: It is strongly advised that students take SQL Administration Part 1 and SQL Administration Part 2 before taking this course as it builds on the concepts taught and discussed in those courses. Also, Learn T-SQL course is highly recommended. All the material and software that students need will be downloaded and the SQL scripts provided by me where applicable.
View with your favorite Player after Extract.
Sharing is caring: