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:
IT – Informatics & Communications Technology Complex (ICTC)
Room: IT 121
535 W. Michigan St.
Indianapolis, IN 46202
There are no upcoming dates for this event.