Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
|Section 2: What Is A Database Management System?|
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|
This section describes the various editions of Microsoft SQL Server, their features, and the program components that make up SQL Server.
|SQL Server licensing in a complex topic. This lecture gives an overview of the different licensing models.
|Section 4: SQL Server Management Studio|
|This section introduces you to SQL Server Management Studio, the graphical tool for managing SQL Server.
|Section 5: SQL Server System Databases|
|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|
|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.
In this section, you will learn about the growth settings for files and their performance implications.
|In this section, you will learn about some other files SQL Server uses, as well as file groups and when they are used.
|This lecture covers the important database option settings, what they do, and how they can affect performance.
|Section 7: Backups And Recovery|
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...")
|This lecture contains a demo of backing up and restoring a database.
|Section 8: SQL Server Agent|
|In this section, you will learn about SQL Server Agent, the event scheduling portion of SQL Server.
|Section 9: SQL Server Management Features|
|In this section, you will learn how to use SQL Server Management Studio to manage your SQL Servers.
|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|
|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.
|Section 11: SQL Server Security|
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.
|This section presents a demonstration of using schemas.
|Section 12: Data Compression|
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|
|This lecture discusses the high availability solution of server clustering.
|This lecture discusses the high availability solution of replication.|
|This lecture discusses the high availability solution of log shipping.
|This lecture discusses the high availability solution of mirroring.
|This lecture discusses the high availability solution of AlwaysOn.
|Section 14: Suggested Mainenance Jobs|
|In this section, you will learn about some basic maintenance jobs you should be performing. This lecture covers backups. A demo is included.
|This lecture covers the limitations of the previous backup methodology and how to devise a better method.|
|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.|
|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.|
|In this section, you will learn about some basic maintenance jobs you should be performing. This lecture covers error logs. A demo is included.|
|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.|
|In this section, you will learn about some basic maintenance jobs you should be performing. This lecture covers consistency checking. A demo is included.|
|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|
|After completing this lesson, you will be able to identify your SQL Server's version and service pack level, including any patches or hotfixes.
|This lecture will show you how to troubleshoot user log in issues.
|This lecture will provide you methods for troubleshooting poor performance due to blocking. A demo is included.
|This lecture shows you how to examine SQL Server wait states and what they mean. A demo is included.
|In this lecture, you will learn why it is important to create a baseline of your SQL Server's performance.
|Section 16: Conclusion|
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.