• CompTIA CASP
    July 26 9:00am
    This workshop lasts 5 days. The CompTIA Advanced Security Practitioner (CASP) Certification is a vendor-neutral credential. The CASP exam is an internationally targeted validation of advanced-level security skills and knowledge. While there is no required prerequisite, the CASP certification is intended to more »
  • CompTIA CASP
    July 26 9:00am
    This workshop lasts 5 days. The CompTIA Advanced Security Practitioner (CASP) Certification is a vendor-neutral credential. The CASP exam is an internationally targeted validation of advanced-level security skills and knowledge. While there is no required prerequisite, the CASP certification is intended to more »
  • Excel 2013: What-If Analysis & Named Scenarios
    July 26 5:30pm
    This workshop lasts 2 hours, and is part of the certificate series Excel 2013 Advanced End-User  This workshop introduces a number of tools that will allow participants to develop what-if models or predict future trends in Excel. Discover how to analyze complex data by using one- and two-input da more »
  • Excel 2013: Basic Automation Using Macros
    July 27 1:30pm
    This workshop lasts 90 minutes, and is part of the certificate series Excel 2013 End-User Macros enable Excel users to automate their work by recording a sequence of commands into a single action. In this workshop, participants will explore how to record and edit macros in Excel, how to make them easi more »
  • Access 2013: Forms
    July 28 9:00am
    This workshop lasts 3.5 hours, and is part of the certificate series Access 2013 End-User Relational forms tie together data from various tables into a single object, facilitating data entry and editing. This workshop is intended for anyone who is interested in learning how to create and enhance vario more »
Monday, July 25, 2016
    IU Calendar




    • CompTIA CASP
      July 26 9:00am
      This workshop lasts 5 days. The CompTIA Advanced Security Practitioner (CASP) Certification is a vendor-neutral credential. The CASP exam is an internationally targeted validation of advanced-level security skills and knowledge. While there is no required prerequisite, the CASP certification is intended to more »
    • CompTIA CASP
      July 26 9:00am
      This workshop lasts 5 days. The CompTIA Advanced Security Practitioner (CASP) Certification is a vendor-neutral credential. The CASP exam is an internationally targeted validation of advanced-level security skills and knowledge. While there is no required prerequisite, the CASP certification is intended to more »
    • Excel 2013: What-If Analysis & Named Scenarios
      July 26 5:30pm
      This workshop lasts 2 hours, and is part of the certificate series Excel 2013 Advanced End-User  This workshop introduces a number of tools that will allow participants to develop what-if models or predict future trends in Excel. Discover how to analyze complex data by using one- and two-input da more »
    • Excel 2013: Basic Automation Using Macros
      July 27 1:30pm
      This workshop lasts 90 minutes, and is part of the certificate series Excel 2013 End-User Macros enable Excel users to automate their work by recording a sequence of commands into a single action. In this workshop, participants will explore how to record and edit macros in Excel, how to make them easi more »
    • Access 2013: Forms
      July 28 9:00am
      This workshop lasts 3.5 hours, and is part of the certificate series Access 2013 End-User Relational forms tie together data from various tables into a single object, facilitating data entry and editing. This workshop is intended for anyone who is interested in learning how to create and enhance vario more »
    Monday, July 25, 2016
      IU Calendar




      • CompTIA CASP
        July 26 9:00am
        This workshop lasts 5 days. The CompTIA Advanced Security Practitioner (CASP) Certification is a vendor-neutral credential. The CASP exam is an internationally targeted validation of advanced-level security skills and knowledge. While there is no required prerequisite, the CASP certification is intended to more »
      • CompTIA CASP
        July 26 9:00am
        This workshop lasts 5 days. The CompTIA Advanced Security Practitioner (CASP) Certification is a vendor-neutral credential. The CASP exam is an internationally targeted validation of advanced-level security skills and knowledge. While there is no required prerequisite, the CASP certification is intended to more »
      • Excel 2013: What-If Analysis & Named Scenarios
        July 26 5:30pm
        This workshop lasts 2 hours, and is part of the certificate series Excel 2013 Advanced End-User  This workshop introduces a number of tools that will allow participants to develop what-if models or predict future trends in Excel. Discover how to analyze complex data by using one- and two-input da more »
      • Excel 2013: Basic Automation Using Macros
        July 27 1:30pm
        This workshop lasts 90 minutes, and is part of the certificate series Excel 2013 End-User Macros enable Excel users to automate their work by recording a sequence of commands into a single action. In this workshop, participants will explore how to record and edit macros in Excel, how to make them easi more »
      • Access 2013: Forms
        July 28 9:00am
        This workshop lasts 3.5 hours, and is part of the certificate series Access 2013 End-User Relational forms tie together data from various tables into a single object, facilitating data entry and editing. This workshop is intended for anyone who is interested in learning how to create and enhance vario more »
      Monday, July 25, 2016
        IU Calendar




        • CompTIA CASP
          July 26 9:00am
          This workshop lasts 5 days. The CompTIA Advanced Security Practitioner (CASP) Certification is a vendor-neutral credential. The CASP exam is an internationally targeted validation of advanced-level security skills and knowledge. While there is no required prerequisite, the CASP certification is intended to more »
        • CompTIA CASP
          July 26 9:00am
          This workshop lasts 5 days. The CompTIA Advanced Security Practitioner (CASP) Certification is a vendor-neutral credential. The CASP exam is an internationally targeted validation of advanced-level security skills and knowledge. While there is no required prerequisite, the CASP certification is intended to more »
        • Excel 2013: What-If Analysis & Named Scenarios
          July 26 5:30pm
          This workshop lasts 2 hours, and is part of the certificate series Excel 2013 Advanced End-User  This workshop introduces a number of tools that will allow participants to develop what-if models or predict future trends in Excel. Discover how to analyze complex data by using one- and two-input da more »
        • Excel 2013: Basic Automation Using Macros
          July 27 1:30pm
          This workshop lasts 90 minutes, and is part of the certificate series Excel 2013 End-User Macros enable Excel users to automate their work by recording a sequence of commands into a single action. In this workshop, participants will explore how to record and edit macros in Excel, how to make them easi more »
        • Access 2013: Forms
          July 28 9:00am
          This workshop lasts 3.5 hours, and is part of the certificate series Access 2013 End-User Relational forms tie together data from various tables into a single object, facilitating data entry and editing. This workshop is intended for anyone who is interested in learning how to create and enhance vario more »
        Monday, July 25, 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




          • CompTIA CASP
            July 26 9:00am
            This workshop lasts 5 days. The CompTIA Advanced Security Practitioner (CASP) Certification is a vendor-neutral credential. The CASP exam is an internationally targeted validation of advanced-level security skills and knowledge. While there is no required prerequisite, the CASP certification is intended to more »
          • CompTIA CASP
            July 26 9:00am
            This workshop lasts 5 days. The CompTIA Advanced Security Practitioner (CASP) Certification is a vendor-neutral credential. The CASP exam is an internationally targeted validation of advanced-level security skills and knowledge. While there is no required prerequisite, the CASP certification is intended to more »
          • Excel 2013: What-If Analysis & Named Scenarios
            July 26 5:30pm
            This workshop lasts 2 hours, and is part of the certificate series Excel 2013 Advanced End-User  This workshop introduces a number of tools that will allow participants to develop what-if models or predict future trends in Excel. Discover how to analyze complex data by using one- and two-input da more »
          • Excel 2013: Basic Automation Using Macros
            July 27 1:30pm
            This workshop lasts 90 minutes, and is part of the certificate series Excel 2013 End-User Macros enable Excel users to automate their work by recording a sequence of commands into a single action. In this workshop, participants will explore how to record and edit macros in Excel, how to make them easi more »
          • Access 2013: Forms
            July 28 9:00am
            This workshop lasts 3.5 hours, and is part of the certificate series Access 2013 End-User Relational forms tie together data from various tables into a single object, facilitating data entry and editing. This workshop is intended for anyone who is interested in learning how to create and enhance vario more »
          Monday, July 25, 2016