Lesson about SQL. Contains elements of component 1.3.2 (d) from OCR A-Level Computer Science spec. Lesson has exam style questions with mark scheme.
Contains explanations of SQL, how to query a relational database (obtain data from multiple tables with one query), creating tables using SQL, inserting and modifying data in tables using SQL. Example of the SQL commands are given followed by exam style questions. Best done over 2 lessons and using an SQL server so the students can type the code and create the database and then query the database.
Included is a Powerpoint with notes and tasks, exam question worksheet to help aid progress.
Please leave a review with your feedback. Thanks
Get this resource as part of a bundle and save up to 41%
A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£2.50