Register for Waitlist
,
This class if full now. You can register on the wait list to be notified when a seat becomes available.
Azure SQL Fundamentals Training
Live Online & Classroom Enterprise Training
Azure SQL Fundamentals introduces core concepts of managing relational databases in the cloud using Azure SQL. It covers deployment models, security, scalability, and basic query operations for cloud-based SQL solutions.
Looking for a private batch ?
REQUEST A CALLBACKNeed help finding the right training?
-
Enterprise Reporting
-
Lifetime Access
-
CloudLabs
-
24x7 Support
-
Real-time code analysis and feedback
What is Azure SQL Fundamentals Course about?
What are the objectives of Azure SQL Fundamentals Course ?
Who is Azure SQL Fundamentals Course for?
What are the prerequisites for Azure SQL Fundamentals Course?
Available Training Modes
Live Online Training
2 DaysSelf-Paced Training
20 HoursCourse Outline Expand All
Expand All
- Overview of Azure SQL Database, SQL Managed Instance, and SQL VM
- Choosing the right Azure SQL deployment model
- Understanding Platform-as-a-Service (PaaS) vs. Infrastructure-as-a-Service (IaaS)
- Creating an Azure SQL Database using the Azure Portal, CLI, and PowerShell
- Configuring compute tiers (DTU vs. vCore), elastic pools, and serverless options
- Connecting to Azure SQL from SSMS, Azure Data Studio, and applications
- Using T-SQL for querying and data manipulation
- Understanding stored procedures, views, and functions
- Working with JSON, XML, and temporal tables in Azure SQL
- Implementing authentication (Azure AD, SQL authentication, managed identities)
- Configuring firewalls, network security, and private endpoints
- Encrypting data with Transparent Data Encryption (TDE) and Always Encrypted
- Indexing strategies and query optimization techniques
- Implementing automatic tuning and performance recommendations
- Using Query Store and Dynamic Management Views (DMVs)
- Configuring Geo-replication and Auto-Failover Groups
- Implementing Point-in-Time Restore and Long-term Backup Retention
- Understanding SQL Managed Instance for enterprise scenarios
- Setting up Azure Monitor, Log Analytics, and Performance Insights
- Configuring alerts, auditing, and compliance tracking
- Automating backups and restores using Azure Backup
Who is the instructor for this training?
The trainer for this Azure SQL Fundamentals Training has extensive experience in this domain, including years of experience training & mentoring professionals.
Reviews
Previous
Next
My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!
Shweta Priya
Sony
I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.
Swati Singh
GE
I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.
Nikhil Kohli
Stryker
I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!
Heena Rajan
Mindtree
