Skip to main content

#Azure DevOps

  • ✅ Agile Project Management
  • ✅ Version Control
  • ✅ CI/CD Pipelines 
  • ✅ Testing & Quality Assurance
  • ✅ Package Management
  • ✅ Security & Compliance
  • ✅ Integration & Extensibility
  • ✅ Scalability & Flexibility
  • ✅ Collaboration & Code Review
Register NowReach Trainer

SQL Server & TSQL Schedules

S NoTime (IST, Mon - Fri)Start Date
16 AM - 7 AMSep 2nd
210 AM - 11 AMAug 26th
36 PM - 7 PMSep 8th
48 PM -9 PMAug 19th

Azure Devops Training Schedules

S NoTime (IST, Mon - Fri)Start DateRegister
18 PM - 9 PMComing SoonRegister

Trainer: Mr. Sai Phanindra Tholeti
www.linkedin.com/in/saiphanindra/

Azure DevOps
Training Course Contents:

Module 1 : Microsoft SQL (TSQL)

Ch 1: SQL SERVER INTRODUCTION

  • Database Introduction
  •  Types of Databases
  •  Need for & ETL, DWH
  •  BI Implementations
  •  SQL Server Advantages
  •  Version, Editions of MSSQL
  •  Data Analyst Job Roles

Ch 2: SQL SERVER INSTALLATIONS

  • SQL Server 2019, 2017
  • SSMS Tools Installation
  • Database Engine (OLTP)
  • SCM, Configuration Tools
  • Instance Types, Uses
  • Authentication Modes
  • Collation, File Stream

Ch 3: SQL BASICS – 1

  • Need for Databases, Tables
  • Need for SQL Commands
  • DDL, DML & DQL Statements
  • Database Creation @ GUI
  • Data Operations @ GUI
  • Session ID, SQL Context
  • DB, Tables, Data @ SQL

Ch 4: SQL BASICS – 2

  • DDL Variants in MSSQL
  • DML Variants in MSSQL
  • INSERT & INSERT INTO
  • SELECT & SELECT INTO
  • Basic Operators in SQL
  • Special Operators in MSSQL
  • ALTER, ADD, TRUNCATE, DROP

Ch 5: Data Imports, Schemas

  • Data Imports with Excel
  •  ORDER BY & UNION
  • UNION ALL For Sorting Data
  •  Creating, Using Schemas
  •  Real-world Banking Database
  •  Table Migrations @ Schemas
  •  2 Part, 3 Part & 4 Part Naming

Ch 6 : Constraints, Index Basics

  • Need for Constraints, Keys
  •  NULL, NOT NULL, UNIQUE
  •  Primary Key & Foreign Key
  •  RDBMS and ER Models
  •  Identity Property, Default
  •  Clustered Index, Primary Key
  •  Non Clustered Index, Unique

Ch 7: Joins & Views Basics

  • JOINS: Purpose. Inner Joins
  • Left / Right / Full Outer Joins
  • Cross Joins, Query Tuning
  • Creating & Using Views
  • DML, SELECT with Views
  • RLS : WITH CHECK OPTION
  • System Views & Metadata

Ch 8: Functions(UDF), Data Types

  • Using Functions in MSSQL
  •  Scalar Value Functions
  • Inline & Multiline Functions
  • Date & Time Functions
  • String, Aggregate Functions
  • Data Types : Integer, Char, Bit
  • SQL Variant, Timestamp, Date

Ch 9: Stored Procedures,Models

  • Stored Procedures & Usage
  • Creating, Testing Procedures
  • Encryption, Deferred Names
  • SPs for Validations, Analysis
  • System SPs, Recompilation
  • Normal Forms & Types
  • Data Models, Self-References

Ch 10: Triggers, Temp Tables

  • Need for Triggers
  • DDL & DML Triggers
  • Using Memory Tables
  • Data Replication, Automation
  • Local & Global Temp Tables
  • Testing & Using Temp Tables
  • SELECT .. INTO & Bulk Loads

Ch 11: DB Architecture, Locks

  • Planning VLDBs : Files, Sizing
  • Filegroups, Extents & Types
  • Log Files : VLF, Mini LSN
  •  Table Location, Performance
  • Schemas, Transfer, Synonyms
  • Transactions Types, Lock Hint
  •  Query Blocking Scenarios

