SQL & POWERBI

Description

Syllabus

Beginners

  • Unit-1: Structured Query Language Session: Basic Concepts
    • Define SQL
    • Why SQL
    • SQL Process
    • SQL Commands
      • DDL-Data Definition Language
      • DML-Data Manipulation Language
      • DCL-Data Control Language
      • DQL-Data Query Language
  • Unit-2: Structured Query Language Session: Relational Model
    • Basic terms used in Relational Model
    • Relation Schema For Candidate
    • Relation Instance
    • Types of Constraints
    • Entity Integrity Constraint
    • Referential Integrity Constraint
    • Operations with Constraint Violation
  • Unit-3: Structured Query Language Session: Database Integrity and Normalisation
    • Relational DataBase Integrity
    • Normalisation
    • Normalization Rules

Intermediate

  • Unit-4: Structured Query Language Session: Properties of Decomposition
    • Relational Decomposition
    • Types of Decomposition
  • Unit-5: Structured Query Language Session: DDL Queries
    • Data Language Definition
    • DDL Commands
  • Unit-6: Structured Query Language Session: DML Queries
    • Data Manipulation Language
  • Unit-7: Structured Query Language Session: Joins
    • Introduction of SQL
    • Types of SQL Joins
  • Advanced

    • Unit-8: Structured Query Language Session: Database Objects
      • Introduction
      • Views
      • Sequences
      • Indexes and Synonyms
    • Unit-9: Power BI
      • History of Power BI
      • What we can do with the help of Power BI
      • Common to both MSExcel& Power BI
      • Base Elements
      • The flow of Work in Power BI
      • Power BI: Desktop Vs Service
      • Power BI: Better than Excel for
      • What is Excel better at compared to Power BI
      • Power BI/MS-Excel- Leveraging Both
      • What is the Excel Data Model?
      • Powerful Self-Service BI with Excel 2013
      • Extend with Hybrid Cloud Solutions
      • Different users of Power BI
      • Installation Of Power BI
    • Unit-10: Power BI
      • Power BI Desktop- Visualizations
      • Power BI Desktop Visualization Report View
      • Power BI Desktop-Sharing Reports Publish to Cloud Service
      • Power BI Desktop-Sharing Reports File/Save as PBIX
      • Power BI Desktop-Sharing Reports File/Export to PDF
      • How you can share your work-Power BI service
      • Let's look at some examples
      • Power BI Cloud
      • Power BI: The Big Picture
      • The process to get success in Power BI
      • PowerPivot Unites Business Users and IT
      • Seamless Transition of the Semantic Model
      • Rode Map to Power BI Solution
      • What are the Trends in BI?
      • What are Dashboards?
      • Power BI’s Ingredients & Data Analysis Workflow
      • What is a component of Power BI
      • What Power BI Component Actually Do?
      • Power Query: Overview, Data Shaping, Manipulation
      • Getting External Data Into Excel
      • Why Power Query
      • PowerQuery& Data Source Accepted
      • Data Sources
      • Power Query: Caveats
      • Introducing Power Map
      • Use of Power Map
      • Top 10 Reasons to Try PowerPivot

    Professional

    • Unit-11: Power BI
      • Tools of Power BI
      • Steps to install Power BI
      • Steps to Connect to Data (After Installation)
      • Steps for entering URL
      • Preparing data in Query Editor (Working on rows first)
      • Preparing data in Query Editor (Working on columns)
      • Data Model-Introduction
      • Creating some Visualizations
      • Power BI Desktop Tool
      • Scenario afterwards
      • Coming to Data View
      • Coming to Relationship View
      • Ribbons of the Desktop
    • Unit-12: Power BI
      • Changes in Functionalities of the Ribbon
      • The interface of Query Editor
      • Accessing Options Menu
      • Opening the new Power BI Project
      • The workflow of Power BI desktop
      • Saving the Project
      • Data Preparation in Query Editor
      • Connecting Power BI Desktop to Data Sources
      • Cleaning of the rows in Query Editor (First Query)
      • Going on to the Second Query
      • Going on to the Third Query
      • Appending Queries
      • Cleaning of the columns in Query Editor
      • Pivoting and Un-Pivoting Columns
      • Turn data into a model scheme
Search box

Feel Free to Contact Us: