Learnfly Academy

MSBI SQL Training

  • Sale
  • Regular price Rs. 30,000.00

Drop a query

Speak to Counsellor: Call 1-800 3000 7460 (India Toll Free)


Quick Overview

Course Description

MSBI is the Microsoft Business Intelligence SQL which, as the name suggests, is extremely resourceful for the organizations running business of different sizes. Through this course you will learn about the use of Business Intelligence tools like SSRS, and SSAS using SQL Server. MSBI enables you to store and retrieve data for smart processing which aids in streamlining business decisions.


During the LearnFly MSBI SQL course you will be given professional training on resourceful tools that will help you bring out effective solutions for a business. The demand for SSAS professionals is enormous. Companies of great repute tirelessly hunt for MSBI SQL-skilled candidates, so a career in this area is undoubtedly 'bright'. Some of the topics that you will be learning during the course are:



  • Constraints
  • Error rows configuration
  • Package configuration
  • Package logging
  • Event handlers
  • Subqueries used with IN or NOT IN
  • Subqueries used ANY or ALL and much more.

Enroll for a Live Class

Enroll for the course at the earliest as we have limited seats available.

Duration : 1 hour
Length : 14 Weeks
Batch Start Date : 19/11/2016
Course Fee Rs. 30000
Test Lab Hours : 30 mins
Class Room Training : Available
Instructor Learnfly Faculty
Available Training Modes Instructor-Led Class

The best of the faculty for the courses have been selected after a strenuous testing process. So, quality training is an assured feature of our curriculum. All course modules have been prepared according to the latest industry standards.

Week 1 – Introduction to SSAS

  • Multidimensional Analysis
  • Tables and OLAP database
  • Creating new data source
  • What is Data source view?
  • Specifying dimension attributes in Dimension wizard
  • Defining Dimension structure
  • Attribute Relationships
  • Types of Relationship : Flexible and Rigid

Week 2 – Structures and Processes

  • What is Process dimension?
  • Troubleshooting of errors
  • Define Column binding
  • Introduction to Process database
  • Creating a new cube
  • Selecting different measures
  • Explaining a Cube structure
  • What is Process cube
  • Browsing in Cube
  • Column Naming
  • Defining various Categories
  • Concept of Customer key and Product key

Week 3 – Type of Database Relationship

  • Importance and Use of dimension
  • Types of Relationship
  • What is No relationship?
  • Regular relationship
  • Fact
  • Referenced relationship
  • What are Partitions?
  • Define and Implement Aggregation

Week-4 SQL SERVER OVERVIEW

  • Types of Database
  • Client server Architecture
  • File server v/s client server DB’s
  • Client communication manager
  • Relational query processor
  • What SQL exactly is?
  • How to open SSMS
  • Introduction of SQL 2012
  • Windows authentication

Week 5: Using Management Studio

  • Skima
  • T-sql
  • Keywords
  • Identification
  • System table
  • Data types
  • Functions
  • Data Manipulation
  • Data control language
  • Drop table
  • The commit/Rollback

Week-6 Designing Relational Database

  • Coolum
  • Select statement clauses
  • Using group by and having clauses
  • Logical and relational operators
  • Joins
  • Relational & logical opera
  • group function
  • Joins Constraints:-
    • Primary key
    • Foreign key
    • Unique key
  • check
  • Not null

Week-7 WORKING WITH SINGLE TABLE QUERIES, MERGING DATA WITH JOINS & UNIONS

  • Joins
  • Types of Joins
  • Complete explanation by using figures and query
  • Inner Join
  • Outer join
  • Self join
  • Creation of tables
  • Cross join
  • Set operators

Week 8: More on Operators

  • Types of Set operators
  • Union
  • Union all
  • Intersect
  • Except
  • Rules of Set operators
  • Temporary Table creation
  • Facts about temporary tables
  • Table variables
  • Example of Function creation
  • Table variables limitations

Week-9 Functions

  • System function
  • Single row function
  • Number function
  • Char/String function
  • Date function
  • General function
  • Inline function
  • Duplicate function

Week-10 Working With SubQueries

  • Sub queries
  • Sub queries used with IN or NOT IN
  • Sub queries used ANY or ALL
  • Sub queries used with EXISTS and NOT EXISTS
  • The update statement
  • Using the set clause to modify
  • Using the where clause
  • using the from clause
  • The DELETE statement
  • The TRUNCATE table statement
  • How to create view
  • Type of view

