Azure DevOps Training

Official Learning Partner

Course Highlights

Complete Real-time and Practical Azure DevOps Training with Real-time Scenarios. This Azure DevOps Training includes Basic to Advanced DevOps Concepts and SDLC Implementation in Azure Platform. This Azure DevOps Training course also includes Azure Fundamentals, Azure Active Directory, Azure Storage, Azure Services, Docker and kubernetes Containers.
This Azure DevOps Training course also incldues Azure Work Item Process Types: Basic, Agile, Scrum and CMMI with Kanban Boards, Queries, CI / CD Pipelines, Integrations, Azure Repos, Azure Test Cases, Azure Artifacts, Git and VSTS Integrations with Azure DevOps Service and Azure DevOps Server.

Azure DevOps and azure fundamentals video banner

Course Content

Azure DevOps
Training Course Contents:

Brochure Download Register Now

Module 1 : SQL Server & T-SQL Queries [For Plans B, C]

Ch 1: SQL SERVER INTRODUCTION

Data, Databases and RDBMS Software
Database Types : OLTP, DWH, OLAP
Microsoft SQL Server Advantages, Use
Versions and Editions of SQL Server
SQL : Purpose, Real-time Usage Options
SQL Versus Microsoft T-SQL [MSSQL]
Microsoft SQL Server – Career Options
SQL Server Components and Usage
Database Engine Component and OLTP
BI Components, Data Science Components
ETL, MSBI and Power BI Components
Course Plan, Concepts, Resume, Project
24 x 7 Online Lab for Remote DB Access
Software Installation Pre-Requisites

Ch 2: SQL SERVER INSTALLATIONS

System Configuration Checker Tool
Versions and Editions of SQL Server
SQL Server and SSMS Installation Plan
SQL Server Pre-requisites : S/W, H/W
SQL Server 2016 / 2017 Installation
SQL Server 2019 Installation
Instance Name and Server Features
Instances : Types and Properties
Default Instance, Named Instances
Port Numbers, Instance Differences
Service and Service Account Use
Authentication Modes and Logins
Windows Logins and SQL Logins
FileStream and Collation Properties

Ch 3: SSMS Tool, SQL BASICS – 1

SQL Server Management Studio
Local and Remote Connections
System Databases: Master and Model
MSDB, TempDB, Resource Databases
Creating Databases : Files [MDF, LDF]
Creating Tables in User Interface
Data Insertion & Storage. Limitations
SQL : Purpose and Real-time Usage
SQL Versus T-SQL : Basic Differences
DDL, DML, SELECT, DCL and TCL
Creating Tables using SQL Scripts
Data Storage, Inserts – Basic Level
Table Data Verifications with Select
SELECT Statement for Table Retrieval

Ch 4: SQL BASICS – 2

Creating Databases & Tables in SSMS
Single Row Inserts, Multi Row Inserts
Rules for Data Insertion Statements
SELECT Statement @ Data Retrieval
SELECT with WHERE Conditions
Batch Concept and Go Statement
AND and OR Operators Usage
IN Operator and NOT IN Operator
Between, Not Between Operators
LIKE and NOT LIKE Operators
UPDATE Statement & Conditions
DELETE & TRUNCATE Statements
Logged and Non-Logged Operations
ADD, ALTER and DROP Columns
ALTER & DROP Table Statements

Ch 5: SQL Basics – 3, T-SQL INTRO

Database Objects : Tables and Schemas
Schemas : Group Tables in Database
Schemas : Security Management Object
Creating Schemas & Batch Concept
Using Schemas for Table Creation
Data Storage in Tables with Schemas
Data Retreival and Usage with Schemas
Table Migrations across Schemas
Import and Export Wizard in SSMS
Data Imports with Excel File Data
Performing Bulk Operations in SSMS
Temporary Tables : Real-time Use
Local and Global Temporary Tables
# and ## Prefix, Scope of Usage

Ch 6 : CONSTRAINTS,INDEXES Basics

Constraints and Keys – Data Integrity
NULL, NOT NULL Property on Tables
UNIQUE KEY Constraints: Importance
PRIMARY KEY Constraint: Importance
FOREIGN KEY Constraint: Importance
REFERENCES, CHECK and DEFAULT
Candidate Keys and Identity Property
Database Diagrams and ER Models
Relationships Verification and Links
Indexes : Basic Types and Creation
Index Sorting and Search Advantages
Clustered and NonClustered Indexes
Primary Key and Unique Key Indexes
Need for Indexes – working with Keys

Ch 7: JOINS, T-SQL Queries : Level 1

JOINS – Table Comparisons Queries
INNER JOINS For Matching Data
OUTER JOINS For (non) Match Data
Left Outer Joins with Example Queries
Right Outer Joins with Example Queries
FULL Outer Joins – Realtime Scenarios
Join Queries with “ON” Conditions
Join Unrelated Tables in SQL Server
NULL, IS NULL Operators in Joins
CROSS JOIN and CROSS APPLY
CROSS JOIN Versus CROSS APPLY
One-way & Two Way Data Comparisons
Important Join Queries in T-SQL
Join Options: Merge, Loop, Hash

Ch 8: Group By, T-SQL Queries Level 2

GROUP BY Queries and Aggregations
Group By Queries with Having Clause
Group By Queries with Where Clause
Using WHERE and HAVING in T-SQL
Rollup : Usage and T-SQL Queries
Cube : Usage and T-SQL Queries
UNION and UNION ALL Operator
EXISTS Operator, Query Conditions
Sub Queries and Alternatives to Joins
Using Joins with Group By Queries
Using Joins with Nested Sub Queries
Sub Queries with Joins and Group By
Using UNION and UNION ALL in Queries
Nested Sub Queries with Group By, Joins
Comparing WHERE, HAVING Conditions

Ch 9: JOINS, T-SQL QUERIES Level 3

GetDate, Year, Month, Day Functions
Date & Time Styles, Data Formatting
DateAdd and DateDiff Functions
Cast and, Convert Functions in Queries
String Functions: SubString, Relicate
Len, Upper, Lower, Left and Right
LTrim, RTrim, CharIndex Functions
MERGE Statement – Comparing Tables
WHEN MATCHED and NOT MATCHED
Incremental Load with MERGE Statement
IIF() Function for Value Compares
CASE Statement : WHEN, ELSE, END
ROW_NUMBER() and RANK() Queries
Dense Rank and Partition By Queries

Ch 10: VIEW, SPs, Function Basics

Views : Types, Usage in Real-time
System Predefined Views and Audits
Listing Databases, Tables, Schemas
Functions : Types, Usage in Real-time
Scalar, Inline and Multi-Line Functions
System Predefined Functions, Audits
DBId, DBName, ObjectID, ObjectName
Variables & Parameters in SQL Server
Procedures : Types, Usage in Real-time
User & System Predefined Procedures
Parameters and Dynamic SQL Queries
Sp_help, Sp_helpdb and sp_helptext
sp_pkeys, sp_rename and sp_help
Important System Objects and Metadata

Ch 11: Triggers & Transactions

Triggers – Purpose, Real-world Usage
FOR/AFTER Triggers – Real time Use
INSTEAD OF Triggers – Real time Use
INSERTED, DELETED Memory Tables
Using Triggers for Data Replication
Enable Triggers and Disable Triggers
Database Level, Server Level Triggers
Transactions : Types, ACID Properties
Transaction Types and AutoCommit
EXPLICIT & IMPLICIT Transactions
COMMIT and ROLLBACK Statements
Open Transaction Scenarios & Cause
Query Blocking Scenarios @ Real-time
NOLOCK and READPAST Lock Hints

Ch 12 : ER MODELS, NORMAL FORMS

Normal Forms for Entity Relationships
First Normal Form and Atomocity
Second Normal Form, Candidate Keys
3rd Normal Form Multi Value Dependancy
Boycee-Codd Normal Form : BNCF
Fourth Normal Form Realtime Advantages
Self Joins & Self Reference Keys
1:1, 1:M, M:1, M:M Relationship Types
Joins with Group By Queries
Joins with Sub Queries, Formating
Office Data Connections, Excel Reports
Excel Pivot Reports and Reports
SQL Queries (Auto Generated) in BI Tools
FETCH OFFSET, NEXT ROWS, Order By
Data Refresh (Manual and Automated)

Real-time Case Study – 1 (Sales & Retail)
Objective : Database Design, Table Design and Relations.
Involves Purchases, Products, Customers and Time Data with Various Data Types.

