SQL Server Administration Part1

SQL Education with a purpose
4.5 (152 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.
1,105 students enrolled Bestselling in SQL Server
$19
$50
62% off
Take This Course
  • Lectures 53
  • Length 9 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2015 English

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

What are the requirements?

  • While not 'mandatory', it is highly recommended that the student take my first course T-SQL - (Free) and have access to a desktop or laptop. All software, scripts, documentation will be provided

What am I going to get from this course?

  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: SQL Server Administration Part 1
What is a Domain
Preview
07:12
Software to download and install
Preview
08:03
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Raphael Asghar, Production SQL Database Administrator

Worked as a Production SQL Database Administrator for over 10 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Created five 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 enviroement. I want to pass that experience and information to my students.

Ready to start learning?
Take This Course