Concepts of PostgreSQL

&#10004Using the Psql client
✔Basic Knowledge about DATABASE
✔DDL, DML, DCL and TCL commands
✔Joins
✔Operators
✔Understanding PostgreSQL data types
✔Numeric data types
✔Integer data types
✔Floating point types
✔Serial types
✔Character types
✔Binary data types
✔Date & time values
✔Boolean values
✔Array types
✔Other data types
✔Understanding sequences
✔Creating & managing indexes
✔Understanding PostgreSQL indexes
✔Partial indexes
✔Indexes on expressions
✔Using COPY to load data
✔Working with Array Values
✔Advanced SQL Functions
✔Using Common Table Expressions (CTE)
✔Views
✔Writing triggers & stored procedures with PL/Psql
✔Variables in procedures
✔Performing loop operations
✔The PERFORM and EXECUTE statements
✔Triggers in PostgreSQL
✔Using the PostgreSQL query optimizer
✔Analyzing & optimizing queries
✔Viewing execution plans with EXPLAIN
✔Understanding PostgreSQL query operators
✔Improving query performance
✔User Defined Functions
✔