Week-11 SELECTING DATA THROUGH VIEWS, T-SQL & STORED PROCEDURES

  • Views
  • Usage
  • Create view
  • Alter view
  • Drop view
  • Rename view
  • Modifying data using view
  • TSQL
  • Stored procedure
  • Creating stored procedure
  • Advantage of stored procedure
  • Drop procedure
  • Error handling in stored procedure
  • User defined function (UDF)
  • Scalar UDFs
  • Inline table value UDFs
  • Multi-statement table UDFs
  • Limitation of UDFs

Week-12 USER-DEFINED FUNCTIONS & TRIGGERS

  • Stored procedure:-
    • Try catch block
    • User stored procedure (UDFs)
    • Inline table value UDFs
    • Limitation of UDFs
    • User stored procedure (USP)
  • Rank function:-
    • DENSE Rank
    • Row Number
    • Triggers
    • Creating Triggers

Week-13 SQL Server Management

  • Pivot
  • SQL server management studio
  • Pivot in excel
  • Pivot in SQL server
  • Stuff
  • For XML path
  • Example for XML path
  • Difference between CHAR, Varchar and NVarchar
  • How to change values

Week-14 Performance Indexing

  • Indexes
  • With no Indexes defined
  • How to create an Index
  • How Indexes works
  • Index advantages
  • Searching for records
  • Sorting records
  • Grouping records
  • Index drawbacks
  • Indexes and Data modification
  • Clustered Indexes
  • Creating a Clustered Index
  • Composite Indexes
  • Covering queries with an index
  • Additional Index guidelines
  • Common Table Expression

 

Learnfly Academy is a forward-thinking educational ecosystem. We train extraordinary people for the emerging professions of the 21st century according to industry demand. We fill a crucial gap between learners and companies to train and hire the best talent in the market. Learning from Learnfly Academy increases your chances by 95% to get you the right job.

Live Class is a live streaming of teacher from our location. Learnfly Academy instructors deliver live classes in an online environment. Attendees join a WebEx session from their preferred location and connect to a hosted lab environment to practice what they learn. We run classes as per Indian Standard time.

Each attendee needs a computer with a high-speed Internet connection in order to connect to

  • A WebEx web conference session and
  • A hosted lab environment.
and For best results, we recommend the following browsers: PC - Internet Explorer or FireFox. Mac - 64-bit browser (Safari of FireFox). or Google Chrome We also highly recommend that you use a computer headset and microphone (VOIP) and that you attend from a quiet workspace to allow you to concentrate.

 

We have a very transparent fee structure. Please see the course fee next to the “Add to Cart” button on this page.

We only provide certified and industry expert trainers to our learners. Our teachers/instructors are highly qualified in their training verticals. Our instructors could be an individual teachers from colleges or working professionals from multi national companies like google, Facebook or Microsoft.

Of course you should. That’s what applications are for, don't worry. It's our responsibility to make sure that you are ready for any course you will attend. If it's not right for you, we'll let you know. We're not shy about things like that.

Yes. We do offer full job assistance once you do the certification from Learnfly. We have partnered ourselves with multiple small business and multi national companies to provide you the best working platform. We also conduct in-house campus events and send you invitations to experience multiple job opportunities at one place. We offer 99% job placement, if you do 2-3 job oriented courses from our catalogs.

Currently, you can attend our class’s in English or Hindi Language.

Yes Off course! You can reschedule a class with your assigned teacher or request for a pre-recorded session on your email.

We accept payments via credit cards, debit cards, net banking & NEFT. You can also pay us via paypal & paytm. Use the “Add to Cart” button provided on this page and checkout by making the online payment. You will receive an automated confirmation on your email after a success-full payment with further instructions.

Once you purchase training, we'll send you an email with registration instructions. Also, One of our counsellor will get in touch with you to assign you an online teacher and decide the class timings. We can either assign you to the existing running batch or add you in the upcoming batches.

You may cancel an order within 30 days of purchase for a full refund, but not inside of 3 days of your scheduled course.

 

Step 1 : Make an Online Payment


Step 2 : Our Counsellor will contact you within few minutes after payment.


Step 3 : Choose your time to attend your live class with our counsellor


Step 4 : Connect with a Live Teacher from your PC, Phone or a tablet & attend the class from anywhere in the world.


You may be interested in:


Customer Reviews

Based on 4 reviews Write a review