Microsoft Business Intelligence
Microsoft SQL Server is one the most popular Relational Database Management System (RDBMS) used in Microsoft universe. It can be used for data storage as well as for data retrieval for applications which can be either on desktop or Web/Browse.
SQL Server Integration Services
SSIS for DBAs: Using SQL Server Management Studio.
Business Intelligence Development Studio.
Introduction to Control Flow.
Advanced Control Flow.
Introduction to Data Flow.
Variables and Configurations.
Debugging, Error Handling and Logging.
Advanced Data Flow.
Extending SSIS through Custom Code.
SSIS Package management
SQL Server Reporting Services
Creating Reports.
Calculations and Formatting.
Grouping and Sorting.
Report Parameters.
Creating Matrix Reports and Charts.
Managing Reporting Services.
Reporting Services Security.
Programming Reporting Services.
Advanced Reporting Services Programming.
Snapshots and Subscriptions.
Ad-Hoc Reporting with Report Builde.
PROJECT:
Project concept will be given and you have to work on that suggestion will be given and progress will be monitored.
Microsoft Business Intelligence
Overview: Microsoft SQL Server is one the most popular Relational Database Management System (RDBMS) used in Microsoft universe. It can be used for data storage as well as for data retrieval for applications which can be either on desktop or Web/Browse.
Course Objectives: Learn about SQL – Structured Query Language v Build database using Data Definition Language Statements Perform basic CRUD operations using Data Manipulation Language statements like Insert, Update and Delete Write and call Stored Procedures and Functions stored in database. v Write and manage database triggers, cursors and Index.
Pre-requisite / Target Audience: This sql server course can be taken by any beginner who wants to build career in Information Technology. The subscriber needs to have working knowledge of Windows Operating System.
MSBI SQL COURSE COVERS :
Introduction to Basic Database Concepts.
E-R Modeling and Diagram.
Normalization.
Introduction to SQL Server.
Introduction to SQL.
DDL and DML Statements.
Working with Queries (DQL).
Aggregate Functions.
Joins and Set Operations.
Implementation of Data integrity.
Working with Constraints.
Implementing Views.
Data Control language (DCL).
Working with Indexes.
Writing Transact-SQL (T-SQL).
Working with Stored Procedures and Functions.
Implementing Triggers.
Working with Cursors.
Transaction Control Language (TCL).
Backup and Restore.
Advance Features.
SQL Server Analysis Services
OLAP Modeling.
Using SSAS in BIDS.
Intermediate SSAS.
Advanced SSAS.
Cube Storage and Aggregation.
Beginning MDX (All Basics).
SSAS Administration.