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
Power BI Training Course For Data Analysts
Business Analyst
Power BI Dev Power BI Dev
with SQL, T-SQL
Total Number of Videos 16 Videos 24 Videos 38 Videos
Power BI Report Design Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Desktop and Visuals Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Python, Google, Facebook Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
R, REST APIs, Gateways Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Custom Visuals, MarketPlace Check-Symbol-for-Yes 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 Reports Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Dashboards, AppWork Space 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
Basic to Advanced DAX and RLS Check-Symbol-for-No 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 Concepts Check-Symbol-for-No Check-Symbol-for-No Check-Symbol-for-Yes
SQL Server T-SQL Queries Check-Symbol-for-No Check-Symbol-for-No Check-Symbol-for-Yes
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
Normal Forms and RAID 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 6,000/- INR 10,000/- INR 14,000/-

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:

Module I: Power BI Basics, Visuals

Module II: Power BI Service (Cloud)

Module III: ETL and Data Modelling

Video 1 : POWER BI INTRODUCTION

  • Power BI Introduction - Target Users
  • Need for Big Data and BI Technologies
  • Purpose of BI and Power BI Suite of Tools
  • Power BI : Self-Service BI, Usage Scope
  • Power BI Versus Microsoft BI (MSBI)
  • Power BI Versus Tableau, QlickView
  • Power BI as End-to-End BI Suite, Cloud
  • Microsoft Data Platform with Power BI
  • Data Collaboration, Visualization, IOT
  • Power BI with Reporting Services (SSRS)
  • Data Scientists and Artificial Intelligence
  • Data Analysts and Business Analysts
  • Power BI Job Roles and Responsibilities
  • Power BI Component : Overview, Lab Plan
  • MCSA Examination for Power BI: 70-778

Video 9 : POWER BI CLOUD - 1

  • Power BI Service (Cloud) Registration
  • Power BI Service (Cloud) Architecture
  • App Workspace Creation in Real-time
  • Publish Reports from Power BI Desktop
  • Reports, Datasets in Power BI Cloud
  • Deployment Verifications in Cloud
  • Creating Dashboards and Realtime Use
  • Pin Visuals and Pin LIVE Report Pages
  • Dashboard Creation with Tiles, Media
  • Tiles - Images, Web Content, Chapters
  • Subscriptions, Insights and Refresh
  • Metrics, Distribution Methods, Actions
  • View Related & Featured Dashboards
  • Favorites, Shares, Dashboard Themes
  • Performance Inspector and QR Codes

Video 17 : POWER QUERY - LEVEL 1

  • Power Query [M Language] - Purpose
  • Power Query Usage & Operation Types
  • Power Query Architecture and Usage
  • QUERY Concept, Properties, Validations
  • Power Query - Data Mash Up Operations
  • Basic Data Types, Literals and Values
  • Expressions, Primitives in M Language
  • Structured Data Values in Power Query
  • LIST, RECORD, TABLE in Power Query
  • Power Query Connection Format Settings
  • let, source, in statements in M Lang
  • Functions, Parameters in Power Query
  • INVOKE Functions & Execution Results
  • Power BI Canvas: Edits, Applied Steps
  • Frowns, Query Header Row Formatting

Video 2: POWER BI ARCHITECTURE

  • Power BI Architecture - Data Components
  • Power BI - Integration in Real-time
  • Interactive Reports, Paginated Reports
  • Analytical Reports and Mobile Reports
  • Power BI Licensing Plans and Pricing
  • Power BI Ecosystem and BI Components
  • Power BI Service (Cloud) and Azure Cloud
  • Power BI Report Server and Report Builder
  • Power BI Mobile Report Publisher Tool
  • Power BI with Excel - Excel Analyzer Tool
  • Power BI Desktop & Excel Publisher Tools
  • Power BI Desktop Installations - 32bit, 64bit
  • Understanding Power BI Desktop Tool
  • Power BI Canvas, Visualizations and Filters
  • Fields, Reports, Data, Relationship Screens
  • Need for Power Query and DAX Expressions
  • Visualizations in Power BI - Overview

