Learning Zone ✕

Theory Concepts

Cryptography Computer Hardware Computer Networks Algorithms OOP Programming Binary Data Boolean Logic Database Concepts

Interactive Quizzes

View All Quizzes

GCSE Computer Science (UK)

1.1 System Architecture 1.2 Memory and Storage 1.3 Computer networks 1.4 Network security 1.5 – Systems software 1.6 – Impacts of digital technology
2.1 – Algorithms 2.2 – Programming fundamentals 2.3 – Producing robust programs 2.4 – Boolean logic 2.5 – Programming languages and IDEs

A-Level Computer Science (UK)

1.1 Contemporary processors, input, output and storage devices 1.2 Software and software development 1.3 Exchanging data 1.4 Data types, data structures and algorithms 1.5 Legal, moral, cultural and ethical issues
2.1 Elements of computational thinking 2.2 Problem solving and programming 2.3 Algorithms

Coding Challenges ✕

Python Challenges

Online Python IDE Python Challenges - All Levels Python Challenges - Beginner Level Python Challenges - Intermediate Level Python Challenges - Advanced Level Python Turtle Challenges Solved Challenges Online Glowscript IDE

HTML / CSS & JavaScript

HTML / CSS & JS Editor HTML / CSS & JS Challenges

LMC

LMC Challenges LMC Simulator

SQL

SQL Challenges

Block Programming

BBC micro:bit Challenges Scratch Challenges

Interactive Coding Puzzles

Pirate Island Space Explorer Interactive Coding Quizzes

Online Interactive Tools ✕

Coding Tools

Online Python IDE HTML / CSS & JS Editor LMC Simulator Online Glowscript IDE Flowchart Sudio Trace Table 101 Dashboard Difference Engine Emulator Analytical Engine Emulator

Design Tools

Network Designer Database ERD Designer

Logic Gates Circuits

Logic Gates Circuits Simulator Logic Gates Diagrams Binary Activities Karnaugh Maps

Cryptography Corner

Enigma Simulator Enigma Mission X Turing-Welchman Bombe Simulator Frequency Analysis Cipher Wheel Visual Cryptography Pigpen Cipher Encoder MRX20 Mission to Mars Cryptography Challenges

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
post
page
◑ Python IDE Dashboard

Member's Area ✕

Register/Sign Up

Become a Member Login Your Account Solved Challenges Membership FAQ Logout

Get In Touch

About Us Contact Us Follow Us

Books Corner

101 Python Challenges 101 Extra Python Challenges
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 ›

Powered by  GDPR Cookie Compliance
Privacy Overview

This website will store some information about your preferences on your own computer inside a tiny file called a cookie. A cookie is a small piece of data that a website asks your browser to store on your computer or mobile device. The cookie allows the website to remember your actions or preferences over time.

You can delete all cookies that are already on your computer, and you can set most browsers to prevent them from being placed. However, if you do this, you may have to manually adjust some preferences every time you visit a site, and some services and functionalities may not work.

Most browsers support cookies, but you can set your browser to decline them and can delete them whenever you like. You can find instructions here for how you can do that on various browsers.

This website uses cookies to:

  1. Identify you as a returning user and to count your visits in traffic statistics analysis
  2. Remember your custom display preferences (such as light/dark theme option)
  3. Provide other usability features, including tracking whether you have already given your consent to cookies

Enabling cookies is not strictly necessary for the website to work but it will provide you with a better browsing experience.

The cookie-related information is not used to identify you personally and is not used for any purpose other than those described here.

There may also be other types of cookies created after you have visited this website. This site uses Google Analytics, a popular web analytics service that uses cookies to help to analyse how users use the site. The information generated by the cookie about your use of this website (including your IP address) will be transmitted to and stored by Google on servers in the United States. Google will use this information for the purpose of evaluating your use of other website, compiling reports on website activity, and providing other services relating to website activity and internet usage. Google may also transfer this information to third parties where required to do so by law, or where such third parties process the information on Google’s behalf. Google undertakes not to associate your IP address with any other data held by Google.