- Free
- Computer Awareness
- 10 lessons
- About 1 h 54 min
Database Basics: Practice
Practice course on Database Basics (Computer Awareness): worked examples and practice.
Start: Tables, records, fields and DBMS
Sign in to keep track of your progress.
About this course
Practice course on Database Basics (Computer Awareness): worked examples and practice.
What you will learn, lesson by lesson
- Tables, records, fields and DBMS Name the parts of a database table and explain what a DBMS does, with exam-style counting questions.
- Keys and relationships between tables Distinguish primary, foreign and candidate keys and identify one-to-one, one-to-many and many-to-many relationships.
- SQL basics: SELECT, WHERE and common commands Read simple SQL queries and predict their results, including SELECT, WHERE, ORDER BY and aggregate functions.
- Data integrity, redundancy and normalisation Explain redundancy, anomalies and the purpose of normalisation in plain language.
- Database mixed practice Attempt mixed questions on tables, keys, SQL and design terms.
Lessons in this course
- 1 Tables, records, fields and DBMS About 12 min Start
- 2 Keys and relationships between tables About 13 min Start
- 3 SQL basics: SELECT, WHERE and common commands About 14 min Start
- 4 Data integrity, redundancy and normalisation About 12 min Start
- 5 Database mixed practice About 14 min Start
- 6 SQL output drills: predict the rows About 13 min Start
- 7 Totals and groups: aggregate and GROUP BY practice About 13 min Start
- 8 Key identification drills: candidate, primary, alternate and foreign About 12 min Start
- 9 Commands, data types and database objects: match-up practice About 11 min Start
- 10 Final self-assessment: database basics Start
Questions about this course
Should I do Foundation first?
If Database Basics is new to you, yes. Start with Database Basics: Foundation and come back to this course after.
Is this course free?
Yes. Every lesson in this course is free to read.
How do I keep track of what I've finished?
Create a free account and sign in. Each lesson you finish is saved to your account and shown here and on your dashboard.
Student reviews
No reviews yet. Students who finish a lesson can rate this course.