SQL/BI
CLASS [40 hr]Subqueries , Derived Table, Set,
Rank Operations and More
SQL/BI
CLASS [40 hr]
RDBMS/SQL:
[12 hr], Integration Service: [10 hr], Reporting Service: [12 hr], Analysis Services: [6 hr]
RDBMS/SQL: [12 hr]:
1) RDBMS/SQL Introduction and Download
2) Creating Tables and Other
Permanent Objects
3) Writing Single Table Queries
-Building Your Foundation
4) T-SQL Fundamentals: System
Functions and Query Writing
5) Data Types, Variables, Table Variable, Temp table, and CTE
6) Subqueries , Derived Table, Set,
Rank Operations and More
7) SQL Constraints and Indexes
8) SQL JOINS
9) Stored Procedure
10) Triggers, View, and Functions
11) Transactions, Locking and
Blocking
12) Execution Plan and
Performance Tuning
Integration Service (Using SSIS): [10 hr]:
1) Introduction of Package
Creation
2) Tools and Transformations
3) Common SSIS Tasks
4) Configuration and Deployment
5) Project work and Interview
Question
Reporting Service (Using SSRS/PowerBI/Tableau): [12 hr]:
1) Employee Details, Drill down E
Details Reports
2) Parameterized, Cascaded
Parameterized Reports
3) Create Above Reports Using SSRS
4) Create Above Reports Using PowerBI
5) Create Above Reports Using Tableau
6) Create Other Reports and Interview
Questions
Analysis Services (Using SSAS): [6 hr]:
1) Introductions and Data
warehouse concept
2) Cube Development, Dimension
and Facts design
3) Hierarchies, Perspectives,
Partition, Storage, and Security
What can be done next (Bonus Class) [2 hr]:
1) Interview Questions Resume
Preparation
=======================================================
Course
Design By: Dee R Chapagain (Dilip)
=======================================================
