Real World SQL Server From The Ground Up

The First Course In A Series of Real World Insights On SQL Server

All Levels 4.0(444 Ratings) 21,562 Students enrolled
Created by Mike West Last updated 03/2016 English English [Auto-generated]
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.

Curriculum for this course
51 Lectures 01:17:40
What Does a SQL Server DBA Do?
6 Lectures 00:21:34
  • Course Introduction. What are we going to learn? 00:01:28
  • What Does A Database Do? It's Different Than What It Is. 00:05:12
  • DBA Daily Look 00:05:41
  • Where Do I Install It SQL Server? 00:00:59
  • The Language of SQL Server 00:06:42
  • What Are The ACID Properties 00:01:32
  • What Are The Different Jobs A DBA Can Have? 00:02:12
  • Quiz 10 questions
  • Key Terms 00:00:46 Summary 00:00:55
  • SQL Server Instances Explained 00:02:07
  • Stepping Through A Basic Installation 00:04:37
  • Quiz 10 questions
  • The Various Versions of SQL Server 00:00:20 The Services SQL Server Uses 00:02:17 What is Collation 00:00:45 The SQL Server Configuration Manager 00:00:43 Key Terms 00:00:35 Summary 00:00:45
  • Database Files 00:04:47
  • Why Do We Need A Log and Data File? 00:01:06
  • File Groups 00:03:38
  • Quiz 10 questions
  • Key Terms 00:00:39 Summary 00:00:34
  • Detach and Attach. The Fastest Way To Move a SQL Server Database. 00:03:47
  • The States of a Database 00:03:11
  • Modifying A SQL Server Database 00:04:31
  • Section 4 Quiz 10 questions
  • Key Terms 00:00:32 Summary 00:00:35
  • Table Basics - Part 1 00:05:17
  • Table Basics - Part 2 00:03:49
  • Heap Versus Table With Clustered Index 00:02:53
  • Section 5 Quiz 10 questions
  • Key Terms 00:01:41 Summary 00:00:42
  • DML and DDL 00:01:41
  • The Anatomy of a SELECT Statement 00:04:09
  • The Big 4 00:05:14
  • Section 6 Quiz 10 questions
  • Key Terms 00:00:23 Summary 00:00:26
  • Defining and Creating Our First Stored Procedure 00:02:47
  • Passing Parameters Into Our Stored Procedures 00:02:32
  • Section 7 Quiz 10 questions
  • What's A Plan? 00:00:50 Key Terms 00:00:24 Summary 00:00:22
    Congratulations and Thank you!!! 00:00:24 Bonus Lecture: What Course Should You Take Next? 00:00:43
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.
+ View more
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!!!

