Power BI - LIVE Online 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. Course includes Basic to Advanced Power Query (M Language) and DAX Language with R Integration and REST API Integration. Dashboards, Streaming Datasets, App Workspace, Content Packs, Data Gateways, Alerts and Power BI Report Server Components and Power BI Mobile Repots with complete, end to end Excel Integration for Big Data Analytics are added advantages with this elegant training on Power BI Training Course. Microsoft OneDrive, Google Analytics and Facebook are also a part of this Power BI Online Training course (Version: 2.59.5135.1011) in addition to Mock Interviews, Resume Guidance, Concept wise Interview FAQs and ONE Real-time Project.

Power BI Training Plans

  PLAN A PLAN B
Description Power BI T-SQL + Power BI
Total Duration 3.5 Weeks 6 Weeks
Power BI Desktop and Visuals Check-Symbol-for-Yes Check-Symbol-for-Yes
Data Modelling and Reports Check-Symbol-for-Yes Check-Symbol-for-Yes
Basic to Adv. Power Query (M Lang) Check-Symbol-for-Yes Check-Symbol-for-Yes
Basic to Advanced DAX and RLS Check-Symbol-for-Yes Check-Symbol-for-Yes
Power BI Cloud (Service), R Integration Check-Symbol-for-Yes Check-Symbol-for-Yes
REST API, Azure Integration Check-Symbol-for-Yes Check-Symbol-for-Yes
Report Server, SSRS Integration Check-Symbol-for-Yes Check-Symbol-for-Yes
Real-Time Project, Resume, Job Support Croos-symbol-for-Yes Croos-symbol-for-Yes
Basic SQL, SQL Server, T-SQL Croos-symbol-for-No Check-Symbol-for-Yes
Joins, Queries, Stored Procedures Croos-symbol-for-No Check-Symbol-for-Yes
Normal Forms,RAID,Query Tuning Croos-symbol-for-No Check-Symbol-for-Yes
End-to-End Project, Resume Croos-symbol-for-No Check-Symbol-for-Yes
Total Course Fee INR 10,000/-
USD 150
INR 14,000/-
USD 250

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

Timings (IST) Free Demo Start Date  
Schedules for Power BI Training
1 9 AM - 10 AM Aug 6th Aug 7th Register
2 11:30 AM - 12:30 PM July 23rd July 23rd Register
3 6:15 PM - 7:30 PM July 30th July 31st Register
4 7 - 9:30 AM (Wknd) July 21st July 21st Register
5 9:30 - 11 AM (Wknd) July 28th July 29th Register
Schedules for SQL Server & T-SQL Training
1 6:30 AM to 7:45 AM July 27th July 30th Register
2 9 AM to 10:15 AM Aug 28th Aug 29th Register
3 10:30 to 11:30 AM Aug 8th Aug 9th Register
4 11:30 to 12:30 PM Aug 6th Aug 7th Register
5 6:15 to 7:30 PM Aug 21st Aug 22nd Register
If above schedule does not work for you, please register for Power BI Training Videos

Power BI Training Course Contents:

Module I: Power BI Basics, Visuals

Module II: ETL and Data Modelling

Module III: Power BI Service (Cloud)

Chapter 1 : Introduction to Power BI

  • Need for Big Data and BI Technologies
  • Purpose of BI & Power BI Suite of Tools
  • Power BI as a Self-Service BI, Scope
  • Comparing Power BI with Microsoft MSBI
  • Comparing Power BI @ Tableu, QlickView
  • Power BI as an End-to-End BI Tool
  • Microsoft Data Platform Technologies
  • Colloboration, Visualization and IOT
  • Power BI with Reporting Services (SSRS)
  • Power BI For Data Scientists, AI Scope
  • Power BI For Business Analysts
  • Power BI Job Roles and Responsibilities
  • Power BI Component :Overview, Lab Plan
  • MCSA Examination for Power BI: 70-778

Chapter 7 : Power Query & M Language - 1

  • Power Query [M Language] - Purpose
  • Power Query Usage & Operation Types
  • Power Query Architecture and Usage
  • QUERY Concept, Properties, Validations
  • Power Query for Data Mashup Operations
  • Basic Data Types, Literals and Values
  • Expressions and Primitives in M Language
  • LIST : Syntax, Examples and Usage
  • RECORD : Syntax, Examples and Usage
  • TABLE : Syntax, Examples and Usage
  • Power Query Connection Formats, Settings
  • let, source & in statements in M Lang
  • Power BI Canvas: Edits, Applied Steps
  • Queries and Applied Steps, Edit Queries

Chapter 13 : Power BI Service (Cloud) - 1

  • Power BI Cloud & Power BI Workspace
  • App Workspace Creation in Real-time
  • Publish Reports from Power BI Desktop
  • Reports and Datasets in Power BI Cloud
  • Pin Visuals and Pin LIVE Report Pages
  • Dashboard Creation and Tiles, Media
  • Images, Web Content, Chapters, Q & A
  • Mobile View, Web View, QR Codes, Shares
  • Enabling Interactive Visuals. Embed Codes
  • Report Shares and Dashboard Shares
  • App Publish Options and App Updates
  • Power BI Report Edits in Cloud, Visuals
  • Download PBIX Reports from Cloud
  • Sharepoint Integration, PPTX and Excel

Chapter 2: Power BI Architecture

  • Power BI Architecture - in Detail, Tools
  • Power BI - Integrations in Real-time
  • Need for Power BI Service and Cloud
  • Need for Power BI Report Server, SSDT
  • Power BI Report Server & Report Builder
  • Power BI Mobile Report Publisher Tool
  • Types of Reports in Power BI - Interactive
  • Analytical, Paginated & Mobile Reports
  • Office Online Server & SharePoint Server
  • Content Packs, Cortana - Q&A Features
  • API Integration: LIVE Streaming DataSets
  • Configure Power BI Cloud, Basic Usage
  • Installing Power BI Desktop, Gateways
  • Installing Excel Publisher & Analyzer

Chapter 8 : Power Query & M Language - 2

  • Data Sources with Excel, File Formats
  • Data Sources with Database Connections
  • BLANK Data Sources Creation & Scope
  • Creating LIST, RECORD, TABLE Queries
  • Functions in Power Query and Usage
  • Defining Functions and Invoke Options
  • Mashup Operations in Power Query Editor
  • Row Filters, Column Filters, Renames
  • Promoting Headers and Query Settings
  • MERGE Queries For Combining Queries
  • Inner Join and Left/Right Outer Joins
  • Left Anti Join, Right Anti Join, Full Join
  • UNION All, Group By and Aggregations
  • Close and Apply Options. Data Imports

Chapter 14 : Power BI Service (Cloud) - 2

  • Dashboard Properties and Security
  • Report properties and Security
  • Dataset properties and Security
  • Report Insights, Related Items & Metrics
  • Quick Insights. Publishing App Workspace
  • Power BI LIVE Report Edits, Downloads
  • Content Packs : Creation and Use
  • Organizational and Service Level
  • Content Packs from Azure MarketPlace
  • Gateway Clusters - Installation
  • Personal and Enterprise Gateways
  • NT SERVICE\PBIEgwSERVICE Account
  • Dataset Refresh Options and Schedules
  • Azure Databus Integration, ODG Logs

Chapter 3 : Using Power BI Desktop

  • Install and Configure Power BI Desktop
  • Understanding Power BI Desktop Tool
  • In-Memory, SMDL and Vertipaq Options
  • Visuals, Fields, Pages and Filters
  • Report, Data and Relationship Options
  • Concept & Use of PBIX and PBIT Files
  • Designing Simple / Basics Reports in PBI
  • Get Data from DAT Files, Basic Reports
  • Enter Data from Excel Files, Basic Reports
  • Creating PBIX Files and Re-Use
  • Creating PBIT Files & Data Import Options
  • Database Connections with Power BI
  • Import and DirectQuery - Data Loads
  • Table Reports, Matrix and Chart Reports
  • Interactive Visuals and Focus Mode

