AZURE SQL & DBA TRAINING IN KOCHI

2546 Reviews
4.8/5
1880 Learners

Overview

AZURE 

Watch
INTRO VIDEO

Why Radical Technologies

  • Highly practical oriented training
  • 25000+ Man-hours of Real-time projects & scenarios
  • 10 to 20+ year Experienced corporate trainers With Real Time Experience.
  • Building up professionals by highly experienced professionals
  • 100 % quality assurance in training .
  • 10000+ Placement Records and 180+ MNC’s and Consultancies Tie up

Check Batch Schedulings

Course Curriculum

Course description

Course Duration: 40 hrs

Weekday & weekend batches available

Classroom | Online | Corporate Training

Pre-requisites

There are no formal prerequisites for this course; however, previous operating system administration experience will be very beneficial.

Course Content

AZURE SQL DATABASE  SYLLABUS

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

DTU, ELASTIC QUERIES, MIGRATIONS

Azure Storage : Types, Creation & Containers
LRS, GRS and RA-GRS Azure Storage Accounts
Storage Containers, Storage Explorer Tool Usage
Data Migration and Database Migration in Azure
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
Data Migration Verification and Row Counts
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
Elastic Scaling with Azure SQL Databases

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

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

ALERTS, BACKUPS / RESTORES

Azure SQL Server Activity Log and Options
Events, Operations and Event Categories
Quick Insights from Events and Filters
Events Exports to Event Hub, Log Analytics
Log Analytics Workspace, Alert Rules
Email / SMS Notifications and Schedules
Log Analytics Settings and Azure Storage
Activity Logs and Audit Reports, Insights
Azure SaaS Notifications System Options
Automated Backups in Azure SQL Database
Long Term & Automated Backup Retentions (bacpac)
Backups – Retentions, Audits. LTR Policy
Restore Points and Azure SQL Database Recovery
Geo-Redundant Backups and Advantages in Azure
Restore Options and DB Creations with LTR
Azure Storage Explorer Tool using Backups
Disaster Recovery (DR) Advantages in Azure

AZURE SQL DBA

HA – DR LEVEL 1

Failover Groups and Active Geo-Replication
Read-Write Failover Policy, Automated Failover
Geo Replication Configurations – Azure Locations
Primary-Secondary and Read / Write Modes
GeoReplication : Monitoring and Forced Failover
Azure Server Failover Process, Strategies
Automated Failover , Manual & Forced Failover
Backup Errors, Geo Replication Errors – Solutions
SQL Data Sync Service and Sync Groups
HUB, MEMBER and SYNC DATABASE
Sync Direction, Sync Schema and Sync Interval
bi-directional Load Balancing and Failover
Conflict Resolution Policy with HUB and MEMBER
Cloud to Cloud / On-Premise Synchronization
Hub to Member and Member to Hub Sync Policies

HA – DR LEVEL 2

Azure AlwaysOn with SQL Server Clusters
Primary Node and Secondary Node Clusters
SQL Server Virtual Machines and Settings
Domain Controller (DC) Virtual Machines
Witness File Share (WFS) Settings in DC
Azure Server Failover Process, Strategies
Adding Databases to Failover Group
Always On Health Check Reports (AOAG)
Configuring and Using Azure Always-On
Load Balancing with Azure Always-On
Azure Cloud Shell – PowerShellGet, Versions
Power Shell Scripts for Configurations
Power Shell Scripts for Job Schedules
Power Shell Scripts for Firewall, ARM
Azure CLI – Purpose, Real-time Use
Command Line Interface for Automations
Azure telemetry Commands and Usage
Help, Show, Create and Firewall Commands

SECURITY MANAGEMENT, RLS

Firewall and Virtual Network Configurations
Server-level Firewall & Database Firewall Rules
System Stored Procedures for Firewall Settings
Logins, Users, Roles and Permissions using T-SQL
Creating Logins without Logins. Containment Users
GRANT, DENY, REVOKE, WITH GRANT Permissions
Role Level and Schema Level Security in Azure
Threat Detection, Transparent Database Encryption
Vulnerability Assessment, Dynamic Data Masking
Implementing RLS – Row Level Security
Creating Users with and without Logins
Using SECURITY Schema for RLS Functions
Creating Security Predicates and Filters
Security Policies for Row Level Security
EXECUTE AS options for RLS. STATE ON/OFF
Dynamic Data Masking with Azure SQL Database
Implementing DDM with Azure Portal & T-SQL

AZURE VIRTUAL MACHINE – WINDOWS

