PostgreSQL CE 8 Silver

Detailed Exam Scopes [ PostgreSQL CE 8 Silver Exam ]

• Basic Knowledge Section
  • Basic characteristics of PostgreSQL
  • License
    • BSD license characteristics
      
  • Changes from the old versions
    • Differences between 7.4 and 8.0
    • Differences between 8.0 and 8.1
  • Basic knowledge of the relational database
    • Basic concepts of the relational data model
    • Roles of the database management system
    • SQL International Standards (SQL92, SQL99, etc)
    • SQL basic knowledge, SQL grouping's (DDL/DML/DCL)
• Administration Section
  • Installtaion method
    • initdb command
    • Concepts of the database cluster
    • Template databases
  • Usages of the standard tools
    • psql, pg_ctl, postmaster, createdb, dropdb, createlang, droplang, createuser, dropuser, vacuumdb
  • Configuration files
    • postgresql.conf
      • Description format
      • CONNECTION AND AUTHENTICATION
      • CLIENT CONNECTION DEFAULTS
      • log_destination, redirect_stderr, silent_mode, log_line_prefix
    • pg_hba.conf
    • Usages of SET/SHOW statements
  • Backup methods
    • Usages of pg_dump, pg_dumpall, pg_restore, psql commands
    • Backup/Restore by copying directories
    • PITR concepts (no questions on detailed PITR usage in Silver exam)
    • Usages of COPY statement and \copy command
  • Basic administrating tasks
    • Adding/Deleting/Changing database users
    • Usages and meanings of VACUUM/ANALYZE
    • Functions to obtain system informaion (version, current_user, etc.)
    • Information schema, System catalog (pg_user, pg_shadow, etc. No questions on statistic VIEWs and pg_stats)
    • Authorization on tables, GRANT/REVOKE statements
• Development/SQL section
  • SQL commands
    • SELECT statement
      • Selecting columns/tables, LIMIT, OFFSET, ORDER BY
      • DISTINCT, GROUP BY, HAVING, subquery
      • JOIN, OUTER JOIN, EXISTS, IN, joining the queries
      • Conditional statements (CASE, COALESCE, NULLIF)
    • INSERT/UPDATE/DELETE statement
    • Sequences
    • Data types (BOOLEAN, string, integer, time, NULL, SERIAL, OID, array)
    • Binary array type, large object
    • Table definitions (constraints, default values, temporary tables, inheritence)
    • ALTER TABLE, DROP TABLE, CREATE TABLE AS
    • Indexes
    • Views
    • Rule, Trigger
    • Schemas
    • PREPARE
    • Cursor
    • Domain definition, type definition
    • Function definition, PL/pgSQL
  • Built-in funtions
    • Aggregate functions (count, sum, avg, max, min)
    • Arithmetic functions, operators
    • String functions (char_length, lower, upper, substring, replace, trim)
    • String operators (||, ~, LIKE, SIMILAR TO)
    • Time functions (age, current_date, current_timestamp, current_time, extract, to_char)
  • Transaction concepts
    • Transaction statements (BEGIN, COMMIT, ROLLBACK, SAVEPOINT, and other equivalent SQL statements
    • Transaction separation levels
    • Implicit locks, LOCK statement, column locks and table locks
    • LISTEN/NOTIFY statement

PostgreSQL CE 8 Silver questions are assumed to be "PostgreSQL version 8.0 running on Linux OS" unless otherwise noted (There are no OS dependent questions in the exam).

Go back to the top of this page