Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Real World SQL Server From The Ground Up to your Wishlist.

Add to Wishlist

Real World SQL Server From The Ground Up

The First Course In A Series of Real World Insights On SQL Server
3.9 (158 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.
9,637 students enrolled
Created by Mike West
Last updated 3/2016
English
$10 $20 50% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 2 mins on-demand audio
  • 21 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Learn the sundry paths a SQL Server DBA can take.
Have a path that will lead you to a rewarding career as a SQL Server DBA.
We will download and install the free version of SQL Server so if you don't have it yet that's ok. It will be covered in the course.
View Curriculum
Requirements
  • We will download and install the free version of SQL Server so if you don't have it yet that's ok. I will be covered in the course.
  • You'll also need a fundamental understanding of computers.
  • There is no other cost other than the price of the course. Everything else is included or free.
Description

"Thanks for being a great inspiration as well, especially taking out your time to compile these courses on Udemy. You do an amazing job!" -- Oochay

Welcome to Real World SQL Server From The Ground Up.

SQL Server is one of the most complicated software offerings Microsoft has.

This builds upon my course "How To Begin Your Career As a SQL Server DBA." If you have't taken it please sign up an take it now. It's FREE!!

This course is my first course filmed entirely in 1080P.

This is the first in a multi-part series of courses on SQL Server Administration.

You need a solid foundation in networking, databases and programming. This wide range of skills is often difficult to obtain without rigorous learning and years of hands on experience.

This course is the first in a two part series that covers much of the foundation of what SQL Server DBAs do and what skills they need to attain in order to excel at their jobs.

All of my courses have a real world on component to them. We will cover the topics in our lectures then apply most of them to real world scenarios.

The REWARDS YOU will OBTAIN are worth the effort. Here are just a few. DBAs are very well compensated. YOU will get to work with some of the SMARTEST people in the IT world. You'll LEARN something EVERY DAY. The profession has been and will continue to be one of the highest growth professions. You'll often get to work remotely.

SQL Server Database Administrators are responsible for the design, implementation, support and maintenance of SQL Server Databases. The role also includes architecting, building and scaling databases for future data growth and capacity.

DBA are also responsible for security, performance and availability of data to users and customers.

This course will give you some direction on how to begin your journey as a SQL Server DBA. I don't want to create any false promises. In addition to years of experience most Senior Level SQL Server resources have read a voluminous amount of product related material.

WE have to start somewhere and THIS COURSE will provide you with the REAL WORLD insight YOU need in order to start your journey.

If YOU are seriously interested in either starting out on the path to becoming a SQL Server Database Administrator the YOU'LL need two key ingredients. Experience and product knowledge. Experience might not be easy to get but it will be impossible if you don't have a very solid foundation in SQL Server.

ENROLL now. Let's get started!!!

Who is the target audience?
  • There are no prerequisites for this course. If you have a basic knowledge of SQL Server then this course is for you.
  • This course will cover the bare minimum we need for our SQL Servers in a production environment.
  • Using the collegiate scale as a guide this course will be a 101 level course.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 44 Lectures Collapse All 44 Lectures 01:34:33
+
What Does a SQL Server DBA Do?
9 Lectures 25:27


What are some of the responsibilies of a DBA? Let's learn a few core aspects to the DBAs job.

Preview 05:41

You can only install SQL Server on a windows operating system.

Preview 00:59

The language of SQL Server is Transact-SQL. Let's learn about it in this lesson.

Preview 06:42

What Are The Different Jobs A DBA Can Have?
02:12

The fundamenal building blocks of the transaction. Let's learn what they are.

What Are The ACID Properties
01:32

Let's learn the core terms for this lesson.

Key Terms
00:46

Let's wrap up this section.

Summary
00:55

Quiz
10 questions
+
Installing SQL Server
8 Lectures 12:12

There are two types of instances in SQL Server. A default instance and a named instance. Let's learn about them in this lesson.

Preview 02:07

Each release of SQL Server may have different editions.

When we build out a box we need to be cognizant of the editions for each version.

Most of the time we will be installing Enterprise or Standard but there are outliers.

The Various Versions of SQL Server
00:20

Depending on the components that you decide to install, SQL Server Setup installs up to ten different services.

The Services SQL Server Uses
02:17

SQL Server 2008 collation settings depend on the type of installation. Typically, you should choose a SQL Server collation that supports the Windows system locale most commonly used at your organization.

What is Collation
00:45

Let's learn how to install the express edition in SQL Server.

Stepping Through A Basic Installation
04:37

SQL Server Configuration Manager is a tool to configure the network protocols used by the SQL Server, and to manage network connectivity.

The SQL Server Configuration Manager
00:43

Let's learn about the key terms in Section 2.

Key Terms
00:35

Let's wrap up what we've covered in this section.

Summary
00:45

Quiz
10 questions
+
Creating Our Database
5 Lectures 10:44

SQL Server has to have two files to be a database. Let's learn what they are.

Database Files
04:47

Why do we need a log file? Why isn't the data file enough. Le's learn why the log file is so critical to a database.

Why Do We Need A Log and Data File?
01:06

In this lesson let's learn how to create file groups for our database files.

File Groups
03:38

Let's cover the terminology of Section 3.

Key Terms
00:39

Let's summarize what we've convered in this section.

Summary
00:34

Quiz
10 questions
+
Manipulating Our Databases
5 Lectures 12:36

The easiest way to move a database is to detach, move and then attach it. Let's learn how to do this.

Detach and Attach. The Fastest Way To Move a SQL Server Database.
03:47

Databases live in a different states. Let's cover them in this lecture.

The States of a Database
03:11

In his lecture let's lean how to modify our existing databases.

Modifying A SQL Server Database
04:31

The cover some new vernacular on working with database files.

Key Terms
00:32

Let's wrap up what we've learned in this section.

Summary
00:35

Section 4 Quiz
10 questions
+
The Table Object
5 Lectures 14:22

The table object is the most important one in SQL Server. Let's learn the basics on creating them.

Table Basics - Part 1
05:17

Let's continue to learn how to define the basics of our tables.

Table Basics - Part 2
03:49

A table can be a heap or a table with a clustered index.

Let's learn the differences.

Heap Versus Table With Clustered Index
02:53

Let's learn the key terms for this section.

Key Terms
01:41

Let's wrap up what we've covered in this course.

Summary
00:42

Section 5 Quiz
10 questions
+
Transact-SQL. The Language of SQL Server
5 Lectures 11:54

There are two branches within transact-sql. Let's learn the difference between DML and DDL.

DML and DDL
01:41

In his lecture let's learn the very basics of the most commonly used statement in all database systems.

The Anatomy of a SELECT Statement
04:09

There are 4 core things we do to manipulate data.

Let's learn what they are in this lesson.

The Big 4
05:14

Let's learn the vernacular of creating out tables.

Key Terms
00:23

Let's wrap up what we've covered in Section 6.

Summary
00:26

Section 6 Quiz
10 questions
+
The Fundamentals of Stored Procedures
5 Lectures 06:56

Let's learn how to create our first stored procedure.

Defining and Creating Our First Stored Procedure
02:47

Let's take our stored procedure statement one more step.

Passing Parameters Into Our Stored Procedures
02:32

Every time we execute a query SQL Serve stores the plan in cache.

Let's learn what a plan cache is.

What's A Plan?
00:50

Let's learn the key terms for Section 7.

Key Terms
00:24

Let's wrap up what we've learned in Section 7.

Summary
00:22

Section 7 Quiz
10 questions
+
Conclusion
2 Lectures 01:08

Thanks for taking my course. You've reached the end of this course.

Congratulations and Thank you!!!
00:24

Bonus Lecture: What Course Should You Take Next?
00:43
About the Instructor
4.2 Average rating
1,554 Reviews
27,816 Students
31 Courses
SQL Server 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.

Report Abuse