Architecting Very large Databases in SQL Server
3.6 (33 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.
227 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Architecting Very large Databases in SQL Server to your Wishlist.

Add to Wishlist

Architecting Very large Databases in SQL Server

A Step by Step Guide to Building VLDBs
3.6 (33 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.
227 students enrolled
Created by Mike West
Last updated 6/2016
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 4 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • By the end of the course you'll have a solid understanding on how to architect VLDBs.
  • You'll be able to create a scalable architecture that scales horizontally regardless of database size.
View Curriculum
Requirements
  • You'll need a copy of SQL Server *ENTERPRISE* edition to complete many of these exercises.
  • Many VLDB features are for Enterprise SQL Server customers.
  • If you don't have an Enterprise Edition you can still watch and learn how to architect these larger scale boxes by watching the courses.
Description

Recent Reviews from other Course: 

Clear concise and informative – Thomas

Clear and step-by-step information – Rosalia 

The course was well structured from start to finish. Keep up the good work. – Arina

Course Summary

VLDB is an acronym. It stands for Very Large Database.  The term is not specific to SQL Server. 

What constitutes a VLDB is always up for discussion.  It’s my opinion that any database over 100 gig should be designed and tuned much more granularly than smaller databases.  

For the purposes of this course I’ll use the benchmark of 100 gig for a VLDB. 

In this course we will learn how to design a VLDB for SQL Server. We will also look at some additional measures you’ll need to take from a performance tuning perspective

In the course we will be highlighting practices you should consider implementing in order to maximize scale and performance of your VLDBs. 

This course will take a real world approach. That simply means you will be able to take what you’ve learned in the lessons and build out a real world VLDB.  

Thanks for your interest in “Architecting Very Large Databases in SQL Server.” 

The first 10 minutes are free on every Udemy course. Please take a moment to watch all ten minutes to ensure this course is right for you. 

It's also a good idea to read over the lecture titles. The titles will provide you with insight into what's really in the course. 

Who is the target audience?
  • This course is for any mid-teir SQL Server resources that want to learn how to architect larger scale databases.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Course Introduction
8 Lectures 16:21

Let's cover the course at a very high level.

Preview 01:09

Is this course right for you. 

Are you here to learn about VLDBs? 

Preview 01:35

Course Downloads
00:00

Let's cover a very basic disk to data file and filegroup layout. 

Preview 03:02

Let's add a new file group and data file. 

Preview 04:36

Let's learn how to kill all the users in a given database so we can alter our schema. 

Preview 01:57

Let's learn how to move schema and data between filegroups. 

Demo: Move Table and Data Between FileGroups
03:21

Let's highlight what we've covered in this introductory section.

Summary
00:41

Quiz
5 questions
+
Building For Scale
11 Lectures 39:14

Multiple data files on smaller data files is a good idea. 

Multiple data files on VLDS is a requirement. 

Let's create some. 

Demo: Creating Multiple Data Files
04:10

What is IFI and why should we enable it? 

Demo: Enabling Instant File Initialization
04:25

Let's define what table partitioning is.

The Basic of Horizontal Partitioning
03:32

Let's demo how to start partitioning our table.

Demo: Horizontally Partitioning a Table
04:18

Let's learn how to compress out data and what data we should compress.

Demo: Row and Page level Compression
02:13

Let's continue learning about compression but this time on a partitioned table.

Demo: Enable Compression on Partitioned Table
02:12

All VLDB should be using back up compression.

Let's learn how to implement it.

Demo: Using Backup Compression
02:53

Let's back up to more than one backup file.

Demo: Backing Up to Multiple Files
04:51

Let's set up tempdb correctly for our VLDBs.

Demo: Setting Up Tempdb Correctly
05:23

Let's rebuild our indexes with a higher level of granularity.

Demo: Smart Maintenance: Rebuilding Indexes Selectively with Ola
04:11

Let's wrap up the high points of this section.

Summary
01:06

Quiz
10 questions
+
Conclusion
1 Lecture 00:18

Thanks for taking my course.

Final Thoughts. Thank you
00:18
About the Instructor
Mike West
4.1 Average rating
2,601 Reviews
42,965 Students
40 Courses
SQL Server and Machine Learning Evangelist

I've been a production SQL Server DBA most of my career.

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.

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 wife and two children.