Overview
Provides a foundation in the most important language when working with data
Focuses on the most used parts of SQL, without getting bogged down in arcane details
Teaches database-agnostic SQL that works on almost any database system
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (19 chapters)
-
Front Matter
Keywords
About this book
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
Who This Book Is For
Anyone new to SQL who is looking for step-by-step guidance toward understanding and writing SQL queries. The book is aimed at those who encounter SQL statements often in their work, and provides a sound baseline useful across all SQL database systems. Programmers, database managers, data scientists, and business analysts all can benefit from the baseline of SQL knowledge provided in this book.
Authors and Affiliations
About the author
Bibliographic Information
Book Title: SQL Primer
Book Subtitle: An Accelerated Introduction to SQL Basics
Authors: Rahul Batra
DOI: https://doi.org/10.1007/978-1-4842-3576-8
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books
Copyright Information: Rahul Batra 2018
Softcover ISBN: 978-1-4842-3575-1Published: 16 June 2018
eBook ISBN: 978-1-4842-3576-8Published: 15 June 2018
Edition Number: 1
Number of Pages: XVII, 194
Number of Illustrations: 14 b/w illustrations
Topics: Database Management