Video 10 : POWER BI CLOUD - 2

  • Dataset Operations @ Power BI Cloud
  • Dataset Actions - Report Creation Options
  • Power BI LIVE Report Edits, Downloads
  • Quick Insights and PBIX Downloads
  • Content Packs in PBI Cloud in Real-time
  • Creating and Using Content Packs
  • Organizational, Service Content Packs
  • Publishing App Workspace, Updates
  • Dataset Refresh Options with DataSource
  • Power BI Data Gateway - Architecture
  • Gateway Installation, Configuration
  • Using Gateways in Power BI Cloud
  • SSO - Single Sign On Security Options
  • Kerberos Authentication, Refresh Modes
  • Incremental Loads, Gateway Versions
  • Data Gateway and Privacy Levels
  • PBIEngw Service and ODG Logs, Audits

Video 18 : POWER QUERY - LEVEL 2

  • Power Query Transformations Categories
  • Query Combine & MERGE Transformations
  • Join Options in Merge Transformation
  • Truncate, Replace, Split, Reduce Rows
  • Manage Columns, Hide / Show Columns
  • Grouping, Aggregations, Column Formats
  • Transpose, Reverse Rows Transformations
  • Power Query - Row Count and Replace
  • Data Type Detection - Scenarios, Use
  • Data Type Conversions and Value Replace
  • Fill Up and Fill Down, Rename Options
  • PIVOT and UNPIVOT Transformations
  • MOVE, FILTER and ConvertToList()
  • SPLIT, FORMAT, MERGE Transformations
  • EXTRACT, PARSE, NUMBER, COMBINE
  • Working with Date, Time Transformations
  • Deriving Year, Quarter, Month, Day

Video 3: POWER BI BASIC EXAMPLES

  • Using Power BI Desktop Tool - Options
  • Report Visuals, Fields, Pages and Filters
  • Report, Data and Relationship Options
  • Working with Visualizations and PBI Canvas
  • Working with Enter Data, Get Data Options
  • Get Data from DAT Files, Basic Reports
  • Enter Data from Excel Files, Basic Reports
  • Concept & Use of PBIX and PBIT Files
  • Creating PBIX Files and Re-Using Reports
  • Creating PBIT Files & Data Import Options
  • Designing Simple / Basics Reports in PBI
  • Visual Interactions in Power BI - Options
  • Spotlight Options with Visuals, Real-time Use
  • Slicer Visual in Power BI and Data Filters
  • Reusing Slicer across multiple Report Pages
  • Visual Sync Property, two directional Filters

Video 11 : EXCEL, SECURITY, ALERTS

  • Using Excel with Power BI Reports
  • Using Excel Analyzer in Power BI
  • Using Excel Publisher in PBI Cloud
  • Creating Datasets in Excel, Office 365
  • Cell Selection and PINS in Power BI
  • Excel Online Service - Edits and Pins
  • Excel ODC Connections - Power Pivot
  • Excel Workbooks, Reports, Dashboards
  • Import and Upload Options in Excel
  • Power Pivot Reports in with Excel
  • Security Levels in Power BI Cloud
  • Dashboard Security, Report Security
  • Dataset Security - Read and Reshare
  • App Workspace Security Management
  • Creating, Managing Alerts in Cloud
  • Row Level Security (RLS) with DAX

Video 19 : POWER QUERY - LEVEL 3

  • Creating Parameters in Power Query
  • Intrinsic & Query Parameters, Usage
  • Parameter Data Types, Default Value Lists
  • Static Lists, Dynamic Lists For Parameters
  • Creating Parameters in Power Query Edits
  • Creating Parameters in Data Set Queries
  • Converting Columns to Lists in Power Query
  • Reports with Range Values - Bookmarks
  • Dynamic Dropdowns with PBIX Reports
  • Parameters with PBIT Reports, Prompts
  • Report Design with Dynamic WebPages
  • Creating Lists and Tables in Power BI
  • Data Conversions and toText() Functions
  • Multi Valued Parameters. Table Columns
  • Dynamic Table Expressions and Functions
  • Report Design with Structured Table Values

Video 4 : HIERARCHIES and FILTERS

  • Working with Hierarchies in Power BI
  • Creating Hierarchies - Options and Usage
  • Data Drill Options with Power BI Hierarchies
  • Data Explore Options - Spotlight and Focus
  • Expand, Expand All Down, Goto Next Level
  • Drill Up, Drill Down and Parent Aggregations
  • See Data, Export Data, See Records Options
  • Include and Exclude with Multi-Field Values
  • Filters and Real-time Usage with Power BI
  • Export Options to CSV Files and Data Drills
  • Using Report Filters, Page Filters in PBIX
  • Using Drill-down Filters and Visual Filters
  • Basic, Advanced, TOP N Filters - Usage
  • Apply and Clear Options with Value Filters
  • Filtering at Category Level, Summary Level
  • Filtering Techniques in Power BI Visuals
  • Usage of Filters in Real-world - Synopsys
  • Cortana and Q & A Features in Power BI

Video 12: REST API, CUSTOM VISUALS

  • REST APIs with Power BI Cloud Service
  • Streaming Datasets Creation in Power BI
  • API : Usage. SubKeys and Channels
  • Push and Pubnub Datasets in Power BI
  • Azure Stream for Real-time Data Reports
  • Real-time Data Tracking Visuals in PBI
  • Power BI Database @ Streaming Datasets
  • Use Streaming Datasets in Tiles in Cloud
  • Use Power BI Dashboards with REST API
  • Power BI Datasets Usage in PBI Desktop
  • 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
  • Data Caching Options in Power BI
  • Preview Features in Power BI Desktop
  • Shape Visual, JSON and XML Option

Video 20 : POWER QUERY - LEVEL 4

  • Common Query & DataSet Options
  • Creating Query Duplicates and use
  • Creating Query References and Use
  • FROWN and Token Comma Expression
  • Applied Steps - Edits and Data Inserts
  • New Step Inclusions using Power Query
  • DELETE and DELETE UNTIL END
  • ENABLE LOAD Options in Power Query
  • Grouping Queries - Usage in Realtime
  • Query Transforms, Sort Direction, Statistics
  • IF..ELSE Conditions in Power Query
  • Data Modeling Options with Power Query
  • Modeling Operations - Custom Columns
  • Columns From Examples in Real-time
  • Conditional Column, Indexed Column
  • Variables, Parameters - Power Query
  • Date and Time Columns. String Functions
  • Custom Functions in Power Query M Lang

Video 5 : BIG DATA with POWER BI

  • Database Properties, Types of Databases
  • OLTP and OLAP Databases with Power BI
  • DWH and HTAP Databases with Power BI
  • On-premise Database Access with Power BI
  • Cloud Database Access in Power BI Visuals
  • Import Option with Database - Advantages
  • Direct Query Option in Real-time, Usage
  • Options with Small and Big Databases
  • Accessing Azure SQL Database in Power BI
  • Reports with Azure SQL DB Connections
  • SQL Queries and Power BI Data Connections
  • Direct Query Limitations in Power BI
  • Query Storage Mode in Power BI Desktop
  • Relation Detection in Power BI Desktop
  • Relationship Management, Inactive Relations
  • 1 - 1, 1 - Many, Many - 1 Table Relations
  • Defining Relations for Visual Interactions

Video 13: POWER BI REPORT SERVER

  • Power BI Admin Console and Settings
  • Installing Power BI Report Server
  • Report Server Configuration Manager
  • Configuring Power BI Report Server
  • Report Server Database TempDB Database
  • Webservice URL, Webportal URL - Usage
  • Report Builder Installation & Usage
  • SQL Server Data Tools (SSDT) Tool Usage
  • Designing Paginated Reports (RDL), Tests
  • Deploy to Power BI Report Server, Settings
  • Data Source Connections, Report Options
  • Register Power BI Report Server to Cloud
  • Tenant IDs Generation and Real-time Usage
  • Integrating Power BI Intranet & Cloud
  • Creating Hybrid Cloud with Power BI
  • Publish RDL Reports to Power BI Cloud
  • Paginated Reports Vs Interactive Reports

