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

Advanced PostgreSQL

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

PostgreSQL is a powerful, open-source, object-relational database system. It’s popular around the world, given its strong reputation for reliability, feature robustness, and performance. In this course, Janani Ravi dives into advanced topics in PostgreSQL. After showing how to install and set up PostgreSQL, Janani shows you how to work with geospatial data, which allows you to specify geographic objects such as locations, lines, and polygons, all on a geographic map, and also supports location-based queries like distance computation and area computation. Next, learn about performing full-text search operations, and how to work with triggers, which let you set up an automated execution of a function when a certain type of operation is performed. Finally, Janani explores transactions, which allow you to bundle multiple steps into a single, all-or-nothing operation.


01 - Introduction
  • 01 - Advanced features in PostgreSQL

  • 02 - 1. Installing and Setting up PostgreSQL
  • 01 - macOS Install PostgreSQL and PGAdmin 4
  • 02 - macOS Install and set up PostGIS
  • 03 - Windows Install PostgreSQL and PGAdmin 4
  • 04 - Windows Install and set up PostGIS

  • 03 - 2. Working with Geospatial Data
  • 01 - Spatial data analysis using PostGIS
  • 02 - The WKT and WKB format
  • 03 - Geometry and geography data types
  • 04 - Spatial reference systems
  • 05 - Creating a table to hold geometry types
  • 06 - Working with basic geometry types
  • 07 - Extracting coordinate values, computing length, and area
  • 08 - Representing real-world data
  • 09 - Computing the distance between locations
  • 10 - Computing locations within a distance and representing lines on a map
  • 11 - Importing shapefiles

  • 04 - 3. Performing Full-Text Search Operations
  • 01 - Full-text search
  • 02 - Basic text search using LIKE and ILIKE
  • 03 - Tsvector and tsquery
  • 04 - Performing a full-text search using the @@ operator
  • 05 - Using logical operations in search terms
  • 06 - Performing a search using a different language
  • 07 - Controlling search parameters
  • 08 - Ranking search results
  • 09 - Creating and using dictionaries

  • 05 - 4. Creating and Managing Triggers
  • 01 - Introducing triggers
  • 02 - Trigger execution order
  • 03 - Creating a row-level, after insert trigger
  • 04 - Creating a row-level, after update trigger
  • 05 - Creating a statement-level trigger

  • 06 - 5. Defining and Launching Transactions
  • 01 - Transactions and transaction isolation levels
  • 02 - Creating and committing transactions
  • 03 - Rolling back transactions
  • 04 - Rolling back committed transactions
  • 05 - Savepoints and rollbacks
  • 06 - The read committed isolation level
  • 07 - The repeatable read isolation level
  • 08 - The serializable isolation level

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

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

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

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