This workshop lasts 3 hours.
Building on what was covered in SQL: Data Retrieval, this workshop is intended for anyone wants to learn how to use SQL to add, update, and delete data and learn advanced data retrieval techniques. In addition, participants will learn basic concepts of database transaction processing.
What You'll learn
use UNION to select similar types of information from unrelated tables
use HAVING to filter results when doing grouping
use SELF-JOINs to create a relationship between a table and itself
use INSERT to add data to a table
use UPDATE to modify existing records in a table
use DELETE to delete existing records from a table
work with transactions to control data modification operations
What you need to know
retrieve records from a single table
use joins to retrieve records from multiple related tables
use WHERE to search for or limit records returned by a query
use aggregate functions and field operations
work with null values in queries
If you don't have those skills, consider first taking the workshop:
There are no upcoming dates for this event.