In weniger als einer Minute können Sie mit dem Lesen von Beginning Databases with PostgreSQL auf Ihrem Kindle beginnen. Sie haben noch keinen Kindle? Hier kaufen Oder fangen Sie mit einer unserer gratis Kindle Lese-Apps sofort an zu lesen.

An Ihren Kindle oder ein anderes Gerät senden

 
 
 

Kostenlos testen

Jetzt kostenlos reinlesen

An Ihren Kindle oder ein anderes Gerät senden

Jeder kann Kindle Bücher lesen  selbst ohne ein Kindle-Gerät  mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.
Beginning Databases with PostgreSQL: From Novice to Professional
 
 

Beginning Databases with PostgreSQL: From Novice to Professional [Kindle Edition]

Richard Stones , Neil Matthew
5.0 von 5 Sternen  Alle Rezensionen anzeigen (2 Kundenrezensionen)

Kindle-Preis: EUR 19,19 Inkl. MwSt. und kostenloser drahtloser Lieferung über Amazon Whispernet

Weitere Ausgaben

Amazon-Preis Neu ab Gebraucht ab
Kindle Edition EUR 19,19  
Taschenbuch EUR 32,70  

Kunden, die diesen Artikel angesehen haben, haben auch angesehen


Produktbeschreibungen

Kurzbeschreibung

PostgreSQL is arguably the most powerful open-source relational database system. It has grown from academic research beginnings into a functionally-rich, standards-compliant, and enterprise-ready database used by organizations all over the world. And it’s completely free to use.



Beginning Databases with PostgreSQL offers readers a thorough overview of database basics, starting with an explanation of why you might need to use a database, and following with a summary of what different database types have to offer when compared to alternatives like spreadsheets. You’ll also learn all about relational database design topics such as the SQL query language, and introduce core principles including normalization and referential integrity.



The book continues with a complete tutorial on PostgreSQL features and functions and include information on database construction and administration. Key features such as transactions, stored procedures and triggers are covered, along with many of the capabilities new to version 8. To help you get started quickly, step-by-step instructions on installing PostgreSQL on Windows and Linux/UNIX systems are included.



In the remainder of the book, we show you how to make the most of PostgreSQL features in your own applications using a wide range of programming languages, including C, Perl, PHP, Java and C#. Many example programs are presented in the book, and all are available for download from the Apress web site.



By the end of the book you will be able to install, use, and effectively manage a PostgreSQL server, design and implement a database, and create and deploy your own database applications.

Synopsis

PostgreSQL is arguably the most powerful open-source relational database system. It has grown from academic research beginnings into a functionally-rich, standards-compliant, and enterprise-ready database used by organizations all over the world. And it's completely free to use. Beginning Databases with PostgreSQL offers readers a thorough overview of database basics, starting with an explanation of why you might need to use a database, and following with a summary of what different database types have to offer when compared to alternatives like spreadsheets. You'll also learn all about relational database design topics such as the SQL query language, and introduce core principles including normalization and referential integrity. The book continues with a complete tutorial on PostgreSQL features and functions and include information on database construction and administration. Key features such as transactions, stored procedures and triggers are covered, along with many of the capabilities new to version 8. To help you get started quickly, step-by-step instructions on installing PostgreSQL on Windows and Linux/UNIX systems are included.In the remainder of the book we show you how to make the most of PostgreSQL features in your own applications using a wide range of programming languages, including C, Perl, PHP, Java and C#.

Many example programs are presented in the book, and all are available for download from the Apress web site. By the end of the book you will be able to install, use, and effectively manage a PostgreSQL server, design and implement a database, and create and deploy your own database applications.


Produktinformation

  • Format: Kindle Edition
  • Dateigröße: 6480 KB
  • Seitenzahl der Print-Ausgabe: 664 Seiten
  • Verlag: Apress; Auflage: 2nd (6. April 2005)
  • Verkauf durch: Amazon Media EU S.à r.l.
  • Sprache: Englisch
  • ASIN: B001DA77JI
  • Text-to-Speech (Vorlesemodus): Aktiviert
  • X-Ray:
  • Durchschnittliche Kundenbewertung: 5.0 von 5 Sternen  Alle Rezensionen anzeigen (2 Kundenrezensionen)
  • Amazon Bestseller-Rang: #248.992 Bezahlt in Kindle-Shop (Siehe Top 100 Bezahlt in Kindle-Shop)

  •  Ist der Verkauf dieses Produkts für Sie nicht akzeptabel?

