SQL Server & T-SQL Training (LIVE, Instructor-Led)

This impeccable Microsoft SQL Server Training Course is exclusively designed for aspiring Data Analysts, Business Analysts, Data Scientists, MSBI / Power BI Engineers and SQL Database Developers. This SQL Server and T-SQL Training Course is designed for both starters as well as for experienced professionals. This course includes SQL Basics, T-SQL Queries, Query Writing and Query Understanding required for Data Analysts and Business Analysts. This course also includes Programming, Tuning and Azure SQL (Cloud) concepts required for BI Developers and SQL Database Developers. One Real-time project is included in this SQL Server and T-SQL Training Course addressing Basic to Advanced SQL Queries, Detailed Database Design, Complex Joins, Common Table Expressions (CTEs), Complex Stored Procedures, Triggers, Remote Joins, Transactions and Query Tuning with XML, BLOB and JSON Data Sources with complete guidance to MCSA 70-761 and MCSA 70-762 Microsoft Certification Exams.

Practice Material, Certification, Resume & Interview Guidance are included in this SQL Server T-SQL Course.

SQL Server & T-SQL Training with Azure SQL

  PLAN A PLAN B PLAN C
Applicable For SQL Dev SQL Dev +
Azure Dev
SQL Dev +
Azure Dev +
Azure DevOps
Course Duration 4 Weeks 6 Weeks 10 Weeks
Course Content Chapters 1 to 20 Chapters 1 to 30 Chapters 1 to 48
Completely Real-time, Practical
Mock Interviews, Case Studies
SQL Basics and Query Writing
SQL DB Design, Table Design
Normal Forms, Joins, Queries
Indexes, Stored Procedures
Excel Integration, Pivot Charts
Advanced Stored Procedures
CTE, PIVOT, XML and BLOB Data
Real-time Project [Banking]
In-depth Query Tuning
Performance Tools, Locks
Complex SPs, MCSA - 70 761
Azure SQL Database (Cloud)
Azure SQL Database Migrations
Stretch Databases, MCSA 70-762
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)
Total Course Fee* INR 6000
USD 81
INR 13000
USD 176
INR 25000
USD 338

Trainer: Mr. Sai Phanindra T

All Session Are Completely Practical & Real Time


Schedules for SQL Server & T-SQL
S No Timings (IST) Start Date  
  Regular Schedules [Mon - Fri]
1 6 AM - 7 AM Dec 29th Register
2 8 AM - 9 AM Jan 19th Register
3 10 AM - 11 AM Jan 4th Register
4 6 PM - 7 PM Jan 25th Register
5 8 PM - 9 PM Dec 4th Register
6 9 PM - 10 PM Dec 14th Register
Azure DevOps Training Schedules
S No Timings (IST) Start Date  
  Regular Schedules [Mon - Fri]
1 10 AM - 11 AM Dec 4th Register
2 6 PM - 7 PM Dec 28th Register
  Weekend Schedules [Sat & Sun]
3 6 AM - 8 AM Dec 12th Register
4 6 PM - 8 PM Dec 19th Register
If none of the above schedules work for you, please opt for On-demand Video Training

 

SQL Server T-SQL Training Highlights

✔ Queries, Joins ✔ Dynamic SQL
✔ Query Tuning ✔ CTEs, TVPs
✔ Excel Imports ✔ In-Memory Tables
✔ Excel Pivots ✔ Azure SQL Concepts
✔ Complex joins ✔ Azure DB Migrations
 

SQL Server T-SQL (DEV) Training Course Contents:

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 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 13: STORED PROCEDURES Level 2

  • Try..Catch & Error Handling Concepts
  • THROW Statement and PRINT Options
  • Event Handling in Stored Procedures
  • Copying Table Data with Transactions
  • Creating and Using Table Data Types
  • Table Valued Parameters (TVP) in SPs
  • ReadOnly Parameters in Stored Procs
  • Output Parameters, Stored Procedures
  • Using Cast, Convert with Stored Procs
  • Identity Property - Missing ID Values
  • Data Validations, DMLs in Stored Procs
  • Dynamic Data Insertions with SPs
  • Table Cloning, Inserts @ Table Variables
  • SQL Injection Attacks - Precautions

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
  • DBEngine and Replication Components

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 Operators
  • Comparing Where, Having Conditions
  • GetDate, Year, Month, Day Functions
  • Rollup with Having & Grouping
  • Date and Time Functions in T-SQL
  • Convert Functions with DateTime
  • DateTime Styles, DateAdd, DateDiff
  • String Functions: Trim, SubString
  • StringSplit, Concat, Len, Left, Right

