• Holiday Training
    December 18 12:00am
    Holiday Training more »
  • Instructional Pool
    December 18 2:00pm
    Lap Swim more »
  • Competition Pool
    December 19 5:30am
    lap swim more »
  • Competition Pool
    December 19 11:00am
    lap swim more »
  • Roncalli Swim and Dive Triangular Meet
    December 19 4:30pm
    Swim meet hosted by Roncalli High School more »
Monday, December 18, 2017
    IU Calendar




    • Holiday Training
      December 18 12:00am
      Holiday Training more »
    • Instructional Pool
      December 18 2:00pm
      Lap Swim more »
    • Competition Pool
      December 19 5:30am
      lap swim more »
    • Competition Pool
      December 19 11:00am
      lap swim more »
    • Roncalli Swim and Dive Triangular Meet
      December 19 4:30pm
      Swim meet hosted by Roncalli High School more »
    Monday, December 18, 2017
      IU Calendar




      • Holiday Training
        December 18 12:00am
        Holiday Training more »
      • Instructional Pool
        December 18 2:00pm
        Lap Swim more »
      • Competition Pool
        December 19 5:30am
        lap swim more »
      • Competition Pool
        December 19 11:00am
        lap swim more »
      • Roncalli Swim and Dive Triangular Meet
        December 19 4:30pm
        Swim meet hosted by Roncalli High School more »
      Monday, December 18, 2017
        IU Calendar




        • Holiday Training
          December 18 12:00am
          Holiday Training more »
        • Instructional Pool
          December 18 2:00pm
          Lap Swim more »
        • Competition Pool
          December 19 5:30am
          lap swim more »
        • Competition Pool
          December 19 11:00am
          lap swim more »
        • Roncalli Swim and Dive Triangular Meet
          December 19 4:30pm
          Swim meet hosted by Roncalli High School more »
        Monday, December 18, 2017

          About This Event

          Summary

          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

          Available Downloads

          • 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:

          Bookmark and Share

          Event Schedule

          There are no upcoming dates for this event.

          IU Calendar




          • Holiday Training
            December 18 12:00am
            Holiday Training more »
          • Instructional Pool
            December 18 2:00pm
            Lap Swim more »
          • Competition Pool
            December 19 5:30am
            lap swim more »
          • Competition Pool
            December 19 11:00am
            lap swim more »
          • Roncalli Swim and Dive Triangular Meet
            December 19 4:30pm
            Swim meet hosted by Roncalli High School more »
          Monday, December 18, 2017