PostgreSQL

The Open Source PostgreSQL database is an object-relational database management system that uses the relational model and supports the SQL standard query language. It is free, platform independent, has developers from all over the world, and is suitable for high-volume work. PostgreSQL includes almost all the features you can find in other commercial or open source databases, and even more. The purpose of writing this book is to make the PostgreSQL database more widely known. CONTENTS INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS RELATIONAL DATABASE DESIGN RELATIONAL DATA MODEL (NORMALIZATION RULES) POSTGRESQL DATA TYPES POSTGRESQL DATABASE OBJECTS INTRODUCTION TO SQL WITH POSTGRESQL BASIC SQL COMMANDS GROUPING AND WORKING ON GROUP DATA DML (DATA MANIPULATION LANGUAGE) CONNECTING MULTIPLE TABLES TOGETHER (JOIN) COMBINING QUERIES (WORKING WITH SUBQUERIES) ADVANCED LEVEL SQL (PL-PgSQL) CONTROL STRUCTURES AND LOOPS IN PL/PGSQL VIEW OBJECTS POSTGRESQL STORED PROCEDURES