Ch 14: STORED PROCEDURES - Level 3

  • Views: User Defined, System Defined
  • Data Retreival with Views, Conditions
  • DML Operations with Views, Conditions
  • Schema Binding, Structural Modifications
  • With Check Options and Data Validations
  • Embedd Views inside Stored Procedures
  • Dynamic Conditions with Views in SPs
  • Views: Real-world Use Cases
  • DML Triggers and DDL Triggers
  • FOR and INSTEAD OF Triggers
  • Magic Tables : Inserted, Deleted
  • ENCRYPTION and CHECK OPTION
  • Cascaded Views, Encrypted Views
  • Updatable Views, Joins with Triggers
  • Stored Procedures @ Triggers, Views

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 9: JOINS, T-SQL QUERIES Level 3

  • Self Referencing Keys, Candidate Key
  • Adding PK to Existing Tables
  • Adding FK to Existing Tables
  • Self Joins and Table Aliases
  • Join Queries with Group By, Aggr
  • Views For T-SQL Query Store
  • Fetch, Offset, Next Rows, Order By
  • Joins with Group By, Sub Queries
  • Formating with IIF and CASE
  • Formating with Cast, Convert
  • Using Joins with Nested Sub Queries
  • Sub Queries and Alternatives to Joins
  • Excel Pivot Tables and Reports
  • Pie Charts & Data Refresh Options

Ch 15: STORED PROCEDURES - Level 4

  • Cursors - Benefits, Cursors in SProcs
  • ForwardOnly, Scroll & Local Cursors
  • Static, Dynamic & Global Cursors
  • Keyset Cursors and @@FetchStatus
  • Nesting of Stored Procedures - Dynamic
  • Data Formatting and WHILE Loops
  • Using Temporary Tables for Formatting
  • CTE : Common Table Expressions
  • Real-time Scenarios with CTEs - Usage
  • ROW_NUMBER() with CTE Queries
  • Using CTEs for Avoiding Self Joins
  • Using CTEs for Avoiding Sub Queries
  • Recursive CTEs and ANCHOR Element
  • Termination Checks in Recursive CTEs

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 10: View, SPs, Function Basics

  • Views : Types, Usage in Real-time
  • System Predefined Views and Audits
  • Listing Databases, Tables, Schemas
  • Function Types, Usage in Real-time
  • Scalar, Inline and Multi-Line Functions
  • UDF: Creation, Executions with Select
  • Variables & Parameters in SQL Server
  • Implementing Dynamic Joins in T-SQL
  • Procedures : Types, Usage in Realtime
  • User & System Predefined Procedures
  • Using Parameters in Stored Procedures
  • Store, Execute T-SQL Queries in SPs
  • Performance Advantages with SPs
  • SPs on Single and Multiple Tables
  • Dynamic Joins & SP Recompilations

Ch 16: XML,BLOB,FUNCTIONS Level 2

  • Functions : Types, Real-world Usage
  • Scalar Value Returning Functions
  • Inline Table Value Functions
  • Multi-Line Table Value Functions
  • WHILE Loops and Iterations in T-SQL
  • Table Variables Usage in T-SQL
  • Data Types, Usage and Conversions
  • Scenario: Generating Calendar Values
  • Composite Keys, Computed Columns
  • Cascading Keys, Auto Update, EXISTS
  • XML AUTO, XML RAW and XML PATH
  • BULK INSERT, BULKCOLUMN, JSON
  • OPENROWSET, PIVOT and UNPIVOT
  • JSON Files - Data Import into SQL DB
  • Nested Queries, Co-related Queries

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
  • Session Level, Connection Level Use

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
  • Auditting Triggers and Real World Use
  • 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 17: Server, DB Architecture

  • Server Architecture and Protocols
  • Database Engine and Query Processor
  • Parser, Optimizer, SQL & DB Manager
  • Storage Engine Components, SQL OS
  • File Manager and Database Files
  • Transaction Services, Buffer Manager
  • Lock Manager, IO Manager, MDAC
  • CLR, WAL, Lazy Writer, Checkpoint
  • Database Architecture - Data Files
  • Database Architecture - Log Files
  • Primary (mdf), Secondary Files (ndf)
  • Filegroups Usage, ReadOnly Filegroups
  • Database Files : Size and Location
  • Pages, Extents. Uniform, Mixed Extents
  • Transaction Log File [LDF], LSN, VLF

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 Sort Options, Search Advantages
  • Clustered and NonClustered Indexes
  • Primary Key and Unique Key Indexes
  • Need for Indexes - working with Keys

