Bala Speed. SQL Essentials

Amazon Digital Services LLC, 2016. — 36 p. — ASIN: B01M7QPAQ7.This book assumes a familiarity with relational data tables.
Readers should have access to a query environment that allows viewing data tables and running SQL
queries against a database or data warehouse.PrerequisitesInstructions
Joining tables
SQL
Single-table operations
Selecting columns
Selecting rows
Sorting result tables
Counting rows
Summing totals
Cartesian Joins
Retrieving data from multiple tables
Distinct values
Union
Subqueries
Updating data
Inserting records
Updating records
Deleting records
NULL valuesAppendix A – Implementation variations
Appendix B – Summary of operators
Appendix C – Other statements
Appendix D – Test environment.