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
Les mer
Offers you information on installing, configuring, and using PostgreSQL 8, the popular open-source database management system, on Windows platforms. This book helps you learn how to interface common Windows development platforms, such as Microsoft Access, Microsoft .NET, and Java, with the PostgreSQL database.
Les mer
AcknowledgmentsIntroductionPart I. Installation and AdministrationChapter 1. Why PostgreSQL?Chapter 2. Installing PostgreSQL on WindowsChapter 3. The PostgreSQL Files and ProgramsChapter 4. Managing PostgreSQL on WindowsPart II. Using PostgreSQL in WindowsChapter 5. The psql ProgramChapter 6. Using Basic SQLChapter 7. Using Advanced SQLChapter 8. PostgreSQL FunctionsChapter 9. Stored Procedures and TriggersChapter 10. SecurityChapter 11: PerformancePart III. Windows Programming with PostgreSQLChapter 12. Microsoft Access and PostgreSQLChapter 13. Microsoft .NET FrameworkChapter 14. Visual C++Chapter 14. JavaINDEX
Les mer

Produktdetaljer

ISBN
9780071485623
Publisert
2007-05-16
Utgiver
McGraw-Hill Education - Europe
Vekt
690 gr
Høyde
226 mm
Bredde
185 mm
Dybde
21 mm
Aldersnivå
P, 06
Språk
Product language
Engelsk
Format
Product format
Heftet
Antall sider
400

Forfatter

Biografisk notat

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.