X
ODT

DBA Fundamentals
On-Demand Training

Starting At: $395.00
On-Demand Training
Call Us At: (904) 413-1911

Pragmatic Works On-Demand Training gives you the ability to learn from industry experts at your own pace. Our courses cover a variety of topics including Business Intelligence, Business Analytics, Big Data, SQL Server Optimization and more.

DBA Fundamentals
$395
Per User Per Year
Unlimited Elite Pack
$995
Per User Per Year
Free Trial
3:13
3:13
2:00

Thanks for reporting a problem. We'll attach technical data about this session to help us figure out the issue. Which of these best describes the problem?

Any other details or context?

Cancel
message

Course Details

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.


Prerequisites


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

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

Curriculum For This Course

Image

Mitchell 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.



Related Courses

Course Info
15 Comprehensive Modules
17 Effective Quizzes
Access on Mobile and TV
Certificate of Completion
Duration:
8h 19m
Download Syllabus
Enrollment Price:
$395/Year

Share this course with your friends