TIM-5020 v5

Johnson, E. (2019). Database fundamentals livelessons [Video file]. Addison-Wesley Professional.

Watch Lesson 4 Video – Manipulating Data.
This video explains what data manipulation language (DML) is and how it is used to select from and insert data into the database tables.

Viescas, J. L. (2018). SQL queries for mere mortals: A hands-on guide to data manipulation in SQL (4th ed.). Addison-Wesley/Pearson Education.

Read Chapter 4: Creating a Simple Query.
This chapter describes how to create a simple query using SQL SELECT statements to find records in the database based on specific criteria.
Read Chapter 8: Inner Joins.
This chapter explains what a JOIN statement is and how this query technique is used to select data from more than one table in the database.
Read Chapter 13: Grouping Data.
This chapter details how to use SELECT and GROUP BY and aggregate functions to select data tables in the database.