Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Help

SQL


61. 

Joe Celko’s Trees and Hierarchies in SQL for Smarties

Joe Celko’s Trees and Hierarchies in SQL for Smarties

By: Joe Celko

Publisher: Morgan Kaufmann

Publication Date: 07-MAY-2004

Insert Date: 22-AUG-2009

Slots: 1.0

Table of Contents • Start Reading

Joe Celko's Trees and Hierarchies in SQL is an intermediate to advanced-level practitioner's guide to mastering the two most challenging aspects of developing database applications in SQL. In this book, Celko illustrates several major approaches to representing trees and hierarchies and related topics that should be of interest to the working database programmer. These topics include hierarchical encoding schemes, graphs, IMS, binary trees, and more. This book covers SQL-92 and SQL:1999....

62. 

Simply SQL

Simply SQL

By: 

Publisher: SitePoint

Publication Date: 28-DEC-2008

Insert Date: 15-AUG-2009

Slots: 1.0

Table of Contents • Start Reading

Simply SQL is a practical step-by-step guide to writing SQL. You'll learn how to make the most of your data using best-practice SQL code. Rather than bore you with theory, it focuses on the practical use of SQL with common databases and uses plenty of diagrams, easy-to-read text, and examples to help make learning SQL easy and fun....

63. 

Joe Celko’s Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL

Joe Celko’s Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL

By: Joe Celko

Publisher: Morgan Kaufmann

Publication Date: 22-JAN-2008

Insert Date: 01-JUL-2009

Slots: 1.0

Table of Contents • Start Reading

Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity. This book will change the way you think about the problems you solve with SQL programs.. Focusing on three key table-based techniques, Celko reveals their power through detailed examples and clear explanations. As you master these techniques, you'll find you are able...

64. 

The Definitive Guide to SQLite

The Definitive Guide to SQLite

By: Michael Owens

Publisher: Apress

Publication Date: 24-MAY-2006

Insert Date: 25-JUN-2009

Slots: 1.0

Table of Contents • Start Reading

Traditional relational databases and embedded databases both have shortcomings that can leave a developer perplexed. So for many people, the solution resides in an open source embeddable database with an amazingly small footprint (less than 250 kilobytes). SQLite packs a powerful array of features and can handle databases as large as 2 terabytes. It offers a flexible set of datatypes and the ability to perform transactions, and it is supported by languages like C, PHP, Perl, and Python. And because SQLite's databases are completely file based, privileges are granted at the operating system...

65. 

SQL für Dummies®

SQL für Dummies®

By: Allen G. Taylor

Publisher: für Dummies

Publication Date: 19-JAN-2007

Insert Date: 04-JUN-2009

Slots: 1.0

Table of Contents • Start Reading

Datenbanken sind das beste Werkzeug, um wichtige Informationen im Auge zu behalten. Mit SQL können die vorhandenen Daten strukturiert und zielsicher abgefragt werden. In "SQL für Dummies" macht Allen G. Taylor die Leser mit der Abfragesprache SQL und dem aktuellen Standard SQL:2003, der 2005 durch eine sorgfältige Einbindung von XML-Komponenten vervollständigt worden ist, auf verständliche und humorvolle Weise vertraut. Er beginnt mit dem notwendigen Grundlagenwissen für den Aufbau eines Datenbankmanagementsystems und den SQL-Hauptkomponenten, zeigt auf, wie man die Daten erstellt, ordnet...

66. 

SQL Bible, Second Edition

SQL Bible, Second Edition

By: 

Publisher: John Wiley & Sons

Publication Date: 07-APR-2008

Insert Date: 22-MAY-2009

Slots: 1.0

Table of Contents • Start Reading

Combining theory with everyday practicality, this definitive volume is packed with the up-to-date information, new features, and explanations you need to get the very most out of SQL and its latest standard. The book is unique in that every chapter highlights how the new SQL standard applies to the three major databases, Oracle 11g, IBM DB2 9.5, and Microsoft SQL Server 2008. The result is a comprehensive, useful, and real-world reference for all SQL users, from beginners to experienced developers. ...

67. 

SQL von Kopf bis Fuß

SQL von Kopf bis Fuß

By: Lynn Beighly

Publisher: O'Reilly Verlag

Publication Date: 15-JAN-2008

Insert Date: 17-APR-2009

Slots: 1.0

Table of Contents • Start Reading

Worum geht es in diesem Buch? Ihre Daten erdrücken Sie? Ihre Tabellen verheddern sich regelmäßig? Wir haben ein Mittel, wie Sie Ihre Datenbanken in den Griff bekommen: SQL von Kopf bis Fuß nimmt Sie mit auf eine Reise durch die SQL-Welt, es ...