Ch 12 : ER MODELS, NORMAL FORMS

  • Normal Forms for Entity Relationships
  • 1st Normal Form and Atomocity
  • 2 Normal Form, Functional Dependancy
  • 3 Normal Form Multi Value Dependancy
  • Boycee-Codd Normal Form : BNCF
  • 4 Normal Form Realtime Advantages
  • 1:1, 1:M, M:1, M:M Relationship Types
  • MERGE Statement - Comparing Tables
  • WHEN MATCHED and NOT MATCHED
  • Incremental Loads, IIF Function
  • CASE Statement : WHEN, ELSE, END
  • ROW_NUMBER() and RANK() Queries
  • Dense Rank and Partition By Queries
  • Identify, Remove Duplicate Rows

Ch 18 - 20: REAL-TIME PROJECT (BANKING)
Includes 2500 Lines of Code (SOLVED).
Phase 1: DATABASE DESIGN
  • End to End Project Work Flow
  • Naming Conventions in Real-time
  • Schemas & Normal Forms (OLTP)
  • Computed Columns and Data Types
  • Email and Phone Number Validations
Phase 2: QUERY DESIGN
  • Views with JOIN Options
  • Implementing Indexed Views
  • Using PIVOT Tables in Queries
  • Dynamic Conditions in Queries
  • Parameterized Queries in T-SQL
Phase 3: PROGRAMMING
  • Event Handling, Error Handling
  • Transactions, Event Handling Options
  • Transaction Nesting, Save Points
  • Stored Procs with Functions, Triggers
  • Project Deployments, Project FAQ
   Project Solution, Interview FAQs

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

Real-time Case Study - 2 (Sales & Retail)
Objective : Query Writing, Excel Integration
Excel Pivot Tables, Pivot Charts,
Data Formatting, ODC Connections & Labelling

Module II: Performance Tuning & MCSA - 70 761

Applicable for Plans B, C

Module III: Azure SQL Database Development & MCSA - 70 762

Applicable for Plan C

Ch 21: QUERY TUNING 1 - AUDITS, INDEXES

  • Audit Long Running Queries using DMVs and DMFs
  • Activity Monitor Tool and Query Statistics Reports
  • Logical I/O, Physical I/O and Database I/O, Wait Time
  • Recent Expensive Queries & Active Expensive Queries
  • Plan Handle and Execution Time - Query Usage Audits
  • Server Dashboards and Memory Consumption Reports
  • Factors Impacting the Query Executions, Performance
  • Indexes: Architecture and Types : Clustered, Non Clustered
  • B Tree Architecture and Advantages : IAM Page, Branches
  • GAM, SGAM, PFS and Index Page Architecture
  • Clustered & Non Clustered Indexes : Creation and Usage
  • Included and ColumnStore Indexes : Creation and Usage
  • Covering Indexes and Filtered Indexes : Creation and Usage
  • Indexed View (Materialized View) : Performance Advantages
  • SORT_IN_TEMPDB, ONLINE = ON. Real-time Considerations