Real-time Case Study – 2 (Sales & Retail)
Objective : Queries, Excel Integration
Pivot Tables, Pivot Charts, ODC Connections

Module 2: Azure DevOps Training Content [For Plans A, B, C]

Azure Funda & DevOps Basics

Ch 1. Azure DevOps Introduction

DevOps : Introduction and Usage
Software Development Life Cycle
Analysis, Design and Implementation
Testing, Deployment & Maintenance
Advantages of SDLC inSoftware
SDLC Implementation Techniques
Waterfall Method & Advantages
Agile Software Development Method
Need for DevOps Implementations
Need for Azure DevOps Implmentation
Azure DevOps : Phases, LifeCycle
Continious Integration and Testing
Continious Deployment, Monitoring

Ch 2. Azure DevOps Org & Security

Azure Account Registartion & Logins
Azure Account Operations in Portal
DevOps Organization Creation
Organization Layout, Unique Names
Organization Entities: Projects, Users
Billing, Auditting, Notifications, Usage
Azure Active Directory Concepts
Azure AD Users : Creation & Use
Azure AD Groups : Creation & Use
AAD Concepts with Azure DevOps
Security Operations with Azure AD
Linking Azure AD Users to DevOps
Tenant Creation and Real-time Use

Ch 3. Azure DevOps Projects, Boards

Azure DevOps Organizations, Projects
Azure DevOps Projects: Entities
Teams, Boards, Repos, Pipelines
Test Plans and Artifacts in Projects
Work Item: Tasks, Bugs & Test Cases
Azure DevOps Work Item Types (WIT)
Overview of Basic and Agile WIT
Overview of CMMI and SCRUM
Inherited Proces, Version Controls
Project Creation and Project Types
Azure DevOps Project Creation, Security
Project Level Operations, Azure Boards
Basic Vocabulary: Items, Epic, Issue

Ch 4. Basic Work Item, Azure Boads

Work Item Concept: Basic WIT
Epics, Issues and Tasks in WIT
Organizing and Tracking WIT
ToDo, Doing and Done Tasks
Backlog Process: Started / Compelted
Epic Creation and Properties
Issue Creation and Properties
Kanban Boards and WIT Reports
Epic and Issue Verifications
Assigned To, Priority and State
Layout Changes in Azure DevOps
Task Completion, State History
Activity Checks, Links, Attachments

Ch 5: Azure Boards: Backlogs, Sprints

Backlogs and Sprints in Basic Type
Product Backlog & Sprint Backlog
Create Work Item : Epic & Issue
Backlogs: Creation, Title, Assign To
Setting Priority and Add Task
Add Issue, New Work Items
User Stories and Effort Estimate
Azure Boards: Queries and Audits
Listing Items and Work Reviews
Triage and Charts (Dashboards)
Parent – Child Related Work Items
Assigned To Me and Followed By

Ch 6: Work Item : Agile Process

Agile Work Item Process Usage
Epic, Feature, User Story, Task
Bug and Work Item Levels
Portfolio Level, Backlog Level
Issue and Bug Level in Agile
Feature, User Story and Tasks
Adding Users to Backlogs, Tests
Backlogs, Tests, Test Plans in Agile
Test Suite and Test Cases in Agile
Agile Work Flow and Glossary
Work Item Status in Agile: New
Active, Closed and Resolved Status

Azure DevOps Service – 1

Ch 7: CMMI Process and Workflow

Azure Boards with CMMI Process
Analysis, Design, Implemention Phases
Testing & Support Phases in CMMI
Work Item Types: Epic, Bug, Feature
Change Request, Issue, Requirement
Tasks, Reviews, Risk and Test Cases
Work Item field index page
Activity, Triage, Committed, Blocked
Subject Matter Expert (SME), Tasks
State, Triage and Commtted Fields
Assigned To, User Acceptance Tests
Origina Estimate, Time Criticality

Ch 8: Scrum Work Item Process

Scrum Work Item Process, Usage
Epics, Backlogs, Bugs and Tasks
Approve, Commit, Work Status
Work Completed / Work Stopped
Move / Remove Backlog Items
Task Level Work Items in DevOps
PBI and Bugs in Scrum Process
Tracking Impediments, Hierarchy
Implementing Scrum Process Item
Assigning, Securing Scrum Items
Limitations with Scrum Process
Comparing Work Item Process

