Books.org participates in affiliate programs including Bookshop.org and the Amazon Services LLC Associates Program. We may earn a commission from qualifying purchases made through links on this page, at no additional cost to you.
Overview
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.
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.
Editorials
From Barnes & Noble
The Barnes & Noble ReviewDon’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