SQL Server Integration Services(SSIS)
- Introduction to MSBI Tool and SSIS
- Need for SSIS and ETL / DWH Entities
- Data Warehouse Design and SSIS
- DW Components and SSIS Tools
- Configuring SSIS Tools and Options
- SSIS Configuration and Catalog DB
- Control Flow Tasks Architecture
- Data Flow Tasks and ETL Architecture
- Data Pipelines and Data Buffers
- SSIS Data Types and Data Conversions
- SSIS Working and Control Flow Options
- SSIS Local and Global Variables - Usage
- Dynamic Precedence Constraints
- Dynamic Connection Managers in DFT
- Data Flow Transformations and Usage
- Handling ETL Enumerations in SSIS
- ETL with Loops & Indexed Connections
- Fast Load Options in OLE-DB Connections
- Conditional Precedence Expressions
- SSIS Parameters Usage and Variables
- Control Flow Breakpoints - Usage
- Data Flow Data Viewers and Audits
- SSIS Expressions & Debugging Options
- Debugging SSIS Packages & Limitations
- Debugging Procedures in Real-time
- Row and Column Transformations
- Combining and Splitting Data
- Performing SQL Database Operations
- MERGE Vs UNION ALL Transformations
- Lookup, Fuzzy Lookup and Grouping
- SORT Vs AGGREGATE Transformations
- OLE-DB Command Usage & Parameters
- Derived Columns & Data Conversions
- SSIS Parameter Mappings & Options
- Tabular Data Stream & Commit Size
- Table Locks & Batch Calculations
- SSIS SCRIPT Task (.NET) and Coding
- Data Analytics and Column Profiling
- Data Sampling and Data Delta
- Type I and Type II SCD Examples
- Dimension Table Design, Surrogate Keys
- SCD - Business Keys and Attributes
- SCD - Historical Attributes and Status
- Event Notifications and Emails
- ETL - Partial and Full Cache Options
- Fact Table Loads and ETL Load IDs
- PIVOT, UNPIVOT and Web Service T/Fs
- TDS Sizing and Memory Options
- CHECKSUM Transformation in DW
- CHECKSUM Transformation Logic, Installation
- Using CHECKSUM for ETL and DWH
- Working with Derived Parity Options
- Partial and Full Cache Options
- SSIS Transactions & Isolation Levels
- Checksum for Type 1 and Type 2
- SSIS Checkpoints and Limitations
- Connection Options and Retaining Stats
- Tuning Techniques with Checksum T/F
- Practical Issues with Checksum – Alternatives
- Configuring Master Packages, Parameters
- Configuring Child Packages, Parameters
- Parameter Bindings, Execute Process
- Using CDC Transformation and Controls
- CDC Source and CDC Splitter Options
- CDC State Options and Usage
- Using CDC for Type I & Type II ETL Loads
- CDC Connections – Performance Advantages
- OLE DB Transformation and Parameters
- ADO.Net Connection Limitations in SSIS
- Solutions to Data Delta Options
- Need for Fact Tables and Techniques
- Dimensions to Fact Table Relations in DWH
- Fact Table Design and Data Load Techniques
- Dimension to Fact ETL Operations
- Generating Time Dimensions for DWH with ETL
- Master Child Packaging for Fact Loads
- SSIS Package Events and Audits
- Package Level Event Handling Options
- SSIS Event Bubbling Escalations
- SSIS Logging & Project Connections
- Windows Event Logs and SSIS Jobs
- SQL Server Logging and Audit Tables
- Project Builds & Bit Level Options
- Creating ISPAC Files : SSIS 2014, 2012
- Securing SSIS Manifest Files (PROD)
- 64 bit and 32 bit Configurations
- Validation & Verification Techniques
- Configuration Options and Connections
- Control Loops and Indexed Connections
- Migrating ISPAC Files - Options
- Package Backups and Package Passwords
- Project Level Passwords and Encryption
- SSIS Deployment and SSIS Catalog DB
- SSIS Catalog Project Files and Options
- Security - Logins, Users, SSIS Admin Roles
- SSIS Catalog Folders in SSIS Database
- Post Deployments and Connections
- Package Configurations, Parameters
- SSIS Package Validations and Reports
- SSIS Package Executions and Reports
- Checksum Management and Encryptions
- SSIS Package Executions with T-SQL Scripts
- Tuning Deployment and Configurations
- SSIS Package Performance Reports
- SSIS Package Security Options
- Encrypting SSIS Catalog Packages
- SSIS Package Store and SSISDB
- Security Audits Reports and Limitations
- SSIS Folder Level Security Options
- Project Level Security and SSIS Roles
- Container and Package Logging
SQL SERVER Reporting Services(SSRS)
- SSRS Architecture and Tools
- Three-Phase Report Life Cycle
- Reporting Services Configurations
- Report Server Database and TempDB
- SSRS 2012 and Web Service URLs
- SSRS 2014 and Web Service URLs
- Communication Ports & Encryptions
- Execution Accounts and Usage
- Report Designer Usage and Scope
- Report Builder Usage and Scope
- Report Manager and Options
- RSCONFIG Tool and Limitations
- SSRS Report Authoring Options
- Data Sources (RDS) Connections
- Credentials and Security Options
- Toolbox Items and Dataset Options
- Table Reports and Matrix Reports
- Report Images, Textbox, Global Fields
- Dynamic Expressions and Options
- Reporting Functions and Formatting
- Report Headers and Report Footers
- Enterprise and Ad-hoc Report Design
- Working with Multiple DataSets
- Joining Local and Shared Datasets
- Configuring Dynamic DataSets
- Working with Remote Datasets
- Reusing XML and Shared Datasets
- Dataset Import Options in RDL
- Designing Wizard based Reports
- Custom Reports and Report Groups
- Row Drilldown and Column Grouping
- Advanced and Static Options in SSRS
- Chart Based Reports and Images
- Using SSRS Expressions & Global Fields
- Sub Report Options with Parameters
- Report Parameters & Properties
- Dynamic Report Parameters and Filters
- Dependent Parameters & Usage
- Multi Valued Null Parameters
- Report Filters - Options and Types
- Toolbox Filters and Limitations
- Sub Reports and Report Actions
- Parent-Child Report Parameters
- Gauge Reports, Indicator Reports
- Pie Charts, Bars and Spark Lines
- Rectangle Reports and List Reports
- Report Testing and Auto Refresh
- Map Reports and Report Dash Boards
- Multiple Chart Areas in Dashboards
- Report Dashboard & Limitations
- Report Scorecards with SQL Queries
- Exporting RDL Reports in SSRS
- LOOKUP Functions – Limitations
- Report Parts and Sub Reports
- Sub Reports versus Report Actions
- Accessing and Controlling Reports
- Map Reports and Stored Procedures
- Configuring Report Builder for Offline Use
- Designing Data Sets in Report Builder
- Chart and Map Wizard in Report Builder
- Report Parts and Web Services
- Report Designer Vs Report Builder
- Publishing Report Parts with RB
- Stored Procedures with Report Builder
- Report Downloads and Edit Options
- Report Builder - Limitations
- Report Manager Configurations
- SSRS Report Builds and Deployment
- Managing Data Source Security
- Exporting and Importing Reports
- Snapshot Management & Schedules
- ReportServerTempdb Usage & Tuning
- Linked Reports & Null Parameters
- Report Caching and Memory Refresh
- Managing Reporting Engine & Tuning
- Report Execution Audits & Events
- Tuning SSRS Reports & Memory Options
- Global and Shared Schedules
- Report Subscriptions and Advantages
- Email and File Share Subscriptions
- Creating Standard Subscriptions
- Creating Data-Driven Subscriptions
- Data Source Credential Store Options
- Subscription & Logging Options
- Report Uploads and Downloads
- Report Sites and Parameter Options
- Report Builder Connections & Caching
- Report Builder Reports to RDL Entries
- Data Source Security Credentials
- Report Server Security Levels
- Security Options and Report Users
- Content Manager and My Reports
- Cloning Report Roles and Schedules
- Report Browser and Report Publisher
- Report (RDL) Configuration Options
- Managing Configurations Files
- RSConfig & Encryption (snk) Keys
- SSRS Reports Upgradation Options
- Scale-out Deployments in SSRS
- SSRS Execution Accounts and Identity
SQL Server Analysis Services(SSAS)
