Power BI Online Training (LIVE, Practical, Interactive)

Complete Real-time and Practical Power BI Training with Real-time Scenarios. Power BI is a cloud-based, elegant end-to-end business analytics tool that enables anyone to visualize, analyze, forecast any type of data with greater speed, efficiency, and understanding.

This Power BI Online Training includes EVERY detail of each Power BI Visual, Usage and Properties as per the latest versions. This Power BI course includes On-premise and Cloud Data Access, REST API, Azure Stream and R Integration including Data Modelling and ETL Techniques with Basic to Advanced Power Query (M Language), DAX Language Functions, Power BI Dashboards, Streaming Datasets, App Workspace, Content Packs, Data Gateways, Alerts, Power BI Report Server Components, Power BI Mobile Repots, Excel Integration, Excel Analysis, KPIs for Big Data Analytics, Microsoft OneDrive, Google Big Query, DataFlow and ETL in Cloud are also a part of this Power BI Online Training course in addition to Mock Interviews, Resume Guidance, Concept wise Interview FAQs and ONE Real-time Project.

Power BI Training Plans

  PLAN A PLAN B PLAN C
Course includes Power BI Power BI & T-SQL Power BI, T-SQL, MSBI
Job Roles (Applicable For) Data Analysts
Business Analyst		 Business Analysts
Power BI Dev		 Microsoft BI Dev
BI Consultant, Architect
Total Duration 3.5 Weeks 6 Weeks 12 Weeks
Power BI Report Design Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Desktop, Custom Visuals Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Data Modelling with Power Query Check-Symbol-for-No Check-Symbol-for-Yes Check-Symbol-for-Yes
Data Modelling with DAX Check-Symbol-for-No Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Cloud, Excel Analysis Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Mobile, R, REST API Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Python Integration, Data Flows Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Real-Time Project in Power BI Check-Symbol-for-No Croos-symbol-for-Yes Croos-symbol-for-Yes
SQL Database, T-SQL Queries Check-Symbol-for-No Check-Symbol-for-No Check-Symbol-for-Yes
Normal Forms, Joins, Query Tuning Check-Symbol-for-No Check-Symbol-for-No Check-Symbol-for-Yes
Sub Queries, Stored Procedures Check-Symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
Excel Pivot Tables, Pivot Charts Check-Symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
Complete MSBI (SSIS, SSAS, SSRS) Check-Symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
ETL with DWH Database Design Check-Symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
OLAP Cube Design. MDX, DAX Check-Symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
SSRS Reports, Cube Reports Check-Symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
MSBI with Power BI Integration Check-Symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
MCSA Certification Guidance Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
End-to-End Project, Resume Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
Total Course Fee INR 10,000/- [USD 150] INR 15,000/- [USD 250] INR 34,000/- [USD 500]

Trainer & Profile : Mr. Sai Phanindra T

Timings (IST) Course Start Date
Schedules for Power BI Training
1 9 AM - 10 AM August 6th Register
2 11:30 AM - 12:30 PM August 27th Register
3 6:30 PM - 7:30 PM July 22nd Register
4 10 AM - 12 PM (Wkn) Aug 10th Register
Schedules for SQL Server & T-SQL Training
1 6:30 AM - 7:30 AM July 24th Register
2 9:00 AM - 10:00 AM September 4th Register
3 10:15 AM - 11:15 AM August 7th Register
4 11:30 AM - 12:30 PM July 30th Register
5 6:30 PM - 7:30 PM August 13th Register
6 7:30 PM - 8:30 PM Aug 20th Register

If above schedules does not work for you, please register for Power BI Training Videos

TRAINING HIGHLIGHTS

Custom Visuals Power BI Mobile
Big Data Sources R, Python, JSON
Excel Analysis Excel Online
Google Big Query Report Server
Gateways, Rest API Power BI Admin

ALL SESSIONS ARE COMPLETELY PRACTICAL & REAL-TIME

Register Today for Free Demo

Power BI Training Course Contents:

Brochure: PDF-Logo

Register Today

Module I: Power BI Basics, Visuals

