Unit 2: Application and data solutions
Week	Theory	Practical	Additional learning experiences (or homework)
	what is a database SQL 1 exercises column: select from where and or not order by distinct in limits	get bookshop connect bookshop sqlite3 python connecting get restuarant.db	practise SQL on bookshop.db get bookshop.db
	SQL 2 exercises column: sum avg min max count alias group by having arithmetic subqueries join creating a database	display rows display fields looping through tuples sqlite3 python display sqlite3 python interaction	create table & insert data pokemon case study distributed example criminals.db case study choosing a book creating a console menu
	Data flow diagrams finish SQL exercises columns	sqlite3 python insert sqlite3 python create update delete draw dfd online save to device	alchemy.db practise queries practise dfd for alchemy.db books receipt
	Entity Relationship Diagram SQL from ERD Normalisation 1 Normalisation 2	sqlite3 python insert sqlite3 python create update delete draw dfd online save to device	alchemy.db practise queries practise dfd for alchemy.db error proofing insert book
	data interchange formats from Unit 3: CSV XML | XML parts JSON | JSON parts more CSV examples more JSON examples	SQLite Examples Flask should be using jinja templates more SQLite, Python & Flask examples	more foreign key examples for personal interest only: Big-O worst case algorithm complexity set theory | logic gates (exercises): Boolean logic (AND OR NOT) and table joins webscraping data
	Catch up week. Recap Unit 1: Creating With Code theory. FIA2 digital solution for remainder of Unit 2.