Welcome to the SQL training for Azure SQL Database. This course is designed for beginners and intermediate learners who want to manage and query databases in Microsoft Azure. You will learn how to create, read, update, and delete data using SQL while leveraging the features of Azure SQL Database.
Module 1: Overview of Azure SQL Database
- What is Azure SQL Database
- Benefits of using Azure SQL Database
- Key differences between on-premises SQL Server and Azure SQL Database
- Understanding Azure resource groups, servers, and databases
- Security features in Azure SQL Database
Module 2: Connecting to Azure SQL Database
- Accessing Azure portal
- Creating a new Azure SQL Database
- Configuring firewall rules for client access
- Connecting using SQL Server Management Studio (SSMS)
- Connecting using Azure Data Studio
- Using Visual Studio Code to query Azure SQL Database
Module 3: SQL Basics
- Introduction to SQL syntax
- Creating and using databases and tables
- Data types in Azure SQL Database
- Inserting data into tables
- Reading data using SELECT statements
- Updating data
- Deleting data
Module 4: Querying Data
- Filtering data using WHERE clause
- Sorting data using ORDER BY
- Using aggregate functions (COUNT, SUM, AVG, MIN, MAX)
- Grouping data using GROUP BY
- Filtering grouped data using HAVING
- Joining tables (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN)
- Subqueries and nested queries
Module 5: Advanced SQL Concepts
- Using views in Azure SQL Database
- Indexing for performance
- Stored procedures
- Functions and user-defined functions
- Transactions and error handling
- Triggers
Module 6: Security and Access Management
- Creating users and roles
- Assigning permissions
- Row-level security
- Dynamic data masking
- Auditing and threat detection
Module 7: Performance and Monitoring
- Monitoring performance using Azure portal
- Query performance insights
- Understanding execution plans
- Scaling databases (DTUs vs vCores)
- Backups and restoring databases
Module 8: Integration and Automation
- Using Azure Data Factory with SQL Database
- Connecting Power BI to Azure SQL Database
- Exporting and importing data
- Automating tasks with Azure Logic Apps or stored procedures
Module 9: Hands-on Exercises
- Create a sample database and tables
- Insert sample data and query it
- Write advanced queries with joins and subqueries
- Implement a stored procedure and trigger
- Monitor database performance and optimize queries
Conclusion
By completing this training, you will be able to confidently create, manage, and query Azure SQL Databases. You will understand best practices for security, performance, and integration with other Azure services.