< Beyond Java />
DURATION: 0.5 Days
PostgreSQL is one of the few open source databases that are well-accepted in corporate environments. It is prized for its stability and performance. However, most developers only use its basic features, not realizing its many features available for improving performance and reducing the complexity of applications.
This course allows the developer to maximize usage of the PostgreSQL database, as well as avoid common pitfalls. This training course was developed and is taught by some of the Philippines’ well-known and respected web developers, and uses the format trusted by some of the best companies in the Philippines.
Developers looking to understand and maximize the features of the PostgreSQL database, as well as avoid common pitfalls.
- Using psql
- Using pgAdmin
- Creating & Restoring Databases
- Analyzing Performance of SQL Statements
- Basic Datatypes, Operators & Functions
- Range Types
- Enumerated Types
- Geometric Types
- Text Search
- Reclaiming Storage
- Gathering Statistics