Ch 9: Inherited Work Item Process

Limitations with System Processes
Need for Inherited Work Items
Creating and Using Inherited Items
Creating New Projects and Items
Default Process and Clone Options
Security Roles: Administrator
Delete and Edit Process Roles
Creating Organizations & Projects
Creating New Work Items & Epics
Descriptions, Groups and Fields
Layouts and Options with Items
Removing WIT, Project & Org

Ch 10: Kanban Boards, Customization

Kanban Boards for Process Reports
Cards : Epic / Issue Status Tracking
Backlog, Active, Resolved, Closed
Define Work Items and Tracking
Product & Portfolio Kanban boards
Swimlanes: Creation and Usage
Work-in-Progress (WIP) Limits
Work in Progress Limits & Usage
Highlight Cards, Define Style Rules
Customizing Kanban Boards
Customize Fields & Styles in Kanban
Splits, Tags, Card Order, Burn Down

Ch 11: Azure Repos, Version Control, Git

Version Control Systems (VCS)
Create workflows, Work with versions
Code together, Version Synchronize
Team Foundation Version Control
GIT : A Distributed System & use
Work Stations and Remote Repos
Git Installation, Repos, git init, git add
git commit, git status, git config
git branch, git checkout, git merge
git remote, git clone, git push
git push, git stash, git log, git rm
Remote Repos (GitHub & Bitbucket)

Ch 12: Azure Repos and Branching

Azure Repos : Configurations, Usage
Azure git Inititalization, Limitations
Need for Tortoise Git, Advantages
git add –all command and Options
git commit -m, git push, git add
git pull and Merging / Branching
Tortoise Git: Installation, Usage
Cloning with Tortoise git, Uploads
Azure Repos: Branching Concept
git branch and changesets in VCS
Branching: Features & Advantages
git branch, git checkout Operations

Azure DevOps Service – 2 Azure DevOps Server

Ch 13: Visual Studio with Azure Repos

Using Visual Studio for Azure Repos
Version Control with Visual Studio
Team Explorer and Cloning Options
Git Changes, Branching & Merging
Synchronization with Azure Repos
Push / Pull and Commit Options
Azure Pipelines and Real-time Use
Version Controls & Deployments
Azure Pipeline Process, Monitoring
Azure Pipelie Advantages, Pricing
CI & CD Pipelines, CI/CD Tools
Azure Pipeline Types & Targets

Ch 14: Continous Integration (CI)

Continous Integration (CI) & Builds
Build Pipelines in Azure DevOps
Local Development and Builds
Git Version Controls / Visual Studio
Azure DevOps Service, Azure Repo
Working with CI Pipelines in Realtime
Azure SQL Database Projects
DACPAC Files : Creation and Tests
Visual Studio Builds and Locations
Git Configuration and Commits
Continious Integration Options
Running CI Pipelines in Azure DevOps

Ch 15: Release Pipelines in Azure DevOps

Release Pipelines : Creation, Usage
Continous Delivery and Deployments
Pre-Production and Production Stages
Working of Release Pipelies in Azure
Pre Deployment, Queue and Agents
Artifacts and Run Deployment Tasks
Release Pipelines and Jobs in Azure
Cloud Deployments in Real-time
SQL Database Deployments in Azure
Creating Releases, Linking Artifacts
Creating Jobs and Execution Context
Post Deployment & Script Verification

Ch 16: Azure and Power BI Pipelines

DevOps Pipelines for Azure Resources
Creating Classic Model Pipelines
Creating New Jobs and Steps
Creating Resource Groups, Parameters
Data Factory Operations & Pipelines
Commenting and Running Pipelines
LIVE Metrics and Log Reports (RAW)
Power BI with Azure DevOps
Power BI Parameters, Azure Pipelines
Pipeline Runs in Dev, Test and Prod
Query Caching, Document CS, Actions
Builds, Artifact Stating Directories

Ch 17: Containers in Azure DevOps

Containerization Concepts, Uses
Comparing VMs and Containers
Advantages of Containers over VM
Prepacked Entities and Dockers
Security Advantages with Containers
Using Containers in Azure DevOps
Azure Containers & Kubernetes
Dev and Test Environments
Docker Hub and App Installations
Docker Container Engine and Use
Docker Architecture, Docker Daemons
Docker Containers & Registries Usage

