TOP HOT – מסלולי הכשרה המבוקשים של נאיה קולג’

חייגו עכשיו: 073-2865544

PostgreSQL Course for Developers

Description:

PostgreSQL is an open-source object-relational database with over 30 years in a market with strong reliability, feature robustness, and performance.

PostgreSQL Course for Developers

PostgreSQL course was designed for developers with SQL knowledge and experience and focuses on functionality that are specific to PostgreSQL. This training course covers SQL, DML, DDL, PL/pgSQL language and basic performance diagnostics. Attendees will learn how to work with a PostgreSQL development environment, manipulate and query data.

PostgreSQL developers

This training (course) is ideal for those who are looking to migrate to PostgreSQL. It is designed for developers with minimal SQL knowledge seeking to leverage their server-side development skills.

Basic knowledge in SQL language.

  • Preparing the PG Instance
    • PostgreSQL for Windows
    • PostgreSQL Docker for Linux
  • Development tools
    • pgAdmin
    • DBeaver
    • IDEA
  • Connecting to PostgreSQL
    • Creating a database/schema
    • Loading the demo schema
    • What is a database object?
    • browsing the schema objects
  • Hand-on Lab
  • Learning SQL
    • Creating a Tables (DDLs): data types, PK, Identity column
    • DMLs: INSERT/DELETE/UPDATE
    • Selecting Data
    • JOINs (INNER, LEFT, RIGHT, OUTER)
    • Built-In Functions
    • Aggregate functions and GROUP BY
    • ORDER BY
  • Hand-on Lab
  • Procedural Language – PL/pgSQL
    • Basics of PL/pgSQL
    • Functions
    • Procedures
    • Cursors (loop, case, if-then-else)
  • Triggers
  • Exception Handling
  • The PERFORM and EXECUTE statements
  • Autonomous Transactions
  • Hand-on Lab
  • Performance tuning
    • Explain the explain
    • Indexes, B-tree, FKs (constraints)
    • Indexes on expressions
  • Analyzing & optimizing queries
  • טרם נקבע מועד פתיחה
  • 09:00-16:30daysימים ושעות
  • 8academic hours שעות אקדמיות
  • בסיסי ומתקדםcourse levelרמת הקורס
  • עבריתlanguageשפת הדרכה
  • לבדיקת התאמה לקורס
  • [current_url]

    השאירו פרטים ונחזור אליכם בהקדם!

Call Now Button דילוג לתוכן