<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

Home / SQL Server / Administering Business Intelligence

Administering Business Intelligence

SQL Server administration ranges from easy query tuning to keeping pace with BI developers using advanced features. DBAs can certainly benefit from this course.

Free Community Plan View Pricing Plans
  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

Administration of SQL Server can often be as simple as query tuning a T-SQL statement or configuring a server properly. When a Business Intelligence developer gets a hold of other ‘cool’ features provided in Standard or Enterprise Edition of SQL Server, then the range of knowledge a DBA has needs to keep up with developers. The Administrator does not need to know how to develop an integration Service (SSIS) package or create a calculated measure in Analysis services (SSAS), but it is good to understand what is needed to help debug and maintain the features used in their enterprise IT systems. Most shops do not use all these components, but most do use more than one.

Course Outline ( Free Preview)

Administering Business Intelligence - What you need to get started

Module 01 - Class Introduction

Module 02A - Installation and Configuration (Installation)

Module 02B - Installation and Configuration (Service Configuration)

Module 02C - Installation and Configuration (SSRS, DQS, and MDS Configuration) 35 min.

Module 03A - Administering SSIS (Introduction to SSIS) 12 min.

Module 03B - Administering SSIS (SSIS Catalog) 14 min.

Module 03C - Administering SSIS (Catalog Configuration) 9 min.

Module 03D - Administering SSIS (Executing a Package - SQL Server Agent) 21 min.

Module 03E - Administering SSIS (Executing a Package - T-SQL) 10 min.

Module 03F - Administering SSIS (Executing a Package - Other Execution Options) 4 min.

Module 03G - Administering SSIS (Environments) 8 min.

Module 03H - Administering SSIS (Best Practices) 7 min.

Module 03I - Administering SSIS (Security) 3 min.

Module 03J - Administering SSIS (Monitoring) 7 min.

Module 04A - Data Quality Services (Introduction) 20 min.

Module 04B - Data Quality Services (Administration) 21 min.

Module 05A - Master Data Services (Overview) 25 min.

Module 05B - Master Data Services (Administrative Tasks) 31 min.

Module 06A - Administering SSAS (Introduction to SSAS) 17 min.

Module 06B - Administering SSAS (SSAS Design Basics) 18 min.

Module 06C - Administering SSAS (Projects and Databases) 17 min.

Module 06D - Administering SSAS (Real Time Analytics) 10 min.

Module 06E - Administering SSAS (Partitions) 15 min.

Module 06F - Administering SSAS (Processing Data) 22 min.

Module 06G - Administering SSAS (Configuration) 15 min.

Module 06H - Administering SSAS (Maintenance) 13 min.

Module 06I - Administering SSAS (Monitoring) 23 min.

Module 06J - Administering SSAS (Security) 9 min.

Module 07A - Administering SSRS (Overview) 16 min.

Module 07B - Administering SSRS (Configuration Manager) 12 min.

Module 07C- Administering SSRS (Reporting Services Tools) 16 min.

Module 07D - Administering SSRS (Deployment) 11 min.

Module 07E - Administering SSRS (Data Sources) 13 min.

Module 07F - Administering SSRS (Security) 10 min.

Module 07G - Administering SSRS (Administrative Tasks) 17 min.

Module 07H - Administering SSRS (Subscriptions and Power BI Integration) 9 min.

This course includes:

  • 9+ hours of training
  • 37 Modules
  • * Access on mobile and browser
  • Certificate of Completion
Free Community Plan View Pricing