Description

This training focuses on Microsoft SQL Server and its related tools: SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

MS SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store and manage data, providing high-performance querying and robust database solutions for businesses of all sizes.

• SSIS (SQL Server Integration Services): A powerful ETL (Extract, Transform, Load) tool used to move, transform, and consolidate data from various sources to meet business needs.
• SSRS (SQL Server Reporting Services): A comprehensive platform for creating, deploying, and managing rich, interactive reports. SSRS enables the creation of both static and dynamic reports, which can be delivered in various formats and accessed online or offline.

Key Learning Objectives:

• Understand the fundamentals of MS SQL Server, including database design, querying, and management.
• Develop the ability to design, build, and manage SSIS packages for data integration.
• Gain expertise in creating and delivering reports using SSRS.
• Explore advanced topics like performance tuning, data warehousing, and report automation.

Pre-requisites for SQL Server with SSIS & SSRS:

1. Basic Understanding of Databases:
   • Familiarity with relational database concepts such as tables, primary/foreign keys, indexes, and joins is essential.
2. Knowledge of SQL:
   • A working knowledge of SQL (Structured Query Language), including the ability to write SELECT, INSERT, UPDATE, and DELETE queries, is recommended.
3. Experience with Windows OS:
   • As MS SQL Server and its tools are Windows-based, basic familiarity with the Windows operating system will help.
4. Familiarity with Basic Programming Concepts:
   • Though not mandatory, knowledge of basic programming logic (like loops, conditionals, and data structures) will be helpful when working with SSIS packages.

With this foundation, participants can smoothly transition into learning advanced functionalities in MS SQL Server, SSIS, and SSRS, preparing them for real-world data management, reporting, and business intelligence tasks.

SQL Server Integration Services (SSIS) – Table of Contents

Chapter 1: Introduction to SSIS

1.1 Overview of ETL (Extract, Transform, Load) (Ref: ETL with Talend)
1.2 Understanding SSIS Components
1.3 SSIS Architecture

Chapter 2: SSIS Basics

2.1 SSIS Project and Package Creation
2.2 Control Flow Tasks
2.3 Data Flow Tasks
2.4 Connection Managers

Chapter 3: Data Sources and Destinations

3.1 Working with Various Data Sources
3.2 Configuring Data Destinations
3.3 Data Flow Transformations

Chapter 4: Variables and Expressions

4.1 Introduction to Variables
4.2 SSIS Expressions
4.3 Variable Scope and Data Types

Chapter 5: Error Handling and Logging

5.1 Implementing Error Handling
5.2 Logging SSIS Events
5.3 Debugging SSIS Packages

Chapter 6: Deployment and Execution

6.1 Package Deployment
6.2 SSIS Package Execution
6.3 Scheduling SSIS Jobs

Chapter 7: Advanced SSIS Features

7.1 Scripting in SSIS
7.2 SSIS Package Configurations
7.3 Custom Components

SQL Server Reporting Services (SSRS)

Chapter 1: Introduction to SSRS

1.1 Overview of Reporting Services
1.2 SSRS Architecture
1.3 SSRS Report Types

Chapter 2: Creating Basic Reports

2.1 Report Wizard
2.2 Tabular and Matrix Reports
2.3 Formatting and Styling Reports

Chapter 3: Parameters and Filters

3.1 Using Parameters in Reports
3.2 Applying Filters to Reports
3.3 Dynamic Reports with Parameters

Chapter 4: Advanced Reporting Features

4.1 Subreports
4.2 Drilldown and Drillthrough Reports
4.3 Charts and Graphs

Chapter 5: Report Deployment and Security

5.1 Deploying Reports
5.2 Securing Reports and Data
5.3 Role-Based Security

Chapter 6: SSRS Integration with Other Tools

6.1 Integrating SSRS with SharePoint
6.2 Power BI Integration
6.3 Mobile Reports and Delivery

Chapter 7: Customizing and Extending SSRS

7.1 Report Builder and Visual Studio
7.2 Customizing Report Layouts
7.3 Creating Custom Report Items

Reference