Power BI - Video Training

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 Video 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 Datasets and Facebook are also a part of this Power BI Video Training course (Version: 2.62.5222.582) 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 18 Videos 30 Videos 62 Videos
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 32,000/- [USD 475]

Power BI Training Highlights

Basic to Adv. DAX Power Query (M Lang)
LIVE Edits, RLS Data Gateways
Azure Integration MSBI with Power BI
Custom Visuals ContentPack, Cloud
R & Python Resume Guidance
Report Server Google Big Query
Interview FAQs Real-time Project

Power BI Video Training - How it works?

Real-time, Practical Training Videos, accessible 24x7. Study Material and Lab Work for every video. Every video is completely Example based. Cloud Access and Big Data access to be provided to every participant. Trainers available for doubts clarifications.

Trainer : Mr. Sai Phanindra T (12+ Yrs Exp). Profile

 

Click Here For Power BI (LIVE) Online Training

Click Here For Power BI Classroom Training

Click Here For Power BI Training Free Demo

 

Power BI Video Training Course Contents:

Old Curriculum: PDF-Logo

Register Today

Module I: Power BI Basics, Visuals

Module II: ETL and Data Modeling

Module III: Power BI Service (Cloud)

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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
Video 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

Video 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

Video 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

Video 18: 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.

SQL Server T-SQL Video Training Contents: (Applicable for Plan C)

Brochure PDF-Image

Register Today

Applicable for Plan C

Module I: SQL Basics, SQL Server Concepts

Module II: T-SQL Queries & Programming Basics

VIDEO 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)

VIDEO 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

VIDEO 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

VIDEO8: 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

VIDEO 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

VIDEO 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

VIDEO 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

VIDEO 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

VIDEO 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

VIDEO 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

VIDEO 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
VIDEO 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 Video Training course?

Complete Real-time and Practical Power BI Training with Real-time Project. 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