Microsoft SQL Server 101
4.2 (63 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.
866 students enrolled
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.
4.2 (63 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.
866 students enrolled
Created by Shaun Stuart
Last updated 7/2015
English
Current price: $80 Original price: $95 Discount: 16% off
30-Day Money-Back Guarantee
Includes:
  • 5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
Requirements
  • Basic knowlege of T-SQL Is helpful, but not required
  • SQL Server 2012 suggested
Description

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
Curriculum For This Course
Expand All 41 Lectures Collapse All 41 Lectures 04:49:59
+
Introduction
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
01:36
+
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
08:29
+
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
04:30
+
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
15:23

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

Data And Log File Growth Settings
06:14

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
04:38

This lecture covers the important database option settings, what they do, and how they can affect performance.
Database Settings
06:28
+
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
11:09

This lecture contains a demo of backing up and restoring a database.
Backup And Restore Demo
06:55
+
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
13:47
+
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
14:43

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
05:55
+
Database Objects
4 Lectures 50:12
In this lecture, you will be given an overview of the database objects tables and views.
Tables
07:30

Views
04:58

Indexes and their maintenance are covered in this section.
Indexes
22:30

This lecture covers another type of database object: stored procedures.
Stored Procedures And Other Objects
15:14
6 More Sections
About the Instructor
Shaun Stuart
4.5 Average rating
103 Reviews
1,149 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.