• IU School of Nursing Lunch with the Dean in Naples, FL
    February 12 12:00am
    You and a guest are cordially invited to join us for a special luncheon to welcome our new dean, Dean Robin Newhouse, at Naples Beach Hotel and Golf Club, Immokalee Room, 851 Gulf Shore Blvd. North, Naples, FL  34102-5397 at 12:00 noon.  Please reply to Theresa Bell at the IU School of Nursing Alumni Association, thebell@iupui.edu or t more »
  • Web Accessibility Evaluation (Webinar)
    February 12 10:00am
    This session is being delivered online and simultaneously in room 144 in Wells Library in Bloomington. This is the online session, so please register for this session only if you plan to attend remotely.” This workshop lasts 2 h more »
  • IU School of Nursing Events in Naples, FL
    February 13 12:00am
    IU School of Nursing Events in Naples, FL – February 13 and 15, 2016   We are pleased to invite you to join us as our guest(s) for two additional events taking place this weekend:   Winter College Reception, Saturday, February 13, 2016 from 4:30 – 6:00pm, (you are welcome to join us for an informal dinner after the more »
  • Illustrator CC 2015: The Basics
    February 13 9:00am
    This workshop lasts 3 hours, and is part of the certificate series Desktop Publishing Fundamentals In this workshop, participants will learn how the basics of Adobe Illustrator, a drawing program. Participants will spend time building basic skills like drawing with brushes, creating and combining shap more »
  • Cascade Server: Managing Content
    February 15 1:30pm
    This workshop lasts 3 hours. Cascade Server: Managing Content will teach users how to manage content in IU’s WCMS, Cascade Server. Users will be provided a demonstration site, demonstration username and passphrase, and will be guided through tasks focused on the skills needed to create and edit conte more »
Friday, February 12, 2016
    IU Calendar




    • IU School of Nursing Lunch with the Dean in Naples, FL
      February 12 12:00am
      You and a guest are cordially invited to join us for a special luncheon to welcome our new dean, Dean Robin Newhouse, at Naples Beach Hotel and Golf Club, Immokalee Room, 851 Gulf Shore Blvd. North, Naples, FL  34102-5397 at 12:00 noon.  Please reply to Theresa Bell at the IU School of Nursing Alumni Association, thebell@iupui.edu or t more »
    • Web Accessibility Evaluation (Webinar)
      February 12 10:00am
      This session is being delivered online and simultaneously in room 144 in Wells Library in Bloomington. This is the online session, so please register for this session only if you plan to attend remotely.” This workshop lasts 2 h more »
    • IU School of Nursing Events in Naples, FL
      February 13 12:00am
      IU School of Nursing Events in Naples, FL – February 13 and 15, 2016   We are pleased to invite you to join us as our guest(s) for two additional events taking place this weekend:   Winter College Reception, Saturday, February 13, 2016 from 4:30 – 6:00pm, (you are welcome to join us for an informal dinner after the more »
    • Illustrator CC 2015: The Basics
      February 13 9:00am
      This workshop lasts 3 hours, and is part of the certificate series Desktop Publishing Fundamentals In this workshop, participants will learn how the basics of Adobe Illustrator, a drawing program. Participants will spend time building basic skills like drawing with brushes, creating and combining shap more »
    • Cascade Server: Managing Content
      February 15 1:30pm
      This workshop lasts 3 hours. Cascade Server: Managing Content will teach users how to manage content in IU’s WCMS, Cascade Server. Users will be provided a demonstration site, demonstration username and passphrase, and will be guided through tasks focused on the skills needed to create and edit conte more »
    Friday, February 12, 2016
      IU Calendar




      • IU School of Nursing Lunch with the Dean in Naples, FL
        February 12 12:00am
        You and a guest are cordially invited to join us for a special luncheon to welcome our new dean, Dean Robin Newhouse, at Naples Beach Hotel and Golf Club, Immokalee Room, 851 Gulf Shore Blvd. North, Naples, FL  34102-5397 at 12:00 noon.  Please reply to Theresa Bell at the IU School of Nursing Alumni Association, thebell@iupui.edu or t more »
      • Web Accessibility Evaluation (Webinar)
        February 12 10:00am
        This session is being delivered online and simultaneously in room 144 in Wells Library in Bloomington. This is the online session, so please register for this session only if you plan to attend remotely.” This workshop lasts 2 h more »
      • IU School of Nursing Events in Naples, FL
        February 13 12:00am
        IU School of Nursing Events in Naples, FL – February 13 and 15, 2016   We are pleased to invite you to join us as our guest(s) for two additional events taking place this weekend:   Winter College Reception, Saturday, February 13, 2016 from 4:30 – 6:00pm, (you are welcome to join us for an informal dinner after the more »
      • Illustrator CC 2015: The Basics
        February 13 9:00am
        This workshop lasts 3 hours, and is part of the certificate series Desktop Publishing Fundamentals In this workshop, participants will learn how the basics of Adobe Illustrator, a drawing program. Participants will spend time building basic skills like drawing with brushes, creating and combining shap more »
      • Cascade Server: Managing Content
        February 15 1:30pm
        This workshop lasts 3 hours. Cascade Server: Managing Content will teach users how to manage content in IU’s WCMS, Cascade Server. Users will be provided a demonstration site, demonstration username and passphrase, and will be guided through tasks focused on the skills needed to create and edit conte more »
      Friday, February 12, 2016
        IU Calendar




        • IU School of Nursing Lunch with the Dean in Naples, FL
          February 12 12:00am
          You and a guest are cordially invited to join us for a special luncheon to welcome our new dean, Dean Robin Newhouse, at Naples Beach Hotel and Golf Club, Immokalee Room, 851 Gulf Shore Blvd. North, Naples, FL  34102-5397 at 12:00 noon.  Please reply to Theresa Bell at the IU School of Nursing Alumni Association, thebell@iupui.edu or t more »
        • Web Accessibility Evaluation (Webinar)
          February 12 10:00am
          This session is being delivered online and simultaneously in room 144 in Wells Library in Bloomington. This is the online session, so please register for this session only if you plan to attend remotely.” This workshop lasts 2 h more »
        • IU School of Nursing Events in Naples, FL
          February 13 12:00am
          IU School of Nursing Events in Naples, FL – February 13 and 15, 2016   We are pleased to invite you to join us as our guest(s) for two additional events taking place this weekend:   Winter College Reception, Saturday, February 13, 2016 from 4:30 – 6:00pm, (you are welcome to join us for an informal dinner after the more »
        • Illustrator CC 2015: The Basics
          February 13 9:00am
          This workshop lasts 3 hours, and is part of the certificate series Desktop Publishing Fundamentals In this workshop, participants will learn how the basics of Adobe Illustrator, a drawing program. Participants will spend time building basic skills like drawing with brushes, creating and combining shap more »
        • Cascade Server: Managing Content
          February 15 1:30pm
          This workshop lasts 3 hours. Cascade Server: Managing Content will teach users how to manage content in IU’s WCMS, Cascade Server. Users will be provided a demonstration site, demonstration username and passphrase, and will be guided through tasks focused on the skills needed to create and edit conte more »
        Friday, February 12, 2016

          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




          • IU School of Nursing Lunch with the Dean in Naples, FL
            February 12 12:00am
            You and a guest are cordially invited to join us for a special luncheon to welcome our new dean, Dean Robin Newhouse, at Naples Beach Hotel and Golf Club, Immokalee Room, 851 Gulf Shore Blvd. North, Naples, FL  34102-5397 at 12:00 noon.  Please reply to Theresa Bell at the IU School of Nursing Alumni Association, thebell@iupui.edu or t more »
          • Web Accessibility Evaluation (Webinar)
            February 12 10:00am
            This session is being delivered online and simultaneously in room 144 in Wells Library in Bloomington. This is the online session, so please register for this session only if you plan to attend remotely.” This workshop lasts 2 h more »
          • IU School of Nursing Events in Naples, FL
            February 13 12:00am
            IU School of Nursing Events in Naples, FL – February 13 and 15, 2016   We are pleased to invite you to join us as our guest(s) for two additional events taking place this weekend:   Winter College Reception, Saturday, February 13, 2016 from 4:30 – 6:00pm, (you are welcome to join us for an informal dinner after the more »
          • Illustrator CC 2015: The Basics
            February 13 9:00am
            This workshop lasts 3 hours, and is part of the certificate series Desktop Publishing Fundamentals In this workshop, participants will learn how the basics of Adobe Illustrator, a drawing program. Participants will spend time building basic skills like drawing with brushes, creating and combining shap more »
          • Cascade Server: Managing Content
            February 15 1:30pm
            This workshop lasts 3 hours. Cascade Server: Managing Content will teach users how to manage content in IU’s WCMS, Cascade Server. Users will be provided a demonstration site, demonstration username and passphrase, and will be guided through tasks focused on the skills needed to create and edit conte more »
          Friday, February 12, 2016