Ch 18: DevOps Server – Configurations

Azure DevOps Server – Advantages
On-Premise Configurations for Server
Code Share, Track Work and Shipping
Visual Studio Team Fundation Server
Azure DevOps Server – Installation
Criterion for Azure DevOps Server
SQL Server Installation for DevOps
Database Engine, FullText Search
Creating Projects in DevOps Server
Creating Work Items and Processes
Work Item Tracking and Reports
Real-time Usage with DevOps Server

Module 3: Power BI Training Content

Part 1: Power BI Report Design

Ch 1 : POWER BI BASICS

Power BI Job Roles in Real-time
Power BI Data Analyst Job Roles
Business Analyst – Job Roles
Power BI Developer – Job Roles
Power BI for Data Scientists
Comparing MSBI and Power BI
Comparing Tableau and Power BI
MCSA 70-778, MCSA 70-779 Exam
Types of Reports in Real-World
Interactive & Paginated Reports
Analytical & Mobile Reports
Data Sources Types in Power BI
Power BI Licensing Plans – Types
Power BI Training : Lab Plan
Power BI Dev & Prod Environments

Ch 2: BASIC REPORT DESIGN

Power BI Desktop Installation
Data Sources & Visual Types
Canvas, Visualizations and Fields
Get Data and Memory Tables
In-Memory xvelocity Database
Table and Tree Map Visuals
Format Button and Data Labels
Legend, Category and Grid
PBIX and PBIT File Formats
Visual Interaction, Data Points
Disabling Visual Interactions
Edit Interactions – Format Options
SPOTLIGHT & FOCUSMODE
CSV and PDF Exports. Tooltips
Power BI EcoSystem, Architecture

Ch 3 : Visual Sync, Grouping

Slicer Visual : Real-time Usage
Orientation, Selection Properties
Single & Multi Select, CTRL Options
Slicer : Number, Text and Date Data
Slicer List and Slicer Dropdowns
Visual Sync Limitations with Slicer
Disabling Slicers,Clear Selections
Grouping : Real-time Use, Examples
List Grouping and Binning Options
Grouping Static / Fixed Data Values
Grouping Dynamic / Changing Data
Bin Size and Bin Limits (Max, Min)
Bin Count and Grouping Options
Grouping Binned Data, Classification

Ch 4 : Hierarchies, Filters

Creating Hierarchies in Power BI
Independent Drill-Down Options
Dependant Drill-Down Options
Conditional Drilldowns, Data Points
Drill Up Buttons and Operations
Expand & Show Next Level Options
Dynamic Data Drills Limitations
Show Data and See Records
Filters : Types and Usage in Real-time
Visual Filter, Page Filter, Report Filter
Basic, Advanced and TOP N Filters
Category and Summary Level Filters
DrillThru Filters, Drill Thru Reports
Keep All Filters” Options in DrillThru
CrossReport Filters, Include, Exclude

Ch 5 : Bookmarks, Azure, Modeling

Drill-thru Filters, Page Navigations
Bookmarks : Real-time Usage
Bookmarks for Visual Filters
Bookmarks for Page Navigations
Selection Pane with Bookmarks
Buttons, Images with Actions
Buttons, Actions and Text URLs
Bookmarks View & Selection Pane
OLTP Databases, Big Data Sources
Azure Database Access, Reports
Import & Direct Query with Power BI
SQL Queries and Enter Data
Data Modeling : Currency, Relations
Summary, Format, Synonyms
Web View & Mobile View in PBI

Ch 6 : Visualization Properties

Stacked Charts and Clustered Charts
Line Charts, Area Charts, Bar Charts
100% Stacked Bar & Column Charts
Map Visuals: Tree, Filled, Bubble
Cards, Funnel, Table, Matrix
Scatter Chart : Play Axis, Labels
Series Clusters & Selections
Waterfall Chart and ArcGIS Maps
Infographics, Icons and Labels
Color Saturation, Sentiment Colors
Column Series, Column Axis in Lines
Join Types : Round, Bevel, Miter
Shapes, Markers, Axis, Plot Area
Display Units,Data Colors,Shapes
Series, Custom Series and Legends

