Popular Selections:
academics tabathletics tabstudent life tabfeatured events tab
 

About This Event

Summary

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:

SQL: Data Retrieval

Bookmark and Share

Event Schedule

There are no upcoming dates for this event.