Advertisement

Beginning SQL Queries

From Novice to Professional

  • Clare¬†Churcher

Table of contents

  1. Front Matter
    Pages i-xxii
  2. Clare Churcher
    Pages 1-13
  3. Clare Churcher
    Pages 15-32
  4. Clare Churcher
    Pages 33-49
  5. Clare Churcher
    Pages 51-66
  6. Clare Churcher
    Pages 67-83
  7. Clare Churcher
    Pages 85-97
  8. Clare Churcher
    Pages 99-128
  9. Clare Churcher
    Pages 129-146
  10. Clare Churcher
    Pages 147-159
  11. Clare Churcher
    Pages 161-173
  12. Clare Churcher
    Pages 175-194
  13. Clare Churcher
    Pages 195-210
  14. Clare Churcher
    Pages 211-212
  15. Clare Churcher
    Pages 213-231
  16. Back Matter
    Pages 233-234

About this book

Introduction

Get started on mastering the one language binding the entire database industry. That language is SQL, and how it works is must-have knowledge for anyone involved with relational databases, and surprisingly also for anyone involved with NoSQL databases. SQL is universally used in querying and reporting on large data sets in order to generate knowledge to drive business decisions.

Good knowledge of SQL is crucial to anyone working with databases, because it is with SQL that you retrieve data, manipulate data, and generate business results. Every relational database supports SQL for its expressiveness in writing queries underlying reports and business intelligence dashboards. Knowing how to write good queries is the foundation for all work done in SQL, and it is a foundation that Clare Churcher's book, Beginning SQL Queries, 2nd Edition, lays well.

  • Write simple queries to extract data from a single table
  • Combine data from many tables into one business result using set operations
  • Translate natural language questions into database queries providing meaningful information to the business
  • Avoid errors associated with duplicated and null values
  • Summarize data with amazing ease using the newly-added feature of window functions
  • Tackle tricky queries with confidence that you are generating correct results
  • Investigate and understand the effects of indexes on the efficiency of queries


Keywords

SQL database database design databases design language relational database

Authors and affiliations

  • Clare¬†Churcher
    • 1
  1. 1.Studio B Productions Great NeckUSA

Bibliographic information

Industry Sectors
Pharma
Automotive
Biotechnology
Finance, Business & Banking
Electronics
IT & Software
Telecommunications
Consumer Packaged Goods
Energy, Utilities & Environment
Engineering