XoomTraining

SQL SSIS and SSRS

We offers online SQL SSIS and SSRS Training with in-depth Practical approach An impeccable training course that is exclusively designed with Basics through Advanced data mining Concepts. All our training sessions are Completely Practical.

354 STUDENTS ENROLLED

    Course Objectives

    SQL Server Integration Services

      • Introduction to SSIS & Data Warehouse
      • SSIS Connection Manager
      • SSIS Sources
      • Basic ETL Entities in SSIS
      • SSIS Expressions & Package Debugging
      • SSIS Transformations
      • SSIS Control Flow Tasks
      • Foreach loops
      • Events, Errors and Logging
      • SQL Server Import and Export Data Wizard
      • SSIS Project Deployments

    SQL Server Reporting Services

      • Introduction to SSRS
      • Designing a Simple Report
      • Data sources and datasets
      • Tables
      • Grouping tables
      • Expressions
      • Pages and printing
      • Parameters
      • Indicators
      • Gauges
      • Matrices
      • Charts
      • Data bars and sparklines
      • Lists
      • Subreports
      • Deploying to Report Manager
      • Using Report Manager
      • Subscriptions
      • Maps
      • Revision of expressions
      • Variables
      • Embedding code
      • Basic Custom Assemblies
      • Examples of custom assemblies
      • Stored procedures in SSRS
      • Parameters using Stored Procedures
      • Dropdown parameters
      • Multivalue dropdowns
      • Customising reports
      • Improving report navigation
      • Linking reports (drilldown)
      • Dynamic reports

    SQL Server Integration Services

    Introduction to SSIS & Data Warehouse

      • Need for SSIS and ETL / DWH Entities
      • Data Warehouse Design and SSIS
      • DW Components and SSIS Tools
      • SSIS Configuration and Catalog DB
      • Control Flow Tasks Architecture
      • Data Flow Tasks and ETL Architecture
      • Data Pipelines and Data Buffers

    SSIS Connection Manager

      • Connection Managers Introduction
      • OLE DB Connection Manager
      • ADO Connection Manager
      • ADO.NET Connection Manager
      • Cache Connection Manager
      • EXCEL Connection Manager
      • File Connection Manager
      • SMO Connection Manager

    SSIS Sources

      • ADO.NET Source
      • Excel Source
      • OLE DB Source
      • Flat File Source
      • XML Source

    Basic ETL Entities in SSIS

      • SSIS Data Types and Data Conversions
      • SSIS Local and Global Variables
      • Dynamic Precedence Constraints
      • Dynamic Connection Managers in DFT
      • Data Flow Transformations and Usage
      • Handling ETL Enumerations in SSIS
      • ETl with Loops & Indexed Connections

    SSIS Expressions & Package Debugging

      • 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

    SSIS Transformations

      • Aggregate Transformation Basic Mode
      • Configure Multiple Outputs in Aggregate Transformation (Aggregate Transformation Advanced Mode)
      • Audit Transformation
      • Copy Column Transformation
      • Character Map Transformation in SSIS
      • Data Conversion Transformation
      • Derived Column Transformation
      • Row Count Transformation in SSIS 2014
      • Row Sampling Transformation
      • Percentage Sampling Transformation
      • Conditional Split Transformation
      • Multicast Transformation
      • Import Column Transformation
      • Export Column Transformation
      • Pivot Transformation in SSIS 2008R2
      • Pivot Transformation in SSIS 2014
      • Unpivot Transformation
      • Cache Transformation
      • Union All Transformation
      • Sort Transformation in SSIS 2014
      • Merge Transformation in SSIS 2014
      • Inner Join Using Merge Join Transformation in SSIS 2014
      • Left Outer Join Using Merge Join Transformation in SSIS 2014
      • Right Outer Join Using Merge Join Transformation in SSIS 2014
      • Full Outer Join Using Merge Join Transformation in SSIS 2014
      • Lookup Transformation
      • Lookup Transformation Using OLE DB Connection Manager
      • Lookup Transformation in Full Cache Mode
      • Lookup Transformation Case Sensitivity
      • Fuzzy Lookup Transformation in SSIS 2014
      • Fuzzy Grouping Transformation in SSIS 2014
      • Term Lookup Transformation
      • Term Extraction Transformation
      • Term Extraction Transformation – Extract Nouns Only
      • Term Extraction Transformation – Extract Noun Phrases Only
      • Term Extraction Transformation – Extract Nouns and Noun Phrases
      • Term Extraction Transformation – Exclusion Tab
      • OLE DB Command Transformation
      • OLE DB Command Transformation – Delete Operations
      • OLE DB Command Transformation – Update Operations

    SSIS Control Flow Tasks

      • Bulk Insert Task
      • Execute T-SQL Statement Task
      • Execute Package Task in SSIS
      • Execute Package Task – Executing Packages in File System
      • Execute Package Task – Executing Packages in SQL Server
      • Execute Package Task – Executing Packages present in the Same Project
      • File System Task
      • File System Task – Copy Directory
      • File System Task – Copy File
      • File System Task – Delete Directory Content
      • File System Task – Delete Directory
      • File System Task – Delete File
      • File System Task – Move Directory
      • File System Task – Move File
      • File System Task – Rename File
      • File System Task – Set Attributes
      • Change Data Capture (CDC)
      • Send Mail Task
      • Script Task
      • Slowly Changing Dimension (SCD)
      • Transfer SQL Server Objects Task in SSIS 2014
      • Transfer SQL Server Objects Task – Transferring SQL Server Tables with Data
      • Transfer SQL Server Objects Task – Transfer SQL Server Table Structures without Data
      • Transfer SQL Server Objects Task – Transferring SQL Server Stored Procedures
      • Transfer SQL Server Objects Task – Transfer SQL Server User Defined Function
      • Transfer SQL Server Objects Task – Transferring SQL Server Views

    Foreach loops

      • Looping over files
      • Looping over records
      • Other for each loops

    Events, Errors and Logging

      • 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
      • Global Connections and Project Audits
      • Using SSIS Data Profile Viewer Task

    SQL Server Import and Export Data Wizard

      • Export Data from SQL Server to Flat File Using Import and Export Data Wizard
      • Import Data from Flat File to SQL Server Using Import and Export Data Wizard
      • Export Data from SQL Server to Excel File Using Import and Export Data Wizard
      • Import Data from Excel File to SQL Server Using Import and Export Data Wizard

    SSIS Project Deployments

      • SSIS Deployment and SSIS Catalog DB
      • SSIS Catalog Project Files and Options
      • Security – Logins, Users, SSIS Admin
      • SSIS Catalog Folders in SSISDB
      • Post Deployments & Connections
      • Package Configurations, Parameters
      • SSIS Package Validations, Reports
      • SSIS Package Scripts with T-SQL
      • Tuning Deployment and Configurations
      • SSIS Package Performance Reports

    SQL SERVER REPORTING SERVICES (SSRS)

    Introduction to SSRS

      • BIDS and Report Manager
      • Solutions and projects
      • The 4 main Visual Studio windows

    Designing a Simple Report

      • Authoring a report
      • Using report items
      • Selecting and formatting report items
      • Number formats

    Data sources and datasets

      • Shared data sources
      • Shared versus embedded datasets
      • Using Query Designer

    Tables

      • Structure of a table
      • Formatting tables
      • Inserting rows
      • Interactive sorting
      • Repeating page headers

    Grouping tables

      • Using the grouping panes
      • Row and column groups
      • Displaying subtotals
      • Outlining

    Expressions

      • Calculated fields
      • The Report Items collection
      • Using built-in fields
      • Conditional formatting using expressions

    Pages and printing

      • Page headers and footers
      • Pagination between groups
      • Header and footer expressions

    Parameters

      • Using query parameters
      • Creating drop lists
      • Multi-value drop lists
      • Formatting using parameters

    Indicators

      • Creating indicators
      • Changing the symbols displayed
      • Stopping indicators stretching

    Gauges

      • Creating and formatting gauges
      • Gauge panels
      • Pointers, scales and ranges

    Matrices

      • Areas of a matrix
      • Sorting and grouping matrices
      • Creating and formatting subtotals

    Charts

      • The areas of a chart
      • Creating charts
      • Formatting charts

    Data bars and sparklines

      • Need for a grouped row
      • Creating data bars
      • Creating sparklines

    Lists

      • Creating and formatting lists
      • Grouping using lists
      • Using rectangles in lists

    Subreports

        • Creating a child report
        • Creating the main report
        • Creating and formatting subreports

    Deploying to Report Manager

            • Choosing a target folder
            • Ways to deploy reports

    Using Report Manager

            • Using Report Manager
            • Creating folders
            • Moving and deleting reports

    Subscriptions

            • How subscriptions work
            • Creating a new subscription
            • Managing subscriptions

    Maps

            • ESRI shapefiles / SQL spatial data
            • Linking to datasets
            • Map layers
            • Center points and point layers

    Revision of expressions

            • Calculated fields
            • Using the expression builder
            • Worked examples of functions
            • Using extra .NET functions

    Variables

            • Report variables
            • Group variables
            • A worked example

    Embedding code

            • Report property coding
            • Using functions in expressions
            • Other ways to write code

    Basic Custom Assemblies

            • Creating class libraries
            • Writing functions in VB or C#
            • Creating and publishing DLLs
            • Referencing functions

    Examples of custom assemblies

            • Counting words
            • Alternating colours
            • Heat maps

    Stored procedures in SSRS

            • Pros and cons
            • Server Explorer
            • Creating and editing procedures
            • Running and debugging

    Parameters using Stored Procedures

            • Creating report parameters
            • Default and null values
            • Coping with empty reports

    Dropdown parameters

            • Creating dropdown parameters
            • Linked dropdowns
            • Replacing SELECT A VALUE

    Multivalue dropdowns

            • Creating using datasets
            • Creating using stored procedures
            • Replacing SELECT ALL
            • Displaying choices made

    Customising reports

            • Editing RDL
            • Passing query string parameters
            • Customizing the parameter bar
            • Creating templates

    Improving report navigation

            • Document maps
            • Using bookmarks

    Linking reports (drilldown)

            • Linking to other reports
            • Drilldowns using charts
            • Linking to URLs

    Dynamic reports

            • Dynamic datasets
            • Dynamic grouping,matrices


    We record every live session we hold. Video recordings of each and every session will be posted on our blog too. So, this means you can get access to what the session is about and this way you do not miss any class. But take a note of it that you can have access to these Video recordings for 6 months only from the date you start your training. Access to these videos or to other required course material will be provided using Google Drive Cloud for lifetime.

    Yes, you can cancel your enrolment. We provide a complete refund after deducting the administration fee. To know more, please go through our Refund Policy.

    We have a team of industry-expert instructors or trainers who possess 8-10 yrs. of relevant experience in various Business Technologies. Every instructor / trainer undergo our specialized training program called “Train the Trainer” at Xoomtrainings. Our trainers are trained so that our learners get a great learning experience.

    Yes, classes at Xoomtrainings are conducted through online video streaming where there is two-way communication between users and instructors. The users can speak by using a microphone, chat by sending a message through a chat window and share their screens with an instructor. For better understanding, users can take the sample recorded class on this page to know of the quality of instruction and the way the class is conducted.

    Yes, the instructor will allocate you a real-time project to have a clear understanding of how you are able to conceptualize and implement the real-world application of the course content.

    Yes, we run multiple offers from time-to-time. Please, contact the support team they will give the Coupon Code.

    Yes, we will give you a discount of Rs 1500/- on selected course if you refer someone. We also offer special discount for groups.

    Yes, we will provide you the links of the software to download (trial version) which are open source and for proprietary tools we will provide you trial version, if available.

    For your practical work, we will help you set up a Virtual Machine on your system with IDE’s. This will be local access for you. The detailed step-wise installation guides are present in your LMS which will help you install and set-up the environment for any course. In case, you come across any doubt, the 24/7 support team will promptly assist you through mail (support@xoomtrainings.in) or Phone (+91 -40-4018 3355)

    4 Mbps of internet speed is recommended to attend LIVE classes. However, we have seen people attending the classes with a much slower internet connection too.

    Yes. You will receive a Digital E-Certificate from us once you complete the course. You can include this is in your Resume to get placed better.

    Xoomtrainings is the largest online education company and a large number of recruitment firms contacts us for our student’s profiles from time-to-time. Since there is a big demand for this skill, we help our certified students get connected to prospective employers. We also help our customers prepare their resumes, work on real life projects and provide assistance for interview preparation. Having said that, please understand that we don’t guarantee any placement. However, if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project.

    No doubt, your transaction is always safe and secure with Xoomtrainings.

    You will get 24/7 access to the blog to post your questions. Trainers will answer your questions through email within 24 hrs. of time. Also, our support team will help you 24/7 through mail (support@xoomtrainings.in) or Phone (+91-40-4018 3355 ,7093502091,92 ).

    You can give us a CALL at INDIA: +91-40-4018 3355 ,7093502091,92  Or Email at contact@xoomtrainings.in

     

    Tab Content

    Course Reviews

    No Reviews found for this course.

    ENROLL NOW
    • Rs.22,500.00
    • 35 Hours

    Course Features

    Lifetime access to the learning management system including Class recordings, presentations, sample code and projects

    Lifetime access to the support team (available 24/7) in resolving queries during and after the course completion

    Xoomtrainings certified based on your project performance, reviewed by our expert panel

    Xoomtrianings enjoys strong relationship with multiple staffing companies in US, UK and India. If you are looking out for exploring Placement opportunities, you can pass your resumes once you complete the course and we will help you with job assistance. We don’t charge any extra fees for passing the resume to our partners and clients

    Course Enquiry

    © 2015 - 2016 Xoom Trainings powered by Innovin IT Solutions Pvt.LTD..All Rights Reserved.
    There are no courses Added to Cart