Module II: ETL and Data Modeling

Module III: Power BI Service (Cloud)

DAY 1 : POWER BI INTRO, INSTALL

  • Need for Big Data and BI Technologies
  • Power BI : Self-Service BI, Usage Scope
  • Data Analyst, Data Scientists Job Roles
  • Power BI Developer, Admin - Job Roles
  • Power BI Vs MSBI & SSRS Vs Tableau
  • Career Options: SQL + Power BI + MSBI
  • MCSA 70-778 Power BI Examination Plan
  • Power BI Architecture and EcoSystem
  • Report Types and Power BI Licensing Plans
  • Developer Tools, Mobile Apps, Gateways
  • Power BI Cloud Account Creation, Usage
  • Power BI Desktop and Power BI DesktopRS
  • Report Builder and Power BI Mobile Tools
  • Power BI Training Course - Lab Plan

DAY 7 : POWER QUERY - LEVEL 1

  • Power Query [M Language] - Architecture
  • Basic Data Types, Literals and Values
  • M Language : Data Mash Up & Primitives
  • let, source, in statements in M Lang
  • Functions, Parameters, Frowns, Invoke
  • Advanced Editor, Grouping, Load / Unload
  • Query Reference, Query Duplicate, Steps
  • Power Query Transformations Categories
  • Query Combine & Union Transformations
  • Merge Transformation Join Kinds, Grouping
  • Truncate, Replace, Split, Reduce Rows
  • Manage Columns, Aggregation Column Formats
  • Transpose, Reverse Rows Transformations
  • Power Query - Row Count and Replace

DAY 13 : POWER BI CLOUD

  • Power BI Service (Cloud) Architecture
  • App Workspace Creation in Real-time
  • Publish Reports from Power BI Desktop
  • Reports, Datasets in Power BI Cloud
  • Dashboards : Pins, Tiles and Shares
  • Pin Visuals and Pin LIVE Report Pages
  • Dashboard Actions : Metrics, Themes
  • REST APIs and Streamining Datasets
  • Pubnub Datasets, API Tiles @ LIVE Data
  • Report Actions: Metrics, Shares
  • Insights, Q & A, Visual Options
  • Persistent Filters, Cross Filtering
  • Report Edits, Filters, Embed Codes
  • Performance Inspector and QR Codes

DAY 2: REPORT DESIGN CONCEPTS

  • Designing Reports using Power BI Desktop
  • Report Visuals, Fields, Pages and Filters
  • Report, Data and Relationship Options
  • Enter Data and Get Data in PBI Canvas
  • Power BI Visualizations & Types, Reports
  • SPOTLIGHT, Web / Mobile, View Options
  • PBIX and PBIT File Formats. Differences
  • Table Visual : Grid Properties and Pages
  • Visual Options : Export and Focus Mode
  • Basic Modelling - Summary,Format,Currency
  • Visual Interactions & Values in Power BI
  • Edit Interactions - Filter, Slice Options
  • Slicer : Number, Text and Date Conditions
  • Visual Sync Property and Limitations

DAY 8 : POWER QUERY - LEVEL 2

  • Data Type Detections and Conversions
  • Fill Up/Fill Down, Rename, Move, Split
  • PIVOT and UNPIVOT Transformations
  • FORMAT, FILTER and ConvertToList()
  • EXTRACT, PARSE, NUMBER, COMBINE
  • DELETE and DELETE UNTIL END
  • Step Edits, New Steps, Step Inserts
  • Working with Date, Time Transformations
  • Deriving Year, Quarter, Month, Day
  • Add Column / Custom Column Transformation
  • Columns From Examples, Index Columns
  • JSON, XML and Query Combine - M Language

DAY 14 : POWER BI CLOUD, EXCEL

  • Defining Datasets in Cloud : Imports
  • Defining Workbooks in Cloud : Uploads
  • Reports from Excel Imports and Datasets
  • Dashboards from Workbooks, Excel Online
  • Creating and Using Content Packs
  • Organizational, Service Content Packs
  • Publishing App Workspace, Updates
  • Using Excel with Power BI Reports
  • Using Excel Analyzer in Power BI
  • Using Excel Publisher in PBI Cloud
  • Excel with Power BI Profiles, Pivot
  • Excel ODC Connections - Power Pivot
  • Connect Options : Excel to PBI Cloud
  • DAX Measures with Excel Analyser

