SQL
This comprehensive online guide, provides a background to databases in particular SQL. SQL is short for Structured Query Language; it's a language that is used for constructing statements called queries to perform operations on the data within a database.
Additional details
| Year band(s) | 7-8, 9-10 |
|---|---|
| Content type | Professional learning, Article or research |
| Format | Web page |
| Core and overarching concepts | Data representation, Data acquisition |
| Australian Curriculum Digital Technologies code(s) |
AC9TDI8P01
Acquire, store and validate data from a range of sources using software, including spreadsheets and databases
AC9TDI10P01
Develop techniques to acquire, store and validate data from a range of sources using software, including spreadsheets and databases |
| Keywords | SQL fundamentals |
| Organisation | University of Cambridge and Raspberry Pi Foundation |
| Copyright | © University of Cambridge and Raspberry Pi Foundation. Creative Commons BY-NC-SA 4.0. |
Related resources
-
Big Data
This comprehensive online guide, provides a background on big data. This topic has information on data mining and predictive analytics.
-
Compression
This comprehensive online guide, provides a background to compression. Compression is a technique that reduces file size. This topic has information about lossy and lossless.
-
Databases
This comprehensive online guide, provides a background to databases. This topic has information about simple databases and more complex ones that include a set of related tables, each with fields and keys
-
Representation of numbers
This comprehensive online guide, provides a background to ways number is represented in computer systems. This topic provides information on binary (base-2) and hexadecimal (hex or base-16) that are used by computers.
-
Representation of text
This comprehensive online guide, provides a background to ways text is represented in computer systems. This topic has information about ASCII and Unicode.
-
Representation of sound
This comprehensive online guide, provides a background to ways sounds are represented in computer systems. This topic has information about data that is stored and processed within a computer system, must be in binary form (digital data).
-
Representation of images
This comprehensive online guide, provides a background to ways images are represented in computer systems. This topic has information about bitmapped graphics and vector graphics.