Learning SQL

Learning SQL

4.4 11
by Alan Beaulieu
     
 

View All Available Formats & Editions

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.

Updated for the latest database management systems — including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 — this

…  See more details below

Overview

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.

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.

Read More

Editorial Reviews

bn.com
The Barnes & Noble Review
Don’t just skim SQL’s surface: Gain a real understanding of what it can do -- in less than 300 pages.

Alan Beaulieu’s Learning SQL starts with all the background you need: No SQL or database experience is required. In the first few chapters, you’ll walk through creating and populating your first database. (Download MySQL and follow along.) You’ll write basic queries, filter data, query multiple tables, work with sets, use built-in functions. Gradually, you’ll move to more complex tasks: grouping, aggregates, and subqueries; even joins, transactions, and indexes.

Beaulieu’s examples are tested with MySQL, Oracle, and SQL Server (and should work fine with most recent databases). The result: a book that’ll work in any environment, whether you’re building applications, working as an admin, or just trying to coax a database into coughing up the right information. Bill Camarda, from the November 2005 Read Only

Product Details

ISBN-13:
9780596007270
Publisher:
O'Reilly Media, Incorporated
Publication date:
09/10/2005
Pages:
312
Product dimensions:
7.02(w) x 9.16(h) x 0.75(d)

Meet 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.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Learning SQL 4.5 out of 5 based on 0 ratings. 11 reviews.
Guest More than 1 year ago
Are you working with relational databases and writing applications, performing administrative tasks, or generating reports? If you are, you're in luck! Author Alan Beaulieu, has done an outstanding job of writing a book that will show you how to interact with the data in your database. Beaulieu, begins by exploring the history of computerized databases, including the rise of the relational model and the SQL language. Then, he demonstrates how to create a MySQL database, create the tables used for the examples in this book, and populate the tables with data. The author continues by introducing the select statement and further demonstrating the most common clauses. Next, he demonstartes the different types of conditions that can be used in the where clause of a select, update, or delete statement. Then, the author shows you how queries can utilize multiple tables via table joins. He continues with a discussion about data sets and how they can interact within queries. Then, he demonstrates several built-in functions used for manipulating or converting data. The author continues by showing you how data can be aggregated. Next, he introduces the subquery and shows how and where they can be utilized. Then, the author further explores the various types of table joins. He continues by exploring how conditional logic can be utilized in select, insert, update, and delete statements. Then, the author introduces transactions and shows how to use them. Finally, he explores indexes and constraints. While this most excellent book demonstrates many of the SQL schema statements, the main focus of this book is on programming features. Filled with example code, you may use some of the code in this book in your programs and documentation. Basically, this book is here to help you get your job done--whatever it may be.
Ayp More than 1 year ago
I would recommend this book to anyone who is starting to learn SQL. This book is a begineers book teaching various SQL statements like SELECT, INSERT, DELETE. The book starts off with the available database models like Network, Object and Heirarchical models and then goes ahead and explains the commands. The commands are written for MySQL which is freely available for download and install. The author also explains the variations in Oracle and SQL Server where appropriate. The commands are grouped together and covered one by one. The topics covered are statements like SELECT, INSERT, DELETE, aggregate functions, joining more than one table, set operations like union, intersection, views, indexes, constraints, transaction etc. There is also "Test your knowledge" at the end of each chapter which helps you to reinforce what you just learnt with the solutions at the end of the book in case you are struck and don't know how to proceed. This book just introduces all the beginners concept in a nice way. The examples are simple to follow and learn. PROS : Covers all SQL commands, Show different variations among Database vendors CONS : Begineer book (no indepth knowledge)
Tomas_Sancio More than 1 year ago
Learning SQL gets you up and running with the language very quickly. The introduction is easy to read and the first instructions are well chosen. It uses an example that can be downloaded from the O'Reilly site and MySQL Server as the programming platform. I opened the book not knowing a thing about SQL and it has helped me plenty.
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago