Advertisement

© 2018

SQL Primer

An Accelerated Introduction to SQL Basics

Book

Table of contents

  1. Front Matter
    Pages i-xvii
  2. Rahul Batra
    Pages 1-9
  3. Rahul Batra
    Pages 11-24
  4. Rahul Batra
    Pages 25-36
  5. Rahul Batra
    Pages 37-46
  6. Rahul Batra
    Pages 47-56
  7. Rahul Batra
    Pages 57-64
  8. Rahul Batra
    Pages 65-74
  9. Rahul Batra
    Pages 75-85
  10. Rahul Batra
    Pages 87-93
  11. Rahul Batra
    Pages 95-107
  12. Rahul Batra
    Pages 109-121
  13. Rahul Batra
    Pages 123-132
  14. Rahul Batra
    Pages 133-140
  15. Rahul Batra
    Pages 141-149
  16. Rahul Batra
    Pages 151-164
  17. Rahul Batra
    Pages 165-173
  18. Rahul Batra
    Pages 175-178
  19. Rahul Batra
    Pages 179-182
  20. Rahul Batra
    Pages 183-187

About this book

Introduction

Build a core level of competency in SQL so you can recognize the parts of queries and write simple SQL statements. SQL knowledge is essential for anyone involved in programming, data science, and data management. This book covers features of SQL that are standardized and common across most database vendors. You will gain a base of knowledge that will prepare you to go deeper into the specifics of any database product you might encounter. 

Examples in the book are worked in PostgreSQL and SQLite, but the bulk of the examples are platform agnostic and will work on any database platform supporting SQL. Early in the book you learn about table design, the importance of keys as row identifiers, and essential query operations. You then move into more advanced topics such as grouping and summarizing, creating calculated fields, joining data from multiple tables when it makes business sense to do so, and more. Throughout the book, you are exposed to a set-based approach to the language and are provided a good grounding in subtle but important topics such as the effects of null value on query results.
 
With the explosion of data science, SQL has regained its prominence as a top skill to have for technologists and decision makers worldwide. SQL Primer will guide you from the very basics of SQL through to the mainstream features you need to have a solid, working knowledge of this important, data-oriented language.

What You'll Learn:
  • Create and populate your own database tables
  • Read SQL queries and understand what they are doing
  • Execute queries that get correct results
  • Bring together related rows from multiple tables
  • Group and sort data in support of reporting applications
  • Get a grip on nulls, normalization, and other key concepts
  • Employ subqueries, unions, and other advanced features

Keywords

SQL Aggregation and Grouping Database Normalization Atomicity ACID Properties Working in Sets Writing Queries Querying

Authors and affiliations

  1. 1.GurgaonIndia

About the authors

​Rahul Batra was first introduced to programming in 1996 with GWBASIC, but he did not seriously foray into programming until 2001 when he started learning C++. Along the way, Rahul dabbled in many other languages such as C, Ruby, Perl, Python, and Lisp. He has worked with databases such as PostgreSQL, Sybase ASA, and SQLite. He is passionate about sharing knowledge, especially with those who are just starting out. Rahul currently lives and works in Gurgaon, India.

Bibliographic information

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