arrow_back
Back
lock
Introduction to Microsoft Business Intelligence (MSBI) Certification Training | Learnoa
lock
Curriculum
lock
SQL Basics and select query to manipulate database, Windows & SQL Authentication, Connection from SS
lock
DDL(Delete) & DML(Truncate) commands continued, Set Operators, tables, Constraints, Tables & Coloum
lock
Group by, Having, Where & Order by clause, Queries & Sub-queries, Date function, Conversion function
lock
Conversion functions- String, Variable, if, IfELSE, Table variables, Control & Looping functions, E
lock
Joins, Ranking functions, Views, Table value inline functions, Scalar functions
lock
Introduction to SSIS-ETL, Server Data Tool, Data migration project, Control & Data flow and it's dif
lock
Transformations and it's types, Annotation, Sequence containter, Data viewer, Data flow
lock
OLEDB Source & Destination, Charactor map, Multicast transformation, Performing & Blocking a transfo
lock
Data conversion, Basic Transformations, , Operations on the database like Merge, Joins & Union
lock
Control flow, Data flow, Parameters, Event handlers, Package explorer, Lookup Transformation
lock
SQL Server Import & Export, Dimensions, Performing a transformation
lock
Control flow components, Dynamic loading of files into SQL, Variables with dynamic values
lock
For & For Each container, Execute package & SQL tasks, Script task, Execute SQL task with paramenter
lock
Row count, Error output handling, Variable mapping, Bulk insert, Send mail & File system tasks, Err
lock
Scheduling, Exception handler, Package configuration
lock
Reporting Services
lock
Report Filter
lock
Project day Configuration of the data flow and process
lock
List Report with Image & Rectangular Report
lock
SQL Server Reporting Services
lock
SSRS Development, Report Generation
lock
Matrics Report, Drilldown Report, Page Break
lock
Hierarchies inside a Dimension & Role of a Dimension
lock
Calculations, Perspective. Aggregations, Storage Design- ROLAP MOLAP, HOLAP, Cubes in Report
lock
1st Assignment
lock
Assignments
lock
Date Functions
lock
DDL and DML
lock
Operators Aggregations Top N
Preview - Microsoft Business Intelligence (MSBI) Certification Training
Discuss (
0
)
navigate_before
Previous
Next
navigate_next
script src="https://cdnjs.cloudflare.com/ajax/libs/OwlCarousel2/2.3.4/owl.carousel.min.js">