Part 2: ETL, Data Modeling, DAX

Ch 7 : POWER QUERY LEVEL 1

Power Query M Language Purpose
Power Query Architecture and ETL
Data Types, Literals and Values
Power Query Transformation Types
Table & Column Transformations
Text & Number Transformations
Date, Time and Structured Data
List, Record and Table Structures
let, source, in statements @ M Lang
Power Query Functions, Parameters
Invoke Functions, Execution Results
Get Data, Table Creations and Edit
Merge and Append Transformations
Join Kinds, Advanced Editor, Apply
ETL Operations with Power Query

Ch 8 : POWER QUERY LEVEL 2

Query Duplicate, Query Reference
Group By and Advanced Options
Aggregations with Power Query
Transpose, Header Row Promotion
Reverse Rows and Row Count
Data Type Changes & Detection
Replace Columns: Text, NonText
Replace Nulls: Fill Up, Fill Down
PIVOT, UNPIVOT Transformations
Move Column and Split Column
Extract, Format and Numbers
Date & Time Transformations
Deriving Year, Quarter, Month, Day
Add Column : Query Expressions
Query Step Inserts and Step Edits

Ch 9 : POWER QUERY LEVEL 3

Creating Parameters in Power Query
Parameter Data Types, Default Lists
Static/Dynamic Lists For Parameters
Removing Columns and Duplicates
Convert Tables to List Queries
Linking Parameters to Queries
Testing Parameters and PBI Canvas
Multi-Valued Parameter Lists
Creating Lists in Power Query
Converting Lists to Table Data
Advanced Edits and Parameters
Data Type Conversions, Expressions
Columns From Examples, Indexes
Conditional Columns, Expressions

Ch 10 : DAX Functions – Level 1

DAX : Importance in Real-time
Real-world usage of Excel, DAX
DAX Architecture, Entity Sets
DAX Data Types, Syntax Rules
DAX Measures and Calculations
ROW Context and Filter Context
DAX Operators, Special Characters
DAX Functions, Types in Real-time
Vertipaq Engine, DAX Cheat Sheet
Creating, Using Measures with DAX
Creating, Using Columns with DAX
Quick Measures and Summaries
Validation Errors, Runtime Errors
SUM, AVERAGEX, KEEPFILTERS
Dynamic Expressions, IF in DAX

Ch 11 : DAX Functions – Level 2

Data Modeling Options in DAX
Detecting Relations for DAX
Using Calculated Columns in DAX
Using Aggregated Measures in DAX
Working with Facts & Measures
Modeling : Missing Relations
Modeling : Relation Management
CALCULATE Function Conditions
CALCULATE & ALL Member Scope
RELATED & COUNTROWS in DAX
Entity Sets and Slicing in DAX
Dynamic Expressions, RETURN
Date, Time and Text Functions
Logical, Mathematical Functions
Running Total & EARLIER Function

Ch 12 : DAX FUNCTIONS Level 3

1:1, 1:M and M:1 Relations
Connection with CSV, MS Access
AVERAGEX and AVERAGE in DAX
KEEPFILTERS and CALCUALTE
COUNTROWS, RELATED, DIVIDE
PARALLELPERIOD, DATEDADD
CALCULATE & PREVIOUSMONTH
USERELATIONSHIP, DAX Variables
TOTALYTD , TOTALQTD
DIVIDE, CALCULATE, Conditions
IF..ELSE..THEN Statement
SELECTEDVALUE, FORMAT
SUM, DATEDIFF Examples in DAX
TODAY, DATE, DAY with DAX
Time Intelligence Functions – DAX

Part 3: Power BI Cloud, Admin

Ch 13 : POWER BI CLOUD – 1

Power BI Service Architecture
Power BI Cloud Components, Use
App Workspaces, Report Publish
Reports & Related Datasets Cloud
Creating New Reports in Cloud
Report Publish and Report Uploads
Dashboards Creation and Usage
Adding Tiles to Dashboards
Pining Visuals and Report Pages
Visual Pin Actions in Dashboards
LIVE Page Interaction in Dashboard
Adding Media: Images, Custom Links
Adding Chs and Embed Links
API Data Sources, Streaming Data
Streaming Dataset Tiles (REST API)

Ch 14 : POWER BI CLOUD – 2

