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
    FREE ACCESS
  • Locked
    4. 
    SQL Server in an Azure Virtual Machine
    5m 14s
    FREE ACCESS
  • Locked
    5. 
    Azure Database for MySQL
    7m 9s
    FREE ACCESS
  • Locked
    6. 
    Data Warehouse and Data Mart
    3m 45s
    FREE ACCESS
  • Locked
    7. 
    Data Warehouse in Azure
    3m 16s
    FREE ACCESS
  • Locked
    8. 
    Azure OLAP Capabilities
    4m 14s
    FREE ACCESS
  • Locked
    9. 
    Implement OLAP Using Azure Analysis Server
    3m 55s
    FREE ACCESS
  • Locked
    10. 
    Implementing ETL
    2m 22s
    FREE ACCESS
  • Locked
    11. 
    Implement REST Using .NET
    4m 32s
    FREE ACCESS
  • Locked
    12. 
    Static and Dynamic Data Masking
    3m 7s
    FREE ACCESS
  • Locked
    13. 
    Implement Dynamic Data Masking
    2m 9s
    FREE ACCESS
  • Locked
    14. 
    Exercise: Work with SQL Server Database
    4m 17s
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE AWS SysOps Associate: AWS SQL Solutions
Likes 2 Likes 2  
COURSE Azure Data Fundamentals: Relational Data Management
COURSE Azure Data Scientist Associate: Non-relational Data Stores

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Azure Developer: File Storage Solutions
Likes 33 Likes 33  
COURSE Azure Developer: PaaS Web Applications
Likes 20 Likes 20  
COURSE Azure Developer: Azure Cloud Technology Solutions
Likes 110 Likes 110