Who is this training for?
Application developers and solution architects
Training objectives
- Understand the basic concepts of database administration
- Master Azure database services
- Secure databases
- Automate and manage tasks
Summary
This course prepares you for the task of developing data-driven applications with Microsoft Azure SQL Database. You'll learn how to create and configure an Azure SQL Database, create and deploy database projects using GitHub Actions and Azure Pipelines, and automate the publishing process. You'll also learn how to use the Data API Builder for Azure SQL Database and how to develop a Data API with Azure Web Apps and Static Web Apps. In addition, you'll learn the skills to import data through an external REST endpoint, export data using an Azure function, and secure an Azure SQL Database. These essential skills will enable you to effectively develop and manage applications with Azure SQL Database.
Course outline
- Get started with Azure SQL Database for modern application development
- Develop for Azure SQL Database
- Develop a data API for Azure SQL Database
- Explore data manipulation options in Azure SQL Database
- Explore security practices for Azure SQL Database
Approach and methodology
Practical and structured approach combining focused theory and guided workshops. Participants gradually design and develop data-driven applications with Azure SQL Database through real-world exercises inspired by business scenarios, promoting immediate application of learnings. Led by a Microsoft certified trainer, the training focuses on interactivity and the development of technical skills that can be directly mobilized to design, optimize and manage data solutions in a real context.
Prerequisites
- Experience in relational databases
- Basic knowledge of security concepts such as identities and permissions
- Experience using the Azure portal to create resources and set permissions
Recommendations
- Basics in relational databases (SQL, queries) Knowledge of Transact-SQL (T-SQL)
- Notions of application development (e.g. architecture, integration)
- Understanding of cloud and Azure concepts
- Familiarity with data management and modeling
