IIRF Online > Development > Database Design & Development > SQL Server > How To Begin Your Career As a SQL Server DBA
How To Begin Your Career As a SQL Server DBA by Udemy
Your First Step In Becoming A Production SQL Server DBA
Course Highlights
- 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.
Skills you will learn!
Curriculum
11 Topics
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
6 Topics
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
7 Topics
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
5 Topics
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
3 Topics
We First Need To Create A Login. Then Create The User At The Database Level
Section 5 Summary
Section 5 Quiz
12 Topics
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
2 Topics
Congratulations and Thank You!
Bonus Lecture "10 Things Every Production SQL Server Should have"
How To Begin Your Career As a SQL Server DBA
Related SQL Server Courses
Thank You!
Your review has been submitted successfully.