CSE 2111 Lecture Notes - Lecture 21: Sql, Graphical User Interface

• School: Ohio State University
• Department: Computer Science & Engineering
• Course: CSE 2111
• Professor: Mark Jackson

Document Summary

Cse 2111 lecture 21 querying a database. Query: a request for information from a database. To extract information from the database: a dynaset, or subset of the database is displayed. Structured query language (sql: ms access 2010, supplies a graphical user interface (gui) called the query by example. The language you use to talk to the database. Wild cards in criteria: an asterisk * replaces any number of characters. Like *cookie* - in product name field will select all records that include the word cookie in the product name field. Like c* in product name field will select c, cookie, cake: a ? replaces a single character. Like b? in the category field will select all records that consists of two characters and start with the letter b . Includes records that have matching keys on both tables. An inner join which is the default join type in access. Multiple conditions in a query: boolean operators - and, or, and.