PostgreSQL Competency (Intermediate Level)

  • 20m
  • 12 questions
The Postgre SQL Competency (Intermediate Level) benchmark assesses your recognition of core Postgre SQL concepts. You will be evaluated on your skills in recognizing high-level elements of Postgre SQL commands and techniques. Learners who score high on this benchmark demonstrate that they have a solid understanding of intermediate-level Postgre SQL concepts.

Topics covered

  • create a table
  • create database objects
  • define the various data types and understand the PRIMARY KEY constraint
  • describe constraints in PostgreSQL
  • describe the FOREIGN KEY - REFERENCES constraint
  • describe the more advance options of the SELECT command
  • describe the various object-sensitive privileges within PostgreSQL
  • retrieve data from tables
  • work with aggregate functions, operators and column labels
  • work with SQL DDL commands in PostgreSQL
  • work with SQL DML commands
  • work with the command line option (psql)