• Competition Lap Pool Closed
    September 25 12:00am
    The competition lap pool for lap swim is closed. more »
  • 7v7 Soccer League
    September 25 12:00am
    Play runs Sept. 11 to Oct. 10. All intramural participants must create an account on IMLeagues.com/iupui. Co-Rec Leagues play on Sundays and Wednesdays. Octane League plays on Sundays. Recreation League plays on Tuesdays. Questions? Contact Matthew Jones - Coordinator of Intramural Sports - 317.278.9939 - mj221@iupui.edu. more »
  • Bubble Ball/Knocker Ball
    September 25 12:00am
    New intramural sport where participants climb into a bublle and play, bounce, roll, and enjoy the excitement. Team entry fee is $60. All intramurals participants are required to create an account on IMLeagues.com/iupui. Questions? Contact Matthew Jones - Coordinator of Intramural Sports - 317.278.9939 - mj221@iupui.edu. more »
  • Fall Career Week, September 26-30
    September 26 12:00am
    This week of career events offers something for everyone! Students, faculty, employers, and alumni share career expertise you won't want to miss. Attend sessions to learn more about majors, career paths, job searching, and more. Most events are in the IUPUI Campus Center. Mark your calendars for Fall Career Week 2016: Sep more »
  • Competition Pool
    September 26 5:30am
    The competition pool for lap swim is open more »
Sunday, September 25, 2016
    IU Calendar




    • Competition Lap Pool Closed
      September 25 12:00am
      The competition lap pool for lap swim is closed. more »
    • 7v7 Soccer League
      September 25 12:00am
      Play runs Sept. 11 to Oct. 10. All intramural participants must create an account on IMLeagues.com/iupui. Co-Rec Leagues play on Sundays and Wednesdays. Octane League plays on Sundays. Recreation League plays on Tuesdays. Questions? Contact Matthew Jones - Coordinator of Intramural Sports - 317.278.9939 - mj221@iupui.edu. more »
    • Bubble Ball/Knocker Ball
      September 25 12:00am
      New intramural sport where participants climb into a bublle and play, bounce, roll, and enjoy the excitement. Team entry fee is $60. All intramurals participants are required to create an account on IMLeagues.com/iupui. Questions? Contact Matthew Jones - Coordinator of Intramural Sports - 317.278.9939 - mj221@iupui.edu. more »
    • Fall Career Week, September 26-30
      September 26 12:00am
      This week of career events offers something for everyone! Students, faculty, employers, and alumni share career expertise you won't want to miss. Attend sessions to learn more about majors, career paths, job searching, and more. Most events are in the IUPUI Campus Center. Mark your calendars for Fall Career Week 2016: Sep more »
    • Competition Pool
      September 26 5:30am
      The competition pool for lap swim is open more »
    Sunday, September 25, 2016
      IU Calendar




      • Competition Lap Pool Closed
        September 25 12:00am
        The competition lap pool for lap swim is closed. more »
      • 7v7 Soccer League
        September 25 12:00am
        Play runs Sept. 11 to Oct. 10. All intramural participants must create an account on IMLeagues.com/iupui. Co-Rec Leagues play on Sundays and Wednesdays. Octane League plays on Sundays. Recreation League plays on Tuesdays. Questions? Contact Matthew Jones - Coordinator of Intramural Sports - 317.278.9939 - mj221@iupui.edu. more »
      • Bubble Ball/Knocker Ball
        September 25 12:00am
        New intramural sport where participants climb into a bublle and play, bounce, roll, and enjoy the excitement. Team entry fee is $60. All intramurals participants are required to create an account on IMLeagues.com/iupui. Questions? Contact Matthew Jones - Coordinator of Intramural Sports - 317.278.9939 - mj221@iupui.edu. more »
      • Fall Career Week, September 26-30
        September 26 12:00am
        This week of career events offers something for everyone! Students, faculty, employers, and alumni share career expertise you won't want to miss. Attend sessions to learn more about majors, career paths, job searching, and more. Most events are in the IUPUI Campus Center. Mark your calendars for Fall Career Week 2016: Sep more »
      • Competition Pool
        September 26 5:30am
        The competition pool for lap swim is open more »
      Sunday, September 25, 2016
        IU Calendar




        • Competition Lap Pool Closed
          September 25 12:00am
          The competition lap pool for lap swim is closed. more »
        • 7v7 Soccer League
          September 25 12:00am
          Play runs Sept. 11 to Oct. 10. All intramural participants must create an account on IMLeagues.com/iupui. Co-Rec Leagues play on Sundays and Wednesdays. Octane League plays on Sundays. Recreation League plays on Tuesdays. Questions? Contact Matthew Jones - Coordinator of Intramural Sports - 317.278.9939 - mj221@iupui.edu. more »
        • Bubble Ball/Knocker Ball
          September 25 12:00am
          New intramural sport where participants climb into a bublle and play, bounce, roll, and enjoy the excitement. Team entry fee is $60. All intramurals participants are required to create an account on IMLeagues.com/iupui. Questions? Contact Matthew Jones - Coordinator of Intramural Sports - 317.278.9939 - mj221@iupui.edu. more »
        • Fall Career Week, September 26-30
          September 26 12:00am
          This week of career events offers something for everyone! Students, faculty, employers, and alumni share career expertise you won't want to miss. Attend sessions to learn more about majors, career paths, job searching, and more. Most events are in the IUPUI Campus Center. Mark your calendars for Fall Career Week 2016: Sep more »
        • Competition Pool
          September 26 5:30am
          The competition pool for lap swim is open more »
        Sunday, September 25, 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 Lap Pool Closed
            September 25 12:00am
            The competition lap pool for lap swim is closed. more »
          • 7v7 Soccer League
            September 25 12:00am
            Play runs Sept. 11 to Oct. 10. All intramural participants must create an account on IMLeagues.com/iupui. Co-Rec Leagues play on Sundays and Wednesdays. Octane League plays on Sundays. Recreation League plays on Tuesdays. Questions? Contact Matthew Jones - Coordinator of Intramural Sports - 317.278.9939 - mj221@iupui.edu. more »
          • Bubble Ball/Knocker Ball
            September 25 12:00am
            New intramural sport where participants climb into a bublle and play, bounce, roll, and enjoy the excitement. Team entry fee is $60. All intramurals participants are required to create an account on IMLeagues.com/iupui. Questions? Contact Matthew Jones - Coordinator of Intramural Sports - 317.278.9939 - mj221@iupui.edu. more »
          • Fall Career Week, September 26-30
            September 26 12:00am
            This week of career events offers something for everyone! Students, faculty, employers, and alumni share career expertise you won't want to miss. Attend sessions to learn more about majors, career paths, job searching, and more. Most events are in the IUPUI Campus Center. Mark your calendars for Fall Career Week 2016: Sep more »
          • Competition Pool
            September 26 5:30am
            The competition pool for lap swim is open more »
          Sunday, September 25, 2016