SQL Server Administration Part1
4.5 (2,402 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10,761 students enrolled

SQL Server Administration Part1

SQL Education with a purpose
Bestseller
4.5 (2,402 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10,761 students enrolled
Created by Raphael Asghar
Last updated 1/2019
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 10 hours on-demand video
  • 35 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Manage SQL Server Administration; install SQL Server in a Production environment following best practice, review storage, data and log files necessities, understand the importance of backups and restores, configure security and more
Course content
Expand 59 lectures 10:05:28
+ SQL Server Administration Part 1
59 lectures 10:05:28
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 (SSMS)
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 (CORRECTION)
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
Requirements
  • 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
Description

The following course will introduce to you the foundation of SQL Server Administration Part 1 as it's practiced in the production real world situations. I have designed this course for the beginner but at the same time introduced elements that are practiced in the real world, so the student gains a faster understanding of the requirements in the production server. Anyone interested in understanding, configuring, managing or is responsible for SQL Server systems will benefit from this course. My first course T-SQL, while not mandatory, should be taken so you gain a better understanding of this course. All software, SQL Scripts and documentation is provided for you. All you need is a desire to learn and fullfill you future goals. These courses will give you that direction.

Who this course is for:
  • I have designed the course for beginners that want to learn how to manage a SQL Server. With examples that are practiced in the real world, the student will valuable lessons that is not taught in books. It is also designed for experienced network adminstrators,developers, programmers, analysts and accidental dbas that want to learn SQL Administration