SQL Server Internals and Architecture Overview (Udemy.com)

A Real World Introduction to SQL Server Internals

( 30 Reviews )

Created by: Mike West

Produced in 2016

What you will learn

At the conclusion of this course you'll understand how data is stored.
You'll also understand the anatomy of a Page. The fundamental unit of storage in SQL Server.
You'll learn how to correctly use several well known but undocumented commands to examine pages.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 76 / 100

Course Description

SQL Server is a massive, complex product.
One DBCC command can have over one hundred thousand lines of code.
Once you've learned the basics creating tables, inserting data, backing up databases then what?
The daily routine of a database developer or DBA often doesn't involve internal structures.
I've been driving for 30 years but don't know the parts to my car's engine. Well, I'm not mechanic either.
If you want to understand how SQL Server really operates then you have to undertake a study of how the two core engines of SQL Server work with one another.
The storage engine stores data and the optimizer processes queries.
This course will provide you with a solid foundation in storage internals. We are going to cover how data is stored at a very low level.
You'll learn the vernacular specific to the page and several new commands that will provide us with some deep insight into what any how SQL Server stores data.
We will cover the data row structure and the transaction log and by the end of this course you'll understand how data moves in SQL Server.
This knowledge will help you troubleshoot SQL Server at a level most DBAs simply don't grasp. We will look at examples and code syntax to determine what works and what doesn't.
Any relational database is a collection of objects, the table being the most fundamental.
However, what they are and what they do are two different things. Relational databases have entities called transactions that transfer and manipulate data.
This course will focus on how and what these transactions are moving.
Thanks for you interest in SQL Server Internals.
I'll see you in the course!!!Who this course is for:

This is a mid level course for those with a solid foundation in SQL Server.
This is not an entry level course.
Everything you need for the course will be included in the course.

Time: 1h

Instructor Details

Mike West

3.8 Rating
30 Reviews

Machine Learning Enthusiast
I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.
Over the last five years I've transitioned to the exciting world of applied machine learning. I'm excited to show you what I've learned and help you move into one of the single most important fields in this space.
Experience, education and passion
I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.
Certifications
Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).
Personal
Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my w