Computer Science LearnITWithMrC ⛯ Year 7 Year 8 Year 9 GCSE
00
AQA
Responsive image

3.7 - Relational Databases and SQL

UserName

Unknown Login

Class

?

My Target Grade

?

My Current Grade

?

0 results forUnknown Login
1
C/Science Progress Grade

Your current progress out of 10


Includes assessments and L/Objectives

0.00
Assessment Average Score

Based upon assessments out of 0


0%
Assessment Best Score

- 0 results


0%
Assessment Weakest Score

- 0 results


0%

Learning Objectives

0 results forUnknown Login
IDSkill_nameRAG
3.7Relational Databases and SQL
3.7.1Relational databases
 R76 I can explain the concept of a database
 R76 I can explain the concept of a relational database
 R76 I can understand the concept of a table in a database
 R76 I can understand the concept of a record in a database
 R76 I can understand the concept of a field in a database
 R76 I can understand the concept of a primary key in a database
 R76 I can understand the concept of a foreign key in a database
 R76 I can understand that the use of a relational database facilitates the elimination of data inconsistency and data redundancy.
3.7.2Structured query language (SQL)
 R77 I can use SQL to retrieve data from a relational database, using the commands: SELECT FROM, WHERE, ORDER BY, ASC / DESC
 R77 I can use SQL to insert data into a relational database using the commands. INSERT INTO, VALUES
 R77 I can use SQL to update data in a relational database using the commands. UPDATE, SET, WHERE
 R77 I can use SQL to delete data in a relational database using the commands. DELETE FROM, WHERE

Assessment Scores

Click on name for Lesson link



0 results forUnknown Login
Recent Comments

Teacher Date: 29-09-21


Unknown Login


Enter Your comment