Learn how to combine WHERE clauses to create sophisticated search conditions. Also learn how to use the NOT and IN operators.
Learn what wildcards are, how they are used, and how to perform wildcard searches using the LIKE operator for sophisticated filtering.
Learn what SQL is and review some basic database terminology.
Learn how to use the SELECT statement to retrieve one or more columns of data from a table. Code commenting and returning distinct values are introduced too.
Learn how to use the SELECT statement’s ORDER BY clause to sort retrieved data as needed.
Learn how to use the SELECT statement’s WHERE clause to specify search conditions.