Embedded Files
Some of terms in the Syllabus section 1.8.3 might seem confusing. However, DDLs are used to create databases and DML is used for changing them. SQL can do both. There are also two main types of SQL: MySQL (open-source, made by Oracle) and MSSQL (made by Microsoft). The differences are slight and since MySQL is open-source it is easier to find tutorials and quizzes.
SQL Practice
W3 Schools
W3schools has 53 exercises which offer practice in writing SQL coding. Work through them all.
SQL ZOO
For additional practice use SQL Zoo https://sqlzoo.net/wiki/SQL_Tutorial- Work through Exercises 1,2,3 and 6. The other exercises are outside the CIE course requirements. The
"Reference How to ...." section is not interactive- so it is better to use W3 schools exercises for these functions.
Entity Relationship Modelling
https://drive.google.com/file/d/19ZSHeyy8iRLv1S3WynBUP4OmeNy5xETa/view?usp=sharing
http://bit.ly/EntityDiagram
Primary Keys vs Foreign Keys Explained https://www.essentialsql.com/what-is-the-difference-between-a-primary-key-and-a-foreign-key/
Ian Simpson Videos
https://www.youtube.com/playlist?list=PLxK3g9_2t07CvjtuDQlFisP0iywQkw8lc
A set of videos looking at example databases questions that you might be expected to answer from the 9608 syllabus
CraignDave Worksheets
Database Normalisation
Databases Past Paper Questions
Other Resources
Entity Relationship Diagrams with Draw.io- Video
Introduction to SQL 6 Videos by Pete Dring
Practice SQL on the sqlzoo online emulator
Game- SQL Island (German Language Only - appears not to work with Google translate)
Free SQL Book - Database-Design-and-Implementation (Howard Gould) far more than you need but if you are interested
Past Paper Videos
w17_qp11_q7 Doctor Patient Appointment System (anc 9608)
s17_qp11_q1- Hospital Nurse System (Andrea Angella) - This video covers the whole of paper 1, but begins with the database question.
Installing SQL on your computer
You can download a copy of MySQL Community Server 8.0.16 here (select the appropriate version according to your operating system). Choose the developer version. Unless, you will have already installed MS Visual C++ , beforehand, it will attempt to install this additional software, (you may need to click OK to approve this). There is no need to sign up for an Oracle account.
Page updated
Report abuse