Real World SQL Server From The Ground Up
What you'll 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.
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 this course is for:
- 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.
Course content
- Preview01:28
- Preview05:12
- Preview05:41
- Preview00:59
- Preview06:42The Language of SQL Server
- 02:12What Are The Different Jobs A DBA Can Have?
- 01:32What Are The ACID Properties
- 00:44Key Terms
- 00:54Summary
- 10 questionsQuiz
Instructor
![Mike West](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.2 Instructor Rating
- 11,567 Reviews
- 210,161 Students
- 53 Courses
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 wife and two children.