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

PostgreSQL Essential Training

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

PostgreSQL is trusted with mission critical information by some of the biggest companies in the world. It’s also highly flexible, which makes it a great choice for data science researchers, educators, nonprofit organizations, and businesses of all sizes. In this course, Adam Wilbert, who has spent the last decade helping people take their first steps in the world of relational databases, introduces you to PostgreSQL. Adam demonstrates how to set up your own server and create a customized relational database. He shows you the features of PostgreSQL that protect your data from unauthorized access, ensure that it’s accurate, and simplify the process of querying information so that you can make actionable decisions. PostgreSQL is a powerful, robust platform. Get started learning how it works!


01 - Introduction
  • 01 - Manage relational data with PostgreSQL

  • 02 - 1. Getting Started with PostgreSQL
  • 01 - What is PostgreSQL
  • 02 - Download and install PostgreSQL
  • 03 - Install PostgreSQL with Docker
  • 04 - Connect to the server with psql
  • 05 - Browse the server with a graphical interface
  • 06 - Connect pgAdmin to Docker
  • 07 - Tour the pgAdmin interface
  • 08 - Use pgAdmins toolset
  • 09 - Create objects with pgAdmins dialog workflows

  • 03 - 2. An Introduction to Relational Databases
  • 01 - The structure of a database table
  • 02 - PostgreSQL native data types
  • 03 - Join tables together with relationships
  • 04 - Create a table and insert rows of data
  • 05 - Challenge Create a table
  • 06 - Solution Create a table

  • 04 - 3. Building a Database
  • 01 - Organize tables with schemas
  • 02 - Create a table with pgAdmin
  • 03 - Link primary and foreign keys
  • 04 - Enforce referential integrity on related records
  • 05 - Challenge Execute a command on the Postgres server
  • 06 - Solution Execute a command on the Postgres server

  • 05 - 4. Retrieving Information with Queries
  • 01 - Import data from a CSV
  • 02 - Retrieve information with a SELECT query
  • 03 - Helpful pgAdmin Query Tool interface elements
  • 04 - Join tables for additional information
  • 05 - Save a query as a database view
  • 06 - Challenge Import data and write queries
  • 07 - Solution Import data and write queries

  • 06 - 5. Managing Data
  • 01 - Add indexes to a table
  • 02 - Automatically fill in default values
  • 03 - Constrain acceptable input values
  • 04 - Challenge Add data constraints
  • 05 - Solution Add data constraints

  • 07 - 6. Database Administration in PostgreSQL
  • 01 - User accounts and roles
  • 02 - Grant privileges to a role
  • 03 - Backup and restore a database
  • 04 - Start and stop the server

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

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 17315
    حجم: 359 مگابایت
    مدت زمان: 181 دقیقه
    تاریخ انتشار: 13 مرداد 1402
    طراحی سایت و خدمات سئو

    45,900 تومان
    افزودن به سبد خرید