68. 

Learning SQL, 2nd Edition

Learning SQL, 2nd Edition

By: 

Publisher: O'Reilly Media, Inc.

Publication Date: 20-APR-2009

Insert Date: 09-APR-2009

Slots: 1.0

Table of Contents • Start Reading

Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this...

69. 

Joe Celko’s SQL for Smarties: Advanced SQL Programming, Third Edition

Joe Celko’s SQL for Smarties: Advanced SQL Programming, Third Edition

By: Joe Celko

Publisher: Morgan Kaufmann

Publication Date: 15-AUG-2005

Insert Date: 26-MAR-2009

Slots: 1.0

Table of Contents • Start Reading

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL masters. These are not just tips and techniques; Joe also offers the best solutions to old and new challenges and conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. In the third edition, Joe features new examples and...

70. 

The Best Damn Exchange, SQL and IIS Book Period

The Best Damn Exchange, SQL and IIS Book Period

By: Henrik Walther; Mark Horninger; Chris Adams

Publisher: Syngress

Publication Date: 05-NOV-2007

Insert Date: 26-MAR-2009

Slots: 1.0

Table of Contents • Start Reading

Exchange, SQL and IIS are at the core of most Microsoft enterprise servers. The 2007 releases of these products, along with the release of Windows Vista and Windows 2008 Server, represents the biggest overhaul of Windows enterprise products since Windows 2000. The dramatic changes to security tools and the addition of features that support "anywhere access" present IT professionals with a steep learning curve. Making certain that these products are configured to meet regulatory compliance requirements adds addtionaly complexity to day-to-day management network management. The Best Damn...

71. 

SQL: Einstieg für Anspruchsvolle

SQL: Einstieg für Anspruchsvolle

By: John-Harry Wieken

Publisher: Addison-Wesley Verlag

Publication Date: 15-DEC-2008

Insert Date: 18-MAR-2009

Slots: 1.0

Table of Contents • Start Reading

Mit diesem Buch erhalten Sie das Wissen, das den Profi vom Einsteiger unterscheidet. Der Autor zeigt einen schnellen Einstieg in die praktische Nutzung von Datenbanksystemen mit SQL . Die Zweifarbigkeit des Buchs hilft beim Lernen - wichtige Codebestandteile werden farblich gekennzeichnet. Praktische Übungen erlauben eigenes Experimentieren und eine erste Erfahrungsbildung mit SQL-Anwendungen ...

72. 

Relationale Datenbanken und Standard-SQL: Konzepte der Anwendung und Entwicklung

Relationale Datenbanken und Standard-SQL: Konzepte der Anwendung und Entwicklung

By: Günter Matthiessen; Michael Unterstein

Publisher: Addison-Wesley Verlag

Publication Date: 14-DEC-2007

Insert Date: 18-MAR-2009

Slots: 1.0

Table of Contents • Start Reading

Das Buch erläutert grundlegende Konzepte relationaler Datenbanken und ihre Umsetzung bei der Entwicklung und Anwendung von praxistauglichen Informationssystemen mit SQL. Es stellt zugleich einen wertvollen Leitfaden für den Praktiker und ein ideales Lehrwerk für den Studierenden dar. Dabei hilft seine gelungene Mischung zwischen methodisch-theoretischen Grundlagen und zahlreichen Anwendungsbeispielen. Es berücksichtigt sowohl SQL:1999 als auch SQL:2003. ...

73. 

SQL kurz & gut, 2nd Edition

SQL kurz & gut, 2nd Edition

By: 

Publisher: O'Reilly Verlag

Publication Date: 30-NOV-2006

Insert Date: 18-MAR-2009

Slots: 1.0

Table of Contents • Start Reading

Die stark erweiterte und aktualisierte Neuauflage des Bestsellers bietet gewohnt knapp und präzise die wichtigsten Informationen zu SQL und deckt neben Oracle Database 10g Release 2, IBM DB2 8.2, Microsoft SQL Server 2005 und MySQL 5.0 nun auch PostgreSQL 8.1 ab. Bei aller Aktualität erhalten geblieben ist das bewährte Konzept des Titels: Anhand konkreter Beispiele werden die SQL-Anweisungen und -Optionen vorgestellt, die in der Praxis am häufigsten benötigt werden. Kompakt, übersichtlich und auf den Punkt gebracht: SQL – kurz & gut ist auch in der zweiten Auflage ein aktuelles, nützliches...

74. 

SQL IN A NUTSHELL

SQL IN A NUTSHELL

By: Kevin E. Kline mit Daniel Kline; Brand Hunt

Publisher: O'Reilly Verlag

Publication Date: 15-MAY-2005

