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 http://dchapagain.blogspot.com... 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