-
PostgreSQL Syllabus
- Using 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 and Other data types
- Understanding sequences
- Creating & managing indexes
- Understanding PostgreSQL indexes – Partial indexes and Indexes on expressions
- Using COPY to load data
- Working with Array Values
- Advanced SQL Functions – Using Common Table Expressions (CTE) and Views
- Writing triggers & stored procedures with PL/Psql – Variables in procedures, Performing loop operations, The PERFORM and EXECUTE statements and Triggers in PostgreSQL
- Using the PostgreSQL query optimizer – Analyzing & optimizing queries, Viewing execution plans with EXPLAIN and Understanding PostgreSQL query operators
- Improving query performance
- User Defined Functions
-
No items in this section
This content is protected, please login and enroll course to view this content!