Course Details

SSIS: SQL Sever Integration Services
1.    About SSIS
2.    ETL procedures
3.    About DTS Packages
4.    About Business Intelligence Projects
5.    About SQL Server Data Tools (SSDT)
6.    Elements of a SSIS project
a.    Data Sources
b.    SSIS Packages
7.    Elements of a Package
a.    Connection Managers
b.    Control Flow Items
c.    Dataflow
d.    Event handlers
e.    Package explorer
8.    Creating a SSIS Project using SQL Server Data Tools
9.    Creating a new Package
10.    Executing a package
11.    Logging ETL operations
12.    Handling errors (exception handling)
13.    Adding an existing package to the Project
Planning an SSIS project
 
14.    Understanding the tasks
15.    Planning control flow operations
16.    Planning data flow operations
 
Optimizing an SSIS Project
 
17.    Running and monitoring
18.    Optimizing
 
Deploying & Running SSIS Projects
 
19.    Deployment procedure
20.    Manual Execution
21.    Scheduling

SSRS: SQL Server Reporting Services
 
22.    Importance of Reporting Servers & Services
23.    About SSRS
24.    Installing SSRS
25.    Stopping and starting SSRS services
26.    Using reporting services tools
27.    Logon to SSRS
 
SSRS Projects
 
28.    Elements of SSRS projects
a.    Data sources
b.    Reports
c.    Report designer
29.    Report planning/modeling
30.    Creating a SSRS project
31.    Formatting reports
32.    Adding/Removing data sets
33.    Adding calculated values to the reports
34.    Using parameters and filters
35.    Using Parameter 
36.    Executing reports
 
Publishing reports
 
37.    Publishing reports onto a SSRS Server
 
Report Subscriptions

38.    About Report Subscriptions
39.    Creating Report Subscriptions
40.    Managing Report Subscriptions

SSAS: SQL Server Analysis Services
1.    Importance of Analytical systems and solutions in business development
2.    Introduction and About SSAS
Building SSAS Projects
 
3.    Elements of SSAS Projects
a.    SSAS Database (OLAP database)
b.    Data sources
c.    Data source views
d.    Dimensions & Facts
e.    Measures
f.    Cubes
g.    Mining structures
4.    Creating a SSAS Project (Multidimensional Analysis Solution)
5.    Creating a cube
6.    Planning Dimensions and facts (tables/views) 
7.    Dimension hierarchies
8.    Sorting an Grouping attributes
9.    Configuring Measures & Measure groups
10.    Building KPI (Key Performance Indicators)
11.    Building Actions
12.    Building Partitions
13.    Building Perspectives
14.    Building Translations
 
MDX Queries
 
15.    MDX Fundamentals
16.    Writing MDX queries
17.    Adding MDX Calculations to a Cube 
Deploying a SSAS Package
 
18.    Debugging a SSAS Project
19.    Deploying a SSAS Database (Project)
20.    Securing SSAS database services using Roles