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

Learning Azure SQL Querying

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

Azure SQL allows you to go live within minutes, using a cloud-hosted database. It provides a great way to begin your journey of learning SQL for data processing and analytics. In this course, Jeremy Villeneuve guides you through the process of getting started. Jeremy goes over what SQL is, as well as common statements and differences in SQL engines. He presents an Azure SQL quick start guide, then shows you how to create new records using the Azure Query Editor. Jeremy explains how to read data in Azure SQL database records, as well as how to update existing data. Each chapter in this course includes a challenge and sample solution, so you can test your understanding of what you learn.


01 - Introduction
  • 01 - Azure SQL for learning SQL fast

  • 02 - 1. What Is SQL
  • 01 - What are tables, rows, and columns
  • 02 - The most common SQL statements
  • 03 - Differences in SQL engines

  • 03 - 2. Azure SQL Quick Start
  • 01 - Create an Azure account
  • 02 - Azure free services
  • 03 - Create an Azure SQL Database
  • 04 - Connect with the Azure Query Editor
  • 05 - Challenge Whitelist an IP address
  • 06 - Solution Whitelist an IP address

  • 04 - 3. Create New Records in Azure SQL Database
  • 01 - Navigating the sample database with Azure Query Editor
  • 02 - Common data types in SQL
  • 03 - Stay unique with identity columns
  • 04 - Inserting new data into a table
  • 05 - Challenge Insert a new product
  • 06 - Solution Insert a new product

  • 05 - 4. Understand How to Read Data in Azure SQL Database Records
  • 01 - Selecting your new record
  • 02 - Using conditional statements to only get the data you need
  • 03 - Sorting your data in SQL with the ORDER BY clause
  • 04 - Joining together multiple tables for increased query results
  • 05 - Challenge Get products by price with the WHERE clause
  • 06 - Solution Get products by price with the WHERE clause

  • 06 - 5. Update Existing Data in Azure SQL Database Records
  • 01 - Using an UPDATE statement to change a record
  • 02 - Deleting your data
  • 03 - Challenge Update the product price
  • 04 - Solution Update the product price

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

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

    ایمیل شما:
    تولید کننده:
    شناسه: 15571
    حجم: 224 مگابایت
    مدت زمان: 86 دقیقه
    تاریخ انتشار: 12 تیر 1402
    طراحی سایت و خدمات سئو

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