Year 11 - Computing
SQL searches
Databases and SQL
Study Hub
Study Guides
This pupil-friendly study guide includes a unit summary, clear notes, common mistakes, and quick questions with answers.
Unit Summary
This unit introduces pupils to databases and SQL, they will explore the key terms used in a database and why relational databases are used to eliminate the redundancy that can occur in a flat file database. They will explore SQL commands to retrieve, update, and delete data in a relational database.
Lesson Summary
You will learn to use SQL to retrieve data from a relational database.
Key Notes
- SQL stands for Structured Query Language. It is a language used to communicate with a database.
- You can use SQL to manipulate databases and retrieve records.
- An SQL SELECT statement allows you to retrieve data from a database.
- The SQL SELECT * statement allows you to return all the data and fields from a table.
Vocabulary To Learn
- SELECT: allows you to retrieve data from a database
- SELECT *: allows you to return all the columns from a database table
Common Mistakes To Avoid
- Using SELECT * is always the best method for returning data from a database table.
3 Quick Questions (With Answers)
1. Describe the system or process from this lesson in clear steps.
SQL stands for Structured Query Language. It is a language used to communicate with a database. You can use SQL to manipulate databases and retrieve records.
2. Define this computing term and give one practical example. 'SELECT'
allows you to retrieve data from a database. Add one real device or system example to prove understanding.
3. Correct this common computing misconception.
Mistake: Using SELECT * is always the best method for returning data from a database table. Correction: You should only use the SELECT * query when all fields are needed. Including unnecessary data can be frustrating for the person viewing and working with the results.
More Lessons In This Unit
Browse all guides in the Year 11 Computing guide library.