Azure Developer: Relational Database Solutions

Azure 2018    |    Intermediate
  • 14 Videos | 1h 3m 20s
  • Includes Assessment
  • Earns a Badge
Likes 24 Likes 24
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

  • Playable
    1. 
    RDBMS Capabilities of Azure
    3m 28s
    UP NEXT
  • Playable
    2. 
    OLTP Implementation and Challenges
    4m 20s
  • Locked
    3. 
    Azure SQL Database
    5m 1s
  • Locked
    4. 
    SQL Server in an Azure Virtual Machine
    5m 14s
  • Locked
    5. 
    Azure Database for MySQL
    7m 9s
  • Locked
    6. 
    Data Warehouse and Data Mart
    3m 45s
  • Locked
    7. 
    Data Warehouse in Azure
    3m 16s
  • Locked
    8. 
    Azure OLAP Capabilities
    4m 14s
  • Locked
    9. 
    Implement OLAP Using Azure Analysis Server
    3m 55s
  • Locked
    10. 
    Implementing ETL
    2m 22s
  • Locked
    11. 
    Implement REST Using .NET
    4m 32s
  • Locked
    12. 
    Static and Dynamic Data Masking
    3m 7s
  • Locked
    13. 
    Implement Dynamic Data Masking
    2m 9s
  • Locked
    14. 
    Exercise: Work with SQL Server Database
    4m 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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 33 Likes 33  
Likes 20 Likes 20  
Likes 110 Likes 110