Insert Date: 18-MAR-2009

Slots: 1.0

Table of Contents • Start Reading

SQL ist die Sprache der Datenbanken. Sie wird verwendet, um Datenbankobjekte anzulegen und Daten in diese Objekte zu laden, um diese Daten abzufragen, zu modifizieren und zu löschen, wenn sie nicht mehr benötigt werden. Datenbanken bilden das Kernstück der meisten Anwendungen in der Wirtschaft. Wenn Sie mit Softwareentwicklung zu tun haben, verwenden wahrscheinlich auch Sie SQL – Grund genug, sich eine gute Sprachreferenz anzuschaffen. Zwar ist SQL eine standardisierte Sprache, aber ihre Implementierungen sind alles andere als standardkonform. Es gibt Unmengen von herstellerspezifischen...

75. 

Einführung in SQL

Einführung in SQL

By: Alan Beaulieu

Publisher: O'Reilly Verlag

Publication Date: 15-FEB-2006

Insert Date: 18-MAR-2009

Slots: 1.0

Table of Contents • Start Reading

SQL kann Spaß machen! Es ist ein erhebendes Gefühl, eine verworrene Datenmanipulation oder einen komplizierten Report mit einer einzigen Anweisung zu bewältigen und dabei einen Haufen Arbeit vom Tisch zu bekommen. Wenn Sie SQL endlich auch souverän nutzen ...

76. 

Sams Teach Yourself SQL in One Hour a Day, Fifth Edition

Sams Teach Yourself SQL in One Hour a Day, Fifth Edition

By: 

Publisher: Sams

Publication Date: 29-MAY-2009

Insert Date: 17-MAR-2009

Slots: 1.0

Table of Contents • Start Reading

The Fifth Edition of Sams Teach Yourself SQL in 21 Days More than 48,000 sold! In just one hour a day, you’ll have all the skills you need to begin creating effective SQL queries, reports, and database applications. With this complete tutorial, you’ll quickly master the basics and then move on to more advanced features and concepts: Quickly apply essential SQL techniques in useful, real-world queries Design trustworthy, high-performance databases Manipulate your data with views and transactions Leverage powerful features including stored procedures, triggers, and...

77. 

SQL and Relational Theory

SQL and Relational Theory

By: 

Publisher: O'Reilly Media, Inc.

Publication Date: 23-JAN-2009

Insert Date: 24-JAN-2009

Slots: 1.0

Table of Contents • Start Reading

Understanding SQL's underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. On the other hand, if you're not well versed in the theory, you can fall into several traps. In SQL and Relational Theory, author C.J. Date demonstrates how you can apply relational theory directly to your use of SQL. With numerous examples and clear explanations of the reasoning behind them, you'll learn how to deal with common SQL dilemmas, such as: Should database access granted be through views instead of base tables?Nulls in your database...

78. 

SQL in a Nutshell, 3rd Edition

SQL in a Nutshell, 3rd Edition

By: 

Publisher: O'Reilly Media, Inc.

Publication Date: 25-NOV-2008

Insert Date: 20-NOV-2008

Slots: 1.0

Table of Contents • Start Reading

For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You'll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts -- all packed into a...

79. 

SQL: Visual QuickStart Guide, Third Edition

SQL: Visual QuickStart Guide, Third Edition

By: Chris Fehily

Publisher: Peachpit Press

Publication Date: 04-JUN-2008

Insert Date: 11-NOV-2008

Slots: 1.0

Table of Contents • Start Reading

SQL is a standard interactive and programming language for querying and modifying data and managing databases. This task-based tutorial and reference guide takes the mystery out learning and applying SQL. After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily immediately launches into the tasks that will get readers comfortable with SQL. In addition to covering all the SQL basics, this thoroughly updated reference contains a wealth of in-depth SQL knowledge and serves as an excellent reference for more experienced users....

80. 

Pro T-SQL 2008 Programmer's Guide

Pro T-SQL 2008 Programmer's Guide

By: Michael Coles

Publisher: Apress

Publication Date: 01-APR-2007

Insert Date: 18-OCT-2008

Slots: 1.0

Table of Contents • Start Reading

Pro T-SQL 2005 Programmer's Guide provides comprehensive and detailed coverage of all the major features and facilities of T-SQL for SQL Server 2005. It is designed for all users of T-SQL, database administrators, systems administrators, application developers, and end-users, who want to learn how to exploit the power of T-SQL. Whatever you need to do with T-SQL, you'll find it described clearly here. Stored procedures, triggers, and user-defined functions are only part of the story. Dynamic SQL, the new XML data type, and SQLCLR programming are also covered, as well as accessing SQL...