وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Azure Data Fundamentals (DP-900) Cert Prep: 2 Working with Relational Data on Azure

سرفصل های دوره

Understanding and working with relational data is a key skill for anybody working with their organization's data platform. Relational data skills are also vital for individuals preparing for the DP-900 Azure Fundamentals exam. In this course, Adam Wilbert covers the basics of working with relational data, and touches on how these basics are implemented using the Azure data services. Go over the steps to organize data with the relational model. Learn how to normalize table designs and link tables with foreign keys. Get a thorough introduction to structured query language (SQL) and how you can use it, then explore additional database objects and the database services that you can find on the Azure Cloud Platform. This course maps to the "Describe How to Work with Relational Data on Azure" skill domain from the DP-900, Azure Data Fundamentals certification Skills Measured doc.


01 - Introduction
  • 01 - Storing relational data on Azure
  • 02 - Preparing for the DP-900 exam

  • 02 - 1. Organizing Data with the Relational Model
  • 01 - Data table structures
  • 02 - Choosing appropriate data types
  • 03 - Create a relationship between tables
  • 04 - The three types of table relationships

  • 03 - 2. Normalizing Table Designs
  • 01 - Create tables for each entity
  • 02 - Create columns for each attribute
  • 03 - Use keys to uniquely identify entities
  • 04 - Link tables with foreign keys

  • 04 - 3. Structured Query Language
  • 01 - A brief history of SQL
  • 02 - Data Manipulation Language statements
  • 03 - Data Definition Language statements
  • 04 - Data Control Language statements

  • 05 - 4. Additional Database Objects
  • 01 - Create a view of the data
  • 02 - Add programmatic stored procedures
  • 03 - Locate data with indexes

  • 06 - 5. Database Services on the Azure Cloud Platform
  • 01 - Run SQL Server with a virtual machine
  • 02 - Benefits of Azure SQL Managed Instance
  • 03 - Cloud-native Azure SQL Database
  • 04 - Tailor an IoT solution with Azure SQL Edge
  • 05 - Open-source database solutions

  • 07 - Conclusion
  • 01 - Next steps
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    شناسه: 3475
    حجم: 138 مگابایت
    مدت زمان: 63 دقیقه
    تاریخ انتشار: 29 دی 1401
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید