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 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
IN THIS COURSE
-
3m 28sAfter completing this video, you will be able to list the essential capabilities of an RDBMS and the benefits of implementing an RDBMS on Azure. FREE ACCESS
-
4m 20sIn this video, you will learn how to identify the architectural implementation of OLTP along with its challenges. FREE ACCESS
-
3. Azure SQL Database5m 1sIn this video, learn how to set up and connect to an Azure SQL Database. FREE ACCESS
-
4. SQL Server in an Azure Virtual Machine5m 14sAfter completing this video, you will be able to describe the implementation of SQL Server in an Azure Virtual Machine. FREE ACCESS
-
5. Azure Database for MySQL7m 9sDuring this video, you will learn how to implement Azure Database with the MySQL database engine and create Entity Framework using VS2017. FREE ACCESS
-
6. Data Warehouse and Data Mart3m 45sAfter completing this video, you will be able to list and compare features of data warehouses and data marts. FREE ACCESS
-
7. Data Warehouse in Azure3m 16sIn this video, you will learn how to set up a data warehouse in Azure and how to use the capabilities of a data warehouse using .NET. FREE ACCESS
-
8. Azure OLAP Capabilities4m 14sUpon completion of this video, you will be able to specify the capabilities of Azure in implementing OLAP. FREE ACCESS
-
9. Implement OLAP Using Azure Analysis Server3m 55sIn this video, you will learn how to implement OLAP using the Azure Analysis server. FREE ACCESS
-
10. Implementing ETL2m 22sAfter completing this video, you will be able to list the implementation scenarios of ETL and the various essential Azure technologies that are used to build an ETL flow. FREE ACCESS
-
11. Implement REST Using .NET4m 32sIn this video, you will learn how to implement REST services using .NET and deploy it as an Azure App service. FREE ACCESS
-
12. Static and Dynamic Data Masking3m 7sLearn how to compare the essential features provided by static and dynamic data masking. FREE ACCESS
-
13. Implement Dynamic Data Masking2m 9sLearn how to apply the steps involved in implementing dynamic data masking for databases. FREE ACCESS
-
14. Exercise: Work with SQL Server Database4m 17sLearn how to create a SQL server database, connect to the database using SSMC, and apply data masking to the data stored in the database. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
