• Premium
  • Computer Awareness
  • 10 lessons
  • About 2 h 2 min

Database Basics: Advanced

Advanced course on Database Basics (Computer Awareness): harder problems and exam-level speed.

About this course

Advanced course on Database Basics (Computer Awareness): harder problems and exam-level speed.

What you will learn, lesson by lesson

  1. Database concepts and the relational model Define database, DBMS, table, record, field and the terms used in the relational model such as tuple, attribute, degree and cardinality.
  2. Keys and integrity constraints Identify candidate, primary, alternate, foreign and composite keys in a table and state what each integrity rule protects.
  3. SQL basics: queries and results Read and write simple SQL statements for creating, selecting, inserting, updating and deleting data, and predict their output.
  4. Normalisation, ER models and transactions Recognise the first three normal forms, read simple entity-relationship ideas and recall the ACID properties of transactions.
  5. Mixed advanced problems on databases Solve mixed questions on terminology, keys, SQL output and design by applying the rules from earlier lessons.

Lessons in this course

  1. 1 Database concepts and the relational model About 12 min Free preview
  2. 2 Keys and integrity constraints About 13 min Premium
  3. 3 SQL basics: queries and results About 14 min Premium
  4. 4 Normalisation, ER models and transactions About 13 min Premium
  5. 5 Mixed advanced problems on databases About 13 min Premium
  6. 6 Aggregate functions, GROUP BY and HAVING About 14 min Premium
  7. 7 Joins, Cartesian product and set operations About 14 min Premium
  8. 8 Functional dependencies and normal forms up to 3NF About 15 min Premium
  9. 9 Views, indexes, command groups and concurrency About 14 min Premium
  10. 10 Final self-assessment: database concepts Premium

Questions about this course

Should I do Foundation first?

If Database Basics is new to you, yes. Start with Database Basics: Foundation, then Practice, and come back to this course after.

Is this course free?

This is a premium course. Lessons marked “Free preview” are open to everyone.

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