SQL Server Administration Part1
4.5 (367 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,134 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server Administration Part1 to your Wishlist.

Add to Wishlist

SQL Server Administration Part1

SQL Education with a purpose
Bestselling
4.5 (367 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,134 students enrolled
Created by Raphael Asghar
Last updated 3/2017
English
Learn Fest Sale
Current price: $10 Original price: $20 Discount: 50% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 9 hours on-demand video
  • 25 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 (Free) 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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 53 Lectures Collapse All 53 Lectures 09:10:47
+
SQL Server Administration Part 1
53 Lectures 09:10:47


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
About the Instructor
Raphael Asghar
4.6 Average rating
1,635 Reviews
18,520 Students
12 Courses
Production SQL Database Administrator

Worked as a Production SQL Database Administrator for over 12 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA.  I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.