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 (46 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.
788 students enrolled
Instructed by Shaun Stuart Development / Databases
$95
Take This Course
  • Lectures 41
  • Contents Video: 5 hours
  • Skill Level All Levels
  • 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 7/2013 English

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

What are the requirements?

  • Basic knowlege of T-SQL Is helpful, but not required
  • SQL Server 2012 suggested

What am I going to get from this course?

  • 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

What is the target audience?

  • New database administrators
  • Junior database administrators
  • Non-database professionals

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: Introduction
Welcome!
Preview
02:24
Section 2: What Is A Database Management System?
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.
Section 3: Microsoft SQL Server
05:33
This section describes the various editions of Microsoft SQL Server, their features, and the program components that make up SQL Server.
01:36
SQL Server licensing in a complex topic. This lecture gives an overview of the different licensing models.
Section 4: SQL Server Management Studio
08:29
This section introduces you to SQL Server Management Studio, the graphical tool for managing SQL Server.
Section 5: SQL Server System Databases
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.
Section 6: Database Files And Options
15:23
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.
06:14

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

04:38
In this section, you will learn about some other files SQL Server uses, as well as file groups and when they are used.
06:28
This lecture covers the important database option settings, what they do, and how they can affect performance.
Section 7: Backups And Recovery
11:09

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...")

06:55
This lecture contains a demo of backing up and restoring a database.
Section 8: SQL Server Agent
13:47
In this section, you will learn about SQL Server Agent, the event scheduling portion of SQL Server.
Section 9: SQL Server Management Features
14:43
In this section, you will learn how to use SQL Server Management Studio to manage your SQL Servers.
05:55
This module describes the dedicated administrator connection of SQL Server, when it should be used, and its limitations. It includes a demo.
Section 10: Database Objects
07:30
In this lecture, you will be given an overview of the database objects tables and views.
Views
04:58
22:30
Indexes and their maintenance are covered in this section.
15:14
This lecture covers another type of database object: stored procedures.
Section 11: SQL Server Security
22:24

In this lecture, you will learn about the basic security model used by SQL Server. You will be introduced to the pre-defined security roles, the permissions granted by each, and when they should be used. You will also learn about database schemas.

03:44
This section presents a demonstration of using schemas.
Section 12: Data Compression
06:04

In this lecture, you will learn about the Enterprise-only feature of data compression and how it can help performance. (Note: I have a 1.5 hour course that discusses Data Compression in much more detail. It is available at https://www.udemy.com/understanding-data-compression-in-sql-server/)

Section 13: High Availablity Solutions
05:14
This lecture discusses the high availability solution of server clustering.
04:42
This lecture discusses the high availability solution of replication.
01:58
This lecture discusses the high availability solution of log shipping.
07:18
This lecture discusses the high availability solution of mirroring.
02:00
This lecture discusses the high availability solution of AlwaysOn.
Section 14: Suggested Mainenance Jobs
12:11
In this section, you will learn about some basic maintenance jobs you should be performing. This lecture covers backups. A demo is included.
02:45
This lecture covers the limitations of the previous backup methodology and how to devise a better method.
06:42
In this section, you will learn about some basic maintenance jobs you should be performing. This lecture covers backup history maintenace. A demo is included.
16:04
In this section, you will learn about some basic maintenance jobs you should be performing. This lecture covers index and statistics maintenance. A demo is included.
03:04
In this section, you will learn about some basic maintenance jobs you should be performing. This lecture covers error logs. A demo is included.
02:00
In this section, you will learn about some basic maintenance jobs you should be performing. This lecture covers database mail maintenance. A demo is included.
05:12
In this section, you will learn about some basic maintenance jobs you should be performing. This lecture covers consistency checking. A demo is included.
01:40
In this section, you will learn about some basic maintenance jobs you should be performing. This lecture covers data compression maintenance and the reasons you may or may not need it.
Section 15: Basic Troubleshooting Tools
02:55
After completing this lesson, you will be able to identify your SQL Server's version and service pack level, including any patches or hotfixes.
03:36
This lecture will show you how to troubleshoot user log in issues.
07:02
This lecture will provide you methods for troubleshooting poor performance due to blocking. A demo is included.
05:13
This lecture shows you how to examine SQL Server wait states and what they mean. A demo is included.
03:30
In this lecture, you will learn why it is important to create a baseline of your SQL Server's performance.
Section 16: Conclusion
Wrap Up
01:03

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Shaun Stuart, 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.

Ready to start learning?
Take This Course