<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

DBA Fundamentals

Our foundation course provides a step-by-step SQL Server overview. Learn installation, post-configuration, maintenance plans, backup essentials, & basic SQL Server-Active Directory integration. Great for beginners.

  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

Starting out as a DBA is rough. Nobody takes the time to show you the ropes, everybody wants ‘advanced’ this, ‘Internals’ that, or Deep Dive level 1000! All that advanced stuff is great, but you need to build a foundation. This course gives a step-by-step overview of SQL Server and will review installing SQL Server and its various services, post configuration, setting up maintenance plans, reviewing essential concepts surrounding what backups should be selected, and basic SQL Server and Active Directory Security.

Course Outline ( Free Preview)

DBA Fundamentals - What you need to get started

Module 01 - SQL Server Installation Options

Module 02 - Post-Install Configuration

Module 03 - Hardware and Virtualization Considerations 33 min.

Module 04 - SQL Server On-Premises and in the Cloud 27 min.

Module 05 - SQL Server and Database Security 26 min.

Module 06 - Backups and Recoveries 46 min.

Module 07 - Management Tools 18 min.

Module 08 - Querying SQL Server 47 min.

Module 09 - High Availability and Disaster Recovery Basics 33 min.

Module 10 - Maintaining SQL Server and Maintenance Plans 16 min.

Module 11 - Understanding SQL Server Agent 33 min.

Module 12 - Baselines and Monitoring 26 min.

Module 13 - Extended Events 32 min.

Module 14 - Basic Troubleshooting and DMVs 33 min.

Module 15A - Business Intelligence Administration (SSIS) 34 min.

Module 15B - Business Intelligence Administration (SSAS) 11 min.

Module 15C - Business Intelligence Administration (SSRS) 12 min.

Class Survey

This course includes:

  • 8+ hours of training
  • 19 Modules
  • * Access on mobile and browser
  • Certificate of Completion