• Competition Pool
    April 28 5:30am
    Lap Swim more »
  • States of Incarceration: Mental Health First Aid Certification
    April 28 8:00am
    This program is an 8-hour course that offers training and certification for those responding to persons affected by mental illness (similar to the traditional Red Cross First Aid training). To register, please visit https://www.eventbrite.com/e/mental-health-first-aid-tickets-31648437328. Registration is required. Support has been more »
  • Mindfulness Meditation
    April 28 11:00am
    Feeling stressed and overwhelmed? Looking for an opportunity to practice self-care? Join us for guided mindfulness meditation. You don't have to be a CAPS client and no registration is needed. Student ID is required. more »
  • Italian Film Festival: Che Vuoi Che Sia (What’s the Big Deal?)
    April 28 6:00pm
    “Che Vuoi Che Sia” (“What’s the Big Deal?”), comedy, 6 p.m. Friday, April 28: Anna and Claudio are pushing back the decision to have a baby until the time they will be financially better off. Their hopes lie in Claudio’s new website idea, but the crowdfunding needed to launch the website doesn’t bring in more »
  • CLOSED
    April 29 12:00am
    Closed - Race for the Cure more »
Thursday, April 27, 2017
    IU Calendar




    • Competition Pool
      April 28 5:30am
      Lap Swim more »
    • States of Incarceration: Mental Health First Aid Certification
      April 28 8:00am
      This program is an 8-hour course that offers training and certification for those responding to persons affected by mental illness (similar to the traditional Red Cross First Aid training). To register, please visit https://www.eventbrite.com/e/mental-health-first-aid-tickets-31648437328. Registration is required. Support has been more »
    • Mindfulness Meditation
      April 28 11:00am
      Feeling stressed and overwhelmed? Looking for an opportunity to practice self-care? Join us for guided mindfulness meditation. You don't have to be a CAPS client and no registration is needed. Student ID is required. more »
    • Italian Film Festival: Che Vuoi Che Sia (What’s the Big Deal?)
      April 28 6:00pm
      “Che Vuoi Che Sia” (“What’s the Big Deal?”), comedy, 6 p.m. Friday, April 28: Anna and Claudio are pushing back the decision to have a baby until the time they will be financially better off. Their hopes lie in Claudio’s new website idea, but the crowdfunding needed to launch the website doesn’t bring in more »
    • CLOSED
      April 29 12:00am
      Closed - Race for the Cure more »
    Thursday, April 27, 2017
      IU Calendar




      • Competition Pool
        April 28 5:30am
        Lap Swim more »
      • States of Incarceration: Mental Health First Aid Certification
        April 28 8:00am
        This program is an 8-hour course that offers training and certification for those responding to persons affected by mental illness (similar to the traditional Red Cross First Aid training). To register, please visit https://www.eventbrite.com/e/mental-health-first-aid-tickets-31648437328. Registration is required. Support has been more »
      • Mindfulness Meditation
        April 28 11:00am
        Feeling stressed and overwhelmed? Looking for an opportunity to practice self-care? Join us for guided mindfulness meditation. You don't have to be a CAPS client and no registration is needed. Student ID is required. more »
      • Italian Film Festival: Che Vuoi Che Sia (What’s the Big Deal?)
        April 28 6:00pm
        “Che Vuoi Che Sia” (“What’s the Big Deal?”), comedy, 6 p.m. Friday, April 28: Anna and Claudio are pushing back the decision to have a baby until the time they will be financially better off. Their hopes lie in Claudio’s new website idea, but the crowdfunding needed to launch the website doesn’t bring in more »
      • CLOSED
        April 29 12:00am
        Closed - Race for the Cure more »
      Thursday, April 27, 2017
        IU Calendar




        • Competition Pool
          April 28 5:30am
          Lap Swim more »
        • States of Incarceration: Mental Health First Aid Certification
          April 28 8:00am
          This program is an 8-hour course that offers training and certification for those responding to persons affected by mental illness (similar to the traditional Red Cross First Aid training). To register, please visit https://www.eventbrite.com/e/mental-health-first-aid-tickets-31648437328. Registration is required. Support has been more »
        • Mindfulness Meditation
          April 28 11:00am
          Feeling stressed and overwhelmed? Looking for an opportunity to practice self-care? Join us for guided mindfulness meditation. You don't have to be a CAPS client and no registration is needed. Student ID is required. more »
        • Italian Film Festival: Che Vuoi Che Sia (What’s the Big Deal?)
          April 28 6:00pm
          “Che Vuoi Che Sia” (“What’s the Big Deal?”), comedy, 6 p.m. Friday, April 28: Anna and Claudio are pushing back the decision to have a baby until the time they will be financially better off. Their hopes lie in Claudio’s new website idea, but the crowdfunding needed to launch the website doesn’t bring in more »
        • CLOSED
          April 29 12:00am
          Closed - Race for the Cure more »
        Thursday, April 27, 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
            April 28 5:30am
            Lap Swim more »
          • States of Incarceration: Mental Health First Aid Certification
            April 28 8:00am
            This program is an 8-hour course that offers training and certification for those responding to persons affected by mental illness (similar to the traditional Red Cross First Aid training). To register, please visit https://www.eventbrite.com/e/mental-health-first-aid-tickets-31648437328. Registration is required. Support has been more »
          • Mindfulness Meditation
            April 28 11:00am
            Feeling stressed and overwhelmed? Looking for an opportunity to practice self-care? Join us for guided mindfulness meditation. You don't have to be a CAPS client and no registration is needed. Student ID is required. more »
          • Italian Film Festival: Che Vuoi Che Sia (What’s the Big Deal?)
            April 28 6:00pm
            “Che Vuoi Che Sia” (“What’s the Big Deal?”), comedy, 6 p.m. Friday, April 28: Anna and Claudio are pushing back the decision to have a baby until the time they will be financially better off. Their hopes lie in Claudio’s new website idea, but the crowdfunding needed to launch the website doesn’t bring in more »
          • CLOSED
            April 29 12:00am
            Closed - Race for the Cure more »
          Thursday, April 27, 2017