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

Level Up: PostgreSQL

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

Are you just starting out on your PostgreSQL journey and looking to see how your skills stack up? Join instructor Sarah Conway in this course for a series of challenges that are designed to take you from an introductory level of knowledge to a more advanced skill set. Test your skills at solving challenges on how to query, select, add, remove, alter, analyze, view, and monitor records while interacting with tables, databases, views, and indexes. Sarah also includes some exercises that show you how to filter sensitive data, encrypt passwords, cancel running queries, generate fictitious data, and more. If you’re ready to take your PostgreSQL skills to the next level, get started here!

This course is integrated with GitHub Codespaces, an instant cloud developer environment that offers all the functionality of your favorite IDE without the need for any local machine setup. With GitHub Codespaces, you can get hands-on practice from any machine, at any time—all while using a tool that you’ll likely encounter in the workplace.

Each installment of the Level Up series offers at least 15 bite-sized opportunities to practice programming at various levels of difficulty, so you can challenge yourself and reinforce what you’ve learned. Check out the “Using GitHub Codespaces with this course” video to learn how to get a codespace up and running.


01 - Introduction
  • 01 - PostgreSQL code challenges
  • 02 - Using GitHub Codespaces with this course

  • 02 - 1. The Basics
  • 01 - Creating a table
  • 02 - Inserting database records
  • 03 - Altering database records
  • 04 - Locating database records
  • 05 - Sorting database records
  • 06 - Deleting database records
  • 07 - Creating a new read-only user

  • 03 - 2. Leveling Up
  • 01 - Creating a table using a foreign key
  • 02 - Identifying transaction totals per customer
  • 03 - Using subqueries to insert records
  • 04 - Handling duplicate records
  • 05 - Using inner joins
  • 06 - Using outer joins
  • 07 - Creating a temporary table

  • 04 - 3. Just for Fun
  • 01 - Pattern matching
  • 02 - Filtering sensitive data
  • 03 - Updating order status
  • 04 - Data cleanup
  • 05 - Generating fictitious data
  • 06 - Encrypting a password
  • 07 - Canceling running queries

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

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

    ایمیل شما:
    تولید کننده:
    شناسه: 26724
    حجم: 96 مگابایت
    مدت زمان: 49 دقیقه
    تاریخ انتشار: 26 آذر 1402
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

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