• CLOSED
    December 17 12:00am
    The competition lap pool for lap swim is closed. more »
  • Holiday Training
    December 18 12:00am
    Holiday Training more »
  • Competition Pool
    December 18 5:30am
    lap swim more »
  • Competition Pool
    December 18 11:00am
    Lap Swim more »
  • Instructional Pool
    December 18 2:00pm
    Lap Swim more »
Sunday, December 17, 2017
    IU Calendar




    • CLOSED
      December 17 12:00am
      The competition lap pool for lap swim is closed. more »
    • Holiday Training
      December 18 12:00am
      Holiday Training more »
    • Competition Pool
      December 18 5:30am
      lap swim more »
    • Competition Pool
      December 18 11:00am
      Lap Swim more »
    • Instructional Pool
      December 18 2:00pm
      Lap Swim more »
    Sunday, December 17, 2017
      IU Calendar




      • CLOSED
        December 17 12:00am
        The competition lap pool for lap swim is closed. more »
      • Holiday Training
        December 18 12:00am
        Holiday Training more »
      • Competition Pool
        December 18 5:30am
        lap swim more »
      • Competition Pool
        December 18 11:00am
        Lap Swim more »
      • Instructional Pool
        December 18 2:00pm
        Lap Swim more »
      Sunday, December 17, 2017
        IU Calendar




        • CLOSED
          December 17 12:00am
          The competition lap pool for lap swim is closed. more »
        • Holiday Training
          December 18 12:00am
          Holiday Training more »
        • Competition Pool
          December 18 5:30am
          lap swim more »
        • Competition Pool
          December 18 11:00am
          Lap Swim more »
        • Instructional Pool
          December 18 2:00pm
          Lap Swim more »
        Sunday, December 17, 2017

          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.

          IU Calendar




          • CLOSED
            December 17 12:00am
            The competition lap pool for lap swim is closed. more »
          • Holiday Training
            December 18 12:00am
            Holiday Training more »
          • Competition Pool
            December 18 5:30am
            lap swim more »
          • Competition Pool
            December 18 11:00am
            Lap Swim more »
          • Instructional Pool
            December 18 2:00pm
            Lap Swim more »
          Sunday, December 17, 2017