How To Begin Your Career As a SQL Server DBA

Your First Step In Becoming A Production SQL Server DBA

4.56 (2988 reviews)

Udemy

platform

English

language

Other

What you will learn

A the end of this course you'll know what IT positions are starting roles for SQL Server DBAs

You'll learn how to sift through job descriptions specific to your level of expertise.

You learn what a day in the life of a DBA looks like.

Why take this course?

"One of the best courses I have taken on Udemy. Short and straight to the point. I have been trying to get into DBA job and have been watching long videos and this by far is THE best course to understand DBA jobs before going into more depth." -- Lopsang Gurung

Welcome to the Course

Congratulations are in order for having chosen to pursue the path of the DBA. YOU'VE made an EXCELLENT decision and one that I have no doubt will be very rewarding should you so wish.

As with any serious endeavor, YOU want to give YOURSELF the very best possible start in order to ensure things can move forward.

This course focuses on what YOU need to know in order to become a REAL WORLD SQL Server DBA.

SQL Server is one of the most complicated software offerings Microsoft has. It requires YOU have a foundation in networks, databases and programming. This wide range of skills is often difficult to obtain without rigorous learning and years of hands on experience.

The REWARDS YOU will OBTAIN are worth 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.

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!!!

Content

What Does A SQL Server DBA Do? Let's Define The Various Roles.

This Course Is About How To Start Our DBA Journey

Is This Course For You? Should You Take This Course?

I've Been A Production DBA For Over A Decade. Let Me Show You How To Start.

The Truth About Your First Job. Think Windows Administrator or Developer.

What Is A Relational Database? How Do The Tables Relate To One Another?

The ACID Properties. Pay Attention Here. Memorize The Bolded Definition.

The Various Jobs That Fall Under The SQL Server DBA Umbrella.

A Look Into The Daily Routine. A Day In The Life Of A Production DBA.

What Interest's You? The Two Forks In The Road.

Let's Wrap Up This Section. A Brief Summary of What We've Learned.

Section 1 Quiz

Installation and Configuration. Let's Talk About Versions and Do An Install.

Let's Download SQL Server Express. The Free Version.

What Are The Editions of SQL Server? Each Release Has Different Editions.

The System Databases

SQL Server Configuration Manager. A Definition and Some Terminology.

Section 2 Summary

Section 2 Quiz

Working With The Table Object. Let's Talk About The Most Important Object.

Let's Walk Through The SQL Panes. Most DBAs Like Only Three.

Table Basics Part 1

Table Basics Part 2

What Are Data Types. We Define Our Structured Data Using Data Types

How Is Data Stored In SQL Server. Let's Talk About Pages and Extents.

Section 3 Summary

Section 3 Quiz

Transact-SQL. The Language of SQL Server. We Need To Speak It.

Data Manipulation Language VS Data Definition Langague

The Very Basics Of The SELECT Statement. This Is Where We Start.

DML - The BIG 4. SELECT, UPDATE, INSERT, DELETE.

Section 4 Summary

Section 4 Quiz

Security. Let's Talk About The Fundamentals of SQL Server Security.

We First Need To Create A Login. Then Create The User At The Database Level

Section 5 Summary

Section 5 Quiz

Backing Up and Restoring. The Most Important Thing You'll Do as a DBA

Basic Database Architecture

What Are Recovery Models?

What Are The Backup Options For A SQL Server Database

Why The Full Backup Is So Important

Full Backup: Demonstration

Differential Backup: Demonstration

Transaction Log Backup: Demonstration

Creating A Very Simple Maintenance Plan For Our Backups

Removing Unwanted Backup and Log Files

Backup Strategies For Real World Boxes

Section 6 Summary

Section 6 Quiz

Conclusion. Let's Talk About What We've Learned.

Congratulations and Thank You!

Bonus Lecture "10 Things Every Production SQL Server Should have"

Reviews

Vadim

November 11, 2023

Instructor speaks excellent English, and voice sounds really good and clear like recorded at a professional recording studio

Luis

June 4, 2023

Excelente curso. Me ayudo a conocer todo lo necesario para administrar SQL Server, es un buen arranque para comenzar a practicar.

Jeffery

March 28, 2023

By far, this is the most valuable straight to the fck*** point course I've ever bought on Udemy (and I've bought a lot). But an update would be super awesome!

Uchenna

August 22, 2022

the teacher's pace was fast and he wasn't quite audible for me as a non-native English speaker. He can also do better by adding more life to his mode of delivery

Joe

August 21, 2021

Been wanting to learn SQL or knowing what the duties are as a DBA. He is very passionate SQL server this is someone you need to learn from

Chris

March 22, 2021

It was good, a little too easy for my liking. But that is because I have been doing sql for a while. The backup section was good for me to know.

Melissa

February 8, 2021

Some videos went a little bit fast on a few topics, but otherwise great course! The videos explains the different topics very well otherwise. Also, the added text documents of notes, and summaries were a great add on.

Mulalo

November 28, 2020

This was an awsome experience with detailed and properly structured course ,I now understand back Up better ..... Thank You....

Sam

April 8, 2020

Would be great if on the Quiz questions, you add related info/tips to each question whether answered correctly or not.

Keith

August 14, 2019

Pretty cool course. Even though it's a few years old it is still works fine in the latest release of SQL Server. Very practical advice.

Katherine

August 4, 2019

The instructor has not yet told us what suite we are working in to create the tables, but he has jumped ahead and taught us about creating a parent table and a child table and the primary and foreign keys.

Raki

July 22, 2019

Enrolled in the course to gain information on SQL backups and got exactly what I was looking for with an engaging delivery from the instructor.

Fernando

July 1, 2019

Great course, came from Oracle administration and this a great course to understand principles and SQL Server architecture.

Greg

June 10, 2019

Reserving judgement until I accessed more of the course im

Saravana