Step 3 / Select topic Postgres Easy

What this bank covers

  • SQL operators on text values
  • String functions and operators
  • Pattern matching
  • Postgres · Easy
  • psql meta-commands
  • PostgreSQL client sessions and transactions
  • psql interactive terminal behavior
  • Numeric data types
  • SQL identifiers and naming rules
  • Character data types
  • PostgreSQL schemas and object name resolution
  • Inserting data
  • Handling insert conflicts in SQL
  • Array types
  • Array types and expressions
  • PostgreSQL JSON data access
  • JSON data access in PostgreSQL
  • JSON operators
  • JSON construction functions
  • Date/time functions
  • Handling missing values in SQL
  • SQL conditional expressions
  • Query result deduplication
  • Data types
  • SQL keywords and literal values
  • Table constraints and data integrity
  • System catalogs and metadata
  • PostgreSQL session information functions
  • Session information functions
  • PostgreSQL system information
  • Database server networking basics
  • SQL expression syntax
  • Type conversion
  • Date/time types
  • Date/time functions and operators
  • Aggregate functions
  • Text pattern handling in SQL
  • Comparison operators
  • Bulk data import and export in PostgreSQL
  • Data loading
  • PostgreSQL sequences
  • Database sequences and transactions
  • Column defaults in table definitions
  • UUID generation in PostgreSQL
  • String literals and quoting
  • Query syntax
  • PostgreSQL interactive terminal basics
  • System administration functions
  • Conditional expressions
  • Date and time conversion functions
  • PostgreSQL runtime configuration settings
  • Arrays
  • Subqueries in the FROM clause
  • Identifiers and key words
  • Date/time functions and server utilities
  • Mathematical functions
  • String constants and literals
  • Indexes and query planning