Azure Data Fundamentals: Relational Data Workloads

IN THIS COURSE

• 1.  Course Overview
  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
• 2.  Characteristics of Relational Data
  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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 12.  Course Summary
  50s
  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