SQL: [12 hr], Integration Service: [10 hr], Reporting Service: [12 hr], Analysis Services: [6 hr]
SQL: [12 hr]:
1) 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 the Above Reports Using SSRS
4) Create the Above Reports Using PowerBI
5) Create the 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)
=======================================================