MySQL / Database Training in BTM , Bangalore

MYSQL / DATABASE CLASSES

TECHIESKILL

MySQL / Database

15000

5y ago

Course Duration:3 Months

Course Details

Course Contents: 1. Introduction to MSBI and Data warehouse concepts Definition of Data Warehouse Why Data Warehouse DWH Architecture Master Data Transaction Data Dimension Table Fact Table OLTP(Online Transaction Processing System) OLAP(Online Analytical Processing System) 2. SQL Server SQL Basics Constrains Joins Working with Data String Functions Date Functions Aggregate Functions Identity Temp Table, Table Variable CTE(Common Table Expression) Sub Queries Operators Case Statements While Loop and If else Statements Views Stored procedures Functions Cursor Triggers Indexes Exception Handling 3. SSIS (SQL Server Integration Services) Introduction of SSIS BIDS(Business Intelligence Development Studio) Components of SSIS Control Flow Items For Loop Container For each Loop Container Sequence Container Bulk Insert Task Data Flow Task Execute SQL Task Execute Package Task Execute Process Task FTP Task File System Task Script Task Send Mail Task Data Flow Items Data Flow Sources OLE DB Source Flat File Source Excel Source Data Flow Transformations Aggregate Audit Character Map Conditional Split Copy Column Data Conversion Derived Column Lookup Fuzzy Lookup Fuzzy Grouping Merge Merge Join Multicast SCD(Slowly Changing Dimension) Sort Union All Data Flow Destinations OLE DB Destination Excel Destination Flat File Destination SQL Server Destination Variables Loggings Configurations Package Deployment Scheduling SSIS Packages SSIS Package Tuning 4. SSRS (SQL Server Reporting Services) Core Components of SSRS Reports Types of Reports Basic SSRS Report Data Sources and Shared Data Sources Datasets and Shared Datasets Report Parameters Cascading parameters Drill down Report. Report Formatting Custom Expressions Drill Through Report Ad-Hoc Reporting with Report Builder Report Model Projects Subscriptions Report Manager and Report Server Report Security Improving Report Performance 5. SSAS (SQL Server Analytical Services) Definition of Cube Advantage of Cube Star and snowflake schema Dimensions and Dimension Types Measures and Measure Types Fact Table and Types Data Source DSV(Data Source View) Hierarchy and Types Cube Structure Dimension Usage and Relationships Calculations Partitions KPIs Actions Aggregations Perspectives Translations Browser Storage Models (ROLAP,MOLAP and HOLAP) 6. MDX (Multi Dimensional Expressions) Retrieving Cube data using MDX Hierarchy Sets Tuples Calculated Member Basic MDX Functions PARANT and CHILDREN Functions LAG and LEAD Functions TIME Functions PARALLELPERIOD Function YTD , QTD , MTD and WTD MDX Calculations.

Are you providing Training Classes

IT Courses / Govt Exam Preparation
Higher Studies / Studies Abroad

List your Institute

Freshersworld.com : The No.1 Jobsite for Fresher Hiring in India

FreshersWorld.com (A TeamLease Company) is the No.1 Jobsite for Freshers in India with over 1.5+ Crore resumes and 60K+ recruiters hiring through us. Apply to Top MNC Jobs / Government jobs by registering now! What’s more? Get daily job alert, placement paper and GK updates every day on your email. FreshersWorld.com (A TeamLease Company) the only website for applying to Govt Jobs and top MNC Jobs all over India. Register Now to benefit from our unlimited fresher focused services!

Connect with us on fingertips

Terms of Use
|
Privacy Policy
|
Copyright
|
Site Map
10.0.1.184

MYSQL / DATABASE CLASSES

Course Details

Jobs

Verify Mobile Number