Dashboards Actions,Report Actions
DataSet Actions: Create Report
Share, Metrics and Exports
Mobile View & Dashboard Themes
Q & A [Cortana] and Pin Visuals
Export, Subscribe, Subscribe
Favorite, Insights, Embed Code
Featured Dashboards and Refresh
Gateways Configuration, PBI Service
Gateway Types, Cloud Connections
Gateway Clusters, Add Data Sources
Data Refresh : Manual, Automatic
PBIEngw Service, ODG Logs, Audits
DataFlows, Power Query Expressions
Adding Entities and JSON Files

Ch 15 : EXCEL & RLS

Import and Upload Options in Excel
Excel Workbooks and Dashboards
Datasets in Excel and Dashboards
Using Excel Analyzer in Power BI
Using Excel Publisher in PBI Cloud
Excel Workbooks, PINS in Power BI
Excel ODC Connections, Power Pivot
Row Level Security (RLS) with DAX
Need for RLS in Power BI Cloud
Data Modeling in Power BI Desktop
DAX Roles Creation and Testing
Adding Power BI Users to Roles
Custom Visualizations in Cloud
Histogram,Gantt Chart,Infographics

Ch 16 : Report Server, RDL

Need for Report Server in PROD
Install, Configure Report Server
Report Server DB, Temp Database
Webservice URL, Webportal URL
Creating Hybrid Cloud with Power BI
Using Power BI DesktopRS
Uploading Interactive Reports
Report Builder For Report Server
Report Builder For Power BI Cloud
Designing Paginated Reports (RDL)
Deploy to Power BI Report Server
Data Source Connections, Report
Power BI Report Server to Cloud
Tenant IDs Generation and Use
Mobile Report Publisher, Usage

Ch 17: MSBI Integrations

Power BI with SQL Server Source
Power BI with SQL Data Warehouse
Power BI with SSAS OLAP Server
Power BI with Azure SQL DB Source
Power BI with Azure SQL Warehouse
Power BI with Azure Analysis Server
Power BI with SSRS (RDL) Reports
Power BI Report Builder Tool
Installation & Configuration
Paginated Reports Design, Use
Data Sources, Datasets, RDL
Report Publish (RDL) to Cloud
Report Verifications, Data Sync
Interactive Vs Paginated Reports
Creating, Managing Alerts in Cloud

Ch 18 : REAL-TIME PROJECT

Project Requirement Analysis
Implementing SDLC Phases
Requirement Gathering, FSA

Phase 1:

PBIX Report Design
Visualizations, Properties
Analytics and Formating

Phase 2:

Data Modeling, Power Query
Dynamic Connections, Azure DB
Parameters and M Lang Scripts

Phase 3:

DAX Requirements, Analysis
Cloud and Report Server
Project FAQs and Solutions

Azure DevOps Training Plans

	Plan A 1. Azure DevOps	Plan B 1. SQL Server TSQL 2. Azure DevOps	Plan C 1. SQL Server TSQL 2. Power BI 3. Azure DevOps
Course Duration	4 Weeks	7 Weeks	11 Weeks
Azure DevOps Benefits	✔	✔	✔
SDLC, Dev & Operations, DevOps	✔	✔	✔
DevOps Tools, Git & GitHub	✔	✔	✔
Docker, Kubernetes, AzureDevOps	✔	✔	✔
Azure Boards, Azure Repos	✔	✔	✔
Azure Testing, Azure Artifacts	✔	✔	✔
Azure Pipelines (CI, CD)	✔	✔	✔
SQL : Basic SQL, SQL Server Concepts	✖	✔	✔
T-SQL : Queries, Joins, Group By	✖	✔	✔
T-SQL : Queries, SProcs, Lock Hints	✖	✔	✔
T-SQL: Queries, Normal Forms, Excel	✖	✔	✔
Power BI: Report Design, Visuals	✖	✖	✔
Power BI: Report Design, Visuals	✖	✖	✔
Power BI: Power Query & ETL	✖	✖	✔
Power BI: Data Modelling @ DAX	✖	✖	✔
Power BI: Cloud, Excel Analyzer	✖	✖	✔
Power BI: Mobile, R, REST API	✖	✖	✔
Total Course Fee*	INR 12000USD 150	INR 17000USD 200	INR 22000USD 315

