WSQ-MS Administering Microsoft Azure SQL Solutions (DP-300)
About This Course
This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.
What You'll Learn
LO2: Design data validation and staging databases for Azure SQL.
LO3: Design and verify an extraction process for Azure SQL that consolidates in accordance to business rules.
LO4: Design a transformation and loading process for Azure SQL in accordance to business rules.
LO5: Develop data integration procedure and translate business requirements into Azure SQL data structure.
Entry Requirements
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working experience with relational databases, including planning and implementing databases.
- Familiarity with database concepts such as indexing, queries, and database schemas.
- Understanding of basic SQL syntax and database-related operations such as backup and restore.
- Some experience with Microsoft Azure services, particularly Azure SQL Database and Azure Virtual Machines.
- An awareness of key concepts related to cloud computing and the various Azure data services is advantageous.
- Minimum Diploma required.
- Trainocate will assess the learner's suitability if they are unable to meet the minimum entry requirements.