SQL and Databases for Beginners (freeCodeCamp)
- Course audio
- Course audio: English
- Level
- Beginner
- Length
- 23 lessons · 4.3 hours
What you'll be able to do
- Create tables with keys and constraints in MySQL
- Query data with filters, wildcards, joins and nested queries
- Design an ER diagram and convert it to a schema
About this course
A complete beginner's course in SQL with MySQL from freeCodeCamp, split at its chapters into 23 lessons. It explains what a database is, tables and keys, installing MySQL on Windows or Mac, creating tables, inserting, updating and deleting data, and constraints. It then builds a small company database to practise queries, wildcards, unions, joins and nested queries, and ends with triggers and designing ER diagrams and turning them into schemas. Useful for DBMS students, aspiring analysts and web developers.
Syllabus
23 lessons · 4:20:39 in total
- 1Introduction2:36
- 2What is a Database?20:34
- 3Tables & Keys20:21
- 4SQL Basics8:55
- 5MySQL Windows Installation9:33
- 6MySQL Mac Installation13:50
- 7Creating Tables15:16
- 8Inserting Data7:12
- 9Constraints9:54
- 10Update & Delete8:00
- 11Basic Queries12:26
- 12Company Database Intro5:28
- 13Creating Company Database16:22
- 14More Basic Queries14:46
- 15Wildcards8:40
- 16Union7:43
- 17Joins10:13
- 18Nested Queries10:03
- 19On Delete8:13
- 20Triggers12:07
- 21ER Diagrams Intro13:41
- 22Designing an ER Diagram12:41
- 23Converting ER Diagrams to Schemas12:05
What to take next
Videos by freeCodeCamp.org, played from their official YouTube channel. Subscribe on YouTube
Official upload by the teacher or institution on their own channel, shown with YouTube's embedded player.
Lessons last checked Oct 2026. Course summary and lesson structure by Sabaq.
Report a problem or a rights request