• Competition Pool
    December 08 5:30am
    Lap Swim more »
  • CyberSec First Responder: Threat Detection and Response
    December 08 9:00am
    This workshop lasts 5 days. Overview: This course covers the duties of those who are responsible for monitoring and detecting security incidents in information systems and networks, and for executing a proper response to such incidents. Depending on the size of the organization, this individual more »
  • Al-Mutanabbi Street Starts Here
    December 08 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 08 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 »
  • Electro-Acoustic Ensemble Concert (E/A)
    December 08 7:30pm
    Come enjoy this great group.  There will be two listening times for you to choose from.  The first concert time is 7:30pm followed by another performance at 9pm.  more »
Thursday, December 8, 2016
    IU Calendar




    • Competition Pool
      December 08 5:30am
      Lap Swim more »
    • CyberSec First Responder: Threat Detection and Response
      December 08 9:00am
      This workshop lasts 5 days. Overview: This course covers the duties of those who are responsible for monitoring and detecting security incidents in information systems and networks, and for executing a proper response to such incidents. Depending on the size of the organization, this individual more »
    • Al-Mutanabbi Street Starts Here
      December 08 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 08 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 »
    • Electro-Acoustic Ensemble Concert (E/A)
      December 08 7:30pm
      Come enjoy this great group.  There will be two listening times for you to choose from.  The first concert time is 7:30pm followed by another performance at 9pm.  more »
    Thursday, December 8, 2016
      IU Calendar




      • Competition Pool
        December 08 5:30am
        Lap Swim more »
      • CyberSec First Responder: Threat Detection and Response
        December 08 9:00am
        This workshop lasts 5 days. Overview: This course covers the duties of those who are responsible for monitoring and detecting security incidents in information systems and networks, and for executing a proper response to such incidents. Depending on the size of the organization, this individual more »
      • Al-Mutanabbi Street Starts Here
        December 08 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 08 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 »
      • Electro-Acoustic Ensemble Concert (E/A)
        December 08 7:30pm
        Come enjoy this great group.  There will be two listening times for you to choose from.  The first concert time is 7:30pm followed by another performance at 9pm.  more »
      Thursday, December 8, 2016
        IU Calendar




        • Competition Pool
          December 08 5:30am
          Lap Swim more »
        • CyberSec First Responder: Threat Detection and Response
          December 08 9:00am
          This workshop lasts 5 days. Overview: This course covers the duties of those who are responsible for monitoring and detecting security incidents in information systems and networks, and for executing a proper response to such incidents. Depending on the size of the organization, this individual more »
        • Al-Mutanabbi Street Starts Here
          December 08 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 08 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 »
        • Electro-Acoustic Ensemble Concert (E/A)
          December 08 7:30pm
          Come enjoy this great group.  There will be two listening times for you to choose from.  The first concert time is 7:30pm followed by another performance at 9pm.  more »
        Thursday, December 8, 2016

          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




          • Competition Pool
            December 08 5:30am
            Lap Swim more »
          • CyberSec First Responder: Threat Detection and Response
            December 08 9:00am
            This workshop lasts 5 days. Overview: This course covers the duties of those who are responsible for monitoring and detecting security incidents in information systems and networks, and for executing a proper response to such incidents. Depending on the size of the organization, this individual more »
          • Al-Mutanabbi Street Starts Here
            December 08 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 08 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 »
          • Electro-Acoustic Ensemble Concert (E/A)
            December 08 7:30pm
            Come enjoy this great group.  There will be two listening times for you to choose from.  The first concert time is 7:30pm followed by another performance at 9pm.  more »
          Thursday, December 8, 2016