• 2017 Marion County Conference on Re-Entry
    October 17 7:30am
    The primary aim of the 2017 Marion County Conference on Re-Entry is to provide capacity-building and networking opportunities to community and faith based providers as well as criminal justice agencies that provide services to individuals re-entering the community after incarceration.  The conference is organized and hosted by the Marion Co more »
  • Competition Pool
    October 17 11:00am
    lap swim more »
  • Instructional Pool
    October 17 4:00pm
    lap swim more »
  • Competition Pool
    October 18 5:30am
    lap swim more »
  • Teaching@IUPUI: Preventing and Managing Disruptive Behavior
    October 18 12:00pm
    How and when should you address disruptive student behaviors? Disruptive student behaviors are those behaviors which impede learning and teaching, and have the potential to escalate or spread if left unchecked. This webinar will present examples of disruptive student behaviors and participants will engage in discussions about how to prevent and more »
Tuesday, October 17, 2017
    IU Calendar




    • 2017 Marion County Conference on Re-Entry
      October 17 7:30am
      The primary aim of the 2017 Marion County Conference on Re-Entry is to provide capacity-building and networking opportunities to community and faith based providers as well as criminal justice agencies that provide services to individuals re-entering the community after incarceration.  The conference is organized and hosted by the Marion Co more »
    • Competition Pool
      October 17 11:00am
      lap swim more »
    • Instructional Pool
      October 17 4:00pm
      lap swim more »
    • Competition Pool
      October 18 5:30am
      lap swim more »
    • Teaching@IUPUI: Preventing and Managing Disruptive Behavior
      October 18 12:00pm
      How and when should you address disruptive student behaviors? Disruptive student behaviors are those behaviors which impede learning and teaching, and have the potential to escalate or spread if left unchecked. This webinar will present examples of disruptive student behaviors and participants will engage in discussions about how to prevent and more »
    Tuesday, October 17, 2017
      IU Calendar




      • 2017 Marion County Conference on Re-Entry
        October 17 7:30am
        The primary aim of the 2017 Marion County Conference on Re-Entry is to provide capacity-building and networking opportunities to community and faith based providers as well as criminal justice agencies that provide services to individuals re-entering the community after incarceration.  The conference is organized and hosted by the Marion Co more »
      • Competition Pool
        October 17 11:00am
        lap swim more »
      • Instructional Pool
        October 17 4:00pm
        lap swim more »
      • Competition Pool
        October 18 5:30am
        lap swim more »
      • Teaching@IUPUI: Preventing and Managing Disruptive Behavior
        October 18 12:00pm
        How and when should you address disruptive student behaviors? Disruptive student behaviors are those behaviors which impede learning and teaching, and have the potential to escalate or spread if left unchecked. This webinar will present examples of disruptive student behaviors and participants will engage in discussions about how to prevent and more »
      Tuesday, October 17, 2017
        IU Calendar




        • 2017 Marion County Conference on Re-Entry
          October 17 7:30am
          The primary aim of the 2017 Marion County Conference on Re-Entry is to provide capacity-building and networking opportunities to community and faith based providers as well as criminal justice agencies that provide services to individuals re-entering the community after incarceration.  The conference is organized and hosted by the Marion Co more »
        • Competition Pool
          October 17 11:00am
          lap swim more »
        • Instructional Pool
          October 17 4:00pm
          lap swim more »
        • Competition Pool
          October 18 5:30am
          lap swim more »
        • Teaching@IUPUI: Preventing and Managing Disruptive Behavior
          October 18 12:00pm
          How and when should you address disruptive student behaviors? Disruptive student behaviors are those behaviors which impede learning and teaching, and have the potential to escalate or spread if left unchecked. This webinar will present examples of disruptive student behaviors and participants will engage in discussions about how to prevent and more »
        Tuesday, October 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




          • 2017 Marion County Conference on Re-Entry
            October 17 7:30am
            The primary aim of the 2017 Marion County Conference on Re-Entry is to provide capacity-building and networking opportunities to community and faith based providers as well as criminal justice agencies that provide services to individuals re-entering the community after incarceration.  The conference is organized and hosted by the Marion Co more »
          • Competition Pool
            October 17 11:00am
            lap swim more »
          • Instructional Pool
            October 17 4:00pm
            lap swim more »
          • Competition Pool
            October 18 5:30am
            lap swim more »
          • Teaching@IUPUI: Preventing and Managing Disruptive Behavior
            October 18 12:00pm
            How and when should you address disruptive student behaviors? Disruptive student behaviors are those behaviors which impede learning and teaching, and have the potential to escalate or spread if left unchecked. This webinar will present examples of disruptive student behaviors and participants will engage in discussions about how to prevent and more »
          Tuesday, October 17, 2017