• Competition Pool
    August 17 5:30am
    lap swim more »
  • Instructional Pool
    August 17 7:30am
    lap swim more »
  • 2017 IUPUI TA Orientation
    August 17 8:30am
    The Center for Teaching and Learning and the Graduate Office will conduct the 2017 IUPUI TA Orientation on Thursday, August 17 from 8:30 a.m. to 2:45 p.m. at the IT Building. Graduate students anticipating to be first-time teaching assistants in Fall 2017 or Spring 2018 are encouraged to register for and attend the TA Orientation. Attendees will more »
  • Peer Mentor Training
    August 17 9:00am
    20 new Peer Mentors for the 21st Century Scholars will complete training.  They will be reviewing training materials and practicing the mentoring techniques they are learning.  There will also be team builders and personal development for the peer mentors at this training. more »
  • 2017 IUPUI Summer Bridge Closing Program
    August 17 12:00pm
    This event is an opportunity for all IUPUI Summer Bridge students, staff and faculty to come together one last time and celebrate the culmination of the summer program.  There will be several key speakers and recognition with cheering for each Summer Bridge section.  more »
Thursday, August 17, 2017
    IU Calendar




    • Competition Pool
      August 17 5:30am
      lap swim more »
    • Instructional Pool
      August 17 7:30am
      lap swim more »
    • 2017 IUPUI TA Orientation
      August 17 8:30am
      The Center for Teaching and Learning and the Graduate Office will conduct the 2017 IUPUI TA Orientation on Thursday, August 17 from 8:30 a.m. to 2:45 p.m. at the IT Building. Graduate students anticipating to be first-time teaching assistants in Fall 2017 or Spring 2018 are encouraged to register for and attend the TA Orientation. Attendees will more »
    • Peer Mentor Training
      August 17 9:00am
      20 new Peer Mentors for the 21st Century Scholars will complete training.  They will be reviewing training materials and practicing the mentoring techniques they are learning.  There will also be team builders and personal development for the peer mentors at this training. more »
    • 2017 IUPUI Summer Bridge Closing Program
      August 17 12:00pm
      This event is an opportunity for all IUPUI Summer Bridge students, staff and faculty to come together one last time and celebrate the culmination of the summer program.  There will be several key speakers and recognition with cheering for each Summer Bridge section.  more »
    Thursday, August 17, 2017
      IU Calendar




      • Competition Pool
        August 17 5:30am
        lap swim more »
      • Instructional Pool
        August 17 7:30am
        lap swim more »
      • 2017 IUPUI TA Orientation
        August 17 8:30am
        The Center for Teaching and Learning and the Graduate Office will conduct the 2017 IUPUI TA Orientation on Thursday, August 17 from 8:30 a.m. to 2:45 p.m. at the IT Building. Graduate students anticipating to be first-time teaching assistants in Fall 2017 or Spring 2018 are encouraged to register for and attend the TA Orientation. Attendees will more »
      • Peer Mentor Training
        August 17 9:00am
        20 new Peer Mentors for the 21st Century Scholars will complete training.  They will be reviewing training materials and practicing the mentoring techniques they are learning.  There will also be team builders and personal development for the peer mentors at this training. more »
      • 2017 IUPUI Summer Bridge Closing Program
        August 17 12:00pm
        This event is an opportunity for all IUPUI Summer Bridge students, staff and faculty to come together one last time and celebrate the culmination of the summer program.  There will be several key speakers and recognition with cheering for each Summer Bridge section.  more »
      Thursday, August 17, 2017
        IU Calendar




        • Competition Pool
          August 17 5:30am
          lap swim more »
        • Instructional Pool
          August 17 7:30am
          lap swim more »
        • 2017 IUPUI TA Orientation
          August 17 8:30am
          The Center for Teaching and Learning and the Graduate Office will conduct the 2017 IUPUI TA Orientation on Thursday, August 17 from 8:30 a.m. to 2:45 p.m. at the IT Building. Graduate students anticipating to be first-time teaching assistants in Fall 2017 or Spring 2018 are encouraged to register for and attend the TA Orientation. Attendees will more »
        • Peer Mentor Training
          August 17 9:00am
          20 new Peer Mentors for the 21st Century Scholars will complete training.  They will be reviewing training materials and practicing the mentoring techniques they are learning.  There will also be team builders and personal development for the peer mentors at this training. more »
        • 2017 IUPUI Summer Bridge Closing Program
          August 17 12:00pm
          This event is an opportunity for all IUPUI Summer Bridge students, staff and faculty to come together one last time and celebrate the culmination of the summer program.  There will be several key speakers and recognition with cheering for each Summer Bridge section.  more »
        Thursday, August 17, 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
            August 17 5:30am
            lap swim more »
          • Instructional Pool
            August 17 7:30am
            lap swim more »
          • 2017 IUPUI TA Orientation
            August 17 8:30am
            The Center for Teaching and Learning and the Graduate Office will conduct the 2017 IUPUI TA Orientation on Thursday, August 17 from 8:30 a.m. to 2:45 p.m. at the IT Building. Graduate students anticipating to be first-time teaching assistants in Fall 2017 or Spring 2018 are encouraged to register for and attend the TA Orientation. Attendees will more »
          • Peer Mentor Training
            August 17 9:00am
            20 new Peer Mentors for the 21st Century Scholars will complete training.  They will be reviewing training materials and practicing the mentoring techniques they are learning.  There will also be team builders and personal development for the peer mentors at this training. more »
          • 2017 IUPUI Summer Bridge Closing Program
            August 17 12:00pm
            This event is an opportunity for all IUPUI Summer Bridge students, staff and faculty to come together one last time and celebrate the culmination of the summer program.  There will be several key speakers and recognition with cheering for each Summer Bridge section.  more »
          Thursday, August 17, 2017