SQL Server & T-SQL Schedules

S No	Time (IST, Mon - Fri)	Start Date	Trainer	Register
1	6 AM - 7 AM	Nov 11th	Mr. Sai Phanindra	Register
2	9 AM - 10 AM	Nov 26th	Mr. Sai Phanindra	Register
3	10 AM - 11 AM	Nov 5th	Mr. Sai Phanindra	Register
4	7 PM - 8 PM	Nov 18th	Mr. Sai Phanindra	Register

Azure DevOps Training Schedules

S No	Time (IST, Mon - Fri)	Start Date	Register
1	6 AM - 7:30 AM (W)	Coming Soon	Register

Power BI Training Schedules

S No	Time (IST, Mon - Fri)	Start Date	Trainer	Register
1	8 AM - 9 AM	Nov 19th	Mr. Sai Phanindra	Register
2	6 PM - 7 PM	Nov 5th	Mr. Sai Phanindra	Register

CURRICULUM

SQL SCHOOL

24x7 LIVE Online Server (Lab) with Real-time Databases.
Course includes ONE Real-time Project.

Technical FAQs

Who is SQL School? How far you have been in the training services ?

SQL School is a registered training institute, established in February 2008 at Hyderabad, India. We offer Real-time trainings and projects including Job Support exclusively on Microsoft SQL Server, T-SQL, SQL Server DBA and MSBI (SSIS, SSAS, SSRS) Courses. All our training services are completely practical and real-time.CREDITS of SQL School Training Center

We are Microsoft Partner. ID# 4338151
ISO Certified Training Center
Completely dedicated to Microsoft SQL Server
All trainings delivered by our Certified Trainers only
One of the few institutes consistently delivering the trainings for more than 8+ Years online as inhouse
Real-time projects in
- Healthcare
- Banking
- Insurance
- Retail Sales
- Telecom
- ECommerce

I registered for the Demo but did not get any response?

Make sure you provide all the required information. Upon Approval, you should be receiving an email containing the information on how to join for the demo session. Approval process usually takes minutes to few hours. Please do monitor your spam emails also.

Why you need our Contact Number and Full Name for Demo/Training Registration?

This is to make sure we are connected to the authenticated / trusted attendees as we need to share our Bank Details / Other Payment Information once you are happy with our Training Procedure and demo session. Your contact information is maintained completely confidential as per our Privacy Policy. Payment Receipt(s) and Course Completion Certificate(s) would be furnished with the same details.

What is the Training Registration & Confirmation Process?

Upon submitting demo registration form and attending LIVE demo session, we need to receive your email confirmation on joining for the training. Only then, payment details would be sent and slot would be allocated subject to availability of seats. We have the required tools for ensuring interactivity and quality of our services.

Please Note: Slot Confirmation Subject to Availability Of Seats.

Will you provide the Software required for the Training and Practice?

Yes, during the free demo session itself.

How am I assured quality of the services?

We have been providing the Trainings – Online, Video and Classroom for the last EIGHT years – effectively and efficiently for more than 100000 (1 lakh) students and professionals across USA, India, UK, Australia and other countries. We are dedicated to offer realtime and practical project oriented trainings exclusively on SQL Server and related technologies. We do provide 24×7 Lab and Assistance with Job Support – even aftrer the course! To make sure you are gaining confidence on our trainings, participans are requested to attend for a free LIVE demo based on the schedules posted @ Register. Alternatively, participants may request for video demo by mailing us to contact@sqlschool.com Registration process to take place once you are happy with the demo session. Further, payments accepted in installments (via Paypal / Online Banking) to ensure trusted services from SQL School™

YES, We use Enterprise Edition Evaluation Editions (Full Version with complete feature support valid for SIX months) for our trainings. Software and Installation Guidance would be provided for T-SQL, SQL DBA and MSBI / DW courses.

Why Choose SQL School

100% Real-Time and Practical
ISO 9001:2008 Certified
Concept wise FAQs
TWO Real-time Case Studies, One Project
Weekly Mock Interviews
24/7 LIVE Server Access
Realtime Project FAQs
Course Completion Certificate
Placement Assistance
Job Support
Realtime Project Solution
MS Certification Guidance

Trending Courses

A laptop on a desk with a lamp. Azure DevOps