Fundamentals

The key concepts of EDB Postgres Advanced Server include its features, benefits, and terminology. The SQL tutorial uses a sample database and explains important database concepts.

• EDB Postgres Advanced Server fundamentals
  • Benefits of EDB Postgres Advanced Server
  • Database compatibility for Oracle developers
  • Terminology
    • Database server (postmaster)
    • Database cluster
    • Configuration files
• SQL fundamentals
  • About the examples
  • Conventions used
  • SQL tutorial
    • Sample database
    • Creating a new table
    • Populating a table With rows
    • Querying a table
    • Executing joins between tables
    • Aggregating data
    • Updating a table
    • Deleting a table
    • The SQL language
  • Advanced concepts
    • Views
    • Foreign keys
    • The ROWNUM pseudo-column
    • Synonyms
    • Hierarchical queries
    • Hierarchical queries
    • Multidimensional analysis
    • Multidimensional analysis
  • Sample database description
    • Available scripts
    • About the sample database
• Supported platforms
• EDB Postgres Advanced Server release notes
  • Component certification
  • Support announcements
    • Backup and Recovery Tool (BART) incompatibility