Chapter 9 : Power Query & M Language - 3

  • Creating Parameters in Power Query
  • Intrinsic & Query Parameters, Usage
  • Parameter Data Types, Default Value Lists
  • Static Lists, Dynamic Lists For Parameters
  • Reports with Range Values - Bookmarks
  • Parameters with PBIT Reports, Prompts
  • New Queries from Dataset Fields, Usage
  • Removing Duplicate Rows and Columns
  • Column Delimters and Field Formatting
  • Change Type and Transform Operations
  • Replace Values & Errors, Transpose
  • Group By Aggregations, Fill, Reverse Rows
  • Format Options in M Language. Bookmarks
  • Pivot and Unpivot Options in Power Query
  • Data Type Conversions & Format Options

Chapter 15 : Excel with Power BI

  • Using Excel with Power BI Reports
  • Using Excel Analyser in Power BI
  • Using Excel Publisher in Cloud
  • Creating Datasets with Excel, Office 365
  • Excel Uploads & Cloud Imports, Office 365
  • Cell Selection and PINS in Power BI
  • Excel Online Service - Edits and Pins
  • Excel ODC Connections and Real-time Use
  • Excel Power Pivot and Power BI Cloud
  • Excel Drilldowns and Drillthru Reports
  • Create Key Performance : KPI Reports
  • Excel for Big Data Analysis, Reporting
  • Worksheets and Dashboards with Excel
  • Power Pivot Reports in with Excel
  • Power View Report Options in Excel

Chapter 4 : Hierarchies and Filters

  • Creating Hierarchies with Report Fields
  • Data / Drill Options - Auto & Manual
  • Data Explore Options : Spotlight, Focus
  • Expand, Goto Next Level and Drill-up
  • See Data, Export Data, See Records
  • Include and Exclude Options, Multi-Field
  • Filters and Real-time Usage with Power BI
  • Using Report Filters and Page Filters
  • Using Drill-down Filters and Visual Filters
  • Apply and Clear Options with Value Filters
  • Adding Text Box, Images, Buttons Shapes
  • Big Data Access with Power BI

Chapter 10 : Power Query & M Language - 4

  • Data Modeling Options with Power Query
  • Modeling Operations - Custom Columns
  • Query Transforms, Sort Direction, Statistics
  • Enabling / Disabling Loads. ToList Options
  • Creating Parameters & Variables. Functions
  • Date and Time Columns. String Functions
  • Advanced Edit Options, Custom Queries
  • Custom Functions in Power Query M Lang
  • Grouping and Sub Groups with Queries
  • Binning with Groups and Query Formats
  • SubString Functions, Splits (Row, Column)
  • Parsing XML and JSON Files. Formatting

Chapter 16: Power BI Report Server

  • Settings and Power BI Admin Console
  • Configuring Power BI Report Server
  • Report Server Database TempDB Database
  • Webservice URL, Webportal URL - Usage
  • Report Builder Installation & 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
  • Publish RDL Reports to Power BI Cloud
  • Paginated Reports Vs Interactive Reports

Chapter 5 : Power BI Visual Properties - 1

  • Fields, Formats and Analytics Options
  • Table Visuals & Properties, Filters
  • Data Bar and Data Scaling Options
  • Divergent Property, Data Labels
  • Matrix : Sub Totals, Grand Totals
  • Drilldown Options : Row and Column
  • Stacked Bar Chart, Clustered Colum Chart
  • Stacked and Clustered Colum Chart
  • 100% Stacked Bar and Column Charts
  • Area & Stacked Area Chart. Ribbon Chart
  • Waterfall Chart, Scatter Chart, Pie Chart
  • Line, Doughnut TreeMap, Funnel, Gauge
  • DETAILED Properties of Every Visual
  • General, Labels, Values, Legend Options
  • Axis, Title, Markers, Filter Options

