By Korry Douglas
ISBN-10: 0672327562
ISBN-13: 9780672327568
The 2d version of the best-selling PostgreSQL has been up-to-date to totally hide new beneficial properties and features of the 8.0 model of PostgreSQL. you'll be lead during the internals of the strong PostgreSQL open resource database bankruptcy, providing an easy-to-read, code-based technique that makes it effortless to appreciate how every one characteristic is applied, how you can most sensible use each one characteristic, and the way to get extra functionality from database functions. This definitive consultant to development, programming and administering the strong PostgreSQL open-source database method can assist you harness the most ordinary open resource, enterprise-level database platforms.
Read Online or Download PostgreSQL, 2nd Edition PDF
Similar sql books
Read e-book online The Guru's Guide to Transact-SQL PDF
It is a coder's publication. it really is meant to aid builders construct functions that utilize Transact-SQL. it is not approximately database management or layout. it isn't approximately end-user or GUI program improvement. it is not even approximately server or database functionality tuning. it is approximately constructing the simplest Transact-SQL code attainable, whatever the software.
New PDF release: Pro SQL Server 2008 Analytics Delivering Sales And Marketing
Professional SQL Server 2008 Analytics presents every thing you must understand to boost refined and visually attractive revenues and advertising and marketing dashboards utilizing SQL Server 2008 and to combine these dashboards with SharePoint, PerformancePoint, and different key Microsoft applied sciences. The ebook starts through addressing the numerous misconceptions that encompass using key functionality signs (KPIs) and giving a short evaluate of the company intelligence (BI) and reporting instruments that may be mixed at the Microsoft platform that will help you generate the consequences that you just want.
[ this is often an excerpt from my weblog put up approximately this publication: [. .]
I am making plans to take the MCTS 70-433 Certification examination. If and whilst is that going to occur, i'm really not yes but. it's not that i am definite while yet i'm hoping it will likely be within the close to destiny. MCITP 70-451 is usually in my to-do checklist for the final area of this yr (or first zone of 2011) because of this it's relatively very important for me to nail this 70-433 examination the soonest I can.
I am now not utilizing the MCTS 70-433 Self-Paced education equipment in my instruction. in its place, i'm utilizing the genuine MCTS SQL Server 2008 examination 70-433 Prep equipment from Syngress. Judging from my confident event taking the 70-431 examination few months in the past, i will rather well say that the true MCTS 70-433 Prep equipment gets the activity performed. i admire the gains of this prep publication. i like the truth that the reply keys of the self attempt questions are stumbled on correct after the questions. a few of the different positive factors of the e-book i like are:
- record Of examination goals in each chapter
- "Configuring & enforcing" and "Head of the category" packing containers that spotlight very important notes approximately specific beneficial properties of SQL Server 2008
- examination Warnings that include info on a few gotchas which may be serious whilst taking the exam
- try out Day tips which spotlight necessary, good, tips on how to keep in mind of.
- step by step Exercises
- FAQ that enhances what you might have long gone over within the chapter
- and naturally the standard creation and precis in every one chapter.
The in basic terms issues that I omit from the MS Press Self-Paced education package are the perform examination CD and the tear-out learn advisor. yet these shouldn't be difficulties as i've got an entry to a improvement setting that i will be able to play with in practise for this examination; and that i created my very own custom-made 70-433 examine consultant (with highlights on every one targets and money containers) according to the Microsoft studying site . i've got made my custom-made examine consultant to be had for everyone. you could obtain it [from my blog]:[. .] or e-mail me at mribunal [at] gmail [dot] com
My genuine good fortune or failure finally will depend on how a lot attempt i'm keen to exert in learning for this examination and never purely on any books or research fabrics.
Defensive Database Programming with SQL Server by Alex Kuznetsov PDF
Resilient T-SQL code is code that's designed to final, and to be adequately reused by way of others. The target of protecting database programming, the aim of this publication, is that can assist you to provide resilient T-SQL code that robustly and gracefully handles instances of accidental use, and is resilient to universal adjustments to the database atmosphere.
- How to Become an Exceptional DBA
- Practical PHP and MySQL: Building Eight Dynamic Web Applications
- Informix Unleashed
- Introduction pratique aux bases de données relationnelles
Additional resources for PostgreSQL, 2nd Edition
Sample text
The underscore (_) character matches any single character. The percent sign (%) matches any sequence of zero or more characters. 9 shows a few examples. 9. info ---------+-------+---------(0 rows) If you want to perform case-insensitive pattern matching, use the ILIKE operator: movies=# SELECT * FROM tapes WHERE title ILIKE '%citizen%'; tape_id | title | duration ----------+----------------------+---------OW-41221 | Citizen Kane | KJ-03335 | American Citizen, An | (2 rows) You can, of course, combine LIKE and ILIKE with the NOT operator to return rows that do not match a pattern: movies=# SELECT * FROM tapes WHERE title NOT ILIKE '%citizen%'; tape_id | title | duration ----------+---------------+-------------AB-12345 | The Godfather | AB-67472 | The Godfather | MC-68873 | Casablanca | AH-54706 | Rear Window | OW-42200 | Sly | 01:36 OW-42201 | Stone | 4 days 01:36 (6 rows) Pattern Matching with Regular Expressions The LIKE and ILIKE operators are easy to use, but they aren't very powerful.
PostgreSQL continues searching through the WHEN clauses until it finds a match. If none of the values match expression 1, the expression evaluates to the value specified in the ELSE clause. If PostgreSQL gets all the way to the end of the list and you haven't specified an ELSE clause, the CASE expression evaluates to NULL. Note that result1, result2, … resultn must all have the same data type. You can see that NULLIF( balance, 0 ) is equivalent to CASE balance WHEN 0 THEN NULL ELSE balance END The second, more flexible form of the CASE expression is called the searched form: CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ...
Next, PostgreSQL could throw out all the rows that fail to satisfy the WHERE clause. In practice, this would be a poor strategy: Cross-joins can get very large quickly. Instead, the PostgreSQL query optimizer analyzes the query and plans an execution strategy to minimize execution time. I'll cover query optimization in Chapter 4. info We've seen two join types so far: cross-joins and inner-joins. Now we'll look at outer-joins. An outer-join is similar to an inner-join: a relationship between two tables is established by correlating a column from each table.
PostgreSQL, 2nd Edition by Korry Douglas
by Paul
4.1