Muutke küpsiste eelistusi

E-raamat: PostgreSQL 8 for Windows

3.40/5 (10 hinnangut Goodreads-ist)
  • Formaat: 400 pages
  • Ilmumisaeg: 03-Apr-2007
  • Kirjastus: Osborne/McGraw-Hill
  • Keel: eng
  • ISBN-13: 9780071509497
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 51,48 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
PostgreSQL 8 for WindowsSuurem pilt
  • Formaat: 400 pages
  • Ilmumisaeg: 03-Apr-2007
  • Kirjastus: Osborne/McGraw-Hill
  • Keel: eng
  • ISBN-13: 9780071509497
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

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
Acknowledgments xi
Introduction xiii
Part I Installation and Administration
What Is PostgreSQL?
3(22)
The Open Source Movement
4(1)
The History of PostgreSQL
5(3)
Comparing PostgreSQL
8(5)
PostgreSQL Versus Microsoft Access
8(4)
PostgreSQL Versus Commercial DBMS Products
12(1)
PostgreSQL Features
13(11)
Transaction Support
13(1)
ACID Compliant
14(4)
Nested Transactions
18(1)
Sub-selects
18(1)
Views
18(2)
Rules
20(1)
Triggers
20(1)
Support for Binary Large Objects (BLOBs)
20(1)
User-Defined Types
21(1)
Roles
21(1)
Table Partitioning
22(2)
Generalized Search Tree (GiST)
24(1)
Summary
24(1)
Installing PostgreSQL on Windows
25(24)
System Requirements
26(7)
Windows Workstations
26(3)
Windows Servers
29(4)
Downloading PostgreSQL
33(2)
Installing PostgreSQL
35(11)
Installation Options Window
36(3)
Service Configuration Window
39(1)
Initialise Database Cluster Window
40(2)
Enable Procedural Languages Window
42(1)
Enable Contrib Modules Window
43(1)
Finish the Install
44(2)
Running PostgreSQL
46(2)
Service Method
46(1)
Manual Method
47(1)
Summary
48(1)
The PostgreSQL Files and Programs
49(32)
The PostgreSQL Directory
50(1)
Database Cluster Directory
50(3)
Configuration Files
53(22)
The postgresql.conf File
54(16)
The pg_hba.conf File
70(4)
The pg_ident.conf File
74(1)
Programs
75(5)
PostgreSQL Server Commands
75(3)
SQL Wrapper Commands
78(1)
PostgreSQL Applications
79(1)
Summary
80(1)
Managing PostgreSQL on Windows
81(40)
The pgAdmin III Program
82(1)
Parts of the PostgreSQL System
83(6)
Tablespaces
85(1)
Databases
86(2)
Group Roles
88(1)
Login Roles
89(1)
Creating a New Application
89(15)
Creating a New Database
89(2)
Creating a New Schema
91(3)
Creating the Tables
94(7)
Entering and Viewing Data
101(3)
The pgAdmin III Query Tool
104(1)
Working with User Accounts
105(7)
Creating Group Roles
106(3)
Creating Login Roles
109(2)
Testing Privileges
111(1)
Database Maintenance
112(2)
Backups and Restores
114(3)
Performing a Backup
115(1)
Restoring a Database
116(1)
Summary
117(4)
Part II Using PostgreSQL in Windows
The psql Program
121(20)
The psql Command-Line Format
122(5)
Connection Options
122(1)
Feature Options
123(3)
Using the Command-Line Options
126(1)
The psql Meta-commands
127(11)
psql General Meta-commands
128(3)
Query Buffer Meta-commands
131(1)
Input/Output Meta-commands
132(1)
Informational Meta-commands
133(2)
Formatting Meta-commands
135(1)
Copy and Large Object Meta-commands
136(2)
The psqlrc.conf File
138(1)
Importing Data with psql
139(1)
Summary
140(1)
Using Basic SQL
141(28)
The SQL Query Language
142(4)
SQL History
142(1)
SQL Format
142(4)
Creating Objects
146(12)
Creating a Database
146(2)
Creating a Schema
148(1)
Creating a Table
149(5)
Creating Group and Login Roles
154(1)
Assigning Privileges
155(3)
Handling Data
158(4)
Inserting Data
158(1)
Modifying Data
159(2)
Deleting Data
161(1)
Querying Data
162(5)
The Basic Query Format
162(2)
Writing Advanced Queries
164(3)
Summary
167(2)
Using Advanced SQL
169(26)
Revisiting the Select Command
170(7)
The Distinct Clause
171(1)
The Select List
171(1)
The From Clause
172(2)
The Where Clause
174(1)
The Group by Clause
174(1)
The Having Clause
175(1)
The Set Operation Clauses
175(1)
The Order by Clause
176(1)
The Limit Clause
176(1)
The for Clause
177(1)
Table Views
177(2)
Table Indexes
179(6)
Why Use Indexes?
180(1)
Creating an Index
180(3)
Determining the Index Method
183(2)
Transactions
185(4)
Basic Transactions
186(1)
Advanced Transactions
187(2)
Cursors
189(5)
Creating a Cursor
189(1)
Using a Cursor
190(4)
Summary
194(1)
PostgreSQL Functions
195(20)
What Is a Function?
196(10)
Operators
196(9)
Built-in Functions
205(1)
String Functions
206(3)
Date and Time Functions
209(2)
Math Functions
211(1)
Aggregate Functions
211(3)
Summary
214(1)
Stored Procedures and Triggers
215(20)
PostgreSQL Procedural Languages
216(1)
Types of Functions
217(1)
The PL/pgSQL Language
217(10)
Creating a PL/pgSQL Function
218(4)
Creating a Stored Procedure Using pgAdmin III
222(3)
PL/pgSQL Function Code
225(2)
Triggers
227(5)
Trigger Function Format
228(1)
Creating a Trigger Function
229(3)
Testing the Trigger Function
232(1)
Summary
232(3)
Security
235(16)
Controlling Network Users
236(6)
Controlling Access via Firewalls
236(3)
Controlling Access via Configuration Files
239(2)
Testing Remote Connectivity
241(1)
Encrypting Network Sessions
242(7)
Enabling SSL in PostgreSQL
244(1)
Encryption Keys and Certificates
244(1)
Creating an SSL Encryption Key
245(3)
Testing SSL Encryption
248(1)
Monitoring Users
249(1)
Summary
250(1)
Performance
251(14)
Enhancing Query Performance
252(5)
The Explain Command
252(3)
Using pgAdmin III to Evaluate Queries
255(2)
The postgresql.conf Performance Parameters
257(4)
Query Tuning
257(2)
Resource Usage
259(1)
Runtime Statistics
260(1)
Summary
261(4)
Part III Windows Programming with PostgreSQL
Microsoft Access and PostgreSQL
265(22)
Interfacing PostgreSQL with Access
266(9)
Installing the ODBC Driver
266(3)
Configuring a PostgreSQL ODBC Connection
269(6)
Creating an Access Application Using PostgreSQL
275(9)
Data Type Considerations
275(1)
Designing an Application Database
276(1)
Setting Up the ODBC Session
277(1)
Creating the Access Application
278(4)
Using PostgreSQL Views in Access
282(2)
Sharing the Application
284(1)
Exporting an Access Application to PostgreSQL
284(2)
Summary
286(1)
Microsoft.NET Framework
287(26)
The Microsoft .NET Framework
288(1)
Creating a .NET Development Environment
289(3)
Downloading the .NET Packages
290(1)
Installing the .NET Packages
290(2)
Integrating the Npgsql Library
292(3)
Downloading Npgsql
293(1)
Installing the Npgsql Library
294(1)
Creating .NET Applications with Npgsql
294(1)
The Npgsql Library
295(16)
The NpgsqlConnection Class
296(4)
The NpgsqlCommand Class
300(9)
The NpgsqlParameterCollection Class
309(2)
Summary
311(2)
Visual C++
313(30)
The Visual C++ Programming Environment
314(8)
Visual C++ Express Edition
314(1)
Downloading and Installing Visual C++ Express Edition
315(4)
Installing the Microsoft Platform SDK
319(3)
The libpq Library
322(3)
The libpq Functions
325(17)
Opening and Closing Sessions
325(5)
Executing SQL Commands
330(8)
Using Parameters
338(4)
Summary
342(1)
Java
343(24)
The Java Development Environment
344(6)
Downloading the Java SDK
345(1)
Installing the Java SDK
346(2)
Building a Java Program Using NetBeans
348(2)
PostgreSQL JDBC Driver
350(4)
Using JDBC in a NetBeans Application
352(1)
Using JDBC in a Java Command-Line Application
353(1)
Java Database Connectivity
354(11)
Starting a Connection
354(2)
Sending SQL Commands
356(6)
Using Parameters and Prepared Statements
362(3)
Summary
365(2)
Index 367


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.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97800715094972e.html
Märksõnad: