Book description
Ideal as a stand-alone primer or when used in conjunction with another introductory computer science text, SQL: The Programming Language will prepare students for core SQL programming courses offered in CS and CIS. With a clear, concise, and descriptive writing style, students will see real-world examples and cases of SQL functionality in database management. Screen shots and figures throughout the text allow readers to visualize important concepts discussed and student exercises urge them to explore problems on their own.
Table of contents
- Cover Page
- Title Page
- Copyright Page
- Contents
- Preface
-
Chapter 1 - Relational Databases, Entities, Tables, and Primary Keys
- 1.1 - Relational Databases and Entities
- 1.2 - Entities, Attributes, Tables, Rows, and Columns
- 1.3 - Primary Keys and Entity Integrity
- 1.4 - Table Schema Notation
- 1.5 - The Text and Number Data Types
- 1.6 - The Currency Data Type
- 1.7 - The Date Data Type
- 1.8 - When is a Number Not a Number?
- 1.9 - More Complete Schema Notation
- 1.10 - The Definition of Null
- 1.11 - Data Integrity
-
Chapter 2 - Entities and Relationships
- 2.1 - Foreign Keys and Relationships between Tables
- 2.2 - The One-to-Many Relationship and Entity Relationship Diagrams
- 2.3 - The One-to-One Relationship
- 2.4 - The Role-to-Actor Relationship: Not One-to-Many
- 2.5 - The Number of Entities Participating in Relationships
- 2.6 - The Referential Integrity Constraint
- 2.7 - The Many-to-Many Relationship
- 2.8 - The Example Database Expanded and Concatenated Primary Keys
- 2.9 - The Complete Example Database
- 2.10 - Data for the Example Database
-
Chapter 3 - Queries in SQL
- 3.1 - What is SQL?
- 3.2 - Simple SQL Queries and the Keywords SELECT and FROM
- 3.3 - Projection
- 3.4 - Column Aliases and the Keyword AS
- 3.5 - Selection on Text Columns and the Keyword WHERE
- 3.6 - Selection on Number Columns
- 3.7 - Selection on Currency Columns
- 3.8 - Selection on Date Columns
- 3.9 - Selection with NULL, is, and NOT
- 3.10 - Queries with the Keyword LIKE
- 3.11 - The Logical Operators AND and OR
- 3.12 - Problem Queries
-
Chapter 4 - Ordering, Calculating, and Grouping in Queries
- 4.1 - The Keyword DISTINCT
- 4.2 - The Keywords ORDER BY
- 4.3 - The Keywords ASC and DESC
- 4.4 - Ordering on More Than One Column
- 4.5 - Calculated Columns in Results
- 4.6 - The Date Functions YEAR, MONTH, and DAY
- 4.7 - The Built-In Function COUNT
- 4.8 - The Built-In Functions MAX, MIN, SUM, and AVG
- 4.9 - The Keywords GROUP BY
- 4.10 - GROUP BY and ORDER BY
- 4.11 - The Keyword HAVING
- 4.12 - Grouping by More Than One Column
- 4.13 - Problem Queries
-
Chapter 5 - Complex Queries and Join Queries
- 5.1 - Selection Queries with DISTINCT
- 5.2 - Selection Queries with Calculated Columns and DISTINCT
- 5.3 - Selection Queries with GROUP BY
- 5.4 - The Join and Qualified Column Names
- 5.5 - The Join with Projection
- 5.6 - The Cartesian Product
- 5.7 - Joins with Additional WHERE Conditions
- 5.8 - Joins with ORDER BY
- 5.9 - Joins with GROUP BY and HAVING
- 5.10 - Three-Way and Multi-Way Joins
- 5.11 - Joins with Calculated Columns and Built-In Functions
- 5.12 - Subqueries
- 5.13 - Problem Queries
- Chapter 6 - Creating Tables and Entering Data
- Annotated Bibliography of References for the Example Database
- Index
Product information
- Title: The SQL Programming Language
- Author(s):
- Release date: July 2009
- Publisher(s): Jones & Bartlett Learning
- ISBN: 9781449613211
You might also like
book
The Language of SQL, 3rd Edition
Get Started Fast with SQL! The only book you need to gain a quick working knowledge …
book
The Language of SQL, Second Edition
The Language of SQL, Second Edition Many SQL texts attempt to serve as an encyclopedic reference …
book
Effective SQL: 61 Specific Ways to Write Better SQL, First Edition
“Given the authors’ reputations, I expected to be impressed. I was blown away! . . . …
book
SQL in a Nutshell, 4th Edition
For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL …