• Administering System Center 2012 Configuration Manager (MOC 10747)
    July 01 9:00am
    This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
  • Administering System Center 2012 Configuration Manager (MOC 10747)
    July 01 9:00am
    This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
  • Excel 2013: The Basics
    July 06 1:30pm
    This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity  Excel 2013 End-User Excel is the most-used spreadsheet and analysis application today. This workshop introduces basic Excel features such as entering various types of data, working with c more »
  • Access 2013: The Basics
    July 07 9:00am
    This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity Access 2013 End-User Access databases are ideal tools for tracking large volumes of related information and is the most commonly used desktop database application in use today. Intended for peo more »
  • Creating Graphics for the Web
    July 08 9:00am
    This workshop lasts 3 hours, and is part of the certificate series Web Creation This workshop introduces the different tools available in Illustrator and Photoshop for creating web graphics. Participants will create graphics for a website, including buttons, a logo, and a banner image. During the crea more »
Thursday, June 30, 2016
    IU Calendar




    • Administering System Center 2012 Configuration Manager (MOC 10747)
      July 01 9:00am
      This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
    • Administering System Center 2012 Configuration Manager (MOC 10747)
      July 01 9:00am
      This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
    • Excel 2013: The Basics
      July 06 1:30pm
      This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity  Excel 2013 End-User Excel is the most-used spreadsheet and analysis application today. This workshop introduces basic Excel features such as entering various types of data, working with c more »
    • Access 2013: The Basics
      July 07 9:00am
      This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity Access 2013 End-User Access databases are ideal tools for tracking large volumes of related information and is the most commonly used desktop database application in use today. Intended for peo more »
    • Creating Graphics for the Web
      July 08 9:00am
      This workshop lasts 3 hours, and is part of the certificate series Web Creation This workshop introduces the different tools available in Illustrator and Photoshop for creating web graphics. Participants will create graphics for a website, including buttons, a logo, and a banner image. During the crea more »
    Thursday, June 30, 2016
      IU Calendar




      • Administering System Center 2012 Configuration Manager (MOC 10747)
        July 01 9:00am
        This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
      • Administering System Center 2012 Configuration Manager (MOC 10747)
        July 01 9:00am
        This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
      • Excel 2013: The Basics
        July 06 1:30pm
        This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity  Excel 2013 End-User Excel is the most-used spreadsheet and analysis application today. This workshop introduces basic Excel features such as entering various types of data, working with c more »
      • Access 2013: The Basics
        July 07 9:00am
        This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity Access 2013 End-User Access databases are ideal tools for tracking large volumes of related information and is the most commonly used desktop database application in use today. Intended for peo more »
      • Creating Graphics for the Web
        July 08 9:00am
        This workshop lasts 3 hours, and is part of the certificate series Web Creation This workshop introduces the different tools available in Illustrator and Photoshop for creating web graphics. Participants will create graphics for a website, including buttons, a logo, and a banner image. During the crea more »
      Thursday, June 30, 2016
        IU Calendar




        • Administering System Center 2012 Configuration Manager (MOC 10747)
          July 01 9:00am
          This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
        • Administering System Center 2012 Configuration Manager (MOC 10747)
          July 01 9:00am
          This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
        • Excel 2013: The Basics
          July 06 1:30pm
          This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity  Excel 2013 End-User Excel is the most-used spreadsheet and analysis application today. This workshop introduces basic Excel features such as entering various types of data, working with c more »
        • Access 2013: The Basics
          July 07 9:00am
          This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity Access 2013 End-User Access databases are ideal tools for tracking large volumes of related information and is the most commonly used desktop database application in use today. Intended for peo more »
        • Creating Graphics for the Web
          July 08 9:00am
          This workshop lasts 3 hours, and is part of the certificate series Web Creation This workshop introduces the different tools available in Illustrator and Photoshop for creating web graphics. Participants will create graphics for a website, including buttons, a logo, and a banner image. During the crea more »
        Thursday, June 30, 2016

          About This Event

          Summary

          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:

              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:

          SQL: Data Retrieval

          Bookmark and Share

          Event Schedule

          There are no upcoming dates for this event.

          IU Calendar




          • Administering System Center 2012 Configuration Manager (MOC 10747)
            July 01 9:00am
            This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
          • Administering System Center 2012 Configuration Manager (MOC 10747)
            July 01 9:00am
            This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
          • Excel 2013: The Basics
            July 06 1:30pm
            This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity  Excel 2013 End-User Excel is the most-used spreadsheet and analysis application today. This workshop introduces basic Excel features such as entering various types of data, working with c more »
          • Access 2013: The Basics
            July 07 9:00am
            This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity Access 2013 End-User Access databases are ideal tools for tracking large volumes of related information and is the most commonly used desktop database application in use today. Intended for peo more »
          • Creating Graphics for the Web
            July 08 9:00am
            This workshop lasts 3 hours, and is part of the certificate series Web Creation This workshop introduces the different tools available in Illustrator and Photoshop for creating web graphics. Participants will create graphics for a website, including buttons, a logo, and a banner image. During the crea more »
          Thursday, June 30, 2016