• Competition Pool
    February 20 5:30am
    lap swim more »
  • Hans Op de Beeck | Staging Silence (2)
    February 20 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 »
  • Aligning Course Learning Outcomes
    February 20 12:00pm
    As IUPUI begins the process of reviewing general education courses over the coming academic year, faculty who teach these courses will want to ensure that their course learning outcomes are properly aligned with the appropriate IUPUI Principles of Undergraduate Learning (PULs) and statewide learning outcomes. This 1 1/2 -hour brown bag workshop more »
  • Inside and Out: The People of IUPUI
    February 20 4:00pm
    Join us for art, food, drinks - and most importantly conversation about the diverse stories and people of IUPUI. Photographer and videographer Aaron Turner will share a collection of photos from IUPUI's diverse community.   Brief program at 4:30pm. Hosted by the IUPUI Multicultural Center. more »
  • Competition Pool
    February 20 5:00pm
    lap swim more »
Monday, February 20, 2017
    IU Calendar




    • Competition Pool
      February 20 5:30am
      lap swim more »
    • Hans Op de Beeck | Staging Silence (2)
      February 20 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 »
    • Aligning Course Learning Outcomes
      February 20 12:00pm
      As IUPUI begins the process of reviewing general education courses over the coming academic year, faculty who teach these courses will want to ensure that their course learning outcomes are properly aligned with the appropriate IUPUI Principles of Undergraduate Learning (PULs) and statewide learning outcomes. This 1 1/2 -hour brown bag workshop more »
    • Inside and Out: The People of IUPUI
      February 20 4:00pm
      Join us for art, food, drinks - and most importantly conversation about the diverse stories and people of IUPUI. Photographer and videographer Aaron Turner will share a collection of photos from IUPUI's diverse community.   Brief program at 4:30pm. Hosted by the IUPUI Multicultural Center. more »
    • Competition Pool
      February 20 5:00pm
      lap swim more »
    Monday, February 20, 2017
      IU Calendar




      • Competition Pool
        February 20 5:30am
        lap swim more »
      • Hans Op de Beeck | Staging Silence (2)
        February 20 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 »
      • Aligning Course Learning Outcomes
        February 20 12:00pm
        As IUPUI begins the process of reviewing general education courses over the coming academic year, faculty who teach these courses will want to ensure that their course learning outcomes are properly aligned with the appropriate IUPUI Principles of Undergraduate Learning (PULs) and statewide learning outcomes. This 1 1/2 -hour brown bag workshop more »
      • Inside and Out: The People of IUPUI
        February 20 4:00pm
        Join us for art, food, drinks - and most importantly conversation about the diverse stories and people of IUPUI. Photographer and videographer Aaron Turner will share a collection of photos from IUPUI's diverse community.   Brief program at 4:30pm. Hosted by the IUPUI Multicultural Center. more »
      • Competition Pool
        February 20 5:00pm
        lap swim more »
      Monday, February 20, 2017
        IU Calendar




        • Competition Pool
          February 20 5:30am
          lap swim more »
        • Hans Op de Beeck | Staging Silence (2)
          February 20 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 »
        • Aligning Course Learning Outcomes
          February 20 12:00pm
          As IUPUI begins the process of reviewing general education courses over the coming academic year, faculty who teach these courses will want to ensure that their course learning outcomes are properly aligned with the appropriate IUPUI Principles of Undergraduate Learning (PULs) and statewide learning outcomes. This 1 1/2 -hour brown bag workshop more »
        • Inside and Out: The People of IUPUI
          February 20 4:00pm
          Join us for art, food, drinks - and most importantly conversation about the diverse stories and people of IUPUI. Photographer and videographer Aaron Turner will share a collection of photos from IUPUI's diverse community.   Brief program at 4:30pm. Hosted by the IUPUI Multicultural Center. more »
        • Competition Pool
          February 20 5:00pm
          lap swim more »
        Monday, February 20, 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




          • Competition Pool
            February 20 5:30am
            lap swim more »
          • Hans Op de Beeck | Staging Silence (2)
            February 20 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 »
          • Aligning Course Learning Outcomes
            February 20 12:00pm
            As IUPUI begins the process of reviewing general education courses over the coming academic year, faculty who teach these courses will want to ensure that their course learning outcomes are properly aligned with the appropriate IUPUI Principles of Undergraduate Learning (PULs) and statewide learning outcomes. This 1 1/2 -hour brown bag workshop more »
          • Inside and Out: The People of IUPUI
            February 20 4:00pm
            Join us for art, food, drinks - and most importantly conversation about the diverse stories and people of IUPUI. Photographer and videographer Aaron Turner will share a collection of photos from IUPUI's diverse community.   Brief program at 4:30pm. Hosted by the IUPUI Multicultural Center. more »
          • Competition Pool
            February 20 5:00pm
            lap swim more »
          Monday, February 20, 2017