• Competition Pool
    January 19 5:30am
    lap swim more »
  • Outlook 2016: Managing Your Email
    January 19 9:00am
    This workshop lasts 2 hours, and is part of the certificate series Office 2016 Productivity Is your Outlook Exchange account a mess? Are you having trouble finding the messages that you need? Are you spending way too much time sorting through files and folders? Have you almost reached your Outlook Exc more »
  • Hans Op de Beeck | Staging Silence (2)
    January 19 10:00am
    In Belgian artist Hans Op de Beeck's film, the real and the imaginary fuse as anonymous hands assemble miniature dioramas of timeless, dreamlike settings. more »
  • Tom Sachs | Radiant City: Paintings 2000-2016
    January 19 10:00am
    A major survey exhibition of Tom Sachs’ paintings showcasing the artist’s ongoing interest in combining mass-produced pop cultural icons with a hand made aesthetic. This exhibition is made possible in part by the generous support of Julie and David Eskenazi. more »
  • Craig McDaniel + Jean Robertson | Close Reading
    January 19 10:00am
    In Close Reading, Herron faculty members Jean Robertson and Craig McDaniel explore the relationship of visual and verbal modes of communicating and expressing meaning. more »
Thursday, January 19, 2017
    IU Calendar




    • Competition Pool
      January 19 5:30am
      lap swim more »
    • Outlook 2016: Managing Your Email
      January 19 9:00am
      This workshop lasts 2 hours, and is part of the certificate series Office 2016 Productivity Is your Outlook Exchange account a mess? Are you having trouble finding the messages that you need? Are you spending way too much time sorting through files and folders? Have you almost reached your Outlook Exc more »
    • Hans Op de Beeck | Staging Silence (2)
      January 19 10:00am
      In Belgian artist Hans Op de Beeck's film, the real and the imaginary fuse as anonymous hands assemble miniature dioramas of timeless, dreamlike settings. more »
    • Tom Sachs | Radiant City: Paintings 2000-2016
      January 19 10:00am
      A major survey exhibition of Tom Sachs’ paintings showcasing the artist’s ongoing interest in combining mass-produced pop cultural icons with a hand made aesthetic. This exhibition is made possible in part by the generous support of Julie and David Eskenazi. more »
    • Craig McDaniel + Jean Robertson | Close Reading
      January 19 10:00am
      In Close Reading, Herron faculty members Jean Robertson and Craig McDaniel explore the relationship of visual and verbal modes of communicating and expressing meaning. more »
    Thursday, January 19, 2017
      IU Calendar




      • Competition Pool
        January 19 5:30am
        lap swim more »
      • Outlook 2016: Managing Your Email
        January 19 9:00am
        This workshop lasts 2 hours, and is part of the certificate series Office 2016 Productivity Is your Outlook Exchange account a mess? Are you having trouble finding the messages that you need? Are you spending way too much time sorting through files and folders? Have you almost reached your Outlook Exc more »
      • Hans Op de Beeck | Staging Silence (2)
        January 19 10:00am
        In Belgian artist Hans Op de Beeck's film, the real and the imaginary fuse as anonymous hands assemble miniature dioramas of timeless, dreamlike settings. more »
      • Tom Sachs | Radiant City: Paintings 2000-2016
        January 19 10:00am
        A major survey exhibition of Tom Sachs’ paintings showcasing the artist’s ongoing interest in combining mass-produced pop cultural icons with a hand made aesthetic. This exhibition is made possible in part by the generous support of Julie and David Eskenazi. more »
      • Craig McDaniel + Jean Robertson | Close Reading
        January 19 10:00am
        In Close Reading, Herron faculty members Jean Robertson and Craig McDaniel explore the relationship of visual and verbal modes of communicating and expressing meaning. more »
      Thursday, January 19, 2017
        IU Calendar




        • Competition Pool
          January 19 5:30am
          lap swim more »
        • Outlook 2016: Managing Your Email
          January 19 9:00am
          This workshop lasts 2 hours, and is part of the certificate series Office 2016 Productivity Is your Outlook Exchange account a mess? Are you having trouble finding the messages that you need? Are you spending way too much time sorting through files and folders? Have you almost reached your Outlook Exc more »
        • Hans Op de Beeck | Staging Silence (2)
          January 19 10:00am
          In Belgian artist Hans Op de Beeck's film, the real and the imaginary fuse as anonymous hands assemble miniature dioramas of timeless, dreamlike settings. more »
        • Tom Sachs | Radiant City: Paintings 2000-2016
          January 19 10:00am
          A major survey exhibition of Tom Sachs’ paintings showcasing the artist’s ongoing interest in combining mass-produced pop cultural icons with a hand made aesthetic. This exhibition is made possible in part by the generous support of Julie and David Eskenazi. more »
        • Craig McDaniel + Jean Robertson | Close Reading
          January 19 10:00am
          In Close Reading, Herron faculty members Jean Robertson and Craig McDaniel explore the relationship of visual and verbal modes of communicating and expressing meaning. more »
        Thursday, January 19, 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




          • Competition Pool
            January 19 5:30am
            lap swim more »
          • Outlook 2016: Managing Your Email
            January 19 9:00am
            This workshop lasts 2 hours, and is part of the certificate series Office 2016 Productivity Is your Outlook Exchange account a mess? Are you having trouble finding the messages that you need? Are you spending way too much time sorting through files and folders? Have you almost reached your Outlook Exc more »
          • Hans Op de Beeck | Staging Silence (2)
            January 19 10:00am
            In Belgian artist Hans Op de Beeck's film, the real and the imaginary fuse as anonymous hands assemble miniature dioramas of timeless, dreamlike settings. more »
          • Tom Sachs | Radiant City: Paintings 2000-2016
            January 19 10:00am
            A major survey exhibition of Tom Sachs’ paintings showcasing the artist’s ongoing interest in combining mass-produced pop cultural icons with a hand made aesthetic. This exhibition is made possible in part by the generous support of Julie and David Eskenazi. more »
          • Craig McDaniel + Jean Robertson | Close Reading
            January 19 10:00am
            In Close Reading, Herron faculty members Jean Robertson and Craig McDaniel explore the relationship of visual and verbal modes of communicating and expressing meaning. more »
          Thursday, January 19, 2017