book: PostgreSQL 8 for Windows (Database Professional's Library)

book: PostgreSQL 8 for Windows (Database Professional's Library) | Richard Blum ...

books:


	• PostgreSQL 8 for Windows (Database Professional's Library) Richard Blum McGraw-Hill Osborne Media, 2007 - 400 pages average customer review:based on 1 review view larger image
	for more information click here

A good overview

I was interested in learning a bit about PostgreSQL, and coming from a SQL Server background on Windows systems, this seemed like a good place to start (I will pick up some more Linux knowledge another day). The book provides a good overview of components and processes, and for someone with experience in other database platforms, the material makes a good bridge.

It will probably not provide much new information to a PostgreSQL "expert", but that is not likely the intended audience. Basic admin topics are covered , as well as some development examples in MS Access, .NET, C++, and Java.

A highlight for me was the discovery of some SQL methods in PostgreSQL that were only supported in the latest release of MS SQL Server, and a few that still are not.

for more information click here

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 utilitiesAdminister your database from the pgAdmin III graphical interface Use the psql command line program to manually execute SQL commandsTake advantage of built-in functions or create your own stored procedures and triggers Implement tested security measuresMaintain optimal database performanceAccess a PostgreSQL database from a Microsoft Access application and migrate Access databases to PostgreSQLCreate .NET, Visual C++, and Java applications that interface with your PostgreSQL server

for more information click here