• CompTIA CASP
    July 27 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 27 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 »
  • 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 »
  • The Office of Equal Opportunity Legal Compliance Training
    July 28 10:00am
    Course Overview:  The Office of Equal Opportunity Legal Compliance Course will provide necessary information to supervisors and HR Professionals in relation to Affirmative Action, Equal Employment Opportunity and the American's with Disabilities Act.  Learning Objectives: - Understand the latest Equal Employment Opportun more »
  • Background Check, I-9 and E-Verify Refresher Training
    July 28 1:30pm
    Course Overview:  This is intended as a refresher/update training on processing background checks, I-9s and E-Verify checks through GIS. However, we will include a brief outline of the basics before moving on to more complicated issues, such as remote hires, non-US citizen hires, and handling Tentative Non-Confirmations. Will discuss crit more »
Wednesday, July 27, 2016
    IU Calendar




    • CompTIA CASP
      July 27 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 27 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 »
    • 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 »
    • The Office of Equal Opportunity Legal Compliance Training
      July 28 10:00am
      Course Overview:  The Office of Equal Opportunity Legal Compliance Course will provide necessary information to supervisors and HR Professionals in relation to Affirmative Action, Equal Employment Opportunity and the American's with Disabilities Act.  Learning Objectives: - Understand the latest Equal Employment Opportun more »
    • Background Check, I-9 and E-Verify Refresher Training
      July 28 1:30pm
      Course Overview:  This is intended as a refresher/update training on processing background checks, I-9s and E-Verify checks through GIS. However, we will include a brief outline of the basics before moving on to more complicated issues, such as remote hires, non-US citizen hires, and handling Tentative Non-Confirmations. Will discuss crit more »
    Wednesday, July 27, 2016
      IU Calendar




      • CompTIA CASP
        July 27 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 27 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 »
      • 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 »
      • The Office of Equal Opportunity Legal Compliance Training
        July 28 10:00am
        Course Overview:  The Office of Equal Opportunity Legal Compliance Course will provide necessary information to supervisors and HR Professionals in relation to Affirmative Action, Equal Employment Opportunity and the American's with Disabilities Act.  Learning Objectives: - Understand the latest Equal Employment Opportun more »
      • Background Check, I-9 and E-Verify Refresher Training
        July 28 1:30pm
        Course Overview:  This is intended as a refresher/update training on processing background checks, I-9s and E-Verify checks through GIS. However, we will include a brief outline of the basics before moving on to more complicated issues, such as remote hires, non-US citizen hires, and handling Tentative Non-Confirmations. Will discuss crit more »
      Wednesday, July 27, 2016
        IU Calendar




        • CompTIA CASP
          July 27 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 27 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 »
        • 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 »
        • The Office of Equal Opportunity Legal Compliance Training
          July 28 10:00am
          Course Overview:  The Office of Equal Opportunity Legal Compliance Course will provide necessary information to supervisors and HR Professionals in relation to Affirmative Action, Equal Employment Opportunity and the American's with Disabilities Act.  Learning Objectives: - Understand the latest Equal Employment Opportun more »
        • Background Check, I-9 and E-Verify Refresher Training
          July 28 1:30pm
          Course Overview:  This is intended as a refresher/update training on processing background checks, I-9s and E-Verify checks through GIS. However, we will include a brief outline of the basics before moving on to more complicated issues, such as remote hires, non-US citizen hires, and handling Tentative Non-Confirmations. Will discuss crit more »
        Wednesday, July 27, 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




          • CompTIA CASP
            July 27 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 27 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 »
          • 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 »
          • The Office of Equal Opportunity Legal Compliance Training
            July 28 10:00am
            Course Overview:  The Office of Equal Opportunity Legal Compliance Course will provide necessary information to supervisors and HR Professionals in relation to Affirmative Action, Equal Employment Opportunity and the American's with Disabilities Act.  Learning Objectives: - Understand the latest Equal Employment Opportun more »
          • Background Check, I-9 and E-Verify Refresher Training
            July 28 1:30pm
            Course Overview:  This is intended as a refresher/update training on processing background checks, I-9s and E-Verify checks through GIS. However, we will include a brief outline of the basics before moving on to more complicated issues, such as remote hires, non-US citizen hires, and handling Tentative Non-Confirmations. Will discuss crit more »
          Wednesday, July 27, 2016