+ View more
Other related courses
02:09:53
3.8 31 $199.99 Free
00:50:26
4 14 Free
01:00:12
4.3 3 Free
01:01:54
4.1 13 Free
00:33:24
0 3 Free
00:42:42
4.2 7 Free
00:56:34
Updated Thu, 05-Dec-2019
3.4 4 Free
05:15:50
Updated Thu, 28-Nov-2019
4.1 2 Free
00:42:11
Updated Sat, 23-Nov-2019
3 5 $24.99 Free
01:14:17
3.3 10 Free
01:51:35
4.1 5 Free
05:55:01
4.3 12 Free
00:53:58
Updated Sat, 23-Nov-2019
0 9 Free
01:20:36
0 4 $19.99 Free
01:03:41
Updated Wed, 04-Dec-2019
4.1 12 Free
00:31:29
3.5 2 Free
01:14:11
Updated Tue, 10-Dec-2019
2.3 6 $19.99 Free
00:55:57
Updated Thu, 03-Oct-2019
4 4 Free
01:08:50
4.1 3 Free
02:16:04
Updated Thu, 14-Nov-2019
4.2 1 Free
01:34:19
0 4 Free
00:39:03
3.2 9 $19.99 Free
00:51:37
1 4 $19.99 Free
04:27:35
4.4 1 Free
01:20:43
Updated Fri, 26-Oct-2018
4 2 $19.99 Free
01:36:13
3.3 4 Free
01:48:23
Updated Wed, 13-Nov-2019
4.1 6 $19.99 Free
00:35:04
0 1 Free
02:16:03
3.7 10 Free
01:03:14
Updated Thu, 25-Oct-2018
4 6 Free
00:32:51
3 5 Free
07:37:33
4.5 11 $19.99 Free
01:41:15
Updated Wed, 27-Nov-2019
3.6 6 Free
00:38:01
Updated Sun, 29-Dec-2019
4.1 6 $34.99 Free
01:12:44
4.1 4 Free
03:14:28
4.1 19 Free
09:39:56
Updated Mon, 22-Jul-2019
3.9 6 Free
01:18:34
3.8 9 $19.99 Free
00:46:03
Updated Mon, 23-Dec-2019
3.5 7 $199.99 Free
00:37:56
Updated Mon, 23-Dec-2019
3.4 5 $199.99 Free
01:17:01
Updated Mon, 23-Dec-2019
3.5 15 $199.99 Free
00:37:13
Updated Mon, 23-Dec-2019
3.5 5 $199.99 Free
01:00:56
Updated Mon, 23-Dec-2019
3.6 4 $199.99 Free
00:33:12
Updated Mon, 23-Dec-2019
3.3 4 $199.99 Free
00:29:09
1 5 Free
00:32:00
4 1 Free
01:36:55
0 2 $89.99 Free
00:38:30
4 6 $19.99 Free
00:48:19
3 11 $24.99 Free
00:36:26
3.1 6 $24.99 Free
02:57:41
Updated Fri, 03-May-2019
3.9 10 $19.99 Free
03:22:38
4 5 $19.99 Free
00:50:26
2.8 12 $24.99 Free
01:27:49
3.8 12 $24.99 Free
01:01:51
3.3 7 $19.99 Free
00:37:40
0 3 $19.99 Free
03:28:46
4.5 41 $199.99 Free
00:41:44
Updated Tue, 31-Dec-2019
3 2 $199.99 Free
01:35:28
Updated Sat, 14-Dec-2019
3.9 6 $19.99 Free
01:15:39
Updated Mon, 09-Apr-2018
3.7 1 Free
00:32:26
2.8 1 Free
06:16:45
3.8 6 $199.99 Free
00:55:26
Updated Sun, 18-Aug-2019
0 3 Free
03:29:01
0 13 Free
01:47:20
Updated Tue, 31-Dec-2019
4 9 Free
23:33:19
Updated Sun, 15-Dec-2019
4.6 2 Free
04:10:41
Updated Sat, 09-Jun-2018
3.7 7 Free
06:12:22
3.8 5 Free
00:41:49
3 3 $19.99 Free
21:39:43
4.2 6 Free
12:04:11
4.3 5 Free
06:10:44
4 19 Free
00:31:49
Updated Mon, 23-Dec-2019
3.9 2 $199.99 Free
00:33:46
Updated Mon, 23-Dec-2019
3 3 $199.99 Free
00:42:01
Updated Mon, 23-Dec-2019
4 2 $199.99 Free
00:35:00
Updated Mon, 23-Dec-2019
4 3 $199.99 Free
00:33:20
Updated Mon, 23-Dec-2019
3.5 3 $199.99 Free
00:29:48
Updated Mon, 23-Dec-2019
2.8 2 $199.99 Free
00:31:30
Updated Mon, 23-Dec-2019
4.3 2 $199.99 Free
00:32:08
Updated Mon, 23-Dec-2019
3 2 $199.99 Free
00:33:28
Updated Mon, 23-Dec-2019
0 2 $199.99 Free
00:33:25
Updated Mon, 23-Dec-2019
1 2 $199.99 Free
00:43:44
Updated Mon, 23-Dec-2019
3 1 $199.99 Free
00:39:51
3.5 1 $199.99 Free
00:33:46
Updated Mon, 23-Dec-2019
3.4 1 $199.99 Free
00:44:27
Updated Mon, 23-Dec-2019
4 1 $199.99 Free
00:33:45
Updated Mon, 23-Dec-2019
4 3 $199.99 Free
00:32:11
Updated Mon, 23-Dec-2019
2.8 2 $199.99 Free
00:30:54
Updated Mon, 23-Dec-2019
2.8 2 $199.99 Free
00:32:12
Updated Mon, 23-Dec-2019
3.3 1 $199.99 Free
00:30:14
Updated Mon, 23-Dec-2019
4.3 1 $199.99 Free
00:31:10
Updated Mon, 23-Dec-2019
0 2 $199.99 Free
00:30:54
3 1 $199.99 Free
00:33:06
Updated Mon, 23-Dec-2019
0 1 $199.99 Free
00:33:00
Updated Mon, 23-Dec-2019
2.5 1 $199.99 Free
00:32:39
Updated Mon, 23-Dec-2019
1 0 $199.99 Free
00:33:14
0 1 $199.99 Free
01:00:36
Updated Mon, 23-Dec-2019
2.3 0 $199.99 Free
00:34:33
Updated Mon, 23-Dec-2019
2.8 0 $199.99 Free
00:38:40
Updated Mon, 23-Dec-2019
2.7 1 $199.99 Free
00:47:44
Updated Mon, 23-Dec-2019
3.8 2 $199.99 Free
00:52:35
2.5 3 $24.99 Free
03:32:33
4.2 6 Free
05:57:36
4 0 Free
08:52:26
4.1 1 Free
06:12:02
4 1 Free
03:44:59
3.9 4 Free
01:03:03
Updated Mon, 23-Dec-2019
4 3 $199.99 Free
00:31:36
Updated Mon, 23-Dec-2019
3.7 0 $199.99 Free
00:30:46
Updated Mon, 23-Dec-2019
2 0 $199.99 Free
06:22:20
4.1 5 Free
10:18:35
Updated Tue, 10-Dec-2019
4.4 7 Free
00:30:43
Updated Mon, 23-Dec-2019
0 1 $199.99 Free
00:31:53
Updated Mon, 23-Dec-2019
0 1 $199.99 Free
03:53:23
3.2 1 $129.99 Free
05:25:45
Updated Sun, 01-Dec-2019
4 6 $199.99 Free
01:00:41
3.4 2 $19.99 Free
04:41:32
3.9 7 Free
01:03:47
3.7 10 Free
05:10:52
3.7 9 $49.99 Free
00:50:35
4.2 1 Free
03:26:04
Updated Fri, 16-Nov-2018
3 3 Free
00:33:39
Updated Mon, 23-Dec-2019
3.2 5 $199.99 Free
00:31:16
Updated Mon, 23-Dec-2019
3 1 $199.99 Free
00:41:08
Updated Mon, 23-Dec-2019
3.3 1 $199.99 Free
04:10:37
Updated Mon, 13-Jan-2020
0 2 Free
01:13:20
Updated Thu, 26-Dec-2019
0 5 Free
00:52:08
Updated Sun, 05-Jan-2020
0 2 $149.99 Free
00:42:06
4.1 6 $19.99 Free
00:52:28
3.2 2 Free
01:55:53
3.6 1 Free
00:38:36
3.7 2 Free
01:14:27
4.6 1 Free
00:58:28
2.7 3 Free
About the instructor
  • 11 Students
  • 1 Courses
+ View more
Machine Learning Evangelist
Student feedback
4
Average rating
  • 6%
  • 7%
  • 40%
  • 65%
  • 80%
Comments
Free
Includes:
  • 01:17:40 On demand videos
  • 51 Lessons
  • Full lifetime access
  • Access on mobile and tv