• CLOSED
    December 10 12:00am
    Facility closed more »
  • JAGS Invite
    December 10 12:00am
    Swim meet more »
  • Al-Mutanabbi Street Starts Here
    December 10 10:00am
    A car bomb exploded in 2007 in the historic intellectual center of Baghdad, al-Mutanabbi Street. More than 130 people died or were wounded, but the place escaped geographic bounds to become a global movement for the free exchange of ideas. View selections from a rare collection of artist's books and broadsides that continue to be generated a more »
  • Undergraduate Student Exhibition
    December 10 10:00am
    The Undergraduate Student Exhibition is juried by Liz Garvey of Simon Garvey Art Access Gallery in New York. Works are typically selected from hundreds of submission across a wide variety of media. more »
  • CLOSED
    December 11 12:00am
    The competition lap pool for lap swim is closed. more »
Saturday, December 10, 2016
    IU Calendar




    • CLOSED
      December 10 12:00am
      Facility closed more »
    • JAGS Invite
      December 10 12:00am
      Swim meet more »
    • Al-Mutanabbi Street Starts Here
      December 10 10:00am
      A car bomb exploded in 2007 in the historic intellectual center of Baghdad, al-Mutanabbi Street. More than 130 people died or were wounded, but the place escaped geographic bounds to become a global movement for the free exchange of ideas. View selections from a rare collection of artist's books and broadsides that continue to be generated a more »
    • Undergraduate Student Exhibition
      December 10 10:00am
      The Undergraduate Student Exhibition is juried by Liz Garvey of Simon Garvey Art Access Gallery in New York. Works are typically selected from hundreds of submission across a wide variety of media. more »
    • CLOSED
      December 11 12:00am
      The competition lap pool for lap swim is closed. more »
    Saturday, December 10, 2016
      IU Calendar




      • CLOSED
        December 10 12:00am
        Facility closed more »
      • JAGS Invite
        December 10 12:00am
        Swim meet more »
      • Al-Mutanabbi Street Starts Here
        December 10 10:00am
        A car bomb exploded in 2007 in the historic intellectual center of Baghdad, al-Mutanabbi Street. More than 130 people died or were wounded, but the place escaped geographic bounds to become a global movement for the free exchange of ideas. View selections from a rare collection of artist's books and broadsides that continue to be generated a more »
      • Undergraduate Student Exhibition
        December 10 10:00am
        The Undergraduate Student Exhibition is juried by Liz Garvey of Simon Garvey Art Access Gallery in New York. Works are typically selected from hundreds of submission across a wide variety of media. more »
      • CLOSED
        December 11 12:00am
        The competition lap pool for lap swim is closed. more »
      Saturday, December 10, 2016
        IU Calendar




        • CLOSED
          December 10 12:00am
          Facility closed more »
        • JAGS Invite
          December 10 12:00am
          Swim meet more »
        • Al-Mutanabbi Street Starts Here
          December 10 10:00am
          A car bomb exploded in 2007 in the historic intellectual center of Baghdad, al-Mutanabbi Street. More than 130 people died or were wounded, but the place escaped geographic bounds to become a global movement for the free exchange of ideas. View selections from a rare collection of artist's books and broadsides that continue to be generated a more »
        • Undergraduate Student Exhibition
          December 10 10:00am
          The Undergraduate Student Exhibition is juried by Liz Garvey of Simon Garvey Art Access Gallery in New York. Works are typically selected from hundreds of submission across a wide variety of media. more »
        • CLOSED
          December 11 12:00am
          The competition lap pool for lap swim is closed. more »
        Saturday, December 10, 2016

          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 10 12:00am
            Facility closed more »
          • JAGS Invite
            December 10 12:00am
            Swim meet more »
          • Al-Mutanabbi Street Starts Here
            December 10 10:00am
            A car bomb exploded in 2007 in the historic intellectual center of Baghdad, al-Mutanabbi Street. More than 130 people died or were wounded, but the place escaped geographic bounds to become a global movement for the free exchange of ideas. View selections from a rare collection of artist's books and broadsides that continue to be generated a more »
          • Undergraduate Student Exhibition
            December 10 10:00am
            The Undergraduate Student Exhibition is juried by Liz Garvey of Simon Garvey Art Access Gallery in New York. Works are typically selected from hundreds of submission across a wide variety of media. more »
          • CLOSED
            December 11 12:00am
            The competition lap pool for lap swim is closed. more »
          Saturday, December 10, 2016