Objective:
This section introduces database queries. After finishing this section, you should be able to:
- Compare and contrast different methods of accessing data from a database.
- Describe the purpose of basic SQL commands.
- Interpret simple SQL queries.
- Answer basic questions about existing Microsoft Access queries.
- Use Microsoft Access to perform basic queries on a database.
- Write SQL commands to do the following:
- Retrieve all data from a particular table.
- Retrieve table data that matches certain criteria.
- Add a new record to an existing table.
- Delete a record from a table.
Links:
- TestOut Courseware: https://labsimapp.testout.com/
Key Terms:
- Query
- Direct Access
- Query Builder
- User Interface Access
- Programmatic Access
- SQL
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
Topics Discussed:
- What kinds of database queries do I already use?
- What is the relationship between queries and CRUD (Create, Read, Update, Delete)?
Assignment:
- Access the TestOut Courseware through the provided link.
- Study 7.4: Querying Databases and complete the 7.4.5, 7.4.7, 7.4.11, 7.4.12, 7.4.13, 7.4.14 & 7.4.15 Labs/Activities and the 10 question Exam to complete the Section.
Assigned: April 24th, 2024
Teacher Pacing Due Date: April 25th, 2024
AZ CS Standard: Computing Systems – HS.CS.T.1