Tag: SQL

The Computer Shop – SQL Task

Posted on by Administrator Posted in A Level Concepts, Computer Science, Computing Concepts, Database Concepts, GCSE Concepts, Solved Challenges, SQL

Working for an online computer shop, you have been asked to assist customers in finding the best computer deal to match their requirements and needs. Your shop has access to a large variety of laptop and desktop computers and hence…

Read more ›

The Bike Shop – SQL Task

Posted on by Administrator Posted in A Level Concepts, Computer Science, Computing Concepts, Database Concepts, GCSE Concepts, Solved Challenges, SQL

As a newly appointed shop assistant for your local bike shop, you have been asked to help customers find their dream bike: a bike that meets all of their requirements. Your shop has access to a large variety of mountain…

Read more ›

SQL Investigation: The Stolen Gemstones

Posted on by Administrator Posted in A Level Concepts, A Level Quiz, Computer Science, Computing Concepts, Database Concepts, GCSE Concepts, GCSE Quiz, Quizzes, Solved Challenges, SQL

On July the 12th, a hundred prestigious guests were invited to the Precious Gemstones Exposition at the famous Royal Castle, England. This exposition provides a unique opportunity to admire the most precious and valuable gemstones in the world. The gemstones…

Read more ›

Relational Databases – Crossword

Posted on by Administrator Posted in A Level Concepts, A Level Quiz, Computer Science, Computing Concepts, Computing Terminology Quiz, Crosswords, Database Concepts, Quizzes, Solved Challenges

Are you confident with your knowledge of key Relational Databases concepts? You can find our more about Relational Databases on the following page.

Relational Databases

Posted on by Administrator Posted in A Level Concepts, Computer Science, Computing Concepts, Database Concepts

Tables, Records & Fields A table is a collection of records. Each record is made of fields. Each field has a data type such as String/Text, Integer, Float/Real, Boolean, Date & Time, etc. Primary Keys, Foreign Keys & Relationships The…

Read more ›

Question Time – Relational Databases

Posted on by Administrator Posted in A Level Concepts, A Level Quiz, Computer Science, Computing Concepts, Database Concepts, Quizzes

– Online Database – – SQL Activities – Feeling confident with your computing knowledge of Relational Databases? Spend a few minutes to answer or research the following questions: ? What are tables used for in a relational database? ? How…

Read more ›

Learn SQL

Posted on by Administrator Posted in A Level Concepts, Computer Science, Computing Concepts, Database Concepts, SQL

SQL is a language used to query a database. In other words SQL is used to filter, sort and manipulate data stored in relational databases. By completing the following activities you will learn more about the syntax of SQL and…

Read more ›