0120 4280181 Admissions Enquiry
affiliated

MSBI Training in Noida

SQL Course Ratings
5 Star Rating: Recommended 4.9 out of 5 based on 1017 ratings.

MSBI Training
MSBI Training
msbi Training
MSBI Course

MSBI Course

MSBI or Microsoft Business Intelligence training covers SQL, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)

SQL Training Topics

  • SQL Syntax
  • SQL Select
  • SQL Distinct
  • SQL Where
  • SQL And & Or
  • SQL Order By
  • SQL Insert
  • SQL Update
  • SQL Delete
  • SQL Demo
  • SQL Try It
  • SQL Advanced
  • SQL Top
  • SQL Like
  • SQL Wildcards
  • SQL In
  • SQL Between
  • SQL Alias
  • SQL Joins
  • SQL Inner Join
  • SQL Left Join
  • SQL Right Join
  • SQL Full Join
  • SQL Union
  • SQL Select Into
  • SQL Create DB
  • SQL Create Table
  • SQL Constraints
  • SQL Not Null
  • SQL Unique
  • SQL Primary Key
  • SQL Foreign Key
  • SQL Check
  • SQL Default
  • SQL Create Index
  • SQL Drop
  • SQL Alter
  • SQL Increment
  • SQL Views
  • SQL Dates
  • SQL Nulls
  • SQL isnull()
  • SQL Data Types
  • SQL Functions
  • SQL Functions
  • SQL avg()
  • SQL count()
  • SQL first()
  • SQL last()
  • SQL max()
  • SQL min()
  • SQL sum()
  • SQL Group By
  • SQL Having
  • SQL ucase()
  • SQL lcase()
  • SQL mid()
  • SQL len()
  • SQL round()
  • SQL now()
  • SQL format()
  • Stored Procedure
  • Function
  • Cursor

SQL Server Integration Services (SSIS) Training Topics

  • Introduction to SQL Server Integration Services
  • Guided tour of Business Intelligence Development Studio
  • Introduction to Data Flow
  • Data Sources
  • Data Flow Transformations
  • Advanced Data Flow
  • Data Flow Destinations
  • Introduction to Control Flow
  • Advanced Control Flow
  • Variables and Configurations
  • Debugging, Error Handling and Logging
  • Extending SSIS through Custom Code – Scripting
  • SSIS Package Deployment
  • SSIS Package Management

SQL Server Reporting Services Training Topics

  • SQL Server Reporting Services (SSRS) Architecture
  • Authoring Reports
  • Creating basic reports
  • Leveraging expressions
  • Grouping and sorting data
  • Implementing Parameters and Filters
  • Building parameters into reports
  • Restricting report data with filters
  • Leveraging Advanced Reporting Features
  • Combining data regions in one report
  • Presenting data with appropriate detail
  • Deploying and Delivering Reports
  • Deploying reports to the server
Trainer

Trainer Profile

Mr Saket Kumar

Senior Software Engineer, Working in MNC

4+ Experience in IT Industry as an MSBI.

  • 4+ Years total Experience in Ms SQL Server
  • Having Good Experience in SQL, P-SQL, T-SQL, SSIS (Integration Services), SSRS (Reporting Services) (Version: 05, 08, 08R2, 12, 14, 16).
  • Projects Handled: Walmart Online Sales, Cardinal Health, American Financial Health Corp.
  • Till Now Trained 300+ Students.

Free Demo Info

Course Date Time
MSBI Demo Class

Venue

Tech Altum
501,5th floor, Om Complex, Sec 15
P.O. Box: 201301
Noida, Uttar Pradesh
201301
Available Discounts
  • Flat 10% Discount if joining on the same day of demo or enquiry.
  • Special discount for group joining.
  • Got someone's reference??, get flat ₹ 500 Discount. .
  • Flat 10% Discount for our old students. .

Apply now

Some Reviews

Completed Oracle DBA SQL Certification with 96% Marks. Tech Altum, an Institute for excellent training, information on best practice, and guidance covering individual technologies.

Rating: 10 out of 10 Priyasha Sharma, Oracle DBA Professional,- Completed Oracle SQL and OCA Certification with 80% and 96% Score

Tech Altum is a good institute and Trainer is Highly Knowledgeable which specially focus on practical rather than theory. I got 100% Score in Oracle SQL certification.

Rating: 10 out of 10 Anubhav Agarwal, Oracle DBA Trainee,- Qualified SQL certification with 100% Score.
Back to Top