Download Udemy – SQL Server Administration Part 1/2/3

SQL Server Administration

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

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

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

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 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

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 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.

download link

Udemy – SQL Server Administration Part 1

Download part 1 – 1 GB

Download part 2 – 582 MB

Udemy – SQL Server Administration Part 2

Download part 1 – 1 GB

Download part 2 – 808 MB

Udemy – SQL Server Administration Part 3 2017-3

Download part 1 – 1 GB

Download part 2 – 234 MB

Password file(s): www.downloadly.ir

Size

4.2/5 – (13386 points)

Be the first to comment

Leave a Reply

Your email address will not be published.


*