SKILL BENCHMARK
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)
