• Administering System Center 2012 Configuration Manager (MOC 10747)
    June 29 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 »
  • Cascade Server: Building a Site
    June 29 9:00am
    This workshop lasts 1 day. Cascade Server: Building a Site will give new site managers the skills they need to plan and build a site in Cascade Server. Users will be provided an empty site and a demonstration username and passphrase. They will be guided through a series of tasks related directly to plannin more »
  • Administering System Center 2012 Configuration Manager (MOC 10747)
    June 29 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 »
  • Canvas: Quizzes & Tests
    June 29 2:00pm
    This workshop lasts 60 minutes. In this webinar, co-presented by CITL and IT Training, participants will learn how to create and grade quizzes and tests in Canvas. Using the functions and flexibility of the Quizzes tool, participants will learn several options for providing feedback on student performance, more »
  • SPSS: The Basics
    June 30 5:30pm
    This workshop lasts 3 hours. SPSS is a powerful statistics application. This workshop, which is intended for people who already have a basic understanding of statistics, introduces SPSS for performing common basic statistical analyses. Participants will learn the basic features of SPSS and how to use it to genera more »
Wednesday, June 29, 2016
    IU Calendar




    • Administering System Center 2012 Configuration Manager (MOC 10747)
      June 29 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 »
    • Cascade Server: Building a Site
      June 29 9:00am
      This workshop lasts 1 day. Cascade Server: Building a Site will give new site managers the skills they need to plan and build a site in Cascade Server. Users will be provided an empty site and a demonstration username and passphrase. They will be guided through a series of tasks related directly to plannin more »
    • Administering System Center 2012 Configuration Manager (MOC 10747)
      June 29 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 »
    • Canvas: Quizzes & Tests
      June 29 2:00pm
      This workshop lasts 60 minutes. In this webinar, co-presented by CITL and IT Training, participants will learn how to create and grade quizzes and tests in Canvas. Using the functions and flexibility of the Quizzes tool, participants will learn several options for providing feedback on student performance, more »
    • SPSS: The Basics
      June 30 5:30pm
      This workshop lasts 3 hours. SPSS is a powerful statistics application. This workshop, which is intended for people who already have a basic understanding of statistics, introduces SPSS for performing common basic statistical analyses. Participants will learn the basic features of SPSS and how to use it to genera more »
    Wednesday, June 29, 2016
      IU Calendar




      • Administering System Center 2012 Configuration Manager (MOC 10747)
        June 29 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 »
      • Cascade Server: Building a Site
        June 29 9:00am
        This workshop lasts 1 day. Cascade Server: Building a Site will give new site managers the skills they need to plan and build a site in Cascade Server. Users will be provided an empty site and a demonstration username and passphrase. They will be guided through a series of tasks related directly to plannin more »
      • Administering System Center 2012 Configuration Manager (MOC 10747)
        June 29 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 »
      • Canvas: Quizzes & Tests
        June 29 2:00pm
        This workshop lasts 60 minutes. In this webinar, co-presented by CITL and IT Training, participants will learn how to create and grade quizzes and tests in Canvas. Using the functions and flexibility of the Quizzes tool, participants will learn several options for providing feedback on student performance, more »
      • SPSS: The Basics
        June 30 5:30pm
        This workshop lasts 3 hours. SPSS is a powerful statistics application. This workshop, which is intended for people who already have a basic understanding of statistics, introduces SPSS for performing common basic statistical analyses. Participants will learn the basic features of SPSS and how to use it to genera more »
      Wednesday, June 29, 2016
        IU Calendar




        • Administering System Center 2012 Configuration Manager (MOC 10747)
          June 29 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 »
        • Cascade Server: Building a Site
          June 29 9:00am
          This workshop lasts 1 day. Cascade Server: Building a Site will give new site managers the skills they need to plan and build a site in Cascade Server. Users will be provided an empty site and a demonstration username and passphrase. They will be guided through a series of tasks related directly to plannin more »
        • Administering System Center 2012 Configuration Manager (MOC 10747)
          June 29 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 »
        • Canvas: Quizzes & Tests
          June 29 2:00pm
          This workshop lasts 60 minutes. In this webinar, co-presented by CITL and IT Training, participants will learn how to create and grade quizzes and tests in Canvas. Using the functions and flexibility of the Quizzes tool, participants will learn several options for providing feedback on student performance, more »
        • SPSS: The Basics
          June 30 5:30pm
          This workshop lasts 3 hours. SPSS is a powerful statistics application. This workshop, which is intended for people who already have a basic understanding of statistics, introduces SPSS for performing common basic statistical analyses. Participants will learn the basic features of SPSS and how to use it to genera more »
        Wednesday, June 29, 2016

          About This Event

          Summary

          This workshop lasts 3.5 hours.

          Relational databases and the data they store are increasingly at the core of how we understand our world and make decisions in it. SQL (Structured Query Language) is the standard programming language used for querying databases and answering questions about the data in databases. Most relational databases, such as Access, SQL Server, Oracle, MySQL, Sybase, and FoxPro, can all be queried using SQL. Participants will learn how to use SQL to retrieve a variety of data for building reports or powering Web and desktop applications. This workshop is intended for participants with a good understanding of relational databases but limited to no experience using SQL.

           

           

          What You'll learn

          • learn basic SQL concepts

          • 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

          What you need to know

          • understand and work with database relationships

          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




          • Administering System Center 2012 Configuration Manager (MOC 10747)
            June 29 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 »
          • Cascade Server: Building a Site
            June 29 9:00am
            This workshop lasts 1 day. Cascade Server: Building a Site will give new site managers the skills they need to plan and build a site in Cascade Server. Users will be provided an empty site and a demonstration username and passphrase. They will be guided through a series of tasks related directly to plannin more »
          • Administering System Center 2012 Configuration Manager (MOC 10747)
            June 29 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 »
          • Canvas: Quizzes & Tests
            June 29 2:00pm
            This workshop lasts 60 minutes. In this webinar, co-presented by CITL and IT Training, participants will learn how to create and grade quizzes and tests in Canvas. Using the functions and flexibility of the Quizzes tool, participants will learn several options for providing feedback on student performance, more »
          • SPSS: The Basics
            June 30 5:30pm
            This workshop lasts 3 hours. SPSS is a powerful statistics application. This workshop, which is intended for people who already have a basic understanding of statistics, introduces SPSS for performing common basic statistical analyses. Participants will learn the basic features of SPSS and how to use it to genera more »
          Wednesday, June 29, 2016