Azure Data Fundamentals: Relational Data Workloads

Azure 2020    |    Intermediate
  • 12 videos | 1h 20m 21s
  • Includes Assessment
  • Earns a Badge
Likes 34 Likes 34
Relational data is stored in tables, which allows users to easily categorize and query the data. In this course, you'll learn about the characteristics of relational data and different relational databases. You'll explore how to use indexes and views in a relational database, as well as the different delivery models for relational data. Next, you'll examine Platform as a Service, Infrastructure as a Service, and Software as a Service. Finally, you'll learn about online transaction and analytical processing. This course is one in a series that prepares learners for the Microsoft Azure Data Fundamentals (DP-900) exam.


  • discover the key concepts covered in this course
    describe the characteristics of relational data
    identify the different data store models
    use indexes in an Azure SQL relational database
    use views in an Azure SQL relational database
    identify the different delivery models for Azure relational data
  • describe Azure Platform as a Service
    describe Azure Infrastructure as a Service
    describe Azure Software as a Service
    describe online transaction processing (OLTP)
    describe online analytical processing (OLAP)
    summarize the key concepts covered in this course


  • 1m 47s
    This video introduces you to your instructor as they highlight the key concepts to be covered in this course. Topics like data characteristics, different database types, and taking a specific look at PaaS, Iaas, and SaaS are all included in what you’ll learn through this series of training videos. FREE ACCESS
  • 7m 24s
    Start your journey toward passing the Microsoft Azure Data Fundamentals exam here as you start learning the ways data is stored into relational tables has an impact on how effectively you can categorize and query that data. Learn the answer to the question of what is the important role relational data characteristics play and also how do you run effective queries to manipulate the data. FREE ACCESS
  • Locked
    3.  Data Store Models
    13m 8s
    Learn what a data store model (DSM) is and the types you work with in Microsoft Azure. Review different types of DSMs including how each type categorizes relational data to link what it’s best at performing to the needs of varying analytical workloads. FREE ACCESS
  • Locked
    4.  Using Indexes in a Relational Database
    5m 40s
    Browse various index types within Microsoft Azure that you can use to get up and running quickly. When you have mastered creating indexes using Azure’s built-in templates, consider creating an index from scratch. Whichever option you use to get started, the index must be created before you start building an Azure SQL relational database.  FREE ACCESS
  • Locked
    5.  Using Views in a Relational Database
    4m 22s
    See how views are used in Microsoft Azure and also learn how they actually relate to SQL databases. Get an in depth look into what exactly views are, what a view does and does not do, and how a view is created.   FREE ACCESS
  • Locked
    6.  Azure Relational Delivery Models
    6m 29s
    Explore the many types of relational databases and different delivery models to use with relational data in Microsoft Azure. Move beyond just exploring this topic and learn to understand how they differ, what are the pros and cons of each, and also how to determine which method works best for your needs.   FREE ACCESS
  • Locked
    7.  Azure PaaS
    8m 22s
    Focus on Microsoft Azure Platform as a Service, also PaaS, to learn key points about the development tools offered, operating systems, and servers and storage. It's imperative you can learn to identify when using PaaS is the right solution for a given scenario.      FREE ACCESS
  • Locked
    8.  Azure IaaS
    9m 22s
    Focus on Microsoft Azure Infrastructure as a Service, also IaaS, to learn its benefits and how to identify scenarios which may be best suited to IaaS. Learning more about the different parts that make IaaS what it is will also help you decide when it's the right solution.   FREE ACCESS
  • Locked
    9.  Azure SaaS
    7m 14s
    Focus on Microsoft Azure Software as a Service, also SaaS, to uncover why it's such a popular choice and to learn how to use that information to identify when SaaS is the solution of choice. Exploring examples of why SaaS might be the preferred choice will help you solidify the information and skills acquired.   FREE ACCESS
  • Locked
    10.  Online Transaction Processing
    6m 54s
    Watch this video to learn what role OnLine Analytical Processing (OLAP) plays when you manage relational database workloads in Microsoft Azure. Go even further in your understanding by learning about the OLAP semantic models and how to identify if OLAP is the best way for you to address a given scenario.  FREE ACCESS
  • Locked
    11.  Online Analytical Processing
    8m 49s
    Go from concept of online analytical processing (OLAP) to exploration and relation to OLTP to discussing its optimization to managing heavy workloads of low read business intelligence relational databases used with Microsoft Azure. Manage relational database workloads, analyze scenarios against OLAP semantic models, and know when OLAP is the right solution. FREE ACCESS
  • Locked
    12.  Course Summary
    Begin your review of this course’s main learning points. See how far you've come as you briefly revisit the topics used to introduce you to basic concepts you must understand to build the foundation to gain more advanced skills on managing relational database workloads in Microsoft Azure. FREE ACCESS


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.



Likes 194 Likes 194  
Likes 49 Likes 49