- Database Design
-
- ERD
-
- Types of relationships
-
- Normalization
-
- SQL
-
- reading ( DQL )
-
-
- projecting ( select )
-
-
-
- filtering ( where, distinct )
-
-
-
- top clause ( limit )
-
-
-
- sorting ( order by )
-
-
-
- aggregation clause ( group by )
-
-
-
- aggregation functions ( group by )
-
-
-
- window functions
-
-
-
- pivoting
-
-
-
- renaming
-
-
-
- string functions and formatting
-
-
-
- time, date and formatting
-
-
-
- array, sets and formatting
-
-
-
- case
-
-
-
- set operations
-
-
-
- cartesian product
-
-
-
- joining ( join )
-
-
-
-
- taxonomy of joins
-
-
-
-
- subquery
-
-
-
-
- anonimous subquery
-
-
-
-
-
- named subquery ( CTE )
-
-
-
-
-
- recursive subquery ( hierarchical CTE )
-
-
-
- defining ( DDL )
-
-
- data types
-
-
-
- create
-
-
-
- alter
-
-
-
- drop
-
-
-
- constrains
-
-
-
- views
-
-
-
- materialzid views
-
-
-
- prepare statement
-
-
-
- stored column ~ generated column
-
-
-
- synonym
-
-
-
- truncate
-
-
-
- enum
-
-
-
- sequence
-
-
-
- index
-
-
-
-
- btree
-
-
-
-
-
- hash
-
-
-
-
-
- bloom filter
-
-
-
-
-
- GIN
-
-
-
-
-
- GiST
-
-
-
-
-
- SP-GiST
-
-
-
-
-
- BRIN
-
-
-
- manipulation ( DML )
-
-
- add, insert
-
-
-
- update
-
-
-
- delete
-
-
- access control ( DCL )
-
- transaction ( TCL )
-
- performance tuning
-
-
- explain
-
-
-
- table statistics
-
-
-
- table partitioning
-
-
-
- profiling and tracing
-
-
- programming
-
-
- user defined functions
-
-
-
- stored procedures
-
-
-
- trigger
-
-
-
- PL/SQL
-
-
-
-
- collections types
-
-
-
-
-
- cursor
-
-
-
-
-
- packages
-
-
-
-
-
- control statements
-
-
-