Azure Developer: Relational Database Solutions Overview/Description Expected Duration Lesson Objectives Course Number Expertise Level Overview/Description Examine how to implement a relational database system as DBaaS provided by Azure. Explore the significance of using OLTP and OLAP and challenges that may arise from their use.
Expected Duration (hours)
1.0
Lesson Objectives Azure Developer: Relational Database Solutions
list the essential capabilities of RDBMS and the benefits of implementing RDBMS on Azure
identify the architectural implementation of OLTP along with its challenges
set up and connect to Azure SQL Database
describe the implementation of SQL server in Azure Virtual machine
implement Azure Database with MySQL database engine and create Entity Framework using VS2017
list and compare features of data warehouse and data mart
setup Datawarehouse in Azure and utilize the capabilities of Datawarehouse using .NET
specify the capabilities of Azure in implementing OLAP
demonstrate the approach of implementing OLAP using the Azure Analysis server
list the implementation scenarios of ETL and the various essential Azure technologies that are used to build ETL flow
implement REST services using .NET and deploy it as Azure App service
compare the essential features provided by Static and Dynamic data masking
demonstrate the steps involved in implementing Dynamic data masking for databases
create SQL server database, connect to the database using SSMC and apply data masking to the data stored in the database
Course Number: it_clmadc_07_enus
Expertise Level
Intermediate