Sqlite Intro Compucademy

A brief introduction to Sqlite, a lightweight database management system ideal for GCSE and A Level Computer Science study and use with Python. You can check out our blog for articles on GCSE and A Level Computer Science and Python programming at https://compucademy.net/ SQL code is below. The DB Browser for Sqlite can be found here: https://sqlitebrowser.org/ ``` CREATE TABLE cards ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, suit TEXT, suit_symbol TEXT, score INTEGER ); INSERT INTO cards (name, suit, suit_symbol, score) VALUES -- Spades ('A', 'spades', '♠', 1), ('2', 'spades', '♠', 2),