A Guide to SQL

Author: Philip J. Pratt,Mary Z. Last

Publisher: Cengage Learning

ISBN: 0324597681

Category: Computers

Page: 360

View: 633

A GUIDE TO SQL, 8E, continues to be the essential SQL reference. It builds on the success of previous editions by presenting basic SQL commands in the context of a running case in which a business uses SQL to manage orders, parts, customers, and sales reps. The book covers the fundamentals of SQL programming using straightforward instruction and extensive hands-on exercises. Continuing with its focus on students learning the basics regardless of the database environment chosen, this edition features examples from the latest databases: Oracle 11g, Access 2007, and MySQL. The eighth edition expands on the use of running case studies by adding a third running case to the extensive hands-on pedagogy at the end of every chapter. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Oracle (Computer file)

A Guide to SQL Featuring Oracle

Author: Philip J. Pratt

Publisher: N.A

ISBN: 9780760049235

Category: Oracle (Computer file)

Page: 246

View: 9176

Through numerous examples, realistic exercises, and hands-on projects, this text teaches the ins-and-outs of how to use SQL in an Oracle environment.

SQL Pocket Guide

A Guide to SQL Usage

Author: Jonathan Gennick

Publisher: "O'Reilly Media, Inc."

ISBN: 9781449396664

Category: Computers

Page: 206

View: 2294

If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2. SQL Pocket Guide describes how these database systems implement SQL syntax for querying, managing transactions, and making changes to data. It also shows how the systems use SQL functions, regular expression syntax, and type conversion functions and formats. All example SQL statements in this book execute against a set of tables, with data that you can quickly download. The third edition covers important database changes, including: Oracle's support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators Functions new to Oracle, such as LISTAGG, NTH_VALUE, and more PostgreSQL’s support of recursive WITH and some window functions DB2 syntax and datatypes, some compatible with Oracle MySQL features such as the TIMESTAMP type and the TO_SECONDS function

Oracle SQL*Plus Pocket Reference

A Guide to SQL*Plus Syntax

Author: Jonathan Gennick

Publisher: "O'Reilly Media, Inc."

ISBN: 1491926694

Category: Computers

Page: 154

View: 5231

The Oracle SQLPlus Pocket Reference is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQLPlus. As Oracle's long-standing interactive query tool, SQLPlus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQLPlus is still often not completely understood or fully utilized.Database administrators and developers alike will therefore find the Oracle SQLPlus Pocket Reference to be extremely beneficial. In addition to summarizing all of the SQLPlus syntax and format options, including new Oracle Database 10g features, this handy, on-the-job guide specifically shows readers how to: Differentiate between SQL and SQLPlus Interact with SQLPlus from both the command line and the web browser Select, insert, update, and delete data Format both text and HTML reports with SQLPlus Specify SQLPlus commands and format elements Tune SQL queries The new third edition of this book has been updated for Oracle Database 10g to include information on both SQLPlus and SQL. New SQL information includes the SELECT statement's new MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN.With its quick-reference format and compact size, the Oracle SQLPlus Pocket Reference follows in the long line of successful "pocket references" offered by O'Reilly. It also serves as the ideal companion to O'Reilly's larger, more comprehensive book on SQLPlus, the bestselling Oracle SQLPlus: The Definitive Guide.Author Jonathan Gennick is an editor for O'Reilly specializing in database and programming titles, having amassed some 17 years of programming and database management experience.

A Guide to MySQL

Author: Philip J. Pratt,Mary Z. Last

Publisher: Cengage Learning

ISBN: 1285700996

Category: Computers

Page: 288

View: 4141

A Guide to MySQL, by Philip Pratt and Mary Last, is yet another step into the open-source arena, which is rapidly growing in the technology industry. Topics include design techniques, data definition, commands to query a database, updates, administration and client tools, and finally, MySQL special topics. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

A Guide to SQL/DS

Author: C. J. Date

Publisher: Addison Wesley Publishing Company


Category: Computers

Page: 505

View: 5291

This is the first book available on SQL/DS, the IBM relational database management system for the VM and VSE environments. It is already one of the most successful database products and is gaining increasing importance, given the accelerating acceptance of the VM environment in the marketplace.

A Guide to the SQL Standard

A User's Guide to the Standard Database Language SQL

Author: C. J. Date

Publisher: Addison-Wesley Professional


Category: Computers

Page: 522

View: 9437

The previous edition of this book established itself as the most complete and understandable treatment of the SQL standard generally available. Many changes have occurred in the SQL standard world since that edition was published. The original 1992 standard itself has been significantly changed and corrected through the publication of two extensive Technical Corrigenda, one in 1994 and one in 1996. Included in the fourth edition of this important book is information on a major new component, the Call-Level Interface (SQL/CLI), and the Persistent Stored Modules feature (SQL/PSM).
Data base management

The Guide to SQL Server

Author: Aloke Nath

Publisher: Addison Wesley Publishing Company


Category: Data base management

Page: 498

View: 9358

This book takes a comprehensive look at this acclaimed new server from Ashton-Tate, providing an overview of database servers in general and a detailed explanation of the features, architecture, and actual operation of SQL Server.

Microsoft SQL Server 2000

A Guide to Enhancements and New Features

Author: Rahul Sharma

Publisher: Addison-Wesley Professional

