PostgreSQL 9 Development
The 3 day class covers important Basic and Intermediate level details for developers interacting with PostgreSQL. Suitable for developers using Java, PHP, Python, perl, .Net and other client languages.
Targets- Software development
- Database Administration
- Systems architecture
- Database development
Topics
- Basic Development
- psql and scripting
- Statement behaviour
- Transaction Management & MVCC
- Transaction Isolation and Visibility
- Data loading
- Client/Server topics
- Interface details (jdbc, DBI, .Net etc)
- User defined functions and procedural languages
- PL/pgSQL
- Triggers
- Extensions
- PostgreSQL extended features
- Using XML
- Aggregates and Set Returning Functions
- Window Functions
- More Functions
- Recursive Queries
- Testing with pgTAP
Requirements
- Basics of programming
- Basics of systems administration
- Basics of PostgreSQL database administration
- PostgreSQL basics
- SQL basics
Course acquired skills
- Basics of PostgreSQL development
- Basics of applications design with PostgreSQL
- Basics of PL/pgSQL
- Techniques of software development with PostgreSQL (debugging, error management, etc.)
