• 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

  1. Data, database and DBMS Define a database and a DBMS and explain why they replace scattered paper or file records.
  2. Tables, records, fields and keys Read a table in terms of rows and columns and identify primary and foreign keys.
  3. Relational databases and relationships Explain the relational model and one-to-one, one-to-many and many-to-many relationships.
  4. SQL: asking questions of a database Read and write simple SQL commands such as SELECT, INSERT, UPDATE and DELETE with a WHERE condition.
  5. Integrity, security and database users Understand integrity rules, normalisation in simple terms, backups and the roles of database users.

Lessons in this course

  1. 1 Data, database and DBMS About 11 min Start
  2. 2 Tables, records, fields and keys About 12 min Start
  3. 3 Relational databases and relationships About 12 min Start
  4. 4 SQL: asking questions of a database About 13 min Start
  5. 5 Integrity, security and database users About 12 min Start
  6. 6 Database models: hierarchical, network, relational and NoSQL About 11 min Start
  7. 7 Fields and data types: choosing the right type About 12 min Start
  8. 8 More SQL: conditions, patterns and changing data About 14 min Start
  9. 9 Designing a simple database step by step About 13 min Start
  10. 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.

Keep going

Privacy · Terms · Refunds · Delivery