DAY 3 : HIERARCHIES, FILTERS

  • Grouping and Binning with Fields
  • Bin Size and Biz Limits (Max, Min)
  • Creating Hierarchies. DrillDown Reports
  • Drill Thru Reports and Conditional Filters
  • Expand, Expand All Down, Goto Next Level
  • Drill Up, Drill Down. Exclude and Include
  • See Data, Export Data, See Records Options
  • Filters : Types and Usage in Real-time
  • Visual Filters, Page Filters, Report Filters
  • Drill-thru Filters with Hierarchy Levels
  • Basic, Advanced, TOP N Filters - Usage
  • Filtering at Category Level, Summary Level
  • Slicer Versus Filters - Comparisons

DAY 9 : POWER QUERY - LEVEL 3

  • Parameter Creation, Edits and Real-time Use
  • Parameter Data Types, Default / Current Values
  • Static Lists, Dynamic Lists For Parameters
  • Creating Parameters in Data Set Queries
  • Converting Columns to Lists in Power Query
  • Dynamic Dropdowns, Multi Valued Parameters
  • Data Conversions and toText() Functions
  • Data Modeling Options - Custom Columns
  • Columns From Examples, Indexed Column
  • Conditional Column, Custom Functions
  • Variables, Parameters - Power Query
  • IF..ELSE Conditions in Power Query
  • Loops and Cases in Power Query Expressions
  • Using Power Query Result in Power BI

DAY 15 : POWER BI CLOUD (ADMIN)

  • Power BI Data Gateway - Architecture
  • Gateway Installation, Configuration
  • Single Sign On Security, Kerberos
  • Incremental Loads and Privacy Levels
  • PBIEngw Service and ODG Logs, Audits
  • DataFlows Creation - Gateway Connections
  • Using Data Flows and Power BI Datasets
  • Security Levels in Power BI Cloud
  • Dashboard Security, Report Security
  • Dataset Security - Read and Reshare
  • App Workspace Security Management
  • Content Pack Security, Featured Items
  • Creating, Managing Alerts in Cloud
  • Row Level Security (RLS) with DAX

DAY 4 : BOOKMARKS, BIG DATA

  • Using Buttons, Images in Power BI Canvas
  • Bookmarks in Power BI Desktop - Usage
  • Buttons, Actions and URLs with Text
  • Using Bookmarks for Visual Filters
  • Using Bookmarks for Page Navigations
  • Using Selection Pane with Bookmarks
  • Buttons, Images in Power BI Desktop
  • Power BI Reports with OLTP Databases
  • Power BI Reports with OLAP Databases
  • Power BI Reports with DWH Databases
  • Power BI Reports with Big Data Sources
  • On-premise, Azure Cloud Database Access
  • Import and Direct Query with Power BI
  • Connect LIVE options in OLAP Databases

DAY 10 : DAX FUNCTIONS - LEVEL 1

  • DAX : Importance and Real-time Usage
  • DAX as library of Functions, Operators
  • Real-world usage of DAX with Power BI
  • Formulation Rules and DAX Data Types
  • In-Memory xVelocity Vertipaq Engine
  • Syntax, Functions, Context Options
  • ROW Context and Filter Context in DAX
  • Creating and Using Measures with DAX
  • Creating and Using Columns with DAX
  • Data Modeling Options in DAX
  • Detecting & Adding Relations for DAX
  • Power BI DAX Functions - Types, Usage
  • Quick Measures in DAX - Auto validations
  • Deciding / Identifying Measures & Columns

