

Richard Blum has worked in the IT industry for more than 22 years as both a systems and network administrator.
Meer over Richard BlumPostgreSQL 8 For Windows
Paperback Engels 2007 9780071485623Samenvatting
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
Lezersrecensies
Inhoudsopgave
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
Rubrieken
- Advisering
- Algemeen management
- Coaching en trainen
- Communicatie en media
- Economie
- Financieel management
- Inkoop en logistiek
- Internet en social media
- IT-management / ICT
- Juridisch
- Leiderschap
- Marketing
- Mens en maatschappij
- Non-profit
- Ondernemen
- Organisatiekunde
- Personal finance
- Personeelsmanagement
- Persoonlijke effectiviteit
- Projectmanagement
- Psychologie
- Reclame en verkoop
- Strategisch management
- Verandermanagement
- Werk en loopbaan