• Story Mapping to Power Mapping
    June 25 9:00am
    About: This workshop will focus on one tool that can be used in community organizing efforts: power mapping. Power mapping can take many forms, but it always focuses on making strategic plans to influence key decision makers. Anyone who is interested in moving beyond having good intentions and towards taking social action should be able to use t more »
  • Administering System Center 2012 Configuration Manager (MOC 10747)
    June 27 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)
    June 27 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 »
  • Second Session, Resiliency for Mental Well-being
    June 27 2:00pm
    Course Overview: This experiential training offers evidence-based strategies to improve psychological flexibility while minimizing irritability, lack concentration and focus, worry and self-doubt. The program leads to positive outcomes by utilizing: values-oriented living; acceptance and commitment; and mindfulness practices. Facilitate more »
  • Background Check, I-9 and E-Verify Refresher Training
    June 28 9:00am
    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 »
Friday, June 24, 2016
    IU Calendar




    • Story Mapping to Power Mapping
      June 25 9:00am
      About: This workshop will focus on one tool that can be used in community organizing efforts: power mapping. Power mapping can take many forms, but it always focuses on making strategic plans to influence key decision makers. Anyone who is interested in moving beyond having good intentions and towards taking social action should be able to use t more »
    • Administering System Center 2012 Configuration Manager (MOC 10747)
      June 27 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)
      June 27 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 »
    • Second Session, Resiliency for Mental Well-being
      June 27 2:00pm
      Course Overview: This experiential training offers evidence-based strategies to improve psychological flexibility while minimizing irritability, lack concentration and focus, worry and self-doubt. The program leads to positive outcomes by utilizing: values-oriented living; acceptance and commitment; and mindfulness practices. Facilitate more »
    • Background Check, I-9 and E-Verify Refresher Training
      June 28 9:00am
      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 »
    Friday, June 24, 2016
      IU Calendar




      • Story Mapping to Power Mapping
        June 25 9:00am
        About: This workshop will focus on one tool that can be used in community organizing efforts: power mapping. Power mapping can take many forms, but it always focuses on making strategic plans to influence key decision makers. Anyone who is interested in moving beyond having good intentions and towards taking social action should be able to use t more »
      • Administering System Center 2012 Configuration Manager (MOC 10747)
        June 27 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)
        June 27 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 »
      • Second Session, Resiliency for Mental Well-being
        June 27 2:00pm
        Course Overview: This experiential training offers evidence-based strategies to improve psychological flexibility while minimizing irritability, lack concentration and focus, worry and self-doubt. The program leads to positive outcomes by utilizing: values-oriented living; acceptance and commitment; and mindfulness practices. Facilitate more »
      • Background Check, I-9 and E-Verify Refresher Training
        June 28 9:00am
        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 »
      Friday, June 24, 2016
        IU Calendar




        • Story Mapping to Power Mapping
          June 25 9:00am
          About: This workshop will focus on one tool that can be used in community organizing efforts: power mapping. Power mapping can take many forms, but it always focuses on making strategic plans to influence key decision makers. Anyone who is interested in moving beyond having good intentions and towards taking social action should be able to use t more »
        • Administering System Center 2012 Configuration Manager (MOC 10747)
          June 27 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)
          June 27 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 »
        • Second Session, Resiliency for Mental Well-being
          June 27 2:00pm
          Course Overview: This experiential training offers evidence-based strategies to improve psychological flexibility while minimizing irritability, lack concentration and focus, worry and self-doubt. The program leads to positive outcomes by utilizing: values-oriented living; acceptance and commitment; and mindfulness practices. Facilitate more »
        • Background Check, I-9 and E-Verify Refresher Training
          June 28 9:00am
          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 »
        Friday, June 24, 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




          • Story Mapping to Power Mapping
            June 25 9:00am
            About: This workshop will focus on one tool that can be used in community organizing efforts: power mapping. Power mapping can take many forms, but it always focuses on making strategic plans to influence key decision makers. Anyone who is interested in moving beyond having good intentions and towards taking social action should be able to use t more »
          • Administering System Center 2012 Configuration Manager (MOC 10747)
            June 27 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)
            June 27 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 »
          • Second Session, Resiliency for Mental Well-being
            June 27 2:00pm
            Course Overview: This experiential training offers evidence-based strategies to improve psychological flexibility while minimizing irritability, lack concentration and focus, worry and self-doubt. The program leads to positive outcomes by utilizing: values-oriented living; acceptance and commitment; and mindfulness practices. Facilitate more »
          • Background Check, I-9 and E-Verify Refresher Training
            June 28 9:00am
            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 »
          Friday, June 24, 2016