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.
Overview
COURSE DIFFICULTY
COURSE DURATION
9h 18m
Skills Learned
After completing this online training course, students will be able to:
Build interactive dashboards and reports in Power BI
Publish and share reports through Power BI Service
Manage Power BI tenant settings and governance
Build ETL packages using SQL Server Integration Services
BI Developers, Data Analysts, Data Engineers, Database Administrators
None
01. Class Introduction
02. Installation and Configuration (Installation)
03. Installation and Configuration (Service Configuration)
04. Installation and Configuration (SSRS, DQS, and MDS Configuration)
05. Administering SSIS (Introduction to SSIS)
06. Administering SSIS (SSIS Catalog)
07. Administering SSIS (Catalog Configuration)
08. Administering SSIS (Executing a Package - SQL Server Agent)
09. Administering SSIS (Executing a Package - T-SQL)
10. Administering SSIS (Executing a Package - Other Execution Options)
11. Administering SSIS (Environments)
12. Administering SSIS (Best Practices)
13. Administering SSIS (Security)
14. Administering SSIS (Monitoring)
15. Data Quality Services (Introduction)
16. Data Quality Services (Administration)
17. Master Data Services (Overview)
18. Master Data Services (Administrative Tasks)
19. Administering SSAS (Introduction to SSAS)
20. Administering SSAS (SSAS Design Basics)
21. Administering SSAS (Projects and Databases)
22. Administering SSAS (Real Time Analytics)
23. Administering SSAS (Partitions)
24. Administering SSAS (Processing Data)
25. Administering SSAS (Configuration)
26. Administering SSAS (Maintenance)
27. Administering SSAS (Monitoring)
28. Administering SSAS (Security)
29. Administering SSRS (Overview)
30. Administering SSRS (Configuration Manager)
31. Administering SSRS (Reporting Services Tools)
32. Administering SSRS (Deployment)
33. Administering SSRS (Data Sources)
34. Administering SSRS (Security)
35. Administering SSRS (Administrative Tasks)
36. Administering SSRS (Subscriptions and Power BI Integration)
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Build interactive dashboards and reports in Power BI
Publish and share reports through Power BI Service
Manage Power BI tenant settings and governance
Build ETL packages using SQL Server Integration Services
WHO SHOULD ATTEND
BI Developers, Data Analysts, Data Engineers, Database Administrators
PREREQUISITES
None
COURSE OUTLINE
01. Class Introduction
02. Installation and Configuration (Installation)
03. Installation and Configuration (Service Configuration)
04. Installation and Configuration (SSRS, DQS, and MDS Configuration)
05. Administering SSIS (Introduction to SSIS)
06. Administering SSIS (SSIS Catalog)
07. Administering SSIS (Catalog Configuration)
08. Administering SSIS (Executing a Package - SQL Server Agent)
09. Administering SSIS (Executing a Package - T-SQL)
10. Administering SSIS (Executing a Package - Other Execution Options)
11. Administering SSIS (Environments)
12. Administering SSIS (Best Practices)
13. Administering SSIS (Security)
14. Administering SSIS (Monitoring)
15. Data Quality Services (Introduction)
16. Data Quality Services (Administration)
17. Master Data Services (Overview)
18. Master Data Services (Administrative Tasks)
19. Administering SSAS (Introduction to SSAS)
20. Administering SSAS (SSAS Design Basics)
21. Administering SSAS (Projects and Databases)
22. Administering SSAS (Real Time Analytics)
23. Administering SSAS (Partitions)
24. Administering SSAS (Processing Data)
25. Administering SSAS (Configuration)
26. Administering SSAS (Maintenance)
27. Administering SSAS (Monitoring)
28. Administering SSAS (Security)
29. Administering SSRS (Overview)
30. Administering SSRS (Configuration Manager)
31. Administering SSRS (Reporting Services Tools)
32. Administering SSRS (Deployment)
33. Administering SSRS (Data Sources)
34. Administering SSRS (Security)
35. Administering SSRS (Administrative Tasks)
36. Administering SSRS (Subscriptions and Power BI Integration)