Ch 12 : Cursors & CTEs, Links

  • Cursors : Realtime Use
  • Fetch & Access Cursor Rows
  • CTEs for SELECT, DML
  • CTEs: Scenarios & Tuning
  • Linked Servers, Remote Joins
  • Linked Servers: MSDTC, RPC
  • Tuning Remote Queries

Ch 13: Merge, Upsert & Rank

  • Need for Merge in ETL
  • Incremental Loads with SQL
  • MERGE and RANK Functions
  • Window Functions, Partition
  • Identify, Remove Duplicates

Ch 14: Grouping & Cube

  • Group By & HAVING
  • Cube, Rollup & Grouping
  • Joins with Group By
  • 3 Table, 4 Table Joins
  • Query Execution Order

Ch 15: Self Joins, Excel Analysis

  • Self Joins & Self References
  •  UNION, UNION ALL
  •  Sub Queries with Joins
  •  IIF, CASE, EXISTS Statements
  •  Excel Analytics, Pivot Reports

Module 2: Azure Devops

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

Ch 1 : Power BI Introduction

  • Reporting Basics & Types
  • Interactive,Analytical Reports
  • Paginated Reports (RDL)
  • Power BI Eco System
  • Power BI Tools,Service,Server
  • Need for Power Query (M)
  • Need for DAX & Cloud

Ch 2: Power BI Basic Reports

  • Power BI Desktop Installation
  • Basic Report Design (PBIX)
  • Data View, Data Models
  • Data Points, Aggregations
  • Focus Mode, Spotlight, Exports
  • ToolTip, PBIX and PBIT
  • Visual Interactions & Edits

Ch 3 : Grouping, Hierarchies

  • Creating Groups in Power BI
  • Groups : Creation & Usage
  • Group Edits Options
  • Bins & Bin Size, Bin Count
  • Hierarchies: Creation, Use
  • Drill Down, Drill Up
  • Conditional Drill Down

Ch 4 : Visual Sync, Filters

  • Slicer & Single Select
  • Multi Select Options
  • Integer, Character Slicers
  • Visual Sync with Slicers
  • Filters: Visual, Page, Report
  • Drill Thru Filters & Usage
  • Basic, Top & Advanced
  • Clear Filter Options, Resets

Ch 5 : Bookmarks, Big Data

  • Bookmarks Creation & Usage
  • Visual Interactions, Bookmarks
  • Images : Actions, Bookmarks
  • Big Data Access with Power BI
  • Storage Modes: Direct Query
  • Import & Performance Impact
  • Formatting & Data Refresh
  • Summary, Date Time Formats

Ch 6 : Power BI Visualizations

  • Chart and Bar Visuals
  • Line and Area Charts
  • Maps, TreeMaps, HeatMaps
  • Funnel, Card, Multrow Card
  • PieCharts & Settings
  • Waterfall, Sentiment Colors
  • Scatter Chart, Play Axis
  • Infographics, Classifications

Ch 7 : Power Query Level 1

  • Power Query (Mashup)
  • ETL Transformations in PBI
  • Power Query Expressions
  • Table Combine Options
  • Merge, Union All Options
  • Table Transformations

Ch 8 : POWER QUERY LEVEL 2

  • Any Column Transformations
  • String / Text Transformations
  • Numeric Analytics & Mashup
  • Date Time Transformations
  • Add Column Transformations
  • Expressions and New Columns

Ch 9 : POWER QUERY LEVEL 3

  • Parameters in Power Query
  • Static Parameters, Defaults
  • Dynamic Dropdowns, Lists
  • Linking with Table Queries
  • Column From Examples
  • Step Edits, Type Conversions

Ch 10 : Power BI Cloud – 1

  • Power BI Cloud Concepts
  • Workspace Creation, Usag
  • Report Publish & Edits
  • Semantic Models in Realtime
  • Dashboard Creation, Usage
  • Clone, Share, Subscribe
  • Q&A, Lineage, Settings

Ch 11 : Power BI Cloud – 2

  • Data Gateways, Data Refresh
  • Data Source Configurations
  • Data Refresh & Scheduling
  • Gateway Optimizations
  • Semantic Model Optimizations
  • Report Optimizations
  • Dashboard Optimizations

Ch 12 : Power BI Cloud – 3

  • Power BI Apps, Shares
  • App Sections & Options
  • App Updates, Security
  • Excel Analytics
  • Data Explorer Option
  • Sharing, Subscriptions
  • Alerts, Metrics, Insights

