Learn ralph small Learn

SQL

A special-purpose programming language designed for managing data in relational database management systems. We recommend the SQL server PostgreSQL

Contribute to this list

Create an account or sign in to save your progess

Beginning Postgres

Use these additional resources for reference and additional practice

Beginning Postgres developers should be able to

  • Insert a new record.
  • Update one or more records.
  • Delete one or more records.
  • Find rows that satisfy one or more conditions.
  • Limit query results.
  • Order query results.
  • Average values in a column.
  • Find the mininum value in a column.
  • Find the maximum value in a column.
  • Sum values in a column.
  • Count values in a column.
  • Paginate results.
  • Suppress duplicates.
  • Answer negation questions. ("Which students don't take course 101?")
  • Answer limit questions. ("Which students take at least 2 courses?")
  • Answer exact questions. ("Which professors teach only 1 course?")
  • Answer relational division questions. ("Find a plane faster than all trains.")

Ongoing Reference