Chapter 11 : DAX Functions & Usage - 1

  • DAX : Importance and Real-time Usage
  • DAX Data Types and DAX Calculations
  • Syntax, Functions, Context Options
  • ROW Context and Filter Context in DAX
  • DAX Functions. Aggregates and Usage
  • Creating and Using Measures with DAX
  • Creating and Using Columns with DAX
  • Vertipaq Engine & Special Characters
  • Operators in DAX - Real-time Usage
  • 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

Chapter 17 : REST APIs & Power BI Admin

  • 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 (Interactive)
  • Power BI Mobile Publisher and Mobile Reports
  • Power BI Vs Tableau, SSRS, Sharepoint
  • Licensing & Pricing Plans in Power BI
  • MSBI SSAS and SSRS with Power BI
  • Custom Visuals in Power BI
  • Configuring Alerts in Power BI
  • Managing and Receiving Alerts
  • Power BI with OneDrive, Google Analytics
  • SaaS Components, OneDrive with PowerBI

Chapter 6 : Power BI Visual Properties - 2

  • Map Reports and Filled Map Reports
  • ArcGIS Maps and Real-time Usage. Options
  • Longitudes and Latitudes. Bing Maps
  • Color Analytical Maps, Styles, Options
  • KPI Reports - Target, Value and Trend
  • Plot Area & Responsiveness Properties
  • Sentiment Colors, Color Saturations
  • Breakdowns, Title, Axis Properties
  • Category & Data Lables, Constant Lines
  • Working with SLICER Visual : Value Filters
  • Horizontal and Vertical Slicer Filters
  • Single Select and MultiSelect Options
  • Frown (Errors), Details. Lock Aspects
  • Custom Visuals & PBIVIZ Files. Visual Sync
  • PBI : Options and Settings, VM Settings

Chapter 12 : DAX Functions & Usage - 2

  • Data Modeling with DAX. Creating Roles
  • Currency Conversions, Field Formatting
  • SUM and SUMX Functions: Differences
  • CALCULATE(), CALCULATEX() Functions
  • CALCULATETABLE Functions. VAR, VARP
  • DATESMTD, DATESQTD, DATESYTD
  • ENDOF(), FirstDay(), LastDay()
  • SAMEPERIODLASTYEAR, STARTOF()
  • Other DAX Functions and Examples
  • DAX Expressions with Quick Measure
  • DAX Usage for Row Level Security
  • Creating Roles with Power BI Desktop
  • DAX Filters and Multi Value Conditions
  • Manage Roles and Membership Options
  • VIEW AS ROLE. Information Functions

Chapter 18 :

New Features from Latest Releases of Power BI

Real-time Project 1 :

For Power BI Registrations: Real-time Project Implementation @ Climate Control Datasets and REST API

Real-time Project 2 :

For Power BI with SQL Server T-SQL Registrations: Real-time Project Implementation @ ERP Database

New Features from Latest Releases of Power BI

Note : Above course curriculum applicable for registrations from July 9th, 2018.

SQL Server & T-SQL Queries (Applicable for Plan B)

Module I: SQL Server & Design, Queries, Joins

Module II: T-SQL Queries, Tuning & Programming

CHAPTER 1: SQL SERVER INSTALLATION

  • What is Data? What is Database? File Store Limitations?
  • Why Microsoft SQL Server? Advantages (Technical/Usage)
  • SQL Server - Career Options, Certifications, Projects
  • What is SQL? What is T-SQL? Differences. Why T-SQL?
  • MSBI Components and Real-time Activities
  • Versions and Editions of SQL Server - Overview
  • Session Wise Plan, Material and Real-time Project Details
  • LAB PLAN - 24x7 LIVE Server (Online Lab)
  • SQL Server Software - Server Installation Steps
  • SQL Server Tools Installation and Verification
  • SSMS in Windows OS, SOS Tool in Mac & LINUX OS
  • H/W & S/W Requirements. Server Configuration Options
  • Instance Types : Default and Named Instances. Instance IDs
  • SQL Server Tools - SQL Server Management Studio (SSMS)

