Learn about and revise the topics of relational databases and structured query language (SQL) with this BBC Bitesize GCSE Computer Science AQA study guide.

For technical clarification, databases come in two flavors: relational and non-relational. Relational (SQL) databases store data in tables with strictly-defined relationships between tables.

SQL-based relational servers are built to handle the demands of financial transactions, designed around the tenets of ACID: Atomicity, Consistency, Isolation, and Durability.

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we ...

These relational databases expanded how companies could store and manage their data, but SQL made it possible to interact with that data in ways that matched their business processes.

Relational databases for operations on large data sets are contraindicated because SQL queries tend to consume many CPU cycles and thrash the disk as they process data.

Even with all the hype around NoSQL, traditional relational databases still make sense for enterprise applications. Here are four reasons why.

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.