DeeRoshTech

• RDBMS Concept
  Basic Introduction E-R Modeling Basic of Keys Normalization Indexing Transaction And Concurrency SQL and Relational Algebra SQL Questions And Answers
• MSBI Concept
  BI Introduction SSIS Tricks Sample ETL SSRS Concept Power-Bi Tableau
• DataWarehouse
  Meaning and Architecture ODS and Data Mart OLAP Models ER Models DW Schema
• Microsoft Azure
  Azure Fundamentals Azure Data Fundamentals Data Engineering on Azure Azure Administrator Azure Solutions Architect
• HTML/CSS
  HTML Concept CSS Concept Startup Project Photo/Videos Project
• Python
  Python Concept JavaScript Concept Cost Cal Project
• Project
  About me

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)

=======================================================

Register

Please fill in this form to create an account.

---

Email Password Repeat Password

---

By creating an account you agree to our Terms & Privacy.

Already have an account? Sign in.

CONTACT

Sample Training Website - Contact Your Instructor