PostgreSQL: Introduction and Concepts

The open source PostgreSQL database is soaring in popularity, as thousands of database and web professionals discover its powerful features, transaction support, performance, and industrial-strength scalability. In this book, a founding member of the PostgreSQL development team introduces everything...

Descripció completa

Guardat en:
Dades bibliogràfiques
Autor principal: Momjian, Bruce
Format: Llibre
Idioma:English
Publicat: Addison.Wesley 2011
Matèries:
Accés en línia:https://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/29522
Etiquetes: Afegir etiqueta
Sense etiquetes, Sigues el primer a etiquetar aquest registre!
Thư viện lưu trữ: Thư viện Trường Đại học Đà Lạt
Descripció
Sumari:The open source PostgreSQL database is soaring in popularity, as thousands of database and web professionals discover its powerful features, transaction support, performance, and industrial-strength scalability. In this book, a founding member of the PostgreSQL development team introduces everything you need to know to succeed with PostgreSQL, from basic SQL commands through database administration and optimization. PostgreSQL assumes no previous database expertise: it establishes a firm foundation of basic concepts and commands before turning to PostgreSQL's advanced, innovative capabilities. Bruce Momjian walks readers step-by-step from their first database queries through the complex queries needed to solve real-world problems. He presents proper query syntax, then explores the value and use of each key SQL commands in working applications. Learn to manipulate and update databases, customize queries, work with SQL aggregates, use joins, combine SELECTs with subqueries, work with triggers and transactions, import and export data, use PostgreSQL query tools, and more. Discover PostgreSQL techniques for server-side programming and multi-user control, and master PostgreSQL's interfaces to C, C++, ODBC, JDBC, Perl, and Tcl/TK. You'll also find detailed coverage of PostgreSQL administration, including backups, troubleshooting, and access configuration.