Free Trial

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

Help

SQL


61. 

Oracle SQL Recipes: A Problem-Solution Approach

Oracle SQL Recipes: A Problem-Solution Approach

By: Grant Allen; Bob Bryla; Darl Kuhn

Publisher: Apress

Publication Date: 17-NOV-2009

Insert Date: 14-MAY-2010

Slots: 1.0

Table of Contents • Start Reading

Have you ever been faced with a new type of query to write, or been asked to create an unfamiliar database object? In such situations, you have probably wanted a good, solid example upon which to build, and instead have been forced into the drudgery of parsing railroad-style syntax diagrams in Oracle's manual set. This book frees you from that drudgery by providing tested and working examples of SQL used to solve common problems faced by developers and database administrators on a daily basis. When you're under pressure to get results fast, Oracle SQL Recipes is there at your...

62. 

Oracle SQL Developer 2.1

Oracle SQL Developer 2.1

By: Sue Harper

Publisher: Packt Publishing

Publication Date: 16-DEC-2009

Insert Date: 06-APR-2010

Slots: 1.0

Table of Contents • Start Reading

Database design and development using this feature-rich, powerful user-extensible interface Install, configure, customize, and manage your SQL Developer environment Includes the latest features to enhance productivity and simplify database development Covers reporting, testing, and debugging concepts Meet the new powerful Data Modeling tool – Oracle SQL Developer Data Modele Detailed code examples and screenshots for easy learning In Detail As technology rapidly evolves, many developers are looking for valuable tools to assist them with their daily tasks. When...

63. 

SQL For Dummies®, 7th Edition

SQL For Dummies®, 7th Edition

By: 

Publisher: For Dummies

Publication Date: 02-FEB-2010

Insert Date: 13-MAR-2010

Slots: 1.0

Table of Contents • Start Reading

Learn SQL the fun and easy way – no programming experience needed! SQL For Dummies, 7th Edition, shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. This book covers the core features of the SQL language. Topics covered include how to use SQL to structure a DBMS and implement a database design; secure a database; and retrieve information from a database. This edition will be revised to reflect the new enhancements of SQL/XML:2008. The latest update of the perennial bestselling SQL For Dummies, which has sold more...

64. 

Joe Celko's Data, Measurements and Standards in SQL

Joe Celko's Data, Measurements and Standards in SQL

By: Joe Celko

Publisher: Morgan Kaufmann

Publication Date: 22-SEP-2009

Insert Date: 09-FEB-2010

Slots: 1.0

Table of Contents • Start Reading

Joe Celko has looked deep into the code of SQL programmers and found a consistent and troubling pattern - a frightening lack of consistency between their individual encoding schemes and those of the industries in which they operate. This translates into a series of incompatible databases, each one an island unto itself that is unable to share information with others in an age of internationalization and business interdependence. Such incompatibility severely hinders information flow and the quality of company data. Data, Measurements and Standards in SQL reveals the shift these...

65. 

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: 01-JUN-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. · Includes graph theory and programming techniques. · Running examples throughout the book help...

66. 

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....

67. 

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...

68. 

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...

69. 

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...

70. 

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. ...

71. 

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 ...

72. 

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...

73. 

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

Joe Celko's SQL for Smarties, 3rd Edition

By: Joe Celko

Publisher: Morgan Kaufmann

Publication Date: 26-JUL-2010

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...

74. 

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: 31-AUG-2011

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...

75. 

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 ...

76. 

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. ...

77. 

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...

78. 

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...

79. 

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 ...

80. 

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...