Want to see your future on the below roles on IT?
Database Developer,
SQL Developer,
Database Software Developer,
ETL Developer,
Data Engineer,
Report/BI Developer/Engineer,
Data Analyst,
Data Scientist,
Optional: Relational Database BSA/QA/Manager
SQL/BI training
Duration: 4 Month
Class Start date: 4/5/2021[3 days in a week]
Fee: $599 [Success/Satisfaction guaranteed or your money back]
Contact: Dilip25352020@gmail.com or Call:214-518-4192
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)
=======================================================
Last edited: 20-Mar-21 03:11 PM
Last edited: 20-Mar-21 03:11 PM
Last edited: 20-Mar-21 03:13 PM