• Get Ahead and Stay Ahead: Breaking through with Problem People at Work
    May 26 12:00am
    This workshop lasts 4 weeks. If you do not have an IU account, just create an IU guest account that you can use to register. The IU Alumni Association has teamed up with Nora Simpson of Get Ahead and Stay Ahead to bring you this special four-week online course, designed to h more »
  • IU Pediatric Dentistry
    May 26 12:00am
    For more information or to registered please contact Karen Jones at kdeery@iupui.edu or 317-274-8959. more »
  • Installing and Configuring Windows Server 2012 (MOC 20410)
    May 26 9:00am
    This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
  • Installing and Configuring Windows Server 2012 (MOC 20410)
    May 26 9:00am
    This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
  • Advanced Web Accessibility (Webinar)
    May 26 1:30pm
    This session is being delivered online and simultaneously in room IT 121 in the Informatics & Communications Technology Complex at IUPUI. This is the online session, so please register for this session only if you plan to attend remotely. more »
Thursday, May 26, 2016
    IU Calendar




    • Get Ahead and Stay Ahead: Breaking through with Problem People at Work
      May 26 12:00am
      This workshop lasts 4 weeks. If you do not have an IU account, just create an IU guest account that you can use to register. The IU Alumni Association has teamed up with Nora Simpson of Get Ahead and Stay Ahead to bring you this special four-week online course, designed to h more »
    • IU Pediatric Dentistry
      May 26 12:00am
      For more information or to registered please contact Karen Jones at kdeery@iupui.edu or 317-274-8959. more »
    • Installing and Configuring Windows Server 2012 (MOC 20410)
      May 26 9:00am
      This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
    • Installing and Configuring Windows Server 2012 (MOC 20410)
      May 26 9:00am
      This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
    • Advanced Web Accessibility (Webinar)
      May 26 1:30pm
      This session is being delivered online and simultaneously in room IT 121 in the Informatics & Communications Technology Complex at IUPUI. This is the online session, so please register for this session only if you plan to attend remotely. more »
    Thursday, May 26, 2016
      IU Calendar




      • Get Ahead and Stay Ahead: Breaking through with Problem People at Work
        May 26 12:00am
        This workshop lasts 4 weeks. If you do not have an IU account, just create an IU guest account that you can use to register. The IU Alumni Association has teamed up with Nora Simpson of Get Ahead and Stay Ahead to bring you this special four-week online course, designed to h more »
      • IU Pediatric Dentistry
        May 26 12:00am
        For more information or to registered please contact Karen Jones at kdeery@iupui.edu or 317-274-8959. more »
      • Installing and Configuring Windows Server 2012 (MOC 20410)
        May 26 9:00am
        This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
      • Installing and Configuring Windows Server 2012 (MOC 20410)
        May 26 9:00am
        This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
      • Advanced Web Accessibility (Webinar)
        May 26 1:30pm
        This session is being delivered online and simultaneously in room IT 121 in the Informatics & Communications Technology Complex at IUPUI. This is the online session, so please register for this session only if you plan to attend remotely. more »
      Thursday, May 26, 2016
        IU Calendar




        • Get Ahead and Stay Ahead: Breaking through with Problem People at Work
          May 26 12:00am
          This workshop lasts 4 weeks. If you do not have an IU account, just create an IU guest account that you can use to register. The IU Alumni Association has teamed up with Nora Simpson of Get Ahead and Stay Ahead to bring you this special four-week online course, designed to h more »
        • IU Pediatric Dentistry
          May 26 12:00am
          For more information or to registered please contact Karen Jones at kdeery@iupui.edu or 317-274-8959. more »
        • Installing and Configuring Windows Server 2012 (MOC 20410)
          May 26 9:00am
          This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
        • Installing and Configuring Windows Server 2012 (MOC 20410)
          May 26 9:00am
          This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
        • Advanced Web Accessibility (Webinar)
          May 26 1:30pm
          This session is being delivered online and simultaneously in room IT 121 in the Informatics & Communications Technology Complex at IUPUI. This is the online session, so please register for this session only if you plan to attend remotely. more »
        Thursday, May 26, 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




          • Get Ahead and Stay Ahead: Breaking through with Problem People at Work
            May 26 12:00am
            This workshop lasts 4 weeks. If you do not have an IU account, just create an IU guest account that you can use to register. The IU Alumni Association has teamed up with Nora Simpson of Get Ahead and Stay Ahead to bring you this special four-week online course, designed to h more »
          • IU Pediatric Dentistry
            May 26 12:00am
            For more information or to registered please contact Karen Jones at kdeery@iupui.edu or 317-274-8959. more »
          • Installing and Configuring Windows Server 2012 (MOC 20410)
            May 26 9:00am
            This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
          • Installing and Configuring Windows Server 2012 (MOC 20410)
            May 26 9:00am
            This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
          • Advanced Web Accessibility (Webinar)
            May 26 1:30pm
            This session is being delivered online and simultaneously in room IT 121 in the Informatics & Communications Technology Complex at IUPUI. This is the online session, so please register for this session only if you plan to attend remotely. more »
          Thursday, May 26, 2016