Murach - Chapter 18 Textbook Code

• How to select data from a single table
• How to use an alias for a column
• How to select rows with a LIMIT clause
• How to select rows with a WHERE clause
• How to use the logical operators
• How to use the IS NULL operator
• How to use the LIKE operator
• How to sort rows with an ORDER BY clause
• How to select data from multiple tables
• When and how to use table aliases
• How to code summary queries
• How to group queries by column
• How to code subqueries
• How to code correlated subqueries
• How to insert rows
• How to update rows
• How to delete rows

Back