DAY 16: Report Server, Mobile Reports

  • Power BI Report Server - Installation
  • Report Server Databases and Web URLs
  • Hybird Cloud [Tenant] Configuration
  • Deploying Reports to Power BI Server
  • Report Builder Paginated Reports, Upload
  • SQL Server Agent, Credentials, Pins
  • Paginated Reports Vs Interactive Reports
  • Power BI Mobile Reports - Configurations
  • Mobile Report Design Tools, Data Sources
  • Power BI Mobile Elements and Grid Counts
  • Excel Data for Power BI Mobile Reports
  • Report Server Sources and Report Hosting
  • Navigation Options with Power BI Mobile
  • Mobile Reports Vs Interactive Reports

DAY 5 : POWER BI VISUALS - LEVEL 1

  • Table Visual and Matrix Visuals: Styles
  • Column Formatting, Conditional Formatting
  • Divergent Colors, Grids, Groups, Totals
  • Chart Reports : Axis, Legend, Value, Labels
  • Stacked Bar Chart, Stacked Column Chart
  • Clustered Bar and Clustered Column Chart
  • 100% Stacked Bar and Stacked Column Charts
  • Line Chart, Area Chart, Stacked Area Chart
  • Ribbon Chart and Scater Chart : Play Axis
  • Match Series, Plot Area, Color Saturation
  • Waterfall Chart - Sentiment Colors
  • Breakdown Count - Decrease / Increase
  • Join Types, Lines: Round, Bevel, Miter
  • Shapes and Markers in Power BI Visuals

DAY 11 : DAX FUNCTIONS - LEVEL 2

  • Date and Time & Text Functions
  • Time Intelligence Functions in DAX
  • Logical & Mathematical Functions
  • Data Modeling with DAX. Creating Roles
  • SUM and DATEDIFF Examples in DAX
  • TODAY, DATE, DAY Arguments with DAX
  • DIVIDE, CALCULATE, Variables
  • IF..ELSE..THEN, RELATED & COUNTROWS
  • SELECTEDVALUE, FORMAT Functions
  • CALCULATE, SUM, ALL Functions
  • FILTER with ROWCOUNT, USERELATIONSHIP
  • EARLIER for Time Based Comparisons
  • Using Variables in DAX Computations
  • Considerations for Quick Measures
DAY 17: POWER BI INTEGRATIONS

Power BI with MSBI Integrations
  • Power BI with MSBI - SSAS OLAP Database
  • Multidimensional, Tabular Mode Databases
  • Import Data and Connect LIVE Options
  • Using MDX & DAX with Power BI Reports
  • Excel Integration with Power BI, SSAS
  • Converting SSRS Reports to Power BI
Power BI for Data Scientists
  • Enabling R Script in Power BI, RMAN
  • Installing R Studio, FORECAST Packages
  • Using R Script Visuals in Power BI
  • Python Visuals in Power BI
  • ETL, Data Modeling with Python

DAY 6 : POWER BI VISUALS - LEVEL 3

  • Tree Map Visual and Funnel Visual
  • Gauge, Donut, Single Row, MultiRow Card
  • Callout Values in KPI Reports and Use
  • Indicator, Trend and Target Goals in KPIs
  • Map Reports and Filled Map Reports
  • ArcGIS Maps - Latitudes and Longitudes
  • Data Points, Series and Data Analytics
  • Constant Lines and Threshold Values
  • Marketplace Visuals and PBIVIZ Files
  • HeatMaps - Visual, Real-time Usage
  • FlowMaps - Visual, Real-time Usage
  • Table HeatMaps with Real-time Usage
  • GanttChart - Visual, Real-time Usage
  • Power BI Infographics, Custom Visuals
  • PBI Infographics with Big Data Sources
  • Custom Visual Limitations & Migrations

DAY 12 : DAX FUNCTIONS - LEVEL 3

  • AVERAGEX and AVERAGE in DAX
  • KEEPFILTERS, COUNTROWS, RELATED
  • DIVIDE with FILTER, ALLSELECTED
  • ALL, MAX, PARALLELPERIOD, DATEDADD
  • CALCULATE with PREVIOUSMONTH
  • FILTER with ROWCOUNT, USERELATIONSHIP
  • TOTALYTD , TOTALQTD, TOTALMTD
  • SAMEPERIODLASTYEAR, IF, VARIANCE
  • DATESINPERIOD and AVERAGEX
  • DAX Variables, Time Type Dimensions
  • HOUR, NOW, SWITCH, TRUE - RETURNs
  • DAX Modeling Components - use
  • TABLES, COLUMNS, RELATIONS
  • MEASURES and HIERARCHIES
  • INTELLISENSE with DAX Editors
  • DISTINCTCOUNT and DIVIDE

