Bang Ti Lenydoor

SQL & Databases Professional Certificate

Wishlist Share
Course cover: SQL & Databases with Free Tools

About Course

NewThis certificate just launched and is open for enrollment now.

This beginner course teaches databases and SQL using tools that cost nothing: SQLite, a free database engine that keeps a whole database in one file, and DB Browser for SQLite, a free and open source visual tool. It is written for young people and small-organisation staff in South Sudan and East Africa who often work on older, low-specification laptops with limited data.

You begin with what a database is, how tables, rows, columns and keys work, and how a database differs from a spreadsheet. You then learn to read data with SELECT, filter and sort it, summarise it with COUNT, SUM, AVG and GROUP BY, and change it safely with INSERT, UPDATE and DELETE. Later modules cover designing tables with primary and foreign keys, normalisation, INNER and LEFT JOINs, NULL values, simple subqueries, views and indexes.

Because beneficiary records are about real people, the course also teaches data privacy and backup habits. The same standard SQL works, with small differences, in MySQL and PostgreSQL, and the lessons point out where those differences appear. All example data is fictional.

The course has 24 written lessons, a quiz after each of the first five modules, a capstone project and a 12-question final examination. It is designed for about 20 hours of study at your own pace. On completion you receive a Bang Ti Lenydoor certificate of completion; it is not an accredited qualification.

Show More

What Will You Learn?

  • Explain tables, rows, columns, primary keys and foreign keys, and when a database suits better than a spreadsheet
  • Install DB Browser for SQLite, create a database and define tables with suitable data types
  • Read data with SELECT, WHERE, ORDER BY, LIMIT and DISTINCT
  • Summarise data with COUNT, SUM, AVG, GROUP BY and HAVING, and handle NULL values correctly
  • Add, change and remove data with safe habits that prevent costly mistakes
  • Design linked tables and combine them with INNER JOIN and LEFT JOIN
  • Use simple subqueries, views and indexes, and protect beneficiary data with sensible privacy practices
  • Plan backups, and complete a small registration and attendance database as a capstone

Course Content

Module 1: Understanding Databases and Setting Up (Weeks 1-2)

  • What Is a Database and Why Do We Need One?
  • Tables, Rows, Columns and Keys
  • Setting Up DB Browser for SQLite
  • Creating Tables and Choosing Data Types
  • Module 1 Quiz: Databases and First Steps

Module 2: Reading and Filtering Data with SELECT (Weeks 3-5)

Module 3: Summarising Data and Changing It Safely (Weeks 5-7)

Module 4: Designing Tables and Combining Them with JOINs (Weeks 7-9)

Module 5: Subqueries, Views, Indexes, Privacy and Backups (Weeks 9-11)

Module 6: Capstone Project and Final Examination (Weeks 11-12)

Scroll to Top