Searching for Information: Simple Queries

Learning Objectives Define the terms database, table, column, row, and query. Identify the different parts of a simple query (FIND, FROM, WHERE). Write a simple query to find information based on a single condition. Write a simple query to find information using an 'AND' condition. Predict the results of a given simple query on a small data table. Explain how searching a database is like asking a very specific question. Have you ever tried to find one specific LEGO brick in a giant box? 🧐 A computer can find information instantly if you ask it the right way! Today, we'll become 'Database Detectives'! We will learn how to ask a computer special questions, called queries, to find exactly the information we need. This is a super-power for organizing a...

TermDefinitionExample DatabaseA super organized collection of information stored on a computer, like a digital filing cabinet.A school's database might have information about all its students, teachers, and classes. TableA chart inside a database that holds information about one specific topic. It's made of columns and rows.A 'Pets' table could store information about different pets. ColumnA vertical part of a table that describes one type of information for all items. It's the title at the top of a list.In a 'Pets' table, 'Name', 'AnimalType', and 'Color' would be columns. RowA horizontal part of a table that contains all the information about a single item.In a 'Pets' table, one row might be: 'Fido', &#...

The Basic Query Pattern FIND * FROM [Table Name] WHERE [Column Name] = 'Value' Use this to find all information about items that match your rule. 'FIND *' means 'get all columns'. 'FROM' tells it which table to look in. 'WHERE' sets the condition or rule for the search. The 'AND' Pattern FIND * FROM [Table Name] WHERE [Column 1] = 'Value1' AND [Column 2] = 'Value2' Use 'AND' when you need to find items that match more than one rule at the same time. Both conditions must be true for an item to be found.