- Free
- Computer Awareness
- 10 lessons
- About 1 h 50 min
Database Basics: Foundation
Foundation course on Database Basics (Computer Awareness): the basics, explained from the start.
Start: Data, database and DBMS
Sign in to keep track of your progress.
About this course
Foundation course on Database Basics (Computer Awareness): the basics, explained from the start.
What you will learn, lesson by lesson
- Data, database and DBMS Define a database and a DBMS and explain why they replace scattered paper or file records.
- Tables, records, fields and keys Read a table in terms of rows and columns and identify primary and foreign keys.
- Relational databases and relationships Explain the relational model and one-to-one, one-to-many and many-to-many relationships.
- SQL: asking questions of a database Read and write simple SQL commands such as SELECT, INSERT, UPDATE and DELETE with a WHERE condition.
- Integrity, security and database users Understand integrity rules, normalisation in simple terms, backups and the roles of database users.
Lessons in this course
- 1 Data, database and DBMS About 11 min Start
- 2 Tables, records, fields and keys About 12 min Start
- 3 Relational databases and relationships About 12 min Start
- 4 SQL: asking questions of a database About 13 min Start
- 5 Integrity, security and database users About 12 min Start
- 6 Database models: hierarchical, network, relational and NoSQL About 11 min Start
- 7 Fields and data types: choosing the right type About 12 min Start
- 8 More SQL: conditions, patterns and changing data About 14 min Start
- 9 Designing a simple database step by step About 13 min Start
- 10 Final self-assessment: database basics Start
Questions about this course
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.