Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Microsoft SQL Server 101 to your Wishlist.

Add to Wishlist

Microsoft SQL Server 101

Everything you need to know about Microsoft SQL Server 2012 if you are a new, junior, or involuntary DBA.
3.8 (55 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.
849 students enrolled
Created by Shaun Stuart
Last updated 7/2015
$10 $95 89% off
4 days left at this price!
30-Day Money-Back Guarantee
  • 5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

This course will provide the non-DBA with everything they need to effectively manage SQL Server - an overview of Microsoft SQL Server 2012, basic database concepts, and suggested maintenance jobs to keep your SQL Server running smoothly. The course includes videos, demos, sample T-SQL scripts, and suggested resources for more in-depth study. Total time is slightly over 4.5 hours. This course is designed for new or junior Database Administrators or non-database professionals who need to maintain the SQL Server systems in their environment.

Who is the target audience?
  • New database administrators
  • Junior database administrators
  • Non-database professionals
Students Who Viewed This Course Also Viewed
What Will I Learn?
Over 4.5 hours of content!
By the end of this course, you will understand basic database concepts
You will know how to use SSMS to manage your SQL Server
You will know how to perform and schedule basic database maintenance tasks
You will know how to perform basic troubleshooting
View Curriculum
  • Basic knowlege of T-SQL Is helpful, but not required
  • SQL Server 2012 suggested
Curriculum For This Course
Expand All 41 Lectures Collapse All 41 Lectures 04:49:59
1 Lecture 02:24
What Is A Database Management System?
1 Lecture 05:42
In this section, you will learn about the different types of database systems, relational and non-relational, and which type Microsoft SQL Server is.
Preview 05:42
Microsoft SQL Server
2 Lectures 07:09
This section describes the various editions of Microsoft SQL Server, their features, and the program components that make up SQL Server.
Preview 05:33

SQL Server licensing in a complex topic. This lecture gives an overview of the different licensing models.
Microsoft SQL Server Licensing
SQL Server Management Studio
1 Lecture 08:29
This section introduces you to SQL Server Management Studio, the graphical tool for managing SQL Server.
Using SQL Server Management Studio
SQL Server System Databases
1 Lecture 04:30
In this lecture, you will learn about the system databases that are present in every SQL Server installation and what information is stored in them.
SQL Server System Databases
Database Files And Options
4 Lectures 32:43
SQL Server databases uses data and log files to store information. This section covers basic details of each type of file and important concepts for managing them.
Data And Log Files

In this section, you will learn about the growth settings for files and their performance implications.

Data And Log File Growth Settings

In this section, you will learn about some other files SQL Server uses, as well as file groups and when they are used.
Filegroups and Full Text Indexes

This lecture covers the important database option settings, what they do, and how they can affect performance.
Database Settings
Backups And Recovery
2 Lectures 18:04

The different database recovery models are presented in this section, as well as how they relate to backup methods. (Note: There is a slight error at the 7:24 mark in the video. In the example, I say "...restore the Sunday night full backup, the Thursday night full backup..." It should be "...restore the Sunday night full backup, the Thursday night DIFFERENTIAL backup...")

Recovery Models and Backup Types

This lecture contains a demo of backing up and restoring a database.
Backup And Restore Demo
SQL Server Agent
1 Lecture 13:47
In this section, you will learn about SQL Server Agent, the event scheduling portion of SQL Server.
An Introduction To SQL Server Agent
SQL Server Management Features
2 Lectures 20:38
In this section, you will learn how to use SQL Server Management Studio to manage your SQL Servers.
Management Features In SSMS

This module describes the dedicated administrator connection of SQL Server, when it should be used, and its limitations. It includes a demo.
The Dedicated Administrator Connection
Database Objects
4 Lectures 50:12
In this lecture, you will be given an overview of the database objects tables and views.


Indexes and their maintenance are covered in this section.

This lecture covers another type of database object: stored procedures.
Stored Procedures And Other Objects
6 More Sections
About the Instructor
4.0 Average rating
93 Reviews
1,113 Students
4 Courses
Senior SQL Server Database Administrator And Author

Shaun J. Stuart is a Database Administrator with over 15 years experience with SQL Server. He holds the following Microsoft certifications: MCTS: SQL Server 2005, MCTS: SQL Server 2008, MCITP: Database Administrator 2008, and MCSA: SQL Server 2012. He is the senior Database Administrator at the largest credit union in Arizona and a co-author of the book Tribal SQL: New Voices In SQL Server, published by Red Gate. He holds a Bachelors degree in electrical engineering.

Report Abuse