SQL Server Database Administration (DBA)

Back To All Courses

100 Lessons

All

Skill Level

9:59h

course Duration

English

Audio

Eng & Esp

Subtitles

Share This Class:

Overview

Do you want to gain practical experience in Database Administration in SQL Server? Welcome.

In this course, learn some of the skills that Microsoft want you to know, and add another tool to your CV or resume, and even go for the official Microsoft certification.

SQL Server is one of the main database tools that is requested in the job market, and the ability to being able to do DBA for SQL Server could be very useful for your current work, and your next job hunt.

The course will take around 10 hours to complete, but completing this will enable you to versed in Database Administration tasks, giving you hands-on experience.

In this course, we will only do activities that require one computer, instead of multiple servers or virtualization.

The course is fairly relaxed – there will be a few “wrong turns”, so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual DBA will be at a basic level, and I’ll introduce every component as we go on.

No knowledge of T-SQL is required, as I’ll demonstrate everything I can through the GUI (Graphical User Interface) as well as T-SQL. However, if you are going to go for the official Microsoft exam, the equivalent knowledge as per the first two sessions in my T-SQL course is essential.

At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and continue your preparations for the official Microsoft certifications.

Completing this course will help you:

Create Backups and Restore Databases, understanding the different recovery models
Manage logins and server roles, and import and export data
Implement and maintain indexes, and manage and configure databases, including compression and concurrency problems
Manage SQL Server Agent and audit SQL Server instances
Collect and analyse troubleshooting data
Plan and install SQL Server and related services, including implementing a migration strategy

Who is the course for?

You don’t need any prior DBA knowledge prior to taking this course.It would be helpful if you knew how to create simple T-SQL statements (SELECT, FROM, WHERE, GROUP BY) for some parts of the course, but not essentialIf you want to know enough T-SQL to assist you with your DBA work, please have a look at the first two sessions of my T-SQL courses.You don’t need any form of SQL Server to already be installed on your computer; I will show you have to download it and install it – for free.

Learning Path

Backup and Restore – Part 1

How to generate T-SQL,
Backing up and Restoring,
Changing Recovery models,
Different backup models,
Point in Time recovery,
Recover from a corrupted drive.

Manage logins and server roles

Create login accounts,
Manage access to the server, and secure SQL server,
Create and maintain user-defined server roles,
Create Database User Accounts,
Fixed and User Database-Level Roles,
Creating and Using Schemas,
Creating access to server/database with least privilege,
Protect objects from being modified

Implement and maintain indexes

Indexes,
Fragmentation,
Fill factor,
Optimise indexes,
Identify unused indexes,
Statistics

Import and Export Data, and Manage SQL Server Agent

Transfer data,
Bulk insert,
Import and Export data,
Jobs and alerts,
RAISERROR,
Adding operators.

Manage and configure databases

Database configuration,
Design multiple file groups,
Manage file space with new filegroups,
Partitioning,
Managing a multi-TB database,
Log file growth,
DBCC,
Contained databases and logins

Compression and concurrency problems

Page and Row Data Compression,
Spare columns,
Columnstore indexes,
Blocking, live locking and deadlocking,
Monitoring.

Troubleshooting data and auditing SQL Server Instances

SQL Server Profiler,
XEvents (Extended Events),
System Monitor,
Bottlenecks,
Server audits,
Elevated privileges,
Track who modified an object.

Plan installation and installing SQL Server

Choosing the right hardware,
Scale-up versus scale-out,
Windows-Level and Service Level Security,
Default and named instances,
Planning the installation of SQL Server,
Testing connectivity,
Configuring an O/S disk.

Implementing a migration strategy and installing additional server

Restore versus detach/attach,
Migrate security, systems and data from other sources,
Full-text indexing,
Security,
Filestream and Filetable.

What people are saying

“Good match for what I was expecting: Installation, DB features, Backup and Restore Explained in detailed manner. the instructor makes it easy to understand. Good course overall. Would recommend it to anyone willing to learn SQLServer administration.”
Sanjay
“Phillip is amazing and his depth knowledge on the subject simply amazes us, even I have Phillips 70-461 course, where I really enjoy his method of teaching. I must say if you wish to start a career in DBA this course is must where he takes us through practical applications. And even the Practice activities at the end of each topic are Brainstorming.”
Shiva
“this is the most comprehensive and well taught course on SQL DBA I have watched. Thank you Phil. Because I loved your teaching Style, I have purchased the Courses on Power BI and soon I will also be taking the courses in Tableau as I build up my Data Analytics and Business Intelligence skills.”
Marc-Alain
“Like every course that you Philip givs out it follows a red line, it has fantastic proportions balancing theory with practical examples. Taking any course from Philips Burtons catalog is just pure learning and will ramp up your skills either if they are new or existing. // Jonas Thank you for making everything so easy to understand!”
Jonas
Previous
Next