• Brebeuf Invite
    January 24 12:00am
    Swim meet more »
  • Competition Pool
    January 25 5:30am
    Lap Swim more »
  • Talking Tenure, Promotion, and Pathways to Engaged Scholarship: Breakfast Opportunity for Junior Faculty and Advanced Graduate Students with Dr. Timothy Eatman
    January 25 8:00am
    Scholars face a number of questions as opportunities and approaches are weighed in scholarly work. Is community engagement an essential element of how you see your work as a scholar and educator? Are you nearing completion of your doctorate and unsure how to represent your interests in community engagement during the interview process? Are you i more »
  • Tom Sachs | Radiant City: Paintings 2000-2016
    January 25 10:00am
    A major survey exhibition of Tom Sachs’ paintings showcasing the artist’s ongoing interest in combining mass-produced pop cultural icons with a hand made aesthetic. This exhibition is made possible in part by the generous support of Julie and David Eskenazi.  more »
  • Spring Study Abroad Fair
    January 25 10:00am
    At the Spring Study Abroad Fair you are invited to find study abroad programs suited for you and speak with program directors!  Join us on:  Wednesday, January 25th, 2017 10am-1pm in the Campus Center Atrium Discuss study abroad program opportunities that best suit you, your interests, or your studies. Explore i more »
Tuesday, January 24, 2017
    IU Calendar




    • Brebeuf Invite
      January 24 12:00am
      Swim meet more »
    • Competition Pool
      January 25 5:30am
      Lap Swim more »
    • Talking Tenure, Promotion, and Pathways to Engaged Scholarship: Breakfast Opportunity for Junior Faculty and Advanced Graduate Students with Dr. Timothy Eatman
      January 25 8:00am
      Scholars face a number of questions as opportunities and approaches are weighed in scholarly work. Is community engagement an essential element of how you see your work as a scholar and educator? Are you nearing completion of your doctorate and unsure how to represent your interests in community engagement during the interview process? Are you i more »
    • Tom Sachs | Radiant City: Paintings 2000-2016
      January 25 10:00am
      A major survey exhibition of Tom Sachs’ paintings showcasing the artist’s ongoing interest in combining mass-produced pop cultural icons with a hand made aesthetic. This exhibition is made possible in part by the generous support of Julie and David Eskenazi.  more »
    • Spring Study Abroad Fair
      January 25 10:00am
      At the Spring Study Abroad Fair you are invited to find study abroad programs suited for you and speak with program directors!  Join us on:  Wednesday, January 25th, 2017 10am-1pm in the Campus Center Atrium Discuss study abroad program opportunities that best suit you, your interests, or your studies. Explore i more »
    Tuesday, January 24, 2017
      IU Calendar




      • Brebeuf Invite
        January 24 12:00am
        Swim meet more »
      • Competition Pool
        January 25 5:30am
        Lap Swim more »
      • Talking Tenure, Promotion, and Pathways to Engaged Scholarship: Breakfast Opportunity for Junior Faculty and Advanced Graduate Students with Dr. Timothy Eatman
        January 25 8:00am
        Scholars face a number of questions as opportunities and approaches are weighed in scholarly work. Is community engagement an essential element of how you see your work as a scholar and educator? Are you nearing completion of your doctorate and unsure how to represent your interests in community engagement during the interview process? Are you i more »
      • Tom Sachs | Radiant City: Paintings 2000-2016
        January 25 10:00am
        A major survey exhibition of Tom Sachs’ paintings showcasing the artist’s ongoing interest in combining mass-produced pop cultural icons with a hand made aesthetic. This exhibition is made possible in part by the generous support of Julie and David Eskenazi.  more »
      • Spring Study Abroad Fair
        January 25 10:00am
        At the Spring Study Abroad Fair you are invited to find study abroad programs suited for you and speak with program directors!  Join us on:  Wednesday, January 25th, 2017 10am-1pm in the Campus Center Atrium Discuss study abroad program opportunities that best suit you, your interests, or your studies. Explore i more »
      Tuesday, January 24, 2017
        IU Calendar




        • Brebeuf Invite
          January 24 12:00am
          Swim meet more »
        • Competition Pool
          January 25 5:30am
          Lap Swim more »
        • Talking Tenure, Promotion, and Pathways to Engaged Scholarship: Breakfast Opportunity for Junior Faculty and Advanced Graduate Students with Dr. Timothy Eatman
          January 25 8:00am
          Scholars face a number of questions as opportunities and approaches are weighed in scholarly work. Is community engagement an essential element of how you see your work as a scholar and educator? Are you nearing completion of your doctorate and unsure how to represent your interests in community engagement during the interview process? Are you i more »
        • Tom Sachs | Radiant City: Paintings 2000-2016
          January 25 10:00am
          A major survey exhibition of Tom Sachs’ paintings showcasing the artist’s ongoing interest in combining mass-produced pop cultural icons with a hand made aesthetic. This exhibition is made possible in part by the generous support of Julie and David Eskenazi.  more »
        • Spring Study Abroad Fair
          January 25 10:00am
          At the Spring Study Abroad Fair you are invited to find study abroad programs suited for you and speak with program directors!  Join us on:  Wednesday, January 25th, 2017 10am-1pm in the Campus Center Atrium Discuss study abroad program opportunities that best suit you, your interests, or your studies. Explore i more »
        Tuesday, January 24, 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




          • Brebeuf Invite
            January 24 12:00am
            Swim meet more »
          • Competition Pool
            January 25 5:30am
            Lap Swim more »
          • Talking Tenure, Promotion, and Pathways to Engaged Scholarship: Breakfast Opportunity for Junior Faculty and Advanced Graduate Students with Dr. Timothy Eatman
            January 25 8:00am
            Scholars face a number of questions as opportunities and approaches are weighed in scholarly work. Is community engagement an essential element of how you see your work as a scholar and educator? Are you nearing completion of your doctorate and unsure how to represent your interests in community engagement during the interview process? Are you i more »
          • Tom Sachs | Radiant City: Paintings 2000-2016
            January 25 10:00am
            A major survey exhibition of Tom Sachs’ paintings showcasing the artist’s ongoing interest in combining mass-produced pop cultural icons with a hand made aesthetic. This exhibition is made possible in part by the generous support of Julie and David Eskenazi.  more »
          • Spring Study Abroad Fair
            January 25 10:00am
            At the Spring Study Abroad Fair you are invited to find study abroad programs suited for you and speak with program directors!  Join us on:  Wednesday, January 25th, 2017 10am-1pm in the Campus Center Atrium Discuss study abroad program opportunities that best suit you, your interests, or your studies. Explore i more »
          Tuesday, January 24, 2017