Want to change your career?
Want to make a better future for your family/Friends?
What to understand the future of technology/IT?
Let's start now!! It is possible!!! It is FUN!!!
SQL/BI training
Duration: 4 Month
Class Start date: 4/5/2021
3 days/week [Monday, Wednesday/Thursay] [7 PM-8:30 PM]
Fee: $599 [Success/Satisfaction guaranteed or your money back]
Contact: Dilip25352020@gmail.com or Call:214-518-4192
http://dchapagain.blogspot.com/
Who I am?: I am an independent database developer, wants to share my knowledge to make a better community.
What we will learn?
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)
=======================================================
