• IUPUI Discovers Indy
    August 28 2:00pm
    Register for this great event to spend the day explore new places in Indianapolis and learn what this great city has to offer. more »
  • Student Support Centers Resource Fair
    August 29 8:00am
    The Student Support Centers Resource Fair will include academic support services from around the IUPUI campus.  Groups will share program information, discuss valuable material from their area, and answer any questions.  Students will gain an increased awareness of academic resources on campus that can assist them in their academic suc more »
  • NSF Graduate Research Fellowship Program
    August 29 12:30pm
    Target Audience: First- and second-year graduate students in STEM and STEM education; undergraduate seniors planning to enroll in STEM or STEM education graduate programs This session will introduce interested first- and second-year graduate students and undergraduate seniors to the National Science Foundation (NSF) Graduate Research Fe more »
  • iMovie: The Basics
    August 29 1:00pm
      This workshop lasts 2 hours. This webinar will cover how to do basic tasks in iMovie, such as import video, cut and edit clips, add transitions, and more   more »
  • Photoshop CC 2015: The Basics
    August 29 1:30pm
    This workshop lasts 3 hours, and is part of the certificate series Desktop Publishing Fundamentals In this workshop, participants will learn the basics of Adobe Photoshop, the premiere image editing application. Particpants will learn how to retouch a photo while building skills that will help them go more »
Sunday, August 28, 2016
    IU Calendar




    • IUPUI Discovers Indy
      August 28 2:00pm
      Register for this great event to spend the day explore new places in Indianapolis and learn what this great city has to offer. more »
    • Student Support Centers Resource Fair
      August 29 8:00am
      The Student Support Centers Resource Fair will include academic support services from around the IUPUI campus.  Groups will share program information, discuss valuable material from their area, and answer any questions.  Students will gain an increased awareness of academic resources on campus that can assist them in their academic suc more »
    • NSF Graduate Research Fellowship Program
      August 29 12:30pm
      Target Audience: First- and second-year graduate students in STEM and STEM education; undergraduate seniors planning to enroll in STEM or STEM education graduate programs This session will introduce interested first- and second-year graduate students and undergraduate seniors to the National Science Foundation (NSF) Graduate Research Fe more »
    • iMovie: The Basics
      August 29 1:00pm
        This workshop lasts 2 hours. This webinar will cover how to do basic tasks in iMovie, such as import video, cut and edit clips, add transitions, and more   more »
    • Photoshop CC 2015: The Basics
      August 29 1:30pm
      This workshop lasts 3 hours, and is part of the certificate series Desktop Publishing Fundamentals In this workshop, participants will learn the basics of Adobe Photoshop, the premiere image editing application. Particpants will learn how to retouch a photo while building skills that will help them go more »
    Sunday, August 28, 2016
      IU Calendar




      • IUPUI Discovers Indy
        August 28 2:00pm
        Register for this great event to spend the day explore new places in Indianapolis and learn what this great city has to offer. more »
      • Student Support Centers Resource Fair
        August 29 8:00am
        The Student Support Centers Resource Fair will include academic support services from around the IUPUI campus.  Groups will share program information, discuss valuable material from their area, and answer any questions.  Students will gain an increased awareness of academic resources on campus that can assist them in their academic suc more »
      • NSF Graduate Research Fellowship Program
        August 29 12:30pm
        Target Audience: First- and second-year graduate students in STEM and STEM education; undergraduate seniors planning to enroll in STEM or STEM education graduate programs This session will introduce interested first- and second-year graduate students and undergraduate seniors to the National Science Foundation (NSF) Graduate Research Fe more »
      • iMovie: The Basics
        August 29 1:00pm
          This workshop lasts 2 hours. This webinar will cover how to do basic tasks in iMovie, such as import video, cut and edit clips, add transitions, and more   more »
      • Photoshop CC 2015: The Basics
        August 29 1:30pm
        This workshop lasts 3 hours, and is part of the certificate series Desktop Publishing Fundamentals In this workshop, participants will learn the basics of Adobe Photoshop, the premiere image editing application. Particpants will learn how to retouch a photo while building skills that will help them go more »
      Sunday, August 28, 2016
        IU Calendar




        • IUPUI Discovers Indy
          August 28 2:00pm
          Register for this great event to spend the day explore new places in Indianapolis and learn what this great city has to offer. more »
        • Student Support Centers Resource Fair
          August 29 8:00am
          The Student Support Centers Resource Fair will include academic support services from around the IUPUI campus.  Groups will share program information, discuss valuable material from their area, and answer any questions.  Students will gain an increased awareness of academic resources on campus that can assist them in their academic suc more »
        • NSF Graduate Research Fellowship Program
          August 29 12:30pm
          Target Audience: First- and second-year graduate students in STEM and STEM education; undergraduate seniors planning to enroll in STEM or STEM education graduate programs This session will introduce interested first- and second-year graduate students and undergraduate seniors to the National Science Foundation (NSF) Graduate Research Fe more »
        • iMovie: The Basics
          August 29 1:00pm
            This workshop lasts 2 hours. This webinar will cover how to do basic tasks in iMovie, such as import video, cut and edit clips, add transitions, and more   more »
        • Photoshop CC 2015: The Basics
          August 29 1:30pm
          This workshop lasts 3 hours, and is part of the certificate series Desktop Publishing Fundamentals In this workshop, participants will learn the basics of Adobe Photoshop, the premiere image editing application. Particpants will learn how to retouch a photo while building skills that will help them go more »
        Sunday, August 28, 2016

          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




          • IUPUI Discovers Indy
            August 28 2:00pm
            Register for this great event to spend the day explore new places in Indianapolis and learn what this great city has to offer. more »
          • Student Support Centers Resource Fair
            August 29 8:00am
            The Student Support Centers Resource Fair will include academic support services from around the IUPUI campus.  Groups will share program information, discuss valuable material from their area, and answer any questions.  Students will gain an increased awareness of academic resources on campus that can assist them in their academic suc more »
          • NSF Graduate Research Fellowship Program
            August 29 12:30pm
            Target Audience: First- and second-year graduate students in STEM and STEM education; undergraduate seniors planning to enroll in STEM or STEM education graduate programs This session will introduce interested first- and second-year graduate students and undergraduate seniors to the National Science Foundation (NSF) Graduate Research Fe more »
          • iMovie: The Basics
            August 29 1:00pm
              This workshop lasts 2 hours. This webinar will cover how to do basic tasks in iMovie, such as import video, cut and edit clips, add transitions, and more   more »
          • Photoshop CC 2015: The Basics
            August 29 1:30pm
            This workshop lasts 3 hours, and is part of the certificate series Desktop Publishing Fundamentals In this workshop, participants will learn the basics of Adobe Photoshop, the premiere image editing application. Particpants will learn how to retouch a photo while building skills that will help them go more »
          Sunday, August 28, 2016