Edulito
  • Home
  • About Us
    • Reviews
  • Teaching Resources
    • Professor Cody
    • Parents & Kids
    • Freebies
    • GCSE Resources >
      • GCSE Computer Science (from 2016)
      • OCR GCSE Computer Science J277 (from 2020)
      • AQA GCSE Computer Science 8525 (from 2020)
      • Edexcel GCSE Computer Science 1CP2 (from 2020)
    • Books >
      • Professor Cody Book
      • Python - A Nuts and Bolts Guide for Teens
      • OCR CS Exam Revision Workbook
    • KS3 Resources
    • Python Programming
    • YouTube Channel >
      • Prof Cody Scratch Videos
      • Learn to Program with Python
      • GCSE Support Videos
  • Blog
  • Contact
  • AQA GCSE Computer Science 8525 (from 2020)
  • >
  • Teacher Pack: Unit 3.7 Relational Databases and SQL 8525 (from 2020)

Teacher Pack: Unit 3.7 Relational Databases and SQL 8525 (from 2020)

SKU:
£10.00
£10.00
Unavailable
per item

The resources within this Teacher Pack cover all aspects of the specification in relation to AQA GCSE Computer Science 8525 (from 2020) component 3.7.

It includes:                               

·        Teaching PowerPoint (includes checkpoint questions and answers) - 23 slides

·        Student PowerPoint (Includes checkpoint questions, but omits the answers)

·        Homework/Classwork Activities (+ mark schemes)

o  Relational Databases

o  Relational Databases and SQL


·        End of unit test (+ mark scheme)


Content Covered:

Explain the concept of a database.

Explain the concept of a relational database.

Understand the following database concepts:

• table

• record

• field

• primary key

• foreign key.

Understand that the use of a relational database facilitates the elimination of data inconsistency and data redundancy.

Be able to use SQL to retrieve data from a relational database, using the commands:

• SELECT

• FROM

• WHERE

• ORDER BY…ASC | DESC

Be able to use SQL to insert data into a relational database using the commands.

INSERT INTO table_name (column1, column 2 …)

VALUES (value1, value2 …)

Be able to use SQL to edit and delete data in a database using the commands.

UPDATE table name

SET column1 = value1, column2 = value2 ...

WHERE condition

DELETE FROM table_name WHERE condition

  • Facebook
  • Twitter
Add to Cart

Home

Teaching Resources

Freebies

Contact

info@edulito.com    Copyright © 2020
  • Home
  • About Us
    • Reviews
  • Teaching Resources
    • Professor Cody
    • Parents & Kids
    • Freebies
    • GCSE Resources >
      • GCSE Computer Science (from 2016)
      • OCR GCSE Computer Science J277 (from 2020)
      • AQA GCSE Computer Science 8525 (from 2020)
      • Edexcel GCSE Computer Science 1CP2 (from 2020)
    • Books >
      • Professor Cody Book
      • Python - A Nuts and Bolts Guide for Teens
      • OCR CS Exam Revision Workbook
    • KS3 Resources
    • Python Programming
    • YouTube Channel >
      • Prof Cody Scratch Videos
      • Learn to Program with Python
      • GCSE Support Videos
  • Blog
  • Contact