Murakami Sale
 
 

Recently Viewed clear list


Original Essays | August 18, 2014

Ian Leslie: IMG Empathic Curiosity



Today, we wonder anxiously if digital media is changing our brains. But if there's any time in history when our mental operations changed... Continue »
  1. $18.89 Sale Hardcover add to wish list

spacer
Qualifying orders ship free.
$39.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Beaverton Database- SQL
1 Burnside - Bldg. 2 Database- SQL
9 Remote Warehouse Computers Reference- General
25 Remote Warehouse Database- Design

Learning SQL

by

Learning SQL Cover

 

Synopses & Reviews

Publisher Comments:

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:

  • Move quickly through SQL basics and learn several advanced features
  • Use SQL data statements to generate, manipulate, and retrieve data
  • Create database objects, such as tables, indexes, and constraints, using SQL schema statements
  • Learn how data sets interact with queries, and understand the importance of subqueries
  • Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements

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.

Book News Annotation:

This is an introduction to SQL, the database computer language designed for the retrieval and management of data in relational database management systems, database schema creation and modification, and database object access control management. Chapters cover creating and populating a database; queries; filtering; querying multiple tables; working with sets; data generation, conversion, and manipulation; grouping and aggregates; subqueries; table joins; conditional logic; transactions; indexes and constraints; views; and metadata. Examples and exercises use MySQL, which is freely available, although they also run on Oracle Database and SQL Server. Annotation ©2009 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. This introductory guide is designed for developers new to the program.

About the Author

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 and can be reached at albeau_mosql@yahoo.com.

Table of Contents

PrefaceChapter 1: A Little BackgroundChapter 2: Creating and Populating a DatabaseChapter 3: Query PrimerChapter 4: FilteringChapter 5: Querying Multiple TablesChapter 6: Working with SetsChapter 7: Data Generation, Conversion, and ManipulationChapter 8: Grouping and AggregatesChapter 9: SubqueriesChapter 10: Joins RevisitedChapter 11: Conditional LogicChapter 12: TransactionsChapter 13: Indexes and ConstraintsChapter 14: ViewsChapter 15: MetadataER Diagram for Example DatabaseMySQL Extensions to the SQL LanguageSolutions to ExercisesColophon

Product Details

ISBN:
9780596520830
Author:
Beaulieu, Alan
Publisher:
O'Reilly Media
Subject:
Database Management - SQL Server
Subject:
Programming languages (electronic computers)
Subject:
Sql (computer program language)
Subject:
Database Management - General
Subject:
Database-SQL
Subject:
Database design
Subject:
MySQL;SQL;SQL Server Oracle SQL;database design
Subject:
CourseSmart Subject Description
Subject:
MySQL;SQL;database design
Edition Description:
Second Edition,Annotated
Publication Date:
20090430
Binding:
Paperback
Language:
English
Illustrations:
Y
Pages:
338
Dimensions:
9.2 x 7 x 0.7 in 0.96 lb

Other books you might like

  1. Investigative Journalism : Proven... Used Trade Paper $27.50
  2. Structuring an Energy Technology... Used Trade Paper $12.95
  3. Learning JavaScript: Add Sparkle and... Used Trade Paper $24.00
  4. Learning PHP 5
    Used Trade Paper $15.00
  5. Catching Fire: How Cooking Made Us Human
    Sale Trade Paper $7.98
  6. The Goddess and the Bull:... Used Hardcover $12.95

Related Subjects

Computers and Internet » Computers Reference » General
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management
Hobbies, Crafts, and Leisure » Games » General Puzzles

Learning SQL New Trade Paper
0 stars - 0 reviews
$39.99 In Stock
Product details 338 pages O'Reilly Media - English 9780596520830 Reviews:
"Synopsis" by ,
SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. This introductory guide is designed for developers new to the program.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.