Book description
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.- 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
Table of contents
- Cover
- Front Matter
- 1. An Introduction to SQL
- 2. Getting Your Database Ready
- 3. The Benefit of Constraints
- 4. Operations on Tables
- 5. Writing Basic Queries
- 6. Manipulating Data
- 7. Organizing Your Data
- 8. Doing More with Queries
- 9. Calculated Fields
- 10. Aggregation and Grouping
- 11. Understanding Joins
- 12. Subqueries
- 13. Working in Sets
- 14. Views
- 15. Indexing
- 16. Access Control Statements
- Further Reading
- Database Management Systems and Tools
- A History of SQL and Relational Databases
- Back Matter
Product information
- Title: SQL Primer: An Accelerated Introduction to SQL Basics
- Author(s):
- Release date: June 2018
- Publisher(s): Apress
- ISBN: 9781484235768
You might also like
book
Getting Started with SQL
Businesses are gathering data today at exponential rates and yet few people know how to access …
book
Head First SQL
Is your data dragging you down? Are your tables all tangled up? Well we've got the …
video
Introducing SQL and Relational Databases
Start on the road to mastery of SQL and databases: two of the most important topics …
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! . . . …