- 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.
Start: Database concepts and the relational model
Sign in to keep track of your progress.
About this course
Advanced course on Database Basics (Computer Awareness): harder problems and exam-level speed.
What you will learn, lesson by lesson
- 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.
- Keys and integrity constraints Identify candidate, primary, alternate, foreign and composite keys in a table and state what each integrity rule protects.
- SQL basics: queries and results Read and write simple SQL statements for creating, selecting, inserting, updating and deleting data, and predict their output.
- Normalisation, ER models and transactions Recognise the first three normal forms, read simple entity-relationship ideas and recall the ACID properties of transactions.
- 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 Database concepts and the relational model About 12 min Free preview
- 2 Keys and integrity constraints About 13 min Premium
- 3 SQL basics: queries and results About 14 min Premium
- 4 Normalisation, ER models and transactions About 13 min Premium
- 5 Mixed advanced problems on databases About 13 min Premium
- 6 Aggregate functions, GROUP BY and HAVING About 14 min Premium
- 7 Joins, Cartesian product and set operations About 14 min Premium
- 8 Functional dependencies and normal forms up to 3NF About 15 min Premium
- 9 Views, indexes, command groups and concurrency About 14 min Premium
- 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.