• Competition Pool
    March 27 5:30am
    lap swim more »
  • 2017 IU Richard M. Fairbanks School of Public Health Department Breakfast and Event
    March 27 8:00am
    Marion County Health Department Event Alumni who work with the Marion County Health Department are welcome to join Fairbanks School of Public Health Founding Dean Paul Halverson, Dr. Virginia Caine, and members of the alumni association board of directors for an alumni networking breakfast. Enjoy a continental breakfast with colleagues wh more »
  • English Week: Writing about Family and Other Adventures in Memoir Writing
    March 27 11:00am
    Robert Rebein, Matt Daugherty, and JJ Gramlich Writers of memoir often draw their inspiration—and their characters—from the people who populate the inner-most world of childhood: parents, grandparents, siblings, aunts and uncles. These are the people we know best, often the people whose actions, good and bad, have impacted us the more »
  • Competition Pool
    March 27 11:30am
    lap swim more »
  • English Week: Research at the Writing Center: Conversations with Writing Consultant Alumni
    March 27 12:00pm
    Marilee Brooks-Gillies and Patrick Stutz Last summer, we began a Peer Writing Tutor/Consultant Alumni Research Project(PWTCARP) site at IUPUI’s University Writing Center (UWC). Our IRB-approved research is based on work spearheaded by writing center scholars Hughes, Gillespie, and Kail and looks exclusively at the experience more »
Monday, March 27, 2017
    IU Calendar




    • Competition Pool
      March 27 5:30am
      lap swim more »
    • 2017 IU Richard M. Fairbanks School of Public Health Department Breakfast and Event
      March 27 8:00am
      Marion County Health Department Event Alumni who work with the Marion County Health Department are welcome to join Fairbanks School of Public Health Founding Dean Paul Halverson, Dr. Virginia Caine, and members of the alumni association board of directors for an alumni networking breakfast. Enjoy a continental breakfast with colleagues wh more »
    • English Week: Writing about Family and Other Adventures in Memoir Writing
      March 27 11:00am
      Robert Rebein, Matt Daugherty, and JJ Gramlich Writers of memoir often draw their inspiration—and their characters—from the people who populate the inner-most world of childhood: parents, grandparents, siblings, aunts and uncles. These are the people we know best, often the people whose actions, good and bad, have impacted us the more »
    • Competition Pool
      March 27 11:30am
      lap swim more »
    • English Week: Research at the Writing Center: Conversations with Writing Consultant Alumni
      March 27 12:00pm
      Marilee Brooks-Gillies and Patrick Stutz Last summer, we began a Peer Writing Tutor/Consultant Alumni Research Project(PWTCARP) site at IUPUI’s University Writing Center (UWC). Our IRB-approved research is based on work spearheaded by writing center scholars Hughes, Gillespie, and Kail and looks exclusively at the experience more »
    Monday, March 27, 2017
      IU Calendar




      • Competition Pool
        March 27 5:30am
        lap swim more »
      • 2017 IU Richard M. Fairbanks School of Public Health Department Breakfast and Event
        March 27 8:00am
        Marion County Health Department Event Alumni who work with the Marion County Health Department are welcome to join Fairbanks School of Public Health Founding Dean Paul Halverson, Dr. Virginia Caine, and members of the alumni association board of directors for an alumni networking breakfast. Enjoy a continental breakfast with colleagues wh more »
      • English Week: Writing about Family and Other Adventures in Memoir Writing
        March 27 11:00am
        Robert Rebein, Matt Daugherty, and JJ Gramlich Writers of memoir often draw their inspiration—and their characters—from the people who populate the inner-most world of childhood: parents, grandparents, siblings, aunts and uncles. These are the people we know best, often the people whose actions, good and bad, have impacted us the more »
      • Competition Pool
        March 27 11:30am
        lap swim more »
      • English Week: Research at the Writing Center: Conversations with Writing Consultant Alumni
        March 27 12:00pm
        Marilee Brooks-Gillies and Patrick Stutz Last summer, we began a Peer Writing Tutor/Consultant Alumni Research Project(PWTCARP) site at IUPUI’s University Writing Center (UWC). Our IRB-approved research is based on work spearheaded by writing center scholars Hughes, Gillespie, and Kail and looks exclusively at the experience more »
      Monday, March 27, 2017
        IU Calendar




        • Competition Pool
          March 27 5:30am
          lap swim more »
        • 2017 IU Richard M. Fairbanks School of Public Health Department Breakfast and Event
          March 27 8:00am
          Marion County Health Department Event Alumni who work with the Marion County Health Department are welcome to join Fairbanks School of Public Health Founding Dean Paul Halverson, Dr. Virginia Caine, and members of the alumni association board of directors for an alumni networking breakfast. Enjoy a continental breakfast with colleagues wh more »
        • English Week: Writing about Family and Other Adventures in Memoir Writing
          March 27 11:00am
          Robert Rebein, Matt Daugherty, and JJ Gramlich Writers of memoir often draw their inspiration—and their characters—from the people who populate the inner-most world of childhood: parents, grandparents, siblings, aunts and uncles. These are the people we know best, often the people whose actions, good and bad, have impacted us the more »
        • Competition Pool
          March 27 11:30am
          lap swim more »
        • English Week: Research at the Writing Center: Conversations with Writing Consultant Alumni
          March 27 12:00pm
          Marilee Brooks-Gillies and Patrick Stutz Last summer, we began a Peer Writing Tutor/Consultant Alumni Research Project(PWTCARP) site at IUPUI’s University Writing Center (UWC). Our IRB-approved research is based on work spearheaded by writing center scholars Hughes, Gillespie, and Kail and looks exclusively at the experience more »
        Monday, March 27, 2017

          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




          • Competition Pool
            March 27 5:30am
            lap swim more »
          • 2017 IU Richard M. Fairbanks School of Public Health Department Breakfast and Event
            March 27 8:00am
            Marion County Health Department Event Alumni who work with the Marion County Health Department are welcome to join Fairbanks School of Public Health Founding Dean Paul Halverson, Dr. Virginia Caine, and members of the alumni association board of directors for an alumni networking breakfast. Enjoy a continental breakfast with colleagues wh more »
          • English Week: Writing about Family and Other Adventures in Memoir Writing
            March 27 11:00am
            Robert Rebein, Matt Daugherty, and JJ Gramlich Writers of memoir often draw their inspiration—and their characters—from the people who populate the inner-most world of childhood: parents, grandparents, siblings, aunts and uncles. These are the people we know best, often the people whose actions, good and bad, have impacted us the more »
          • Competition Pool
            March 27 11:30am
            lap swim more »
          • English Week: Research at the Writing Center: Conversations with Writing Consultant Alumni
            March 27 12:00pm
            Marilee Brooks-Gillies and Patrick Stutz Last summer, we began a Peer Writing Tutor/Consultant Alumni Research Project(PWTCARP) site at IUPUI’s University Writing Center (UWC). Our IRB-approved research is based on work spearheaded by writing center scholars Hughes, Gillespie, and Kail and looks exclusively at the experience more »
          Monday, March 27, 2017