IaaS, Azure VM. Install Azure Virtual Machines
Install/Configure Windows Server, Redhat, Ubuntu
SQL Server Azure VM – Config Settings, Elastic Pools
Resource Groups, Resource Pools and eDTUs
Verify SQL Instances in Azure VM. sysadmin Account
Azure Storage Blades and Pricing Options
Azure VM – Settings, DB Creation in Azure VM
On-Premise & Azure Virtual Machines: Similarities
SSMS, SQL Server Instance, Agent in Azure VM
Azure Virtual Machines ; Security Options
Azure SQL Database in VM to SQL Cloud
Azure SQL Database in VM to on-Prem
Deployment Automation Process, Automation Scripts
SQL Database in AWS and Google Cloud
Azure Virtual Machine Configuration Settings
Azure SQL Database Advantages in Virtual Machines
Public Access with SQL Server Instance, Security

LINUX VM, MANAGED INSTANCES

SQL Server on LINUX – RHEL (Red Hat Linux)
Advantages of LINUX RHEL Over Windows
LINUX RHEL Security Management, Firewall
Storage, vCores and Storage Options in VM
RHEL Clusters for SQL Server on LINUX
Failover Mode and Node Majority – TCP
Deployment Models and Azure Resource Manager
RHEL Cluster Resource Manager Settings
Pacemaker and SQL Server Nodes in AG
SQL Database Managed Instance – TDE
Native Virtual Networks and Scalability
Lift – Shift LOB Applications, PaaS Infrastructure
Frictionless Migration for On-Premise
vCore Purchasing Model for Azure SQL DB
Gen 4 and Gen 5 Logical CPUs, Resource Limits
Managed Instances Vs AWS & Google Cloud
Cell Level Encryption and Always-Encrypted

Drop A Query

Training Options

Live Online Training

  • Highly practical oriented training
  • Installation of Software On your System
  • 24/7 Email and Phone Support
  • 100% Placement Assistance until you get placed
  • Global Certification Preparation
  • Trainer Student Interactive Portal
  • Assignments and Projects Guided by Mentors
  • And Many More Features

Course completion certificate and Global Certifications are part of our all Master Program

Live Classroom Training

  • Weekend / Weekdays / Morning / Evening Batches
  • 80:20 Practical and Theory Ratio
  • Real-life Case Studies
  • Easy Coverup if you missed any sessions
  • PSI | Kryterion | Redhat Test Centers
  • Life Time Video Classroom Access ( coming soon )
  • Resume Preparations and Mock Interviews
  • And Many More Features

Course completion certificate and Global Certifications are part of our all Master Program

Exam & Certification

Course Reviews

I had a wonderful experience in Radical technologies where i did training in Hadoop development under the guidance of Shanit Sir. He started from the very basic and covered and shared everything he knew in this field. He was brilliant and had a lot of experience in this field. We did hands on for every topic we covered, and that’s the most important thing because honestly theoretical knowledge cannot land you a job.
Rohit Agrawal Hadoop
I have recently completed Linux course under Anand Sir and can assuredly say that it is definitely the best Linux course in Pune. Since most of the Linux courses from other sources are strictly focused on clearing the certification, they will not provide an insight into real-world server administration, but that is not the case with Anand Sir’s course. Anand Sir being an experienced IT infrastructure professional has an excellent understanding of how a data center works and all these information is seamlessly integrated into his classes.
Manu Sunil Linux
I had undergone oracle DBA course under Chetan sir’s Guidance an it was a very good learning experience overall since they not only provide us with theoretical knowledge but also conduct lot of practical sessions which are really fruitful and also the way of teaching is very fine clear and crisp which is easier to understand , overall I had a great time for around 2 months , they really train you well.also make it a point to clear all your doubts and provide you with clear and in-depth concepts hence hope to join sometime again
Reema banerjee Oracle DBA
I have completed Oracle DBA 11g from Radical technology pune. Excellent trainer (chetna gupta ). The trainer kept the energy level up and kept us interested throughout. Very practical, hands on experience. Gave us real-time examples, excellent tips and hints. It was a great experience with Radical technologies.
Mrudul Bhokare Oracle DBA
Linux learning with Anand sir is truly different experience… I don’t have any idea about Linux and system but Anand sir taught with scratch…He has a great knowledge and the best trainer…he can solve all your queries related to Linux in very simple way and giving nice examples… 100 🌟 to Anand Sir.
Harsh Singh Parihar Linux
Prev
Next

Why we are the best Radical Technologies

Radical Technologies is truly progressing and offer best possible services. And recognition towards Radical Technologies is increasing steeply as the demand is growing rapidly.

Creative

0%

Innovative

0%

Student Friendly

0%

Practical Oriented

0%

Valued Certification

0%

Training FAQs

Similar Courses

ENQUIRE NOW
[]
1 Step 1
keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right
FormCraft - WordPress form builder