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