Azure Developer: Relational Database Solutions
Azure 2018
| Intermediate
- 14 Videos | 56m 50s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
-
list the essential capabilities of RDBMS and the benefits of implementing RDBMS on Azureidentify the architectural implementation of OLTP along with its challengesset up and connect to Azure SQL Databasedescribe the implementation of SQL server in Azure Virtual machineimplement Azure Database with MySQL database engine and create Entity Framework using VS2017list and compare features of data warehouse and data martsetup Datawarehouse in Azure and utilize the capabilities of Datawarehouse using .NET
-
specify the capabilities of Azure in implementing OLAPdemonstrate the approach of implementing OLAP using the Azure Analysis serverlist the implementation scenarios of ETL and the various essential Azure technologies that are used to build ETL flowimplement REST services using .NET and deploy it as Azure App servicecompare the essential features provided by Static and Dynamic data maskingdemonstrate the steps involved in implementing Dynamic data masking for databasescreate SQL server database, connect to the database using SSMC and apply data masking to the data stored in the database
IN THIS COURSE
-
1.RDBMS Capabilities of Azure3m 28sUP NEXT
-
2.OLTP Implementation and Challenges4m 20s
-
3.Azure SQL Database5m 1s
-
4.SQL Server in an Azure Virtual Machine5m 14s
-
5.Azure Database for MySQL7m 9s
-
6.Data Warehouse and Data Mart3m 45s
-
7.Data Warehouse in Azure3m 16s
-
8.Azure OLAP Capabilities4m 14s
-
9.Implement OLAP Using Azure Analysis Server3m 55s
-
10.Implementing ETL2m 22s
-
11.Implement REST Using .NET4m 32s
-
12.Static and Dynamic Data Masking3m 7s
-
13.Implement Dynamic Data Masking2m 9s
-
14.Exercise: Work with SQL Server Database4m 17s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.