DAY 18 - 20 : Real-time Project

Case 1: Real-time Project for Power BI
  • Includes Power BI Dev, Data Modeling
  • Includes Power BI Cloud, Report Server

Case 2: Real-time Project for SQL + Power BI
  • Includes Power BI Dev, Data Modeling
  • Includes Power BI Cloud, Report Server
  • Includes SQL Database Queries, Joins

Case 3: Real-time Project for MSBI + Power BI
  • Includes Power BI Dev, Data Modeling
  • Includes Power BI Cloud, Report Server
  • Includes SQL Database Queries, Joins
  • Includes OLAP, DWH and HTAP Data Sources

Note : Above course curriculum applicable for registrations from March 15th, 2019.

Applicable for Power BI Training : Plan B

Module I: SQL Basics, SQL Server Concepts

Module II: T-SQL Queries & Programming Basics

DAY 1: DATABASE & SQL SERVER BASICS

  • Introduction to Data, Databases, DBMS
  • Database Basics : Types of Databases
  • DB Types: OLTP, OLAP, DWH, HTAP
  • Microsoft SQL Server : Advantages
  • SQL, Transact SQL (T-SQL) Variants
  • Microsoft SQL Server - Career Options
  • SQL Developers : Job Responsibilities
  • BI Developers : Roles, Responsibilities
  • Data Analyst : Roles, Responsibilities
  • Business Analyst Vs Data Analyst
  • Course Plan, Mock Interview Details
  • Real-time Project Details For Resume
  • 24x7 LIVE Server Access (Online Lab)

DAY 7: JOINS AND QUERIES - Level 1

  • JOINS - Types and Real-time Usage
  • JOIN Types and JOIN Options in T-SQL
  • INNER JOIN - Examples, WHERE, ON
  • OUTER JOIN - LEFT, RIGHT, FULL
  • CROSS JOIN and CROSS APPLY
  • MERGE JOIN - Joining Bigger Tables
  • LOOP JOIN - Joining Smaller Tables
  • HASH JOIN - Joining HEAP Tables
  • GROUP BY Queries and Aggregations
  • GROUP BY Queries with Having Clause
  • ROLLUP, CUBE Queries with Group By
  • Grouping () Functions in Rollup, Cube
  • Replacing Nulls: ISNULL, COALESCE

DAY 2: SQL SERVER INSTALLATION

  • SQL Server 2019 Installation Guidance
  • SQL Server 2017 and 2016 Installation
  • Installation Pre-Requisites and Precautions
  • SQL Server Management Studio (SSMS)
  • SSMS - SQL Server Instance Connections
  • SQL Server Versions, Editions Comparisons
  • Evaluation, Developer Editions - Instances
  • Instances, Instance Types & Instance IDs
  • System Administrator Users @ Instance
  • Windows Authentication Type and its Use
  • Mixed Mode Authentication Type and Use
  • Default Admin Account in SQL Server : "sa"
  • SQL Server Services and Service Accounts
  • File Stream and Collation in SQL Instances

DAY 8: SUB QUERIES, JOINS - Level 2

  • Joining 2 Tables with Group By, Having
  • Joining 3 Tables with Group By, Having
  • Joining 4 Tables with Group By, Having
  • Using MERGE and ROLLUP with Joins
  • Sub Queries Versus Joined Queries
  • Nested Queries and Joins in WHERE
  • Nested Sub Queries with JOIN Options
  • Cast and Convert Functions - Usage
  • Date, Time Functions, Sub Queries
  • DateAdd, DateDiff, Date Time Types
  • Date & Time Styles Usage in Queries
  • Data Formatting Options in Queries
  • Using Date and Time Formats in Joins
  • Join Queries - Aggregations, Formats

