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.
- What you'll learn
- Course Description
- Course Outline
- Instructor
- System Requirements
- What to know beforehand
What you'll learn
This course includes:
- 9+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
Course Description
This course includes:
- 9+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
Course Outline
Administering Business Intelligence - What you need to get started
Module 01 - Class Introduction 22 min.
Module 02A - Installation and Configuration (Installation) 48 min.
Module 02B - Installation and Configuration (Service Configuration) 15 min.
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 hours of training
- Access on mobile and browser
- Certificate of Completion
Instructor
Manuel Quintana has been teaching and developing training content for Pragmatic Works for the past 6 years. The areas of knowledge he has worked with includes the Microsoft SQL BI Stack (T-SQL, SSIS, SSAS, and SSRS), the Power Platform (Power BI, Power Automate, and PowerApps), and other various Azure services. Manuel has also authored a couple of books around Power BI and the Power Platform and participates within the community by presenting topics at various SQL Server or Power BI User groups.
This course includes:
- 9+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
System Requirements
This course includes:
- 9+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
What to know before class
This course includes:
- 9+ hours hours of training
- Access on mobile and browser
- Certificate of Completion