Free Trial

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

Help

SQL


61. 

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

62. 

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

63. 

SQL: kurz & gut

SQL: kurz & gut

By: Jonathan Gennick

Publisher: O'Reilly Verlag

Publication Date: 15-DEC-2008

Insert Date: 18-MAR-2009

Slots: 1.0

Table of Contents • Start Reading

Der Bestseller in stark erweiterter und aktualisierter Neuauflage: Gewohnt knapp und präzise deckt SQL - kurz & gut die wichtigsten Funktionen und Themen zur effektiven Arbeit mit SQL ab. Dabei behandelt die Taschenreferenz neben Oracle Database 10g Release 2, IBM DB2 8.2, Microsoft SQL Server 2005 und MySQL 5.0 nun auch PostgreSQL 8.1. Aus dem Inhalt: Anweisungen zur Datenmanipulation (SELECT, DELETE, INSERT, UPDATE, MERGE) und zur Transaktionsverwaltung (START TRANSAKTION, SAVEPOINT, COMMIT, ROLLBACK) Gebräuchliche SQL-Funktionen (Datums-, String-, Umwandlungs-, Aggregat- und...

64. 

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

65. 

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

66. 

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

67. 

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

68. 

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

69. 

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

70. 

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

71. 

Refactoring SQL Applications

Refactoring SQL Applications

By: ;

Publisher: O'Reilly Media, Inc.

Publication Date: 22-AUG-2008

Insert Date: 19-AUG-2008

Slots: 1.0

Table of Contents • Start Reading

What can you do when database performance doesn't meet expectations? Before you turn to expensive hardware upgrades to solve the problem, reach for this book. Refactoring SQL Applications provides a set of tested options for making code modifications to dramatically improve the way your database applications function. Backed by real-world examples, you'll find quick fixes for simple problems, in-depth answers for more complex situations, and complete solutions for applications with extensive problems. Learn to: Determine if and where you can expect performance gainsApply quick fixes, such as...

72. 

SQL Fundamentals, Third Edition

SQL Fundamentals, Third Edition

By: John J. Patrick

Publisher: Prentice Hall

Publication Date: 02-SEP-2008

Insert Date: 12-JUN-2008

Slots: 1.0

Table of Contents • Start Reading

SQL for the Real World Don’t just learn “generic” SQL. Learn SQL to get results with the world’s top database platforms–Oracle for the enterprise and Microsoft Access for the desktop. Based on John Patrick’s hands-on SQL course at the University of California, Berkeley Extension, this book shows exactly how to retrieve the data you want, when you need it, in any application–from ad hoc reports to the data warehouse. Thoroughly updated for the newest versions of Oracle, Access, and the SQL standard, this book contains more exercises, techniques, and solutions than ever before. You’ll learn...

73. 

Essential SQLAlchemy

Essential SQLAlchemy

By: 

Publisher: O'Reilly Media, Inc.

Publication Date: 05-JUN-2008

Insert Date: 05-JUN-2008

Slots: 1.0

Table of Contents • Start Reading

Essential SQLAlchemy introduces a high-level open-source code library that makes it easier for Python programmers to access relational databases such as Oracle, DB2, MySQL, PostgreSQL, and SQLite. SQLAlchemy has become increasingly popular since its release, but it still lacks good offline documentation. This practical book fills the gap, and because a developer wrote it, you get an objective look at SQLAlchemy's tools rather than an advocate's description of all the "cool" features. SQLAlchemy includes both a database server-independent SQL expression language and an object-relational mapper...

74. 

Sams Teach Yourself SQL® in 24 Hours, Fourth Edition

Sams Teach Yourself SQL® in 24 Hours, Fourth Edition

By: 

Publisher: Sams

Publication Date: 30-MAY-2008

Insert Date: 10-MAY-2008

Slots: 1.0

Table of Contents • Start Reading

In just 24 lessons of one hour or less, you will learn professional techniques to design and build efficient databases and query them to extract useful information. Using a straightforward, step-by-step approach, each lesson builds on the previous one, allowing you to learn the essentials of ANSI SQL from the ground up. Example code demonstrates the authors’ professional techniques, while exercises written for MySQL offer the reader hands-on learning with an open-source database. Included are advanced techniques for using views, managing transactions, database administration, and extending...

75. 

SQL For Dummies®

SQL For Dummies®

By: 

Publisher: John Wiley & Sons

Publication Date: 14-AUG-2006

Insert Date: 06-MAR-2008

Slots: 1.0

Table of Contents • Start Reading

See how SQL interfaces with today's environments Start building and using relational databases with SQL's newest features The database may be the twenty-first century filing cabinet, but building one is a little more complex than sliding drawers into a metal box. With this book to guide you through all the newest features of SQL, you'll soon be whipping up relational databases, using SQL with XML to power data-driven Web sites, and more! Discover how to * Use SQL in a client/server system * Build a multitable relational database * Construct nested and recursive queries * Set...

76. 

SQL Queries for Mere Mortals®: A Hands-On Guide to Data Manipulation in SQL, Second Edition

SQL Queries for Mere Mortals®: A Hands-On Guide to Data Manipulation in SQL, Second Edition

By: 

Publisher: Addison-Wesley Professional

Publication Date: 24-SEP-2007

Insert Date: 15-SEP-2007

Slots: 1.0

Table of Contents • Start Reading

Unless you are working at a very advanced level, this is the only SQL book you will ever need. The authors have taken the mystery out of complex queries and explained principles and techniques with such clarity that a "Mere Mortal" will indeed be empowered to perform the superhuman. Do not walk past this book! --Graham Mandeno, Database Consultant SQL Queries for Mere Mortals provides a step-by-step, easy-to-read introduction to writing SQL queries. It includes hundreds of examples with detailed explanations. This book provides the tools you need to understand, modify, and create SQL...

77. 

Head First SQL

Head First SQL

By: 

Publisher: O'Reilly Media, Inc.

Publication Date: 28-AUG-2007

Insert Date: 06-SEP-2007

Slots: 1.0

Table of Contents • Start Reading

Is your data dragging you down? Are your tables all tangled up? Well we've got the tools to teach you just how to wrangle your databases into submission. Using the latest research in neurobiology, cognitive science, and learning theory to craft a multi-sensory SQL learning experience, Head First SQL has a visually rich format designed for the way your brain works, not a text-heavy approach that puts you to sleep. Maybe you've written some simple SQL queries to interact with databases. But now you want more, you want to really dig into those databases and work...

78. 

SQL Pocket Guide, 2nd Edition

SQL Pocket Guide, 2nd Edition

By: 

Publisher: O'Reilly Media, Inc.

Publication Date: 17-APR-2006

Insert Date: 01-SEP-2007

Slots: 1.0

Table of Contents • Start Reading

SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two.Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses...

79. 

SQL Injection Defenses

ShortCut

SQL Injection Defenses

By: 

Publisher: O'Reilly Media, Inc.

Publication Date: 22-MAR-2007

Insert Date: 16-MAY-2007

Slots: 1.0

Table of Contents • Start Reading

This Short Cut introduces you to how SQL injection vulnerabilities work, what makes applications vulnerable, and how to protect them. It helps you find your vulnerabilities with analysis and testing tools and describes simple approaches for fixing them in the most popular web-programming languages. This Short Cut also helps you protect your live applications by describing how to monitor for and block attacks before your data is stolen.Hacking is an increasingly criminal enterprise, and web applications are an attractive path to identity theft. If the applications you build, manage, or guard...

80. 

Information Trapping: Real-Time Research on the Web

Information Trapping: Real-Time Research on the Web

By: 

Publisher: New Riders

Publication Date: 07-DEC-2006

Insert Date: 10-NOV-2006

Slots: 1.0

Table of Contents • Start Reading

How many times have you run a Google search that resulted in thousands of results? With over 8 billion pages online and more posted every day, the Web more than likely contains the information you’re looking for — if only you could find it. In Information Trapping: Real-Time Research on the Web, Internet-search-engine expert Tara Calishain makes researching more efficient and rewarding for anyone for whom the Web is an indispensable tool — academics, journalists, scientists, and professionals, as well as bloggers, genealogists, and hobbyists. She does so by teaching the latest techniques for...