New to PG?
Start here
BusinessComputer ScienceDesign & TechnologyEnglishHumanitiesLanguagesMathematicsPEScienceClearReviseAbout
Back to All Units

Practical skills

£120.00 + VAT Discounted rate from £96.00

+

Practical skills in SQL

Essential skills for KS3, GCSE and A Level

>

Inside the Unit...

Download Free Sample 10.1mb

Areas Covered

  • Lesson 1 Intro to SQL
  • Download sample lesson above
  • Lesson 2 WHERE and ORDER BY
  • Lesson 3 LIKE, SUM and COUNT
  • Lesson 4 Using two tables
  • Lesson 5 INSERT and UPDATE
  • Lesson 6 DELETE and SQL injection
  • Unit assessment

There are complete SQL solutions to practical problems included in this unit.

Summary

This unit gives students extensive practical opportunities to use SQL with engaging databases and real-world data. Students begin by learning the basics of SQL including SELECT and WHERE. They then build on WHERE clauses and add in the ability to put data into order with ORDER BY. The aggregate functions SUM and COUNT are covered along with the use of two tables. Adding and editing data using INSERT and UPDATE statements and removing data with the DELETE statement are covered towards the end of the unit.
Finally students will get the opportunity to carry out practical SQL injection.

The unit covers everything required for SQL at GCSE level with OCR, AQA and Cambridge iGCSE exam boards. It is also a thorough foundation to most of the SQL topics required in AQA and OCR A-level.

What's included?

The SQL skills satisfy all of the core skills required for the Computer Science GCSE and most at A Level. This unit contains:

  • PowerPoint slides for each lesson
  • Detailed lesson plans
  • Learning objectives and outcomes
  • Worksheets and homework activities with answers
  • Exemplar project solutions

What people say...

“
”

I've found your service very effective and the materials are great.

Alasdair Sharp. Computer Science teacher, Balfron High School

“
”

Our students like the PG Online Computer Science textbooks as they are comprehensive and detailed, with lots of background information to improve overall understanding of the topics.

Mr Patrick Kilgarriff. Head of Computing & ICT, Gunnersbury Catholic School

Relevant Textbooks

Inside the Unit...

  • Download Free Sample 10.1mb

    Areas Covered

    • Lesson 1 Intro to SQL
    • Download sample lesson above
    • Lesson 2 WHERE and ORDER BY
    • Lesson 3 LIKE, SUM and COUNT
    • Lesson 4 Using two tables
    • Lesson 5 INSERT and UPDATE
    • Lesson 6 DELETE and SQL injection
    • Unit assessment

    There are complete SQL solutions to practical problems included in this unit.

  • How to order

    1. Add individual units to a draft order or download a blank order form below to complete manually

    2. Using a draft order you can either:

    1. Save your order online
      (registration or log in required)
    2. Email us your complete order
      (registration or log in required)
    3. Create a PDF
      (to fax or email at a later date)

    Download blank order form

    PDF

    Word

  • Unit Pricing and Discounts

    Each unit is individually priced for LIFE. Please view each unit for detail. 

    Discounts are cumulative based on the total number of units licenced to your department.

    All prices subject to further discounts and VAT.

    There are no annual renewal fees.

    2-5 units 10% discount
    6-11 units 15% discount
    12+ units 20% discount