DAY 3: BASIC SQL QUERIES - Level 1

  • DDL, DML, SELECT, DCL and TCL
  • Creating SQL Databases and Tables
  • CREATE, ALTER, DROP Statements
  • INSERT, UPDATE, DELETE Statements
  • Data Inserts, Values and Table Scan
  • Data Types & their Usage (Basic Level)
  • INTEGER, CHAR, FLOAT Data Types
  • Character Range for Character Data
  • INSERT and INSERT INTO Statements
  • Single Row Inserts, Multi Row Inserts
  • SELECT Statement for Table Retrieval
  • WHERE Examples : =, !=, <,>, <=, >=
  • AND, OR, NOT, IN, NOT IN Conditions
  • BETWEEN, NOT BETWEEN Conditions

DAY 9: INDEXES, VIEWS QUERIES

  • Indexes: Architecture and Types
  • Clustered and Non Clustered Indexes
  • Included and ColumnStore Indexes
  • FILTERED and COVERING Indexes
  • UNIQUE Indexes, Query Optimizer
  • LIVE Online Indexes in Real-time
  • B Tree Structures and IAM Pages
  • Tuning Joined Queries, Conditions
  • Views on Tables - SCHEMABINDING
  • ENCRYPTION and CHECK OPTION
  • Orphan Views - Real-world Solutions
  • Cascaded Views, Encrypted Views
  • System Views for Metadata Access
  • Indexed Views / Materialized Views

DAY 4: BASIC SQL QUERIES - Level 2

  • CHAR Versus VARCHAR Data Types
  • VARCHAR & NVARCHAR Data Types
  • GO Statement, SQL BATCH Concept
  • BIGINT, BIT, SQL_Variant Data Types
  • IS NULL, NOT NULL. LIKE, NOT LIKE
  • ORDER BY with ASC, DESC Options
  • DISTINCT, TOP and COUNT() Options
  • FETCH, OFFSET, NEXT ROW Options
  • UNION, UNION ALL and Sub Queries
  • Single Quotes, Double Quotes, Aliases
  • UPDATE : Conditional & Unconditional
  • DELETE and TRUNCATE Commands
  • ALTER Command   DROP Command

DAY 10: Functions, Procedures - 1

  • Scalar Value Returning Functions
  • Inline Table Functions, Dynamic Joins
  • Multi-Line Table Functions Usage
  • Table Variables and Table Data Type
  • Variables & Parameters in SQL Server
  • OBJECTID, OBJECTNAME Functions
  • System Functions & Metadata Access
  • Stored Procedures - Purpose, Usage
  • IF .. ELSE and ELSE IF Conditions
  • Using Procedures with Parameters
  • Recompilation of Stored Procedures
  • Sp_help, Sp_helpdb and sp_helptext
  • Sp_recompile, sp_pkeys System SPs

DAY 5: SERVER, DB ARCHITECTURE

  • Client Server Architecture, TDS Packets
  • SNAC and OLE DB Command for TDS
  • TDS Packets and SQL Query Processing
  • SQL Server Architecture Components
  • Protocols, SQL Native Client (SNAC)
  • Query Optimizer (QO) and SQL Manager
  • Storage Engine, File and DB Manager
  • Transaction Manager and Lock Manager
  • Buffer Manager, SQL OS and IO Buffer
  • Synchronization and Thread Scheduler
  • Logs, Checkpoints, Virtual Log File (VLF)
  • DB Data Files (mdf) and Log Files (ldf)
  • Primary/Secondary Files (ndf), Filegroups
  • Write Ahead Log (WAL) and Lazy Writer
  • Log Sequence Number (LSN), Mini LSN

