MSBI & SQL – Course Contents

MSBI & SQL – Course Contents

learn MSBI online, msbi online training from india

learn MSBI online, msbi online training from india

Course Duration: – 30 Sessions (Each session is 2 Hr)

Objectives

At the end of MSBI training course, the student will be able to :

  • Understand the life cycle of database 
  • Understand the design,implementation and maintenance.
  • Understanding to ISIS.SSRS,SSAS
  • Developing the ISIS packages.
  • Define MDX Language.

Benefits to you:

  • 100% student satisfaction guaranteed, if NOT fee will be returned back to student
  • Hands-on practices
  • Teaching with real-time examples
  • Introduction of various tools to be used by MSBI developers.

Course Contents

Life Cycle of Database:

  • Design
  • Implementation
  • Maintenance

Module1: Design (6 Hours)

  • Basics (DBMS,RDBMS)
  • SQL Server Environment
  • Creating a Database
  • Constructing tables
  • Data Types
  • Data Integrity[ Where all the constraints will be covered]
  • Relationships(One – One, One – Many, Many – Many)
  • Normalization & Normal Forms
  • DDL-Data Definition Language
  • DML-Data Manipulation Language
  • DCL-Data Control Language

Module2: Implementation (14 Hours)

  • SQL Programming Concepts (Operators, Built-in Functions, Clauses)
  • Joins and Sub Queries
  • Views
  • Indexes
  • Stored Procedures
  • User Defined Functions
  • Transactions and Locks
  • Cursors
  • Triggers
  • XML Integration

Module3: Administration or Maintenance (4 Hours)

  • Security
  • Database Maintenance(DBCC Commands, Backup & Restore)
  • Replication
  • SQL Server Agent
  • Performance Monitoring
  • SSIS-SQL Server Integration Services
  • SSRS-SQL Server Reporting Services
  • SSAS-SQL Server Analysis Services

Introduction to MSBI:  (2 Hours)

What is MS-BI

Advantages of MS-BI

DWH Concepts

  • What is DWH?
  • Definition of DWH (Ralph Kimball, Bill Inmon Definitions)
  • OLTP Vs OLAP
  • DWH Architecture
  • Data Acquisition Process (ETL)
  • Data Analysis Process (OLAP)
  • DWH Design Guidelines (Star, Snowflake Schemas)
  • Tools used in DWH
  • Data Mart

Introduction to SSIS: (2 Hours)

  • SSIS installation
  • SSIS Architecture
  • Package
  • Tasks ,Control Flow , Data Flow

Developing SSIS Packages: (3 Hours)

  • SSIS Wizard
  • SSIS Designer (BIDS Environment)
  • Variables and Expressions
  • Breakpoints
  • Data viewers
  • Configuring Error Output

Errors and Debugging SSIS  (8 Hours)

  • Events Handling
  • Execution Logging
  • Control Flow Tasks
  • Data Flow Tasks(ETL)
  • .Net Scripting Task

SSIS Administration (3 Hours)

  • Configuration
  • Deployment
  • Security
  • Manually Executing SSIS Package
  • Scheduling SSIS Package
  • Importing and Exporting Packages
  • Monitoring and Optimizing Packages

DWH with SSIS  (1 Hour)

  • Dimension Tables Data Loading
  • Fact Tables Data Loading

Introduction to SSRS (1 Hour)

  • What is SQL Server Reporting Services?
  • What can you do with SSRS reports?
  • What components does SSRS use?
  • Who uses SSRS?

Authoring Reports (2 Hours)

  • Basics Of SSRS
  • Data Source
  • Data Set
  • SSRS Expressions
  • Reports Formatting

Advanced Authoring (3 Hours)

  • Parameterized Reports
  • Sub Reports
  • Drill Down Reports
  • Linked Reports In SSRS
  • Filters in SSRS
  • Actions In SSRS

SSRS Administration  (2 Hours)

  • Installation and Configuration
  • Deployment and Security
  • Subscriptions and Rendering
  • Caching and Snapshots

AD – Hoc Reports Development  (1 Hour)

  • Report Model Project
  • Model Designer
  • Report Builder

Introduction to SSAS (1 Hour)

  • Dimensions
  • Facts
  • Data Sources
  • Data Source Views

Developing Cubes ( 4 Hours)

  • Cube Designer
  • Partitions and Aggregations
  • Dimension Usage
  • Calculations and Kpis
  • Perspectives, Actions

MDX Language (4 Hours)

  • Axes, Slice
  • Tuple and set
  • MDX Queries
  • MDX expressions

SSAS Administration (3 Hours)

  • Installation
  • Configuration
  • Deployment
  • Processing
  • Security
  • Backup and Restore

learn MSBI online, msbi online training from india

Contact Us

5th Floor, T-Hub Building
IIIT Campus, Gachibowli Circle,
Hyderabad, Telangana 500032.
Phone: +91-9966465202 (India)
+1-415-935-5884 (USA) rajuonlinetraining@gmail.com
www.rajutechnologies.com
Skype: rajutechnologies

Raju Technologies

Raju Technologies is founded and operated by real-time EXPERTS. We'll assure that, training will be delivered with 100% quality. We always reachable after the training as well.