NEED HELP? TALK TO AN EXPERT (904) 638-5743

DBA Fundamentals

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • SQL Server installation options, as well as hardware and virtualization considerations
  • SQL Server and database security, including backups and recoveries
  • How to query SQL Server and Business Intelligence administration of SSIS, SSAS and SSRS
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

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.

 

Click here for a downloadable PDF

Outline

 

Module 01 | SQL Server Installation Options
32m 29s total

 

Module 01A | SQL Server Installation Options
32m 29s

 

Module 02 | Post-Install Configuration
39m 15s total

 

Module 02A | Post-Install Configuration
39m 15s

 

Module 03 | Hardware and Virtualization Considerations
33m 18s total

 

Module 03A | Hardware and Virtualization Considerations
33m 18s

 

Module 04 | SQL Server On-Premises and in the Cloud
27m 25s total

 

Module 04A | SQL Server On-Premises and in the Cloud
27m 25s

 

Module 05 | SQL Server and Database Security
25m 34s total

 

Module 05A | SQL Server and Database Security
25m 34s

 

Module 06 | Backups and Recoveries
46m 28s total

 

Module 06A | Backups and Recoveries
46m 28s

 

Module 07 | Management Tools
17m 37s total

 

Module 07A | Management Tools
17m 37s

 

Module 08 | Querying SQL Server
46m 42s total

 

Module 08A | Querying SQL Server
46m 42s

 

Module 09 | High Availability and Disaster Recovery Basics
33m 16s total

 

Module 09A | High Availability and Disaster Recovery Basics
33m 16s

 

Module 10 | Maintaining SQL Server and Maintenance Plans
15m 51s total

 

Module 10A | Maintaining SQL Server and Maintenance Plans
15m 51s

 

Module 11 | Understanding SQL Server Agent
32m 46s total

 

Module 11A | Understanding SQL Server Agent
32m 46s

 

Module 12 | Baselines and Monitoring
26m 03s total

 

Module 12A | Baselines and Monitoring
26m 03s

 

Module 13 | Extended Events
31m 54s total

 

Module 13A | Extended Events
31m 54s

 

Module 14 | Basic Troubleshooting and DMVs
33m 29s total

 

Module 14A | Basic Troubleshooting and DMVs
33m 29s

 

Module 15 | Business Intelligence Administration
57m 30s total

 

Module 15A | SSIS
34m 21s

 

Module 15B | SSAS
11m 03s

 

Module 15C | SSRS
12m 06s

Instructor

MITCHELL PEARSON

Training Content Manager

Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure.

 

System Requirements

  • Microsoft Windows 7, Windows 8 or 8.1 desktop or Windows 10
  • Microsoft Windows 2008 / 2008R2 / 2012 / 2012 R2 server operating system
  • 2 GHz or faster CPU
  • 4 GB of available RAM (recommended 8 GB)
  • 60 GB of free hard drive space
  • SQL Server 2012 or 2014 Developer Edition, Standard Edition or Enterprise Edition including the client tools and Books Online
  • AdventureWorks2012 or AdventureWorks2014 and AdventureWorksDW2012 or AdventureWorksDW2014 databases installed on the instance. These sample databases can be found here.

What to Know Before Class

This class assumes that you have no prior understanding of SQL Server fundamentals at all, and will hopefully, provide those to you.

REVIEWS

Pending reviews - check back later

Pending reviews - check back later

Pending reviews - check back later

Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required