SQL Azure Database Administrator, Data Analyst.

Microsoft Certification (AZ-900 & DP-300) supported course.

Understanding of fundamentals of Azure (IaaS, PaaS & SaaS).

Creating Azure Virtual Machines on Windows machines. Using Azure Virtual Machine Images (which includes SQL Server).
Creating/configuring Azure SQL Databases (PaaS/DBaaS)
Creating Server/Database firewall rules in Azure SQL Databases.
Creating logins & users for Azure database and securing databases.
Azure Elastic Pool Databases and Elastic Jobs.
Exporting BACPAC from Azure SQL Databases.
Creating and configuring Azure SQL Database Managed Instance.
Migrating On-Prem Databases to Azure SQL Databases (Singleton) using DMA. Exposure to DMA tools for On-Prem and Azure migrations.
Performed end to end migration using DMS (Data Migration Services) Azure Service.
Performed Lift/Shift migrations from On-Premises to Azure Managed Instance
SQL Database, Elastic DBs, Managed Instance, Migrations
Migrated SQL Database from On-premises (On-Prem) to Azure Database (Cloud) using different techniques DMA, DMS, BACPAC.
Installation & configuring NOSQL database on Azure platform.
Data bricks, data factory, concepts

Gallery (4)

About the Trainer

5 Avg Rating

1 Reviews

1 Students

2 Courses

Amit Patil

MCA

10 Years of Experience

I am Microsoft Certified (70-462) Database Administrator (DBA) with overall 6 Years of Experience, presently working as Database Consultant @ reputed MNC - Bengaluru.

Trained over 200+ BCA/MCA students and MSSQL DBA/ SQL Support Engineer through Offline, Classroom/Workshops and Online.

We provide rich real time experience on MSSQL DBA and RDBMS with latest market trends on live servers. Training is on MSSQL server (2005,2008R2/2012).