Ch 26: AZURE CLOUD INTRO, CONFIGURATION

  • Introduction to Cloud. Need for Cloud, Advantages
  • Cloud Architecture Basics - IaaS, PasS and SaaS
  • Advantages of Microsoft Cloud - Azure Platform
  • Azure Products and Azure Services - MarketPlace
  • SQL Database Implementations in Azure Platform
  • Logical Servers, Virtual Machines, Managed Instance
  • Installing SSMS and Azure Data Studio (ADS) Tools
  • Creating Azure Account and Free Subscriptions
  • Creating Azure SQL Server (Logical Server)
  • Firewall Settings for Azure SQL Server (Logical Server)
  • Adding Firewall Rules - IP for Remote Access
  • Server Properties and Status Check. Server Name Format
  • Password Resets and Azure SQL Server Name Format
  • Creating Azure SQL Databases and Pricing Tiers
  • Azure SQL Database Access from SSMS Tool

Ch 22: QUERY TUNING 2 - PARTITIONS, INDEX MANAGEMENT

  • Query Store - Settings and Advantages. Options
  • PARTITIONS Mechanism : Advantages, Performance
  • Partition Functions and Partition Schemes - Usage
  • Partitioning Un-partitioned Tables using GUI
  • Table Data Compression Techniques : ROW, PAGE
  • Compression of Speific Partitions, REBUILDS
  • Partition and Compression Recommendations for OLTP
  • Auditing and Verifying Partitions with sys.partitions
  • Index Management - DOP : Degree Of Parallelism
  • Index Rebuilding Process and Fragmentation Audits
  • Index Page Count and Index Condition Checks
  • Resumable Indexes: ONLINE and RESUME Options
  • PAUSE and RESUME Options in Index Rebuilds
  • Fast, Detailed Scans and Stats NoRecompute
  • Statistics Management : Index and Column Stats

Ch 27 : DTU, ELASITC QUERIES, MIGRATIONS

  • DTU : Data Transaction Unit, Resource Allocations
  • Basic, Standard and Premium Plans For SQL DB
  • vCore Based Purchasing : Gen 4 and Gen 5 Types
  • General Purpose and Business Critical Plans
  • Compute Tier : Provisioned and Serverless
  • Bounding Box Model, Elastic Pools & Queries
  • eDTUs and Elastic Pool, per Database Settings
  • Azure Storage : Types, Creation & Containers
  • LRS, GRS and RA-GRS Azure Storage Accounts
  • Storage Containers, Storage Explorer Tool Usage
  • Data Migration Assistant (DMA) Tool, Assessment
  • Data / Database Migrations To Azure SQL
  • Database Exports and Imports in Azure with bacpac
  • Migration Scopes : Schema, Data, Schema & Data
  • Schema Generation and Compatibility For Migration

Ch 23: QUERY TUNING 3 - TUNING TOOLS, LOCK MANAGEMENT

  • Tuning Tools : Creating Workload Files and Trace Files
  • SQL Profiler Tool - Tuning Template and TSQL / SP Events
  • DTA Tool with Profiler Trace Files: Tuning Recommendations
  • DTA with Query Cache (Procedure Cache) & .SQL File Inputs
  • Perfmon Counters : Processor, Disk, Memory, Transactions, DB
  • Execution Plans - Internals. Actual, LIVE Execution Plans
  • Query Costs : IO, CPU Cost, SubTree Cost, Operator Cost
  • NUMA Nodes, Boost SQL Priority, Thread Count, IO Affinity
  • Execution Plan Issues with Spooling Mechanism
  • Lock Types: Shared Lock, Intent Shared, Exclusive Lock
  • Intent Exclusive, Update, Metadata, Schema Lock
  • Lock Audits : SP_WHO2, SP_LOCK, sysprocesses
  • Isolation Levels - ReadCommitted, Read Uncommitted
  • Serializable, Snapshot, Repeatable Read Isolations
  • Read Committed Snapshot Isolation Level in Real-time
  • Deadlock Simulation, Deadlock Prevention Scenarios
  • Deadlock Audits and Lock Events in Profiler Tool

