• 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

  1. Tables, records, fields and DBMS Name the parts of a database table and explain what a DBMS does, with exam-style counting questions.
  2. Keys and relationships between tables Distinguish primary, foreign and candidate keys and identify one-to-one, one-to-many and many-to-many relationships.
  3. SQL basics: SELECT, WHERE and common commands Read simple SQL queries and predict their results, including SELECT, WHERE, ORDER BY and aggregate functions.
  4. Data integrity, redundancy and normalisation Explain redundancy, anomalies and the purpose of normalisation in plain language.
  5. Database mixed practice Attempt mixed questions on tables, keys, SQL and design terms.

Lessons in this course

  1. 1 Tables, records, fields and DBMS About 12 min Start
  2. 2 Keys and relationships between tables About 13 min Start
  3. 3 SQL basics: SELECT, WHERE and common commands About 14 min Start
  4. 4 Data integrity, redundancy and normalisation About 12 min Start
  5. 5 Database mixed practice About 14 min Start
  6. 6 SQL output drills: predict the rows About 13 min Start
  7. 7 Totals and groups: aggregate and GROUP BY practice About 13 min Start
  8. 8 Key identification drills: candidate, primary, alternate and foreign About 12 min Start
  9. 9 Commands, data types and database objects: match-up practice About 11 min Start
  10. 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.

Keep going

Privacy · Terms · Refunds · Delivery