Thursday, November 22, 2018

  • 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.


By creating an account you agree to our Terms & Privacy.
Already have an account? Sign in.


CONTACT

Sample Training Website - Contact Your Instructor

Posted by https://deerprofile.netlify.com/ at 10:25 AM 3 comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Translate

Wikipedia

Search results

Search This Blog

About Me

https://deerprofile.netlify.com/
View my complete profile

Popular Posts

  • Certification and reviews
    Certified  Microsoft AZ Data Engineer     Certified  Microsoft AZ Admin Associate  Microsoft Certified: AZ Solutions Architect Expert SQL A...
  • (no title)
    Whatever the mind can conceive and believe, it can achieve   ― Napoleon Hill RDBMS Concept Basic Introduc...
  • How to design smarter index?
    https://wehavetoknowthis.blogspot.com/2019/07/how-to-design-smarter-index.html
  • आमा
    आमा सृष्टि, आमा सृजना सन्तानका लागी ईश्वर मेरो आस्था, मेरो आशिष्, मेरो आमा आमा स्नेह, आमा प्रेम सन्तानका लागी सामिप्यता मेरो जीवन, मेर...
  • (no title)
    It’s hard to believe it’s been almost two months since Steve Jobs passed away . "When you grow up you, tend to get told that the worl...

Blog Archive

  • November (1)
  • July (1)
  • October (1)
  • July (4)
  • January (1)
  • December (8)
  • November (6)
  • June (1)
  • February (1)
  • January (8)

Featured Post

RDBMS and DW Introduction

Concept of RDBMS: https://wehavetoknowthis.blogspot.com/2020/01/rdms-introduction.html    Concept of Data warehouse: https://wehavetoknowthi...

Powered by Blogger.