Ch 28 : AZURE SQL DATABASE TUNING

  • Azure SQL Server Level Tuning Options
  • Azure SQL Database Level Tuning Options
  • Automated Tuning Options and Peak-Loads
  • Force Plan, Create Index and Drop Index
  • Query Performance Insight, Recommendations
  • IO Metrics, CPU Metrics & Query Statistics
  • Data File IO, Log File IO, Custom Reports
  • Query Audits with Query IDs, Dashboards
  • DTU Usage Reports and Elastic Queries
  • Query Level Recommendations and Query Costs
  • Azure Search Service Configuration, Pricing Tiers
  • Azure Search for Data Import and Indexer Options
  • Suggester and Analyzer Index Modes for Tuning
  • Retrievable, Facetable, Filterable Indexes
  • Facetable and Searchable Indexes for Tuning
  • Change Tracking Options, Watermark Columns
  • Full Text Search : Performance Advantages

Ch 24: QUERY TUNING 4 - FULL TEXT SEARCH, MOT TABLES

  • Full Text Search (FTS) Mechanism - Architecture, Tuning
  • Stop Words, Stemmer and Thesaurus For FullText Indexes
  • Indexer Program, Query Processor & FT Query Compilation
  • Database Catalogs (FTC) and FDHost.exe. Daemon Threads
  • Full Text (FT) Indexes : Query Tuning. Filter Daemon Host
  • Creating Full Text Catalogs (FTCs) and FT Indexes
  • CONTAINS() Queries and FREETEXT() Queries with SELECT
  • Query Performance Impact with SQL Server T-SQL Queries
  • Resumable Indexes, Usage in SQL Server 2017 & 2019
  • ONLINE, RESUME, PAUSE, MAX_DURATION Options
  • In-Memory Tables : Creation and Practical Usage for Tuning
  • Memory Snapshots at Database Level and Table Level
  • FileStream Files and Memory Snapshot Filegroups for MOT
  • MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT
  • Temporal Tables : for DML Audits, System Versioning
  • Using Temporal Tables for Data Audits, Timestamps
  • Statistics : Purpose, Auto Creation and Updates

Ch 29 : XEL GRAPHS, STRETCH DATABASES

  • SQL Traces : Creation and Audits. Limitations
  • SQL Traces : Event Class, Category, Filter, Conditions
  • Extended Events Package, Target, Action, Session
  • TSQL and SP Debug Events with Global Fields
  • XE Objects : Catalog & Dynamic Management Views
  • XE Profiler - Templates for Event Profiling (Audits)
  • Comparing XE Profiler with SQL Profiler Tool
  • Comparing Azure SQL Database with On-Premise
  • Stretch Databases in Azure SQL Databases
  • Stretch Databases - Tuning Benefits, Cautions
  • Table Level Migrations with Azure SQL Databases
  • Compute Performance Levels and DSU Pricing
  • Data Storage and Azure Database Snapshots
  • Geo Backup Of Tables and Hybrid Cloud Settings
  • Remote Data Archive Configuration in Azure
  • Database Master Key [DMK], Cold Data Migration
  • Real-time Advantages of Stretch Databases
Ch 25 : MCSA 70 761 Exam Pattern, Examples, Guidance
Ch 30 : MCSA - 70 762 Exam Pattern, Examples, Guidance

Module I: Azure Funda & DevOps Basics

Module II: Azure DevOps Service - 1

Azure DevOps Service - 2
Az DevOps Server

Ch 1. Azure Fundamentals

  • Basics of Cloud Computing
  • Cloud Services: Advantages
  • Cloud Services: Product Models
  • Virtualization Concepts in Cloud
  • Comparing On-Premise with Cloud
  • DevOps : Introduction, Use
  • Azure Cloud : Features, Advantages
  • Azure Cloud : Services & Usage
  • Azure Cloud : Platform Components
  • Azure Resoures, Service Types
  • Azure PaaS, IaaS & SaaS
  • Azure Account Creation, Resources

Ch 7: Organizations & Projects

  • Azure DevOps: Implementation Plan
  • Creating and Using Organizations
  • Planning and Security Advantages
  • Region Specifications and Owners
  • Users and Resource Limits
  • Azure DevOps - Org Notifications
  • Azure Projects - Creation, Use
  • Public and Private Projects
  • Version Control: Git and TFS
  • Work Item Process: Agile
  • Basic, CMM and Scrum Options
  • Security, Teams, Dashboards

