Nelson Higher Education

Higher Education

The SQL Programming Language

  • Kirk Scott
  • ISBN-10: 0763766747
  • ISBN-13: 9780763766740
  • 0 Pages | Paperback
  • COPYRIGHT: 2010 Published
Request a Copy for Review


About the Product

An international standard, SQL, or structured query language, is a programming language used to store, manage, and retrieve data housed in relational databases. Ideal as a stand-alone primer or when used in conjunction with another introductory computer science text, The SQL Programming Language prepares you for future SQL programming courses offered within CS and CIS. With a clear, concise, and descriptive writing style, you will see real-world examples and cases of SQL functionality in database management. Each section focuses on a concrete concept which is illustrated with one or more example queries and the tables of results which they produce. The exercises parallel the examples, allowing you to reinforce the concepts introduced and explore them further. The book includes an example Microsoft Access database, allowing you to run the given example queries and see them in action, and also allows you to work the exercises and check your solutions against those provided.

Table of Contents

Chapter 1: Relational Databases, Entities, Tables, and Primary Keys
Chapter 2: Entities and Relationships
Chapter 3: Series in SQL
Chapter 4: Ordering, Calculating, and Grouping in Queries
Chapter 5: Complex Queries and Join Queries
Chapter 6: Creating Tables and Entering Data