• CLOSED
    June 27 12:00am
    pool closed more »
  • USA Swimming National Championships
    June 27 12:00am
    meet more »
  • USA Swimming National Championships and World Championship Trials
    June 27 6:00am
    Swim meet for National Championship and World Championship trials. more »
  • Nanotechnology Experiences for Students and Teachers
    June 27 8:45am
    High School students, grades 9-12, come for 2 weeks of programming that explore the interdisciplinary field of nanotechnology.  This cutting-edge field is rapidly becoming an essential part of science, engineering, medicine, and many other disciplines.  They will earn a college credit hour in Engineering & Technology and/or Sc more »
  • Competition Pool
    June 27 11:30am
    lap swim more »
Tuesday, June 27, 2017
    IU Calendar




    • CLOSED
      June 27 12:00am
      pool closed more »
    • USA Swimming National Championships
      June 27 12:00am
      meet more »
    • USA Swimming National Championships and World Championship Trials
      June 27 6:00am
      Swim meet for National Championship and World Championship trials. more »
    • Nanotechnology Experiences for Students and Teachers
      June 27 8:45am
      High School students, grades 9-12, come for 2 weeks of programming that explore the interdisciplinary field of nanotechnology.  This cutting-edge field is rapidly becoming an essential part of science, engineering, medicine, and many other disciplines.  They will earn a college credit hour in Engineering & Technology and/or Sc more »
    • Competition Pool
      June 27 11:30am
      lap swim more »
    Tuesday, June 27, 2017
      IU Calendar




      • CLOSED
        June 27 12:00am
        pool closed more »
      • USA Swimming National Championships
        June 27 12:00am
        meet more »
      • USA Swimming National Championships and World Championship Trials
        June 27 6:00am
        Swim meet for National Championship and World Championship trials. more »
      • Nanotechnology Experiences for Students and Teachers
        June 27 8:45am
        High School students, grades 9-12, come for 2 weeks of programming that explore the interdisciplinary field of nanotechnology.  This cutting-edge field is rapidly becoming an essential part of science, engineering, medicine, and many other disciplines.  They will earn a college credit hour in Engineering & Technology and/or Sc more »
      • Competition Pool
        June 27 11:30am
        lap swim more »
      Tuesday, June 27, 2017
        IU Calendar




        • CLOSED
          June 27 12:00am
          pool closed more »
        • USA Swimming National Championships
          June 27 12:00am
          meet more »
        • USA Swimming National Championships and World Championship Trials
          June 27 6:00am
          Swim meet for National Championship and World Championship trials. more »
        • Nanotechnology Experiences for Students and Teachers
          June 27 8:45am
          High School students, grades 9-12, come for 2 weeks of programming that explore the interdisciplinary field of nanotechnology.  This cutting-edge field is rapidly becoming an essential part of science, engineering, medicine, and many other disciplines.  They will earn a college credit hour in Engineering & Technology and/or Sc more »
        • Competition Pool
          June 27 11:30am
          lap swim more »
        Tuesday, June 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




          • CLOSED
            June 27 12:00am
            pool closed more »
          • USA Swimming National Championships
            June 27 12:00am
            meet more »
          • USA Swimming National Championships and World Championship Trials
            June 27 6:00am
            Swim meet for National Championship and World Championship trials. more »
          • Competition Pool
            June 27 11:30am
            lap swim more »
          • Nanotechnology Experiences for Students and Teachers
            June 28 8:45am
            High School students, grades 9-12, come for 2 weeks of programming that explore the interdisciplinary field of nanotechnology.  This cutting-edge field is rapidly becoming an essential part of science, engineering, medicine, and many other disciplines.  They will earn a college credit hour in Engineering & Technology and/or Sc more »
          Tuesday, June 27, 2017