Ch 13: Azure Functions, App Service, Alerts

  • Azure Functions and Automations
  • Azure Event Notifications, Audits
  • Azure App Services & Webapps
  • Build, Deployment and Scaling
  • Azure App Service Migrations
  • Azure Apps Versus DevOps
  • Azure Monitoring and Alerts
  • Notification Options in Azure
  • Alert Management, Operators
  • Creating, Managing Alert Rules
  • RBAC , Continuous Monitoring
  • Smart Groups and Performance

Ch 2. Azure Services, Configurations

  • Azure Registration and Azure Portal
  • Azure Resources and Azure Services
  • Azure Resource Types, Resource Groups
  • Creating Resource Groups in Azure Portal
  • Resource Groups: Access, Advantages
  • Cost and Billing Management
  • Azure Storage Account Creation
  • Storage Account Types, Replication
  • Azure BLOB Data Storage Containers
  • Azure Storage Explorer Tool
  • Uploads, Imports, SAS and Access Key
  • Azure File Storage and On-Premise Access

Ch 8: Azure Boards

  • Azure Boards - Creation, Use
  • Work Item - Fields & Sprints
  • Kanban Boards, Item Tracking
  • Backlogs and Code Testing
  • Bugs and Feature Requests
  • Team Dashboards, Monitoring
  • Azure Boards with Agile Process
  • Azure Boards For CMMI Procces
  • Azure Boards For Scrum Procces
  • Change Column & Queries
  • Style Rules and Highlight Cards
  • Color Tag & Work Item Cards

Ch 14: Azure DevOps Resources in Portal

  • Azure DevOps Services From Portal
  • Application Insights and Logs
  • Log Analytics and Storage Account
  • API Management Services
  • API Connections in Azure
  • Azure DevOps Organizations
  • DevTest Labs From Azure Portal
  • Build Apps with Azure DevOps
  • Azure Pipelines and Samples
  • Plan and Buld Tasks in DevOps
  • Setup Azure DevOps Org Account
  • Create & Publish Azure Pipelines

Ch 3. Azure Active Directory, Monitoring

  • Azure Active Directory Service
  • Azure AD : Users, Tokens & Passwords
  • Azure AD : Groups, Members, Owners
  • Azure AD : App Registrations, Tokens
  • Service Principals and Real-time Use
  • Identity & Access Management (IAM)
  • Azure Monitoring and Metrics
  • Azure Dashboards and Counters
  • Customizations and Usage Reports
  • Azure Alerts and Conditions
  • Notifications: Push/Email/SMS
  • Log Analytics and Health Checks

Ch 9: Azure Repos

  • Azure Repository (Repo), Storage
  • Distributed Versus Centralized
  • Azure DevOps Repos: Cloning
  • Commit, Push and Pull Options
  • Branch & Branch Policies
  • Fork, Git and WorkFlow
  • Git Versus TFVC, Customizations
  • Public Projects and Pull Requests
  • Notification Options in Repos
  • Team Foundation Version Control
  • Git and TFS Projects in DevOps
  • Azure Repos with Slack

Ch 15: Azure DevOps Strarter, App Insights

  • Azure DevOps Starter Deployments
  • Migrations from Git Repository
  • Continuous Integration (CI)
  • Continuous Delivery (CD)
  • Item Pipeline and Workflow
  • Azure DevOps Pipelines
  • DevOps Starter, Github Integration
  • DevOps Starter, DevOps Integration
  • DevOps Starter Vs Azure DevOps
  • Github Actions & Azure DevOps
  • Azure DevOps to Azure VM
  • Examine CI and CD Pipelines

Ch 4. SDLC, Dev & Operations, DevOps

  • Software Development Life Cycle
  • SRS Documents and Principles
  • Design, Planning and Coding
  • Coding Techniques and Tools
  • Testing Operations, Issues
  • UAT, Production Deployment Issues
  • Need for DevOps Services
  • Life Cycle Management
  • Automations and Code Control
  • DevOps Tools and Techniques
  • DevOps : Advantages, Benefits
  • DevOps Engineers: Job Roles

Ch 10: Azure Pipelines For CI/CD - 1

  • Azure Pipelines - Architecture, Creation
  • Azure Pipeline Creation Ecosystem
  • Continious Integration (CI)
  • Continious Development (CD)
  • Build Pipeline in Azure DevOps
  • Key Concepts, Real-time Use
  • Creating Pull and Push Requests
  • Release Pipelines - Creation, Use
  • Multi Stage Release Pipelines
  • New Branch Options with Pipelines
  • Classic Release Pipelines
  • Classic Editor - Pipeline Creation

