DBA Fundamentals

$95.00

What Will You Learn?

  • How to write queries that involve multiple tables and summary queries
  • How to modify data and understand the logical programming aspects of T-SQL

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.

Instructor

MITCHELL PEARSONMITCHELL PEARSON

BI Consultant and Trainer
As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.

 

What to Know Before the Class

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


Duration: 8:19:37
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.
DBA Fundamentals - What you need to get started
Module 01 - SQL Server Installation Options
32:29
Module 02 - Post-Install Configuration
39:15
Module 03 - Hardware and Virtualization Considerations
33:18
Module 04 - SQL Server On-Premises and in the Cloud
27:25
Module 05 - SQL Server and Database Security
25:34
Module 06 - Backups and Recoveries
46:28
Module 07 - Management Tools
17:37
Module 08 - Querying SQL Server
46:42
Module 09 - High Availability and Disaster Recovery Basics
33:16
Module 10 - Maintaining SQL Server and Maintenance Plans
15:51
Module 11 - Understanding SQL Server Agent
32:46
Module 12 - Baselines and Monitoring
26:03
Module 13 - Extended Events
31:54
Module 14 - Basic Troubleshooting and DMVs
33:29
Module 15A - Business Intelligence Administration (SSIS)
34:21
Module 15B - Business Intelligence Administration (SSAS)
11:03
Module 15C - Business Intelligence Administration (SSRS)
12:06
Class Survey

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 at http://msftdbprodsamples.codeplex.com