• Competition Pool
    March 27 11:30am
    lap swim more »
  • Competition Pool
    March 28 5:30am
    lap swim more »
  • Phyllis Bramson | Love and Affection in a Hostile World
    March 28 10:00am
    A survey of Chicago-based artist Phyllis Bramson's provocative painting and mixed-media work, which examine Eastern iconography as constructed in the Western imagination. more »
  • English Week: Building Community Partnerships Through Writing in W231
    March 28 11:00am
    Mary Ann Cohen, Dustin Branum, Sarah Grace Fraser, Taylor Gibbs, and Garad Huckleberry W231 introduces students to expanded research and writing skills and emphasizes the role of professional writing. As their main project, W231 students collaborate and solve a problem faced by a local business or organization. The teams conduct research to id more »
  • English Week: Graduate Student Experiences in the Teaching English Practicum
    March 28 12:00pm
    Julie Belz with Samantha Melvin, Esen Gokpinar-Shelton, Kim Robertson, and Kim Waletich The English Department at IUPUI offers two graduate degrees in Teaching English to Speakers of Other Languages (TESOL): a graduate certificate (18 credits) and an MA TESOL (31 credits). Five former and current TESOL students will speak about their d more »
Monday, March 27, 2017
    IU Calendar




    • Competition Pool
      March 27 11:30am
      lap swim more »
    • Competition Pool
      March 28 5:30am
      lap swim more »
    • Phyllis Bramson | Love and Affection in a Hostile World
      March 28 10:00am
      A survey of Chicago-based artist Phyllis Bramson's provocative painting and mixed-media work, which examine Eastern iconography as constructed in the Western imagination. more »
    • English Week: Building Community Partnerships Through Writing in W231
      March 28 11:00am
      Mary Ann Cohen, Dustin Branum, Sarah Grace Fraser, Taylor Gibbs, and Garad Huckleberry W231 introduces students to expanded research and writing skills and emphasizes the role of professional writing. As their main project, W231 students collaborate and solve a problem faced by a local business or organization. The teams conduct research to id more »
    • English Week: Graduate Student Experiences in the Teaching English Practicum
      March 28 12:00pm
      Julie Belz with Samantha Melvin, Esen Gokpinar-Shelton, Kim Robertson, and Kim Waletich The English Department at IUPUI offers two graduate degrees in Teaching English to Speakers of Other Languages (TESOL): a graduate certificate (18 credits) and an MA TESOL (31 credits). Five former and current TESOL students will speak about their d more »
    Monday, March 27, 2017
      IU Calendar




      • Competition Pool
        March 27 11:30am
        lap swim more »
      • Competition Pool
        March 28 5:30am
        lap swim more »
      • Phyllis Bramson | Love and Affection in a Hostile World
        March 28 10:00am
        A survey of Chicago-based artist Phyllis Bramson's provocative painting and mixed-media work, which examine Eastern iconography as constructed in the Western imagination. more »
      • English Week: Building Community Partnerships Through Writing in W231
        March 28 11:00am
        Mary Ann Cohen, Dustin Branum, Sarah Grace Fraser, Taylor Gibbs, and Garad Huckleberry W231 introduces students to expanded research and writing skills and emphasizes the role of professional writing. As their main project, W231 students collaborate and solve a problem faced by a local business or organization. The teams conduct research to id more »
      • English Week: Graduate Student Experiences in the Teaching English Practicum
        March 28 12:00pm
        Julie Belz with Samantha Melvin, Esen Gokpinar-Shelton, Kim Robertson, and Kim Waletich The English Department at IUPUI offers two graduate degrees in Teaching English to Speakers of Other Languages (TESOL): a graduate certificate (18 credits) and an MA TESOL (31 credits). Five former and current TESOL students will speak about their d more »
      Monday, March 27, 2017
        IU Calendar




        • Competition Pool
          March 27 11:30am
          lap swim more »
        • Competition Pool
          March 28 5:30am
          lap swim more »
        • Phyllis Bramson | Love and Affection in a Hostile World
          March 28 10:00am
          A survey of Chicago-based artist Phyllis Bramson's provocative painting and mixed-media work, which examine Eastern iconography as constructed in the Western imagination. more »
        • English Week: Building Community Partnerships Through Writing in W231
          March 28 11:00am
          Mary Ann Cohen, Dustin Branum, Sarah Grace Fraser, Taylor Gibbs, and Garad Huckleberry W231 introduces students to expanded research and writing skills and emphasizes the role of professional writing. As their main project, W231 students collaborate and solve a problem faced by a local business or organization. The teams conduct research to id more »
        • English Week: Graduate Student Experiences in the Teaching English Practicum
          March 28 12:00pm
          Julie Belz with Samantha Melvin, Esen Gokpinar-Shelton, Kim Robertson, and Kim Waletich The English Department at IUPUI offers two graduate degrees in Teaching English to Speakers of Other Languages (TESOL): a graduate certificate (18 credits) and an MA TESOL (31 credits). Five former and current TESOL students will speak about their d more »
        Monday, March 27, 2017

          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




          • Competition Pool
            March 27 11:30am
            lap swim more »
          • Competition Pool
            March 28 5:30am
            lap swim more »
          • Phyllis Bramson | Love and Affection in a Hostile World
            March 28 10:00am
            A survey of Chicago-based artist Phyllis Bramson's provocative painting and mixed-media work, which examine Eastern iconography as constructed in the Western imagination. more »
          • English Week: Building Community Partnerships Through Writing in W231
            March 28 11:00am
            Mary Ann Cohen, Dustin Branum, Sarah Grace Fraser, Taylor Gibbs, and Garad Huckleberry W231 introduces students to expanded research and writing skills and emphasizes the role of professional writing. As their main project, W231 students collaborate and solve a problem faced by a local business or organization. The teams conduct research to id more »
          • English Week: Graduate Student Experiences in the Teaching English Practicum
            March 28 12:00pm
            Julie Belz with Samantha Melvin, Esen Gokpinar-Shelton, Kim Robertson, and Kim Waletich The English Department at IUPUI offers two graduate degrees in Teaching English to Speakers of Other Languages (TESOL): a graduate certificate (18 credits) and an MA TESOL (31 credits). Five former and current TESOL students will speak about their d more »
          Monday, March 27, 2017