SQL Server Database Administration (DBA)

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:

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 essential
If 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

  • How to generate T-SQL,
  • Backing up and Restoring,
  • Changing Recovery models,
  • Different backup models,
  • Point in Time recovery,
  • Recover from a corrupted drive.
  • 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
  • Indexes,
  • Fragmentation,
  • Fill factor,
  • Optimise indexes,
  • Identify unused indexes,
  • Statistics
  • Transfer data,
  • Bulk insert,
  • Import and Export data,
  • Jobs and alerts,
  • RAISERROR,
  • Adding operators.
  • 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
  • Page and Row Data Compression,
  • Spare columns,
  • Columnstore indexes,
  • Blocking, live locking and deadlocking,
  • Monitoring.
  • SQL Server Profiler,
  • XEvents (Extended Events),
  • System Monitor,
  • Bottlenecks,
  • Server audits,
  • Elevated privileges,
  • Track who modified an object.
  • 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.
  • Restore versus detach/attach,
  • Migrate security, systems and data from other sources,
  • Full-text indexing,
  • Security,
  • Filestream and Filetable.

What people are saying

Are You Ready To Start?

More Courses

You might also be interested in these courses

Database Fundamentals in 8 hours

Learning Database Fundamentals with Microsoft SQL Server

Database Fundamentals in 8 hours

View Course

Microsoft SQL Server Reporting Services

Learn to create reports in SSRS

SQL Server Reporting Services

Learn how to create reports in SSRS
View Course