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

Python Challenges - All Levels Python Challenges - Beginner Level Python Challenges - Intermediate Level Python Challenges - Advanced Level Python Turtle Challenges Solved Challenges

HTML / CSS & JavaScript

HTML / CSS & JavaScript

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 LMC Simulator Flowchart Sudio Trace Table 101 Dashboard

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 ›