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…
More results...
Tag: SQL
The Bike Shop – SQL Task
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…
SQL Investigation: The Stolen Gemstones
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…
Relational Databases – Crossword
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
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…
Question Time – Relational Databases
– 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…
Learn 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…
LMC Simulator
Flowchart Studio
Python Syntax