PostgreSQL 8 for Windows (Database Professional's Library) (DATABASE & ERP - OMG) - Softcover

Blum, Richard

Softcover

ISBN 10: 0071485627 ISBN 13: 9780071485623

Publisher: McGraw-Hill Osborne Media, 2007

Synopsis

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

The easiest way to set up a PostgreSQL database server on Windows

Get up-and-running on PostgreSQL quickly using this hands-on guide. Filled with real-world examples, PostgreSQL 8 for Windows offers you practical, step-by-step details on installing, configuring, and using PostgreSQL 8--the full-featured, open-source database management system--on Windows platforms. You'll learn to administer, secure, and tune your database and use SQL. You'll also discover how to interface Microsoft Access, Microsoft .NET, Visual C++, and Java with the PostgreSQL database.

• Install and configure PostgreSQL 8 on Windows
  
• Customize your system using the configuration files
• Work with the utilities
• Administer your database from the pgAdmin III graphical interface
• Use the psql command line program to manually execute SQL commands
• Take advantage of built-in functions or create your own stored procedures and triggers
• Implement tested security measures
• Maintain optimal database performance
• Access a PostgreSQL database from a Microsoft Access application and migrate Access databases to PostgreSQL
• Create .NET, Visual C++, and Java applications that interface with your PostgreSQL server

About this title

About the Author

Richard Blum has worked for more than 18 years in the IT field as a network and systems administrator. During this time he has worked with database servers in UNIX, Linux, Novell, and Microsoft servers.

From the Back Cover

The easiest way to set up a PostgreSQL database server on Windows

Get up-and-running on PostgreSQL quickly using this hands-on guide. Filled
with real-world examples, PostgreSQL 8 for Windows offers you practical,
step-by-step details on installing, configuring, and using PostgreSQL
8--the full-featured, open-source database management system--on Windows
platforms. You'll learn to administer, secure, and tune your database and
use SQL. You'll also discover how to interface Microsoft Access, Microsoft
.NET, Visual C++, and Java with the PostgreSQL database.

Install and configure PostgreSQL 8 on Windows
Customize your system using the configuration files
Work with the utilities
Administer your database from the pgAdmin III graphical interface
Use the psql command line program to manually execute SQL commands
Take advantage of built-in functions or create your own stored procedures
and triggers
Implement tested security measures
Maintain optimal database performance
Access a PostgreSQL database from a Microsoft Access application and
migrate Access databases to PostgreSQL
Create .NET, Visual C++, and Java applications that interface with your
PostgreSQL server

Edition details

• Publisher: McGraw-Hill Osborne Media
• Publication date: 2007
• Language: English
• ISBN 10: 0071485627
• ISBN 13: 9780071485623
• Binding: Paperback
• Number of pages: 400