Richard Blum has worked in the IT industry for more than 22 years as both a systems and network administrator.

Meer over Richard Blum

Richard Blum

PostgreSQL 8 For Windows

Name: PostgreSQL 8 For Windows
Author: Richard Blum

Specificaties

Paperback, 384 blz. | Engels

McGraw-Hill Computing | 1e druk, 2007

ISBN13: 9780071485623

Rubricering

Hoofdrubriek : Computer en informatica

McGraw-Hill Computing 1e druk, 2007 9780071485623

77,10

In winkelwagen

Verwachte levertijd ongeveer 11 werkdagen

Samenvatting

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

Specificaties

ISBN13:9780071485623

Taal:Engels

Bindwijze:paperback

Aantal pagina's:384

Uitgever:McGraw-Hill Computing

Druk:1

Hoofdrubriek:IT-management / ICT

Over Richard Blum

Richard Blum has worked in the IT industry for more than 22 years as both a systems and network administrator. He has administered UNIX, Linux, Novell, and Microsoft servers, as well as automated network monitoring with Linux shell scripts and written scripts in most of the common Linux shell environments. Richard is the author of several books, including 'Professional Linux Programming' (Wrox).

Andere boeken door Richard Blum

Bekijk alle boeken

Inhoudsopgave

Acknowledgments
Introduction

Part 1: Installation and Administration
1. Why PostgreSQL?
2. Installing PostgreSQL on Windows
3. The PostgreSQL Files and Programs
4. Managing PostgreSQL on Windows

Part 2: Using PostgreSQL in Windows
5. The psql Program
6. Using Basic SQL
7. Using Advanced SQL
8. PostgreSQL Functions
9. Stored Procedures and Triggers
10. Security
11. Performance

Part 3: Windows Programming with PostgreSQL
12. Microsoft Access and PostgreSQL
13. Microsoft .NET Framework
14. Visual C++
15. Java

Index