DAY 11: TRIGGERS, TRANSACTIONS

  • Triggers - Purpose, Types Of Usage
  • DML Triggers - Events, Practical Use
  • FOR/AFTER Triggers - Real time Use
  • INSTEAD OF Triggers - Real time Use
  • INSERTED, DELETED Memory Tables
  • Enable Triggers and Disable Triggers
  • Database Level DDL Triggers - Usage
  • Server Level DDL Triggers - Usage
  • COMMIT and ROLLBACK Statements
  • EXPLICIT & IMPLICIT Transactions
  • Autocommit Transaction, ACID Options
  • Conditional Commits and Rollbacks
  • Open Transactions and Query Impact
  • Query Blocking Scenarios @ Real-time
  • NOLOCK and READPAST Lock Hints

DAY 6 : CONSTRAINTS Level 1

  • Constraints, Keys - Table Data Integrity
  • NULL, NOT NULL Property on Tables
  • UNIQUE KEY Constraints: Importance
  • PRIMARY KEY Constraint: Importance
  • FOREIGN KEY Constraint: Importance
  • REFERENCES, OLTP Relational Tables
  • CHECK, DEFAULT Constraints Usage
  • Candidate Keys and Identity Property
  • Normal Forms : 1 NF, 2 NF and 3 NF
  • BCNF, 4 NF, EKNF and ETNF Designs
  • Schemas - Purpose. Using DBO schema
  • User Defined Schemas & Data Transfer
  • Database Diagrams, PK-FK Base Tables
  • Local Temporary Tables and Sessions
  • Global Temporary Tables and Connections
DAY 12: REAL-TIME CASE STUDIES, EXCEL

SCENARIO 1: HEALTHCARE DOMAIN
  • Writing Queries : Joins, Group By
  • Joining 2 and More Tables, Formatting
  • Writing Sub Queries with Joins
  • ROW_NUMBER and RANK Functions
  • DENSE_RANK, PARTITION BY Queries

SCENARIO 2: SALES & RETAIL DOMAIN
  • Excel File - Imports and Exports
  • Excel Pivot Tables and Pivot Charts
  • Excel ODC Connections in Real-time
  • CASE and IIF() Conditional Queries
  • String Functions with JOIN Queries
 
EVERY SESSION IS COMPLETELY PRACTICAL. REAL-TIME. TASKS, MATERIAL, LAB WORK for EVERY SESSION. Register Today
 
Trainer Profile
Reviews
Course Curriculum
Mode of Training
Free Demo
Register Today

Who can benefit from this Power BI Online Training course?

Complete Real-time and Practical Power BI Training with Real-time Scenarios. Power BI is a cloud-based, elegant end-to-end business analytics tool that enables anyone to visualize, analyze, forecast any type of data with greater speed, efficiency, and understanding. It connects users to a broad range of data through easy-to-use dashboards, interactive reports and compelling visualizations for your day to day corproate business data needs!

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer : Mr. Sai Phanindra T

SQL Server & T-SQL
SQL Server Course

Online (LIVE)

SQL Server Course

Classroom

SQL Server Course

Videos

SQL Server DBA
SQL DBA Course

Online (LIVE)

SQL DBA Course

Classroom

SQl DBA Course

Videos

MSBI (SSIS, SSAS, SSRS)
MSBI Online Training Course

Online (LIVE)

MSBI Classroom Training

Classroom

MSBI Video Course

Videos

 
SSIS (with ETL, DWH)
SSIS Online Training

Online (LIVE)

SSIS Classroom Training

Classroom

SSIS Video Training

Videos

SSAS (with MDX, DAX)
SSAS Online Training

Online (LIVE)

SSAS Classroom Training

Classroom

SSAS Video Training

Videos

SSRS & Power View
SSRS Online Training

Online (LIVE)

SSRS Classroom Training

Classroom

SSRS Video Training

Videos

 
SQL Performance Tuning
SQL Performance Tuning

Online (LIVE)

SQL Performance Tuning

Classroom

SQL Performance Tuning

Videos

Power BI Training
PowerBI Online Course

Online (LIVE)

PowerBI Classroom Course

Classroom

PowerBI Video Course

Videos

PL-SQL Training
PL-SQL-Courses

Online (LIVE)

PL-SQL-Courses

Classroom

PL-SQL-Courses

Videos

Register Today