Ch 13 : Report Server & DAX

  • Power BI Report Server
  • Report Database, TempDB
  • Web Service & Server URL
  • Paginated Reports (RDL)
  • Report Builder Tool Usage
  • DAX : Purpose, Realtime Use

Ch 14: DAX Level 2

  • DAX Measures Creation, Use
  • DAX Functions: IIF, ISBLANK
  • SUM, CALCULATE Functions
  • DAX Cheat Sheet : Examples
  • Quick Measures in Power BI
  • Running Totals, Filters

Ch 15 : DAX Level 3

  • Star Rating Calculations
  • Data Models & DAX
  • Star & Snowflake Schemas
  • Dimensions, Fact Tables
  • DAX Expressions & Joins
  • DAX Variables, Usage

Ch 16 : DAX Level 4

  • Dynamic Report with DAX
  • SELECTED MEMEBER
  • Time Intelligence with DAX
  • PARALLELPERIOD, DATE
  • DAX with Big Data
  • Big Data Analytics

Ch 17 : Realtime Project Phase 1

  • Project Requirement Spec
  • Understanding Data, Formats
  • Report Pattern Design
  • Report Design & Modelling
  • Power Query, DAX, Insights
  • Analytical Reports in Cloud

Ch 18 : Realtime Project Phase 2

  • Complete Project Solution
  • Project FAQs, Key Roles
  • Real-world Considerations
  • Power BI Admin Concepts
  • Resume Points, FAQs
  • PL 300 Exam Guidance

SQL SCHOOL

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

Azure Devops Training FAQs

What is Azure Devops Job Role?

👉 Azure DevOps Engineer helps automate and manage the software build, test, and deployment process in the cloud to deliver applications faster and more reliably.

An Azure DevOps Engineer:
✅ Builds and manages CI/CD pipelines.
✅ Automates builds, tests, deployments.
✅ Manages Azure infrastructure using IaC (ARM, Bicep, Terraform).
✅ Ensures security, compliance, monitoring.
✅ Collaborates with dev, QA, and ops teams for smooth delivery.

What are the Job Roles of an Azure Devops?

💼 Top Job Roles:

  1. Python Developer – Build applications, APIs, and backend systems.

  2. Software Developer – Create software solutions using Python.

  3. Data Analyst – Analyze and visualize data using Python libraries.

  4. Data Scientist – Build and deploy machine learning models.

  5. Machine Learning Engineer – Design intelligent systems and algorithms.

  6. AI Engineer – Work on AI projects like chatbots and image recognition.

  7. Automation Engineer – Automate tasks, workflows, and testing.

  8. Web Developer (Python) – Develop web apps using Django or Flask.

  9. DevOps Engineer (Python) – Automate CI/CD pipelines and deployments and more..!

💼 Job Roles of an Azure DevOps Engineer

✅ Design and manage CI/CD pipelines for automated builds, testing, and deployment.
✅ Set up and maintain Azure infrastructure using Infrastructure as Code (ARM, Bicep, Terraform).
✅ Ensure application security, compliance, and performance monitoring.
✅ Collaborate with development, QA, and operations teams for smooth delivery.
✅ Automate manual tasks to improve efficiency.
✅ Manage Azure Repos, Boards, Artifacts, and Test Plans.
✅ Troubleshoot deployment issues and improve release processes.
✅ Support containerization (Docker, Kubernetes) and cloud-native app deployments.

What does our Azure Devops Training course contains?

The course is carefully curated with below module:
👉🏻Module 1: Microsoft SQL (TSQL)
👉🏻Module 2: Azure Devops
👉🏻Module 2: Power BI

Who can join this course?

  • Freshers looking to start a career in Devops or cloud technologies

  • Students from any background interested in software delivery and cloud tools

  • IT and Non-IT professionals aiming to upskill

  • Anyone with basic computer knowledge and a passion for learning

No prior coding experience is required. All concepts are taught from scratch

What training modes are available?

Option 1:        LIVE Online Training  (100% Interactive, step by step, assignments)

Option 2:        Self Paced Videos (100% practical, step by step with concept wise assignments)

You may choose any one of these options, same curriculum!

I (Trainer) shall be available for doubts and clarifications, assignment check and review.

Why should I choose SQL School for Azure devops training?

👉🏻 Every session is Practical, Step by Step with Concept wise FAQs !!

👉🏻 100% results with on-time practice.  Daily Tasks for every session.

👉🏻 Concept wise tasks be submitted before next class for Job Waiters / Starters.

👉🏻 Concept wise tasks due for submission by Weekends for Working Professionals.

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