• Joint meeting of the LFSOP Board of Visitors and Alumni Board
    October 19 12:00am
    For additional information, please contact Sharon Holland at shollan@iupui.edu. more »
  • Competition Pool
    October 19 5:30am
    lap swim more »
  • Mental Health Awareness Day
    October 19 10:00am
    Join us on Thursday, October 19th from 10 am-2 pm in the Campus Center Atrium for Mental Health Awareness Day! We will have music, snacks, free depression screenings, and information/resources related to mental health. Please contact IUPUI CAPS at (317) 274-2548 for more information.  more »
  • Competition Pool
    October 19 11:00am
    lap swim more »
  • How Does it Feel to Be a Problem: Being Young and Arab in America
    October 19 2:30pm
    Faculty and student discussion with Professor Moustafa Bayoumi, regarding his highly-acclaimed, best-selling book How Does it Feel to Be a Problem: Being Young and Arab in America. more »
Wednesday, October 18, 2017
    IU Calendar




    • Joint meeting of the LFSOP Board of Visitors and Alumni Board
      October 19 12:00am
      For additional information, please contact Sharon Holland at shollan@iupui.edu. more »
    • Competition Pool
      October 19 5:30am
      lap swim more »
    • Mental Health Awareness Day
      October 19 10:00am
      Join us on Thursday, October 19th from 10 am-2 pm in the Campus Center Atrium for Mental Health Awareness Day! We will have music, snacks, free depression screenings, and information/resources related to mental health. Please contact IUPUI CAPS at (317) 274-2548 for more information.  more »
    • Competition Pool
      October 19 11:00am
      lap swim more »
    • How Does it Feel to Be a Problem: Being Young and Arab in America
      October 19 2:30pm
      Faculty and student discussion with Professor Moustafa Bayoumi, regarding his highly-acclaimed, best-selling book How Does it Feel to Be a Problem: Being Young and Arab in America. more »
    Wednesday, October 18, 2017
      IU Calendar




      • Joint meeting of the LFSOP Board of Visitors and Alumni Board
        October 19 12:00am
        For additional information, please contact Sharon Holland at shollan@iupui.edu. more »
      • Competition Pool
        October 19 5:30am
        lap swim more »
      • Mental Health Awareness Day
        October 19 10:00am
        Join us on Thursday, October 19th from 10 am-2 pm in the Campus Center Atrium for Mental Health Awareness Day! We will have music, snacks, free depression screenings, and information/resources related to mental health. Please contact IUPUI CAPS at (317) 274-2548 for more information.  more »
      • Competition Pool
        October 19 11:00am
        lap swim more »
      • How Does it Feel to Be a Problem: Being Young and Arab in America
        October 19 2:30pm
        Faculty and student discussion with Professor Moustafa Bayoumi, regarding his highly-acclaimed, best-selling book How Does it Feel to Be a Problem: Being Young and Arab in America. more »
      Wednesday, October 18, 2017
        IU Calendar




        • Joint meeting of the LFSOP Board of Visitors and Alumni Board
          October 19 12:00am
          For additional information, please contact Sharon Holland at shollan@iupui.edu. more »
        • Competition Pool
          October 19 5:30am
          lap swim more »
        • Mental Health Awareness Day
          October 19 10:00am
          Join us on Thursday, October 19th from 10 am-2 pm in the Campus Center Atrium for Mental Health Awareness Day! We will have music, snacks, free depression screenings, and information/resources related to mental health. Please contact IUPUI CAPS at (317) 274-2548 for more information.  more »
        • Competition Pool
          October 19 11:00am
          lap swim more »
        • How Does it Feel to Be a Problem: Being Young and Arab in America
          October 19 2:30pm
          Faculty and student discussion with Professor Moustafa Bayoumi, regarding his highly-acclaimed, best-selling book How Does it Feel to Be a Problem: Being Young and Arab in America. more »
        Wednesday, October 18, 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




          • Joint meeting of the LFSOP Board of Visitors and Alumni Board
            October 19 12:00am
            For additional information, please contact Sharon Holland at shollan@iupui.edu. more »
          • Competition Pool
            October 19 5:30am
            lap swim more »
          • Mental Health Awareness Day
            October 19 10:00am
            Join us on Thursday, October 19th from 10 am-2 pm in the Campus Center Atrium for Mental Health Awareness Day! We will have music, snacks, free depression screenings, and information/resources related to mental health. Please contact IUPUI CAPS at (317) 274-2548 for more information.  more »
          • Competition Pool
            October 19 11:00am
            lap swim more »
          • How Does it Feel to Be a Problem: Being Young and Arab in America
            October 19 2:30pm
            Faculty and student discussion with Professor Moustafa Bayoumi, regarding his highly-acclaimed, best-selling book How Does it Feel to Be a Problem: Being Young and Arab in America. more »
          Wednesday, October 18, 2017