Download at MAXIMUM SPEED and remove 503 Error

Purchase a VIP membership and download using our fastest servers, up to 1Gb/s
If you get 503 error while downloading, Become VIP to download with unlimited connections.

Description

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.

SQL Server Administration course feature

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.

Specifications of the SQL Server Administration course:

  • Publisher: Udemy
  • Instructor: Raphael Asghar
  • Level: Basic to Advanced
  • Duration: 28:52:16
  • Number of lessons: 147 lessons
  • English language

SQL Server Administration headers

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

What is a VLF virtual log file

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

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

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

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

Orphans

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

prerequisites:

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.

Pictures

SQL Server Administration Part1

Installation guide

View with your favorite Player after Extract.

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

File password (s): www.downloadly.ir

Size

2 Comments. Leave new

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.
You need to agree with the terms to proceed

Menu