Amazon cover image
Image from Amazon.com

Learning SQL / Alan Beaulieu.

By: Material type: TextTextPublisher: Beijing : O'Reilly, 2009Edition: Second editionDescription: xiii, 320 pages : illustrations ; 24 cmContent type:
  • text
Media type:
  • unmeditaed
Carrier type:
  • volume
ISBN:
  • 9780596520830
Other title:
  • Learning Structured Query Language
Subject(s): DDC classification:
  • 005.756 BE.L 2009 23
LOC classification:
  • QA76.73.S67 B43 2009
Contents:
A little background -- Creating and populating a database -- Query primer -- Filtering -- Querying multiple tables -- Working with sets -- Data generation, conversion, manipulation -- Grouping and aggregates -- Subqueries -- Joins revisited -- Conditional logic -- Transactions -- Indexes and constraints -- Views -- Metadata -- ER diagram for example database -- MySQL extensions to the SQL language.
Summary: Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server2008.Summary: 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.
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Collection Call number Status Date due Barcode
Books Books The Knowledge Hub Library Computing 005.756 BE.L 2009 (Browse shelf(Opens below)) Not For Loan 190284
Browsing The Knowledge Hub Library shelves, Collection: Computing Close shelf browser (Hides shelf browser)
005.743 CO.D 2015 Database systems : 005.743 CO.D 2015 Database systems : 005.743 CO.D 2015 Database systems : 005.756 BE.L 2009 Learning SQL / 005.756 TE.D 2011 Database modeling and design : 005.756 TE.D 2011 Database modeling and design : 005.756 TE.D 2011 Database modeling and design :

Includes index.

A little background -- Creating and populating a database -- Query primer -- Filtering -- Querying multiple tables -- Working with sets -- Data generation, conversion, manipulation -- Grouping and aggregates -- Subqueries -- Joins revisited -- Conditional logic -- Transactions -- Indexes and constraints -- Views -- Metadata -- ER diagram for example database -- MySQL extensions to the SQL language.

Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server2008.

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.

There are no comments on this title.

to post a comment.