Mehr über den Autor

Entdecken Sie Bücher, lesen Sie über Autoren und mehr

Kundenrezensionen

4 Sterne
0
3 Sterne
0
2 Sterne
0
1 Sterne
0
5.0 von 5 Sternen
5.0 von 5 Sternen
Die hilfreichsten Kundenrezensionen
5.0 von 5 Sternen Happy 18. April 2014
Format:Taschenbuch|Verifizierter Kauf
Happy with purchase and product overall. Fast and quality delivery. I would recommend and definitely I will buy again from amazon.de.
War diese Rezension für Sie hilfreich?
5.0 von 5 Sternen Useful book for basic undestanding of postgres 3. Januar 2014
Format:Kindle Edition|Verifizierter Kauf
The book includes all needed aspects of postgres that help to understand how to build a database and write good queries. Basic introduction to query performance is also given, but without going too deeply (there are enough books on that too). Must-read for beginners who want to quickly get into postgres
War diese Rezension für Sie hilfreich?
Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)
Amazon.com: 4.7 von 5 Sternen  23 Rezensionen
26 von 26 Kunden fanden die folgende Rezension hilfreich
4.0 von 5 Sternen Useful, but has limitations 6. März 2007
Von One more opinion - Veröffentlicht auf Amazon.com
Format:Taschenbuch
This book would be better labeled "Beginning Databases with Postgresql - From Novice to Amateur with a few Provisos."

This book is good for getting you to the stage where you have some basic confidence in using PostgreSQL (an excellent database). Do NOT expect to be able to learn what it is you are learning Postgres for without a great deal of googling, hanging out on the #postgresql irc channel (hint: type ?? and topic, VERY useful), searching the mailing list archives, reading the online documentation (which is very useful), and of course, liberal use of \? and \h in psql.

After you have some basic familiarity with Postgres you will still use Matthew and Stones from time to time, looking up syntax etc. For that it is useful.

One of the most annoying things is that it promotes bad database design through the "bpsimple" and "bpfinal" sample databases. Anyone using such a database would be constantly having to clean out garbage data in their database. Take for example their customer table. Their only unique constraint is the primary key, customer_id. If they don't have either a multiple column primary key or some other unique constraint, they will constantly be getting duplicate customers.

At least when I was learning MS Access the books I used taught me good principles such that I am not having to deal with duplicate values years later.

Unfortunately due to the dearth of Postgresql books this is still one of the better offerings. I would give it 3 stars if there was more competition.
36 von 39 Kunden fanden die folgende Rezension hilfreich
4.0 von 5 Sternen learn general SQL 25. April 2005
Von W Boudville - Veröffentlicht auf Amazon.com
Format:Taschenbuch
The book serves two audiences. One is those seeking to learn SQL. The other is those wanting to learn Postgresql. Naturally there is some overlap. But consider the first group. There are indeed several good texts on the theory of relational databases and using SQL to access and change these tables. But the books often deal at an abstract level that does not use a specific SQL implementation. Which makes it very hard to learn SQL. As a practical matter, you need to commit to an implementation, even just as a pedagogic decision. Well, as the authors explain, Postgresql is a good choice. It conforms broadly to SQL92 and is free open source. (The only other major free alternative being MySQL.) After all, you typically can't get onto a free copy of Oracle 10g or IBM's dB2 to learn from.

So just from this standpoint, the book gives you a solid learning experience with SQL. Eminently transportable to a job involving a proprietary SQL, like those mentioned above. Of course, those have unique tweaks. But the methods described here are universal to the field.

Now what if you want to actually learn Postgresql? There are chapters on using it from the command line and so on. The book also devotes a chapter each to getting at Postgresql from C, PHP, Perl, Java and C#. Typically, you are unlikely to need all of these chapters. But it shows the flexibility of the database.
14 von 15 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Great overview of database theory and PostgreSQL use 25. Juni 2005
Von Harold McFarland - Veröffentlicht auf Amazon.com
Format:Taschenbuch
Despite the fact that many books claim to be for everyone from the beginner to the professional this book is one of the few that actually hits the mark. Not content to just dive right into PostgreSQL and how to us it, the authors include a lot of database history and theory that is sadly lacking from similar books. But it is not just for beginners. The authors include more advances sections on things like accessing the database using C, PHP, Perl, Java, and C#.

