Description
SQL Server Administration is SQL Server Administration Video Tutorial Name. The purpose of this course is to provide students with a specific objective to provide the necessary training. In this tutorial, you’ll learn how to set up and manage SQL Server yourself. You can also learn how to back up your data in this tutorial.
You’ll also tackle security and configuration issues in the SQL Server Administration training suite. This training kit consists of three parts. All three parts of this series are prepared for you in this post. By going through all three sections of this tutorial, you’ll become a pro at managing SQL Server.
SQL Server Administration Course Feature
With this tutorial, you will learn how to manage SQL servers to manage your server perfectly. You have 59 students in this course.
It should be noted that if you want to handle SQL Server administration professionally, you need to see the following sections of this tutorial. You can access the other two parts of this collection below.
SQL Server Administration Course Specifications:
- Publisher: Udemy
- Instructor: Raphael Asghar
- Level: Beginner to Advanced
- Duration: 28:52:16
- Number of lessons: 147 lessons
- English
SQL Server Management Headers
Administering SQL Server, Part 1
07:12
To download and install software
08:03
POST ADDENDUM
08:11
APPLICATION REQUIRED
07:34
CREATE VM
18:22
INSTALLATION SQL SERVER 2017
09:43
ADVENTUREWORKS 2017 DB
08:13
SQL 2014 VS 2017 COMPARISON
02:38
Create a domain controller for the virtual machine
06:00
Promote a domain controller to Active Directory
15:06
Create a Vm for SQL Server 2012 Installation Part 1
10:29 am
Creating vm for SQL Server 2012 Installation Part 2
13:46
Install SQL on a separate disk with service accounts, part 1
11:13
Install SQL on a separate disk with service accounts, part 2
13:23
Installing SP2 service packs and hotfixes
09:20
A tour of SQL Server Management Studio
10:28 am
Introduction to Database Systems
13:32
SQL Server data and log files
08:21
Detail Transaction log ATM example
07:35
Automatic growth and sizing of the transaction log
16:11
Types of recovery models
12:15 p.m
Function fn_dblog to view the transaction log
07:18
What is a VLF Virtual Log File?
11:22 a.m
Create a SQL database
14:06
The importance of tempdb
13:24
Adding and detaching a database
08:28
Introduction to backups
13:45
Full database backup
10:59
Transaction log backups
10:56 a.m
Different backups
08:16
Introduction to Restoration
05:19
Restore the database using the GUI
11:39
Restore the database using a differential
09:11
Recovery mode with tail log backup
11:56
Backing up using a maintenance plan
11:11
Backing up the database using a maintenance plan
10:33 am
Maintenance plan tasks
05:45
Do not shrink the database
15:43
Importance of using SQL Server Agent
07:58
Create a simple backup job using SQL Server Agent
05:20
Importance of DBCC CheckDB
09:38
Using SQL Server Agent in several steps
05:59
Configuring SQL Database Mail
10:58
Setting Up SQL Database Mail, Part 2
05:16
Setting up warnings for serious errors 17-25
14:23
Central administration with SQL Server Agent
00:52
Central administration with SQL Server Agent
12:21 p.m
Free VMware Pro Player installation for virtualization
17:44
Introduction to SQL Server Security
13:44
Demonstration of user login roles
11:43 am
Managing Security with T SQL
06:27
Choose authentication or mixed mode security
13:19
Access SQL Server via SQL Login
12:46 p.m
Understanding SQL Server Roles
11:45
Managing SQL Server roles via TSQL
05:57
Introduction to SQL Server Roles
12:59 p.m
SQL Server Rights Management
14:38
Best Practice Security for SQL Server
13:22
SQL Administration, Part 2 Table of Contents
00:53
Administering SQL Server, Part 2
06:28
14:40
Install SQL Suite
11:20
POST ADDENDUM
08:11
APPLICATION REQUIRED
07:34
CREATE VM
18:22
INSTALLATION SQL SERVER 2017
09:43
ADVENTUREWORKS 2017 DB
08:13
COMPARISON OF SQL SERVER 2014 VS 2017
02:38
A clustered index
16:59
Create a non-clustered index
12:07 p.m
Compound index
18:06
Use or not use indexes
11:20
Decisive factors in creating indexes
20:09
Using an SQL profile for indexes
19:41
Reorganizing and rebuilding indexes
15:47
to SQL Profiler
17:57
SQL Profiler’s longest running query
13:37
audit logins
12:11 p.m
SQL profile with index tuning
10:40 a.m
SQL Profiler Best Practice
05:24
SQL Server Sidetracking
16:31
Database Engine Tuning Advisor
12:10
Statistics
11:44 am
Activity monitor
14:01
SQL Performance Monitor
16:24
SQL performance hardware issues
12:49 p.m
SQL Performance Monitor Hardware Processor
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 a.m
A traffic jam
04:45
Extended events
18:20
Extended events via TSQL
11:59
Database snapshots
15:12
Import data export
10:01 am
BCP
12:59 p.m
septum
19:51
Part 2 of the section
19:51
Section 3
12:46 p.m
Embedded Database, Part 1
11:47 a.m
Included 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
APPLICATION REQUIRED
07:34
CREATE VM
18:22
INSTALLATION 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
Part 1 of installing Server1
11:15
Part 2 of installing Server1
09:34
Part 1 of Server 2 Installation
13:35
Part 2 of Server 2 Installation
13:25
Part 2 of Server 2 Installation
15:00
Part 4 of Installing Server 2
15:34
Log Shipping Part 1
15:33
Log Shipping Part 2
18:32
Log Shipping Part 3
17:06
Log Shipping Manual Troubleshoot Part 1
12:11 p.m
Log Shipping Manual Troubleshooting Part 2
10:48 am
Orphans
18:29
Log shipment tracking
14:16
Database mirroring
18:43
Database Mirroring Using the GUI Part 1
12:31 p.m
Database Mirroring Using the GUI Part 2
13:11
Monitoring Database Mirroring, Part 1
12:40 p.m
Monitoring Database Mirroring, Part 2
09:55
replication
12:43 p.m
Transaction Replication Part 1
11:15
Transaction Replication Part 2
12:35 p.m
Peer to Peer Replication Part 1
11:14
Peer to Peer Replication Part 2
12:44 p.m
Always there
17:19
Always On Required Part 1
09:53
Always On Part 2 Required
12:16 p.m
Always On Settings Cluster
14:40
Always part 1 of the demo
14:50
Always demo part 2
18:15
Backups
13:23
prerequisites:
Part 1: Although not \”required\”, it is highly recommended that students take my first T-SQL course – and have access to a desktop or laptop. All software, scripts, documentation are provided
Part 2: All a student needs is a laptop or desktop computer. If necessary, all material is downloaded via the Internet. Additionally, you need SQL Administration Part 1. All scripts and documents will be sent to me by the student as a ZIP file.
Part 3: It is strongly recommended that students complete SQL Administration Part 1 and SQL Administration Part 2 before taking this course, as it builds on the concepts taught and discussed in these courses. A course to learn T-SQL is also highly recommended. All materials and software needed by students are downloaded and I provide SQL scripts if needed.
Pictures
installation manual
After extraction, watch with your favorite player.