Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
61. | 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 | Overview: SQL: Einstieg für Anspruchsvolle
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 By: Günter Matthiessen; Michael Unterstein Publisher: Addison-Wesley Verlag Publication Date: 14-DEC-2007 Insert Date: 18-MAR-2009 Slots: 1.0 | Overview: Relationale Datenbanken und Standard-SQL: Konzepte der Anwendung und Entwicklung
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. | By: Jonathan Gennick Publisher: O'Reilly Verlag Publication Date: 15-DEC-2008 Insert Date: 18-MAR-2009 Slots: 1.0 | Overview: SQL: kurz & gut
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. | 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 | Overview: SQL IN A NUTSHELL
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. | By: Alan Beaulieu Publisher: O'Reilly Verlag Publication Date: 15-FEB-2006 Insert Date: 18-MAR-2009 Slots: 1.0 | Overview: Einführung in SQL
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 By: Ryan Stephens; Ron Plew; Arie D. Jones Publisher: Sams Publication Date: 29-MAY-2009 Insert Date: 17-MAR-2009 Slots: 1.0 | Overview: Sams Teach Yourself SQL in One Hour a Day, Fifth Edition 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. | By: C.J. Date Publisher: O'Reilly Media, Inc. Publication Date: 23-JAN-2009 Insert Date: 24-JAN-2009 Slots: 1.0 | Overview: SQL and Relational Theory
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 By: Kevin Kline Publisher: O'Reilly Media, Inc. Publication Date: 25-NOV-2008 Insert Date: 20-NOV-2008 Slots: 1.0 | Overview: SQL in a Nutshell, 3rd Edition
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 By: Chris Fehily Publisher: Peachpit Press Publication Date: 04-JUN-2008 Insert Date: 11-NOV-2008 Slots: 1.0 | Overview: SQL: Visual QuickStart Guide, Third Edition 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 By: Michael Coles Publisher: Apress Publication Date: 01-APR-2007 Insert Date: 18-OCT-2008 Slots: 1.0 | Overview: Pro T-SQL 2008 Programmer's Guide
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. | By: Stephane Faroult; Pascal L'Hermite Publisher: O'Reilly Media, Inc. Publication Date: 22-AUG-2008 Insert Date: 19-AUG-2008 Slots: 1.0 | Overview: Refactoring SQL Applications
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 By: John J. Patrick Publisher: Prentice Hall Publication Date: 02-SEP-2008 Insert Date: 12-JUN-2008 Slots: 1.0 | Overview: SQL Fundamentals, Third Edition 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. | By: Rick Copeland Publisher: O'Reilly Media, Inc. Publication Date: 05-JUN-2008 Insert Date: 05-JUN-2008 Slots: 1.0 | Overview: Essential SQLAlchemy 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 By: Ryan Stephens; Ron Plew; Arie D. Jones Publisher: Sams Publication Date: 30-MAY-2008 Insert Date: 10-MAY-2008 Slots: 1.0 | Overview: Sams Teach Yourself SQL® in 24 Hours, Fourth Edition 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. | By: Publisher: John Wiley & Sons Publication Date: 14-AUG-2006 Insert Date: 06-MAR-2008 Slots: 1.0 | Overview: SQL For Dummies® 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 By: John L. Viescas; Michael J. Hernandez Publisher: Addison-Wesley Professional Publication Date: 24-SEP-2007 Insert Date: 15-SEP-2007 Slots: 1.0 | Overview: SQL Queries for Mere Mortals®: A Hands-On Guide to Data Manipulation in SQL, Second Edition 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. | By: Lynn Beighley Publisher: O'Reilly Media, Inc. Publication Date: 28-AUG-2007 Insert Date: 06-SEP-2007 Slots: 1.0 | Overview: Head First SQL 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. | By: Jonathan Gennick Publisher: O'Reilly Media, Inc. Publication Date: 17-APR-2006 Insert Date: 01-SEP-2007 Slots: 1.0 | Overview: SQL Pocket Guide, 2nd Edition 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. |
By: Martin Nystrom Publisher: O'Reilly Media, Inc. Publication Date: 22-MAR-2007 Insert Date: 16-MAY-2007 Slots: 1.0 | Overview: SQL Injection Defenses
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 By: Tara Calishain Publisher: New Riders Publication Date: 07-DEC-2006 Insert Date: 10-NOV-2006 Slots: 1.0 | Overview: Information Trapping: Real-Time Research on the Web 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...
|