BNU: BSc in Computing

Week 9 Activities - SQL INSERT, DELETE, SELECT, UPDATE

Useful Resources

• Wesbite TutorialsPoint: Learn SQL
• Data Generator An online realistic data generator for testing databases.
• Video Access Database Objects , a 4 minute video by Microsoft.
• Video Build Tables and set Data Types , a 4 minute video by Microsoft.
• Video Build Tables with the Table Designer , a 4 minute video by Microsoft.
• Video Add Calculated Fields to a Table , a 4 minute video by Microsoft.
• Video Setting up Table Relationships , a 5 minute video by Microsoft.
• Video Creating relationships using the lookup wizard , a 3 minute video by Microsoft.
• Video Creating relationships using the Relationship Pane , a 3 minute video by Microsoft. This is an alternative to the lookup wizard, but the wizard is usually a better way.
• Video Creating Many to Many relationships , a 4 minute video by Microsoft. It uses the Relationships pane, but I would use the lookup wizard for Product to Order-Details so that when you look in the Order Details table you see the Product name, and not an unrecognisable number.
• Video Creating One to One relationships , a 3 minute video by Microsoft.
• Video Copying data from Excel , a 3 minute video by Microsoft. I think that importing Excel data is a better an more controllable option.
• Video Getting Started with Queries , a 6 minute video by Microsoft. Does not demonstrate Make Table or Append Table queries.
• Tutorial Using Tables in Access 2016 A microsoft tutorial that contains more detail than you need. You need all the topics upto External Data. The first section should help with P1, P2

Week Index

• CO558 Index
• Intro to RDBMS
• Normalise 1NF
• Normalise 2NF 3NF
• Data Modelling 1
• Data Modelling 2
• ERD Case Studies
• TCA1 & TCA2
• Intro to SQL
• SQL Queries
• SQL Joins
• Advanced SQL
• DB Transactions