Between this beginning user and advanced user level the authors fill in all the intermediate parts so the book ends up providing a well-organized education from the principles of database design through database setup, query, ODBC access setup, and using a programming or scripting language to accessing and updating the database. The book also includes detailed information on selection procedures, data manipulation, functions, stored procedures, triggers, and PostgreSQL Administration. As a result you end up with a book where the database theory applies to all relational databases and as it becomes more technical in nature it moves from there to information specific to PostgreSQL for the advanced user, administrator, or programmer. Beginning Databases with PostgreSQL, Second Edition is highly recommended to anyone interested in using this particular SQL engine.
10 von 10 Kunden fanden die folgende Rezension hilfreich
3.0 von 5 Sternen Average for Apress 16. April 2010
Von HugeStakkaBoFan - Veröffentlicht auf Amazon.com
Format:Taschenbuch|Verifizierter Kauf
This isn't really a bad book, but given the clarity with which PostgreSQL's official (and free) documentation is written, a lot of it also isn't necessary. Sure, it's really thick, but a lot of those pages are dedicated to really ugly screenshots and Windows-specific silliness I'm willing to bet few members of this product's target audience are particularly interested in. There are also entire chapters dedicated to C# and Java APIs which should probably be separate books if they really wanted to do justice to such topics--their inclusion here just feels like pointless filler.

If you have absolutely no idea what SQL is and want to get your feet wet with Postgres, then this is absolutely the book for you. If you have a pretty good idea what you're doing and just want to pick up on some of Postgres' quirks, I'm not too sure you'll be getting your money's worth here. It just tries to cover way too much ground too quickly, and the information ends up getting stretched a little thin.
9 von 9 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Great book 16. Mai 2006
Von Guillaume Lelarge - Veröffentlicht auf Amazon.com
Format:Taschenbuch|Verifizierter Kauf
I ordered this book because amazon.com bundled it with « Beginning PHP and PostgreSQL 8 ». I must admit I was happily surprised. It's definitely more than a copy of the PostgreSQL manual. Explanations are simple to understand.

There's a chapter on database design, something really important to me.

Something that surprises me too is the big part on languages. The PostgreSQL manual focused on C with libpq and there's not much on other languages. This book brings a lot of informations with PHP, Perl, Java, C#.

This book also brings informations on new PostgreSQL 8 functionnalities (tablespace, $$ quoting). Unfortunately, there's nothing on release 8.1 (CREATE ROLE for example).

Finally, a great book to begin with, a reference for the rest of us.
Waren diese Rezensionen hilfreich?   Wir wollen von Ihnen hören.
Kundenrezensionen suchen
Nur in den Rezensionen zu diesem Produkt suchen

Beliebte Markierungen

 (Was ist das?)
&quote;
We can override defaults for the database name, username, server host name, and listening port by setting the environment variables PGDATABASE, PGUSER, PGHOST, and PGPORT, &quote;
Markiert von 4 Kindle-Nutzern
&quote;
A slightly different way to use LIMIT is in conjunction with the OFFSET clause, which specifies a starting position. &quote;
Markiert von 4 Kindle-Nutzern
&quote;
If you want to know how PostgreSQL will process a SQL statement, you can get it to tell you by prefixing the SQL with EXPLAIN. Rather than execute the statement, PostgreSQL will tell you how the statement would be processed. &quote;
Markiert von 4 Kindle-Nutzern

Kunden diskutieren

Das Forum zu diesem Produkt
Diskussion Antworten Jüngster Beitrag
Noch keine Diskussionen

Fragen stellen, Meinungen austauschen, Einblicke gewinnen
Neue Diskussion starten
Thema:
Erster Beitrag:
Eingabe des Log-ins
 

Kundendiskussionen durchsuchen
Alle Amazon-Diskussionen durchsuchen
   


Ähnliche Artikel finden