CHAPTER 7: STORED PROCEDURES - LEVEL 1

  • Stored Procedures - Purpose, Syntax, Properties and Types
  • Compilation, Precompilation and Query Optimization (QO)
  • Variables - Usage and Data Types in Stored Procedures
  • Parameters - Usage and Data Types in Stored Procedures
  • Stored Procedure Executions - Syntax, Alternate Options
  • Stored Procedures for Data Validations & Missing Identity
  • Stored Procedures for Dynamic SQL Queries. Views & SPs
  • Stored Procedures for Data Reporting. Advantanges, Tuning
  • Important System Procedures For Metadata Access. Usage
  • Important Extended Procedures For Application Operations
  • IF.. ELSE, IF .. ELSE IF, IIF Conditions. PRINT statements
  • Error Handling Techniques in T-SQL: TRY, CATCH, THROW
  • Dynamic Parameters and Variables. Examples with Views
  • Default Parameter Values, Data Types and NULL Values
  • Batch Executions with Stored Procedures. Variants

CHAPTER 2: SQL BASICS - DDL, DML, SELECT

  • Basic SQL for Beginners. Introducing Databases, Tables
  • What is SQL? Why T-SQL? Basic SQL Queries in SSMS
  • DDL and DML Statements - Creating & Using Databases
  • Table Creation (Basic Level) - Columns and Data Types
  • Issues with Digital Data into Characters. Missing Values
  • INSERT / Store Data into SQL Server Tables - Options
  • Single Row and Multiple Row Inserts with NULL Values
  • SELECT Queries and Basic Operators : IN, BETWEEN
  • IS, UNION, UNION ALL, Other Basic SQL Operators
  • UPDATE Statements with / without Conditions. SET
  • DELETE Statements with Conditions. Logging Options
  • TRUNCATE Statement - DELETE Comparisons, Logging
  • SYSTEM DATABASES - Purpose and Importance. Resource
  • CLIENT - SERVER Architecture (TDS) & Client Statistics

CHAPTER 8: STORED PROCEDURES - LEVEL 2

  • Stored Procedures for Sub Queries, Dynamic Queries
  • Using NCHAR and NVARCHAR in Stored Procedures
  • Variables and Parameters in Stored Procedures
  • Using Stored Procedures with Database Tables
  • Using Stored Procedures with Views and System Viewss
  • Metatada Access and Compilation Options
  • Important System Stored Procedures and Usage
  • Sp_help, Sp_helpdb, sp_pkeys, sp_helptext
  • Sp_recompile, sp_rename, sp_renamedb
  • User Defined Procedures with System SPs
  • Using Extended Stored Procedures - Usage
  • Recursion of Stored Procedures and Practical Usage
  • Stored Procedures for Dynamic Values, sysname data
  • Unicode Data and OUTPUT Parameters with SProcs

CHAPTER 3: SQL SERVER DATABASE DESIGN

  • SQL Database Architecture - Logical and Physical View
  • Database Properties - Files - Types - Storage Options
  • Data Files : Purpose and Sizing. Detailed Architecture
  • Filegroups : Purpose and Grouping Options. Properties
  • Log files : Sizing, Placement & Detailed Architecture
  • Pages, Extents (Uniform, Mixed). Data Allocation Process
  • Write Ahead Log (WAL) and Log Sequence Number (LSN)
  • Virtual Log File (VLF) and MINI LSN. Operation Audits
  • Database Creation using GUI - Adding Files, Filegroups
  • Database File and Filegroup Options. GUI Limitations
  • Database Creation using T-SQL Scripts. SYNTAX Rules
  • Database with Filegrowth, Autogrowth, MAXSIZE Options
  • mdf, ndf, ldf and Custom Extensions. Dynamic Extensions
  • Planning and Designing Very Large Databases (VLDB)
  • CHAR versus VARCHAR Differences - Type, Size Allocations

CHAPTER 9: VIEWS - FUNCTIONS & QUERIES

  • Views on Tables - Stored SELECT Statements, Data Access
  • SCHEMABINDING and ENCRYPTION Options - Advantages
  • Cascaded Views and WITH CHECK OPTION, Advantages
  • Orphan Views - Scenarios and Realworld Solutions
  • Common System Views For Metadata Access, Object IDs
  • Functions: Types, Purpose and Usage. Return Values
  • Scalar Value and Inline Table Value Functions
  • Multi-Line Table Value Returning Functions - Usage
  • Table Variables and Parameters in SQL Server. Usage
  • ROLLUP and CUBE - Sub Totals, Grand Totals, Aggregates
  • ROLLUP of Table Data. Column Aggregations. ORDER BY
  • CUBE on Table Data - Purpose & Usage. Permutations
  • Queries with GROUPING() Option in SELECT, Using HAVING
  • HAVING versus WHERE Conditions - Usage Differences

CHAPTER 4: TABLE DESIGN & QUERIES

  • Table Design - Creation. Columns - Data Types, Length
  • Routing Tables to Database File Groups, Advantages
  • Schemas - Purpose, Creation and Usage with Tables
  • Table Design using T-SQL Scripts - Syntax, Examples
  • Data Types, Length, NULLs and Naming Conventions
  • UNION, UNION ALL Operators. Differences, Row Order
  • CREATE, ALTER, DROP -- INSERT, UPDATE, DELETE
  • SELECT Queries with Schema on Tables, Column Aliases
  • T-SQL Data Types and NULL Values. Computed Columns
  • Comparing DELETE and TRUNCATE - TLog Files
  • T-SQL Operators: IN, BETWEEN, IS, AND, OR, EXISTS
  • Default Schema and Default Filegroup for Table Design
  • Basic Sub Queries - SELECT, MIN/ MAX. Column Aliases
  • Temporary Tables : Purpose and Types. Local and Global
  • Synonyms : Purpose. Alternate Object Reference, Queries

CHAPTER 10: TRANSACTIONS & TRIGGERS

  • Need for Transactions, Transaction Scenarios
  • ACID Properties and Transaction Types. Atomic Property
  • EXPLICIT, IMPLICIT Transactions - Query Blocking
  • IMPLICIT Transactions - Usage, Database Settings
  • AUTOCOMMIT Transactions - Advantages, Examples
  • OPEN Transactions and Audits. OPENTRAN commands
  • Nested Transactions and COMMIT / ROLLBACK Rules
  • SavePoint Options with Explicit Transactions, Rollbacks
  • LOCK HINTS : READPAST, NOLOCK, HOLDLOCK - Usage
  • Triggers - Purpose and Types. Scope Of Usage
  • DML Triggers - Events, Types and Practical Usage
  • FOR / AFTER Triggers and INSTEAD OF Triggers
  • INSERTED & DELETED Memory Tables with DML Triggers
  • Triggers for DML Operation Audits and Data Sampling
  • Database Triggers and Server Level Triggers

CHAPTER 5: CONSTRAINTS and KEYS

  • Constraints and Keys - Ensuring Table Data Integrity
  • Normal Forms - Types, Relational Database (RDB) Design
  • OLTP Database Model & BCNF - Relations with PK / UQ
  • NULL, NOT NULL and Default Nullability for Columns
  • UNIQUE KEY Constraints: Importance, Uniqueness, Nulls
  • PRIMARY KEY Constraint: Properties, Priority, Limitations
  • FOREIGN KEY Constraint: References, Relations & Usage
  • CHECK Constraints: Properties, Conditions and Usage
  • DEFAULT Constraints: Properties, Usage and Limitations
  • Relations with Tables across Multiple Schemas, Usage
  • Identity Property with / without PRIMARY KEY, Usage
  • Naming Conventions For Constraints, Columns and Tables
  • Normal Forms - Types, Purpose and Usage. With Examples
  • BCNF: Boycee-Codd Normal Form and Practical Usage

CHAPTER 11: INDEXES and QUERY TUNING OPTIONS

  • Indexes: Architecture (Page Level), Purpose and Types
  • Clustered Indexes - Architecture, Fragmentation Issues
  • Non Clustered Indexes - Architecture, Column References
  • Execution Plans and Query Optimization (QO) Techniques
  • Execution Plan - Table Scan, Index Scan and Index Seek
  • INCLUDED INDEXES - Index Seeks, Query Tuning
  • COLUMNSTORE Indexes - Advantages, Usage Examples
  • FILTERED Indexes & Online Indexes
  • Materialized Views / Indexed Views - Tuning Options
  • Query Optimizer (QO) Options for Index Pages, Data Pages
  • Limitations of Indexes - Impact on DML and SELECT
  • Primary Key Index, Composite Indexes and Precautions
  • RID and Index Key Concepts. Index Page - Data Page Arch"
  • Real-world Considerations For Indexes (Tables, Views)

CHAPTER 6: JOINS, SUB QUERIES & NESTED QUERIES

  • JOINS - Purpose and Types, Use Case Scenarios
  • JOIN - Types, Queries and Importance of Reports
  • CROSS JOIN in detail. Examples and Conditions @ WHERE
  • INNER JOIN in detail. Examples with WHERE and ON
  • Comparing INNER JOIN with CROSS JOIN for Conditions
  • OUTER JOINS in detail. LEFT, RIGHT and FULL Joins
  • SELF JOINS with INNER / OUTER Joins. Usage Scenarios
  • Working with Self Joins on non key columns, advantages
  • JOINS with more than 2 tables. Syntax, Precedence Order
  • Query Optimization Considerations with Schema References
  • Deciding the best Join Type, Order and Query Options
  • JOIN Queries with Options and UNION, UNION ALL Operators
  • Basic Sub Queries and Joins. Alternate Syntax & Queries
  • Using ON and WHERE for Join Conditions. Working with NULLs
  • Using SubQueries for Self Joins and Outer Joins
  • Working with Nested Queries and Nested Sub Queries
  • Using Sub Queries and Nested Sub Queries with Outer Joins
  • End User Access to SQL Databases - Reporting Tools, Options
  • A Real-world Case Study understanding Joins & Queries

CHAPTER 12: SQL SERVER ARCHITECTURE

  • Client - Server Architecture of SQL Server
  • SQL Server Tools - Connection Options, TDS Packets
  • Protocols : TCP / IP, Named Pipes, Shared Memory
  • SQL Native Client (SNAC) and OLE DB Drivers / Providers
  • ISO - OSI Model of Data Connections, Encrypted Data
  • Query Processing and Query Optimizer (QO) Components
  • SQL Server Architecture For Database Engine, LCM Options
  • Architecture - Query Processor and Storage Engine
  • Architecture - Query Parser, Optimizer, Mini LSN, MDAC
  • Architecture - SQL Engine, SQL Manager and Query Buffers
  • Architecture - Write Ahead Log (WAL), Lazy Writer Threads
  • Architecture - SQLOS Threads and Task Schedulers, CLR
  • SQL Database Architecture - RAID Levels (S/W, H/W)
  • Log Sequence Numbers (LSN) and Time Mapping. Audits
  • Log File Architecture - Virtual Log Files and Usage
  • Log File Architecture - Mini LSN & Degree Of Parallelism
  • DB Catalogs, CLR Integration and MDAC Components
  • LSN Timestamps and MINILSN. Background Threads @ SQL
  • Version Differences: SQL Server 2014, 2016, 2017
 
EVERY SESSION IS COMPLETELY PRACTICAL. REAL-TIME. TASKS, MATERIAL, LAB WORK for EVERY SESSION. 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