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...

ver descrição completa

Na minha lista:
Detalhes bibliográficos
Autor principal: Momjian, Bruce
Formato: Livro
Idioma:English
Publicado em: Addison.Wesley 2011
Assuntos:
Acesso em linha:https://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/29522
Tags: Adicionar Tag
Sem tags, seja o primeiro a adicionar uma tag!
Thư viện lưu trữ: Thư viện Trường Đại học Đà Lạt
Descrição
Resumo: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.