Digital Technologies Digital Solutions ICT Applied Download Resources Web Applications Games Recycle Bin

Structured Query Language

SQL lets you access and manipulate databases.
DB Browser for SQLite → download

database basics
# theory prac 1 prac 2
what is a database get bookshop.db error proofing
data flow diagrams connect to bookshop.db inserting a new book
entity relationship diagrams display books data (rows)
normalisation display books data (fields)
creating tables using DDL looping through a list of tuples
foreign key constraints choosing a book
creating a console menu
recording chosen books
sql
# sql 1 sql 2
introduction sum & avg
installation (& restaurant db) min & max
select from count & alias
where group by & having
and or not arithmetic operators
<, > & like subqueries
order by join (& orders db)
distinct, in & between alchemy db
practise learnt skills
limits creating db using db browser
samples
# sqlite3 python
connecting
displaying
interacting
inserting
creating, updating & deleting
case study: pokemon
case study: criminals