Chapter-5-SQL Data Manipulation Book Database systems Carolyn E. Begg, Thomas Connolly

• Purpose and importance of SQL.
• How to retrieve data from database using SELECT and:
• Use compound WHERE conditions.
• Sort query results using ORDER BY.
• Use aggregate functions.
• Group data using GROUP BY and HAVING.
• Use subqueries.
• Join tables together.
• Perform set operations (UNION, INTERSECT, EXCEPT).
• How to update database using INSERT, UPDATE, and DELETE.

Attached Files

chapter-5-SQL Data Manipulation Carolyn E. Begg, Thomas Connolly.ppt (4.32 MB, 735 views)

__________________