• NCAA DI Men's Championships
    March 24 12:00am
    Swim Meet more »
  • CLOSED
    March 24 12:00am
    Swim Meet more »
  • CLOSED
    March 25 12:00am
    Closed more »
  • C. Thomas Lewis | The Virgin Forest Project
    March 25 10:00am
    C. Thomas Lewis invites audiences to experience the sights and sounds of three Indiana forests through a series of immersive, high-definition films. Lewis is a lecturer in IUPUI's Media Arts and Science program. more »
  • Freya Powell | Omniscience and Oblivion
    March 25 10:00am
    For this sound installation, New York-based artist Freya Powell created an audio archive where participants were invited to anonymously share one memory they would like to keep forever and one they would like to let go. more »
Friday, March 24, 2017
    IU Calendar




    • NCAA DI Men's Championships
      March 24 12:00am
      Swim Meet more »
    • CLOSED
      March 24 12:00am
      Swim Meet more »
    • CLOSED
      March 25 12:00am
      Closed more »
    • C. Thomas Lewis | The Virgin Forest Project
      March 25 10:00am
      C. Thomas Lewis invites audiences to experience the sights and sounds of three Indiana forests through a series of immersive, high-definition films. Lewis is a lecturer in IUPUI's Media Arts and Science program. more »
    • Freya Powell | Omniscience and Oblivion
      March 25 10:00am
      For this sound installation, New York-based artist Freya Powell created an audio archive where participants were invited to anonymously share one memory they would like to keep forever and one they would like to let go. more »
    Friday, March 24, 2017
      IU Calendar




      • NCAA DI Men's Championships
        March 24 12:00am
        Swim Meet more »
      • CLOSED
        March 24 12:00am
        Swim Meet more »
      • CLOSED
        March 25 12:00am
        Closed more »
      • C. Thomas Lewis | The Virgin Forest Project
        March 25 10:00am
        C. Thomas Lewis invites audiences to experience the sights and sounds of three Indiana forests through a series of immersive, high-definition films. Lewis is a lecturer in IUPUI's Media Arts and Science program. more »
      • Freya Powell | Omniscience and Oblivion
        March 25 10:00am
        For this sound installation, New York-based artist Freya Powell created an audio archive where participants were invited to anonymously share one memory they would like to keep forever and one they would like to let go. more »
      Friday, March 24, 2017
        IU Calendar




        • NCAA DI Men's Championships
          March 24 12:00am
          Swim Meet more »
        • CLOSED
          March 24 12:00am
          Swim Meet more »
        • CLOSED
          March 25 12:00am
          Closed more »
        • C. Thomas Lewis | The Virgin Forest Project
          March 25 10:00am
          C. Thomas Lewis invites audiences to experience the sights and sounds of three Indiana forests through a series of immersive, high-definition films. Lewis is a lecturer in IUPUI's Media Arts and Science program. more »
        • Freya Powell | Omniscience and Oblivion
          March 25 10:00am
          For this sound installation, New York-based artist Freya Powell created an audio archive where participants were invited to anonymously share one memory they would like to keep forever and one they would like to let go. more »
        Friday, March 24, 2017

          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




          • NCAA DI Men's Championships
            March 24 12:00am
            Swim Meet more »
          • CLOSED
            March 24 12:00am
            Swim Meet more »
          • CLOSED
            March 25 12:00am
            Closed more »
          • C. Thomas Lewis | The Virgin Forest Project
            March 25 10:00am
            C. Thomas Lewis invites audiences to experience the sights and sounds of three Indiana forests through a series of immersive, high-definition films. Lewis is a lecturer in IUPUI's Media Arts and Science program. more »
          • Freya Powell | Omniscience and Oblivion
            March 25 10:00am
            For this sound installation, New York-based artist Freya Powell created an audio archive where participants were invited to anonymously share one memory they would like to keep forever and one they would like to let go. more »
          Friday, March 24, 2017