Study Hub

Study Guides

This pupil-friendly study guide includes a unit summary, clear notes, common mistakes, and quick questions with answers.

Back to Study HubBrowse Year 11 Computing Guides

Year 11 - Computing

SQL fundamentals

Databases and SQL

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 create SQL queries to insert and update data stored in a 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 INSERT statement allows you to add data into pre-existing tables.
  • An SQL UPDATE statement allows you to modify records.
  • Existing records can be deleted from a table by using an SQL DELETE statement.

Vocabulary To Learn

  • SQL: Structured Query Language: declarative language designed for managing data held in a relational database management system
  • INSERT: an SQL INSERT statement allows you to add data into pre-existing tables
  • UPDATE: an SQL UPDATE statement allows you to modify records

Common Mistakes To Avoid

  • You can delete data from a database using an SQL command without any consideration.

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. 'SQL'

Structured Query Language: declarative language designed for managing data held in a relational database management system. Add one real device or system example to prove understanding.

3. Correct this common computing misconception.

Mistake: You can delete data from a database using an SQL command without any consideration. Correction: You should delete data using SQL commands carefully as data may be linked to other tables in the database.

More Lessons In This Unit

Browse all guides in the Year 11 Computing guide library.