Ch 16: Power Shell & Azure DevOps

  • Azure Power Shell and DevOps
  • Power Shell Installations
  • Power Shell in Azure Portal
  • Creating Resources in Portal
  • Creating Pipelines in PowerShell
  • YAML Snippet and Arguments
  • Writing Sample Apps, Builds
  • Writing Warnings and Errors
  • Powershell with Multiple Args
  • Service Fabric Manifests
  • Publish Test Results in DevOps
  • Run Functional Test Results

Ch 5. DevOps Tools, Git & GitHub

  • DevOps Tools & Life Cycle Stages
  • Continuous Development (CD)
  • Continuous Integration (CI)
  • Planning Phase: UML Tools
  • Code: Visuaal Studio, Git
  • Build: Maveen and Gradle
  • Test: Selleinum and Junit
  • Release: Jenking, Bamboo
  • Deploy: Puppet, Chef, Ansible
  • Operate: Visual Studio Options
  • Monitor: NewRelic, Splunk
  • Git & GitHub For Code Store

Ch 11: Azure Pipelines For CI/CD - 2

  • Continous Integration Pipelines
  • PreDeployments in Azure devOps
  • WorkTeam Correlation Options
  • Azure Pipelines - Customizations
  • GitHub with Azure Active Directory
  • GitBub with DevOps Integration
  • Pipeline Creation Comparisions
  • AzurePipelines for YAML
  • Agent, Approvals and Artifacts
  • Caching, Conditions and Jobs
  • Classic Builds and Class Release
  • Dependancies, Job Deployments

Ch 17: 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
  • Services and Service Account, Agent
  • SSMS Tools Installation for Access
  • Server Connections, Authentication
  • Database Creation using SSMS

Ch 6. Docker, Kubernetes, AzureDevOps

  • Introduction to Docker in Azure
  • Understanding Docker Lifecycle
  • ACI Containers and Options
  • Introduction to Kubernetes in Azure
  • Kubernetes Lifecycle Implementation
  • Azure Kubernetes Containers, Options
  • Azure DevOps : Advantages
  • Azure DevOps: Services
  • Azure Boards, Azure Repos
  • Azure Pipelies and Realtime Use
  • Azure Test Plans and Artifacts
  • VSTS Versus Azure DevOps

Ch 12: Azure Testing & Artefacts

  • Azure Testing Options in DevOps
  • Manual Testing in Kanban
  • Manual Testing in Test Manager
  • UAT and Test Tracking
  • Test Case Explorer in DevOps
  • Stakeholder Feedback
  • Azure Artifacts and Feeds
  • Single Feeds & Multi Feeds
  • Nuget, npm, Maven with DevOps
  • Versions and Compatability
  • Retention Polocies with Artifacts
  • Maven Central Upstream Sources

Ch 18: DevOps Server & Visual Tools

  • Privacy Advantages with DevOps Server
  • XML Definition Files and Options
  • Build Server Configurations
  • Content Version and Projects
  • General Administration Tasks
  • Server Level Administration Tasks
  • Adding Users to Projects
  • Grant and Restrict Permissions
  • Set Code & Test Properties
  • Area and Iteration Paths
  • Adding Teams and Scaling
  • Billing Items & Monitoring
 

Above Course Curriculum is applicable for registrations from Dec 2nd, 2020

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

SQL Server T-SQL Classroom Training - Highlights :

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Certification Guidance to MCSA Exams
  • Interview Preparation & MOCK Interviews
 
 
  • End-End Database Design & Implementation
  • Detailed SQL Server Architecture, DB Design
  • Query Tuning, Stored Procedures, Linked Servers
  • In-Memory, New Features of SQL Server 2017
  • Azure SQL Database Programming, Sharding
  • In-Memory Tables and Azure Performance Insights
 
Register Today  Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer: Mr. Sai Phanindra T [ 13+ Yrs of Technical Expertise, Microsoft Certified Trainer ]

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