Video 21 : DAX FUNCTIONS - LEVEL 1

  • DAX : Importance and Real-time Usage
  • DAX as library of Functions, Operators
  • Real-world usage of DAX with Power BI
  • Real-world usage of Excel, MSBI SSAS
  • DAX Architecture and Entity Sets
  • Formulation Rules for using DAX
  • DAX Data Types and Working Options
  • Syntax, Functions, Context Options
  • Concept of Measures and Calculations
  • ROW Context and Filter Context in DAX
  • DAX Structures and Syntax Options
  • DAX Functions and Types in Real-time
  • Creating and Using Measures with DAX
  • Creating and Using Columns with DAX
  • Vertipaq Engine & Special Characters
  • Operators in DAX - Real-time Usage
  • DAX Formulas Limitations in Power BI

Video 6 : Power BI VISUALS - LEVEL 1

  • Power BI Visualizations and Types
  • Fields, Formats and Analytics Options
  • Table Visuals & Properties, Filters
  • Data Bar and Data Scaling Options
  • Divergent Colors and Data Labelling
  • Conditional Formatting, Grid Lines
  • Matrix : Sub Totals, Grand Totals
  • Drilldown Options : Row and Column
  • Row Groups and Column Groups in Matrix
  • Slicer Visual - Properties, Alignment
  • Single Select and Show All Options
  • Chart Reports - Types, Common Properties
  • Axis, Legend, Value and Tooltip Options
  • Stacked Bar Chart, Clustered Column Chart
  • Stacked Bar Chart : Properties, Use
  • Stacked Column Chart : Properties, Use
  • Clustered Bar Chart : Properties, Use
  • Clustered Column Chart : Properties
  • 100% Stacked Bar and Column Charts
  • Data Label Properties, Legend Properties
  • Comparing Bar Charts and Column Charts

Video 14 : POWER BI WITH SSAS, SSRS

  • MSBI SSRS Integration with Power BI
  • SSRS Report Portal URL to Power BI Cloud
  • Power BI KPI Reports Vs SSRS KPI Reports
  • Converting and Working with Mobile Reports
  • Report Builder Reports to Powert BI
  • IMPORT and CONNECT LIVE Options
  • Query Mode and Complete Cube Browse
  • Using MDX Queries with Power BI Queries
  • MDX SELECT and Perspective Access
  • KPIs and MDX Expressions with Power BI
  • Using KPIs in Power BI Reports, Usage
  • Cube & Perspective Browsing in PBI
  • MDX Queries and Filters with Power BI
  • SSAS MDX Scripts with Power BI Visuals
  • Using KPI Fields in Power BI Visuals
  • KPI Visual : Goals, Status and Trends
  • SSAS Tabular Mode Options in Power BI
  • MDX @ Tabular Mode OLAP in Power BI
  • DAX @ Tabular Mode OLAP in Power BI
  • DAX Filters in Tabular Mode SSAS
  • MDX, DAX Tabular Mode OLAP in Power BI

Video 22 : DAX FUNCTIONS - LEVEL 2

  • Data Modeling Options in DAX
  • Detecting & Adding Relations for DAX
  • Power BI DAX Functions - Types, Usage
  • Power BI DAX Functions - Cheat Sheet
  • Power BI Reports - DAX Functionalities
  • Calculated Columns, Aggregated Measures
  • Quick Measures in DAX - Auto validations
  • PowerPivot xVelocity & Vertipaq Store
  • In-Memory Processing : DAX Performance
  • 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, Conditions
  • Using Variables in DAX, Calculations
  • IF..ELSE..THEN Statement in DAX
  • SELECTEDVALUE, FORMAT Functions
  • RELATED & COUNTROWS in DAX
  • CALCULATE, SUM, ALL Functions

Video 7 : POWER BI VISUALS - LEVEL 2

  • Line Chart, Area Chart Properties, Usage
  • Stacked Area Chart - Properties, Usage
  • Line and Stacked Column Charts Usage
  • Line and Clustered Column Chart Usage
  • Visual Fields, Shared Axis, Legend
  • Column Series and Column Axis in Lines
  • Join Types, Lines: Round, Bevel, Miter
  • Shapes and Markers in Power BI Visuals
  • X Axis, Y Axis Properties, Plot Area
  • Display Units, Data Colors, Shapes
  • Series, Custom Series and Legends
  • Ribbon Chart - Properties, Line Width
  • Match Series and Plot Area Options
  • Waterfall Chart - Sentiment Colors
  • Breakdown Count - Decrease / Increase
  • Scatter Chart - Play Area and Axes
  • Axis Values, Color Saturation, Legend
  • Line and Donut Charts - Properties
  • Inner Radius, Details and Values
  • Data Point and Series Limitations

Video 15 : POWER BI with R

  • Introduction to R Language, Usage
  • R Scripts and R Visuals - Realtime Use
  • MRO : Microsoft R Open - Installation
  • MKL : Math Kernel Library Usage Options
  • R Language Compiler from RMAN
  • R Language License from Intel MKL
  • Enabling R Script in Power BI
  • Using R Script Visuals in Power BI
  • Installing R Studio for R Scripts
  • Install FORECAST Packages in R Studio
  • Using R Script Editor Window in R Studio
  • Writing R Scripts in Power BI. Executions
  • Using R Visual in Power BI Desktop
  • "game" Console in Power BI Report Fields
  • Console, Date and Search Options with R
  • Executing and Testing R Scripts
  • Power BI Limitations with R Visuals
  • Duplicate Data Removal with R Visuals
  • Power BI with R for Data Scientists
  • R Visuals - Limitations in Power BI

Video 23 : DAX FUNCTIONS - LEVEL 3

  • AVERAGEX and AVERAGE in DAX
  • KEEPFILTERS and CALCUALTE
  • COUNTROWS and FILTER Functions
  • Using RELATED with FILTER Function
  • DIVIDE with FILTER, ALLSELECTED
  • Using ALL, MAX DAX Functions in FILTER
  • Using ALLSELCTED and Differences
  • Using Numeric and Text Conditions
  • PARALLELPERIOD, DATEDADD in DAX
  • CALCULATE with PREVIOUSMONTH
  • FILTER Conditions with ROWCOUNT
  • USERELATIONSHIP Function in DAX
  • TOTALYTD , TOTALQTD, TOTALMTD
  • Time Intelligence with DIVIDE Functions
  • Time Intelligence with CALCULATE
  • DATESINPERIOD and AVERAGEX
  • EARLIER for Time Based Comparisons
  • Using Variables in DAX Computations
  • Time Type Dimensions - DAX Expressions
  • Considerations for Quick Measures

Video 8 : POWER BI VISUALS - LEVEL 3

  • Tree Map, Funnel and Gauge Reports
  • Group and Values in Tree Map Visuals
  • Min. Max Values and Goal Indicators
  • Single Row Card and Multi Row Cards
  • Non-Interactive Visuals in MultiRow
  • 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
  • Using Buttons, Images in Power BI Canvas
  • Bookmarks in Power BI Desktop - Usage
  • Using Bookmarks with Buttons, Actions
  • Using Bookmarks for Visual Filters
  • Using Bookmarks for Page Navigations
  • Using Selection Pane with Bookmarks
  • Buttons, Images in Power BI Desktop

Video 16 : Power BI Real-time Project

    This Power BI Training includes ONE Real-time Project Implementation on LIVE, 24 x 7 Climate Control Datasets with Cloud & REST API Integration. This project uses Microsoft One Drive, High Level End User Collaborations with 360 degree Dashboards. Includes Power BI Report Server Paginated Reports and Data Gateways with Azure Data Sync and ODG Logs.

     

    This Power BI Project includes Power BI Cloud with Mobile Integrations and

Video 24 : DAX FUNCTIONS - LEVEL 4

  • DAX Variables, Joins and Usage
  • Value Assignments with DAX
  • CONCATENATE Function in DAX
  • HOUR, NOW, SWITCH, TRUE
  • RETURN Values with DAX Functions
  • Numeric and Other DAX Options
  • DAX Modeling Components - use
  • TABLES, COLUMNS, RELATIONS
  • MEASURES and HIERARCHIES
  • INTELLISENSE with DAX Editors
  • Comments in DAX - Syntax Options
  • DISTINCTCOUNT and DIVIDE
  • SAMEPERIODLASTYEAR and IF
  • Revenue and Budget with DAX
  • VARIANCE Calculations in DAX
  • TOTALYTD, YTD, QTD and MTD

Note : Above course curriculum applicable for registrations from Sep 1st, 2018.

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

Applicable for Plan C

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
 

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