Learning SQL / Alan Beaulieu.
Material type: TextPublication details: Sebastopol, CA : O\'Reilly Media, ©2009.Edition: 2nd edDescription: xiii, 320 pages : illustrations ; 24 cmISBN:- 9780596520830
- 0596520832
- 005.756 BEA
Item type | Current library | Call number | Status | Date due | Barcode | |
---|---|---|---|---|---|---|
Standard Loan | Clonmel Library Main Collection | 005.756 BEA (Browse shelf(Opens below)) | Available | 39002100621722 |
Enhanced descriptions from Syndetics:
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 book, you will:
Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.
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 revisted Conditional logic -- Transactions -- Indexes and constraints -- Views -- Metadata.
Originally published: 2005.
Author notes provided by Syndetics
Alan Beaulieu has been designing, building, and implementing custom database applications for over 13 years. He currently runs his own consulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning, and Parallel Server. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters.