Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Architecting Very large Databases in SQL Server
Rating: 3.9 out of 5(71 ratings)
401 students

Architecting Very large Databases in SQL Server

A Step by Step Guide to Building VLDBs
Created byMike West
Last updated 6/2016
English

What you'll 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.

Course content

3 sections • 20 lectures • 55m total length

  • Course Introduction1:09

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

  • Is this Course Right for You?1:35

    Is this course right for you. 

    Are you here to learn about VLDBs? 

  • Course Downloads
  • Simple Disk Layout (SAN and Locally Attached Storage)3:02

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

  • Demo: Adding a New FileGroup and Data File4:36

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

  • Demo: Kill All Users in Database (The Fool Proof Way)1:57

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

  • Demo: Move Table and Data Between FileGroups3:21

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

  • Summary0:40

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

  • Quiz

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 this course is for:

  • This course is for any mid-teir SQL Server resources that want to learn how to architect larger scale databases.

Report abuse