This SQL Server training class is designed to help you gain a deep understanding about Microsoft Azure, including Azure virtual machines, Azure SQL Database, and Azure SQL Managed Instance. This course includes complete practical approach to Azure SQL Database Administration (Azure SQL DBA) activities including On-premise to Azure Database Migrations, Troubleshooting, Security Management. This course will help you take advantage of your existing SQL Server skills and learn about managing, high availability, and performance of this cloud first solution.
Course Objectives:
In this module you will learn:
- Evolution of SQL Server in Azure.
- Differentiate which deployment option is best for workloads for the organization.
- Choosing the purchasing models, service tiers, and hardware that best fit a workload.
- You will get a knowledge of what to use when and how to configure, secure, monitor, and troubleshoot Azure SQL.
- You’ll learn how to create Azure SQL Databases and methodologies for migrating your on-premises databases to Azure, different ways of connecting to Azure and methodologies for tuning, plus maintenance considerations and built-in/external monitoring and alerting.
- You’ll learn about automation and scheduling options that are available within Azure too, covering Azure Automation, Elastic Agent, and discuss how PowerShell can be used to deploy assets.
Course content
Introduction
- A brief history of why and how Microsoft built Azure SQL.
- Various deployment options and service tiers, including what to use for the organization, and when.
- Some of the options include Azure SQL Database
- Azure SQL Managed Instance, and SQL Server in an Azure virtual machine.
Azure Virtual Machines
- Compliance
- Networking
- Active Directory integration
- Installing SQL Server
- Configuring SQL Server
- Maintenance considerations
- HA/DR options
- Performance scaling
- Billing considerations and licensing
Azure SQL deployment options
- SQL Server on virtual machines
- Azure SQL Managed Instance
- Azure SQL Database
- Azure SQL Managed Instance pools
- Azure SQL Database elastic database pools.
Migrating to Azure Virtual Machines
- Collecting on-premises data for sizing
- Benchmarking Azure virtual machines
- Choosing the correct size of virtual machine
- Migration strategies
- Pros and cons
Azure SQL Database
- Overview of Azure SQL Database
- Features:
- Restore services
- Dynamic Data Masking
- Row-Level security
- Always Encrypted
- Query Store
- Index Advisor
- Geo-replication
- Elastic pools
- On-premises differences
- Pricing
- Creating Azure SQL Databases
- Maintenance considerations
- Automation
- Monitoring and alerting
Migrating to Azure SQL Database
- DTU Calculator
- Upgrade planning
- Migrating databases to Azure SQL Database
- Tuning options
- Connectivity
- Azure Data Studio for SQL Server
Azure Managed Instance
- Azure Security Center
- Operations Insights
- Log Analytics
- Vulnerability Assessment
- Data Classification
- Threat Protection
Administration and Scheduling
- Azure Automation
- Elastic Agent
- PowerShell
Additional Azure Services
- Hyper-Scale
- Power BI
- Azure Data Factory
- Azure Data Warehouse
- Azure Analysis Services
To see the full course content Download now
Course Prerequisites
- Fundamentals of SQL
Who can attend
- Graduates and undergraduates who want to learn to maintain SQL Azure databases and architects that want to learn to leverage SQL Azure in their applications.
- Database administrators
- Data management specialists that manage on-premises and cloud relational databases built with SQL Server and Azure Data Services
Number of Hours: 30hrs
Certification
Key features
- One to One Training
- Online Training
- Fastrack & Normal Track
- Resume Modification
- Mock Interviews
- Video Tutorials
- Materials
- Real Time Projects
- Virtual Live Experience
- Preparing for Certification
FAQs
DASVM Technologies offers 300+ IT training courses with 10+ years of Experienced Expert level Trainers.
- One to One Training
- Online Training
- Fastrack & Normal Track
- Resume Modification
- Mock Interviews
- Video Tutorials
- Materials
- Real Time Projects
- Materials
- Preparing for Certification
Call now: +91-99003 49889 and know the exciting offers available for you!
We working and coordinating with the companies exclusively to get placed. We have a placement cell focussing on training and placements in Bangalore. Our placement cell help more than 600+ students per year.
Learn from experts active in their field, not out-of-touch trainers. Leading practitioners who bring current best practices and case studies to sessions that fit into your work schedule. We have a pool of experts and trainers are composed with highly skilled and experienced in supporting you in specific tasks and provide professional support. 24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts. Our trainers has contributed in the growth of our clients as well as professionals.
All of our highly qualified trainers are industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo before they are certified to train for us. We also ensure that only those trainers with a high alumni rating continue to train for us.
No worries. DASVM technologies assure that no one misses single lectures topics. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. If required you can even attend that topic with any other batches.
DASVM Technologies provides many suitable modes of training to the students like:
- Classroom training
- One to One training
- Fast track training
- Live Instructor LED Online training
- Customized training
Yes, the access to the course material will be available for lifetime once you have enrolled into the course.
You will receive DASVM Technologies recognized course completion certification & we will help you to crack global certification with our training.
Yes, DASVM Technologies provides corporate trainings with Course Customization, Learning Analytics, Cloud Labs, Certifications, Real time Projects with 24x7 Support.
Yes, DASVM Technologies provides group discounts for its training programs. Depending on the group size, we offer discounts as per the terms and conditions.
We accept all major kinds of payment options. Cash, Card (Master, Visa, and Maestro, etc), Wallets, Net Banking, Cheques and etc.
DASVM Technologies has a no refund policy. Fees once paid will not be refunded. If the candidate is not able to attend a training batch, he/she is to reschedule for a future batch. Due Date for Balance should be cleared as per date given. If in case trainer got cancelled or unavailable to provide training DASVM will arrange training sessions with other backup trainer.
Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.
Please Contact our course advisor +91-99003 49889. Or you can share your queries through info@dasvmtechnologies.com