ISBN: 0201752832

Category: Computers

Page: 557

View: 6569

Focusing primarily on the new features of SQL Server 2000, this informative overview draws on real-world examples and situations to demonstrate how to use the security features, replication, backup procedures, data warehousing, and optimization techniques of SQL 2000 and is accompaned by a companion CD-ROM that contains sample code, along with scripts and utilities for day-to-day DBA jobs. Original. (Intermediate)
Relational databases

A Guide to SYBASE and SQL Server

A User's Guide to the SYBASE Product (a Relational Database Management System with Application Development Facilities) from Sybase, Inc

Author: D. McGoveran

Publisher: Addison Wesley Longman

ISBN: 9780201557107

Category: Relational databases

Page: 548

View: 4886


The Essence of SQL

A Guide to Learning Most of SQL in the Least Amount of Time

Author: David Rozenshtein

Publisher: Coriolis Group Books

ISBN: 9780964981218

Category: Computers

Page: 119

View: 5420

Ideal for programmers, managers, and students who want to quickly acquire an in-depth understanding of SQL, this book covers the important aspects of the programming language. It takes the readers from the fundamentals to the most complex features of SQL, providing a smooth transition from other programming languages.

Einführung in SQL

Author: Alan Beaulieu

Publisher: O'Reilly Germany

ISBN: 3897219387

Category: Computers

Page: 353

View: 8662

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 so einen Haufen Arbeit vom Tisch zu bekommen. Einführung in SQL bietet einen frischen Blick auf die Sprache, deren Grundlagen jeder Entwickler beherrschen muss. Die aktualisierte 2. Auflage deckt die Versionen MySQL 6.0, Oracle 11g und Microsoft SQL Server 2008 ab. Außerdem enthält sie neue Kapitel zu Views und Metadaten. SQL-Basics - in null Komma nichts durchstarten: Mit diesem leicht verständlichen Tutorial können Sie SQL systematisch und gründlich lernen, ohne sich zu langweilen. Es führt Sie rasch durch die Basics der Sprache und vermittelt darüber hinaus eine Reihe von häufig genutzten fortgeschrittenen Features. Mehr aus SQL-Befehlen herausholen: Alan Beaulieu will mehr vermitteln als die simple Anwendung von SQL-Befehlen: Er legt Wert auf ein tiefes Verständnis der SQL-Features und behandelt daher auch den Umgang mit Mengen, Abfragen innerhalb von Abfragen oder die überaus nützlichen eingebauten Funktionen von SQL. Die MySQL-Beispieldatenbank: Es gibt zwar viele Datenbankprodukte auf dem Markt, aber welches wäre zum Erlernen von SQL besser geeignet als MySQL, das weit verbreitete relationale Datenbanksystem? Der Autor hilft Ihnen, eine MySQL-Datenbank anzulegen, und nutzt diese für die Beispiele in diesem Buch. Übungen mit Lösungen: Zu jedem Thema finden Sie im Buch gut durchdachte Übungen mit Lösungen. So ist sichergestellt, dass Sie schnell Erfolgserlebnisse haben und das Gelernte auch praktisch umsetzen können.


kurz & gut ; [behandelt Oracle DB2, SQL Server & MySQL]

Author: Jonathan Gennick

Publisher: O'Reilly Verlag DE

ISBN: 9783897212688


Page: 171

View: 3525


The SQL Server 7.0 Handbook

A Guide to Microsoft Database Computing

Author: Ken England,Nigel Stanley

Publisher: Digital Press

ISBN: 9781555582012

Category: Computers

Page: 451

View: 3139

This concise and authoritative handbook explains how to implement, administer, design and tune Microsoft's leading data base, and how to use it with other data management technologies and products.

Understanding SQL and Java Together

A Guide to SQLJ, JDBC, and Related Technologies

Author: Jim Melton,Andrew Eisenberg

Publisher: Morgan Kaufmann

ISBN: 9781558605626

Category: Computers

Page: 514

View: 9487

A discussion of the use of Java for accessing database systems. The book focuses largely on SQLJ but includes other approaches as well, including JDBC, JavaBlend, and interfacing with GUI tools. The coverage is based on using real products, and a single subject domain runs throughout the book and is used for all examples. The CD-ROM contains various software components and examples.

SQL f?r Dummies

Author: Allen G. Taylor

Publisher: John Wiley & Sons

ISBN: 352768039X

Category: Computers

Page: 432

View: 3333

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:2011 verst?ndlich und humorvoll 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 und abfragt und SQL-Anweisungen in Programme einbindet. Zudem erkl?rt er, wie SQL mit XML verkn?pft werden kann, um Websites mit einer Datenbank zu verbinden. Au?erdem gibt es jede Menge Profi-Informationen, wie man zum Beispiel Datenbanken und Daten sch?tzen kann und Fehler lokalisiert und behebt.

A Guide to developing client/server SQL applications

Author: Setrag Khoshafian

Publisher: Morgan Kaufmann Publishers


Category: Computers

Page: 634

View: 5919

A practical introduction to database management for the millions of workstation users entering distributed client/server environments. The authors provide a tutorial on database management concepts and explain them in standard SQL. This foundation combined with a comprehensive survey of client/server technology, offers a balanced presentation of database servers such as EE, RDB, Oracle, and SQL Server.