Issued by Foundryy · Databases & SQL
SQL and Database Fundamentals
Learn to ask questions of data with SQL and to design tables that stay correct as an app grows. You will write joins, aggregations and window functions on realistic datasets, then design and query a normalised schema of your own.
- Duration
- 3 months
- Study time
- 92 hours
- Modules
- 7
- Cost
- At enrollment
- SQL
- PostgreSQL
- Database Design
- Data Modeling
- Query Optimization
Curriculum
- 18 h
Relational thinking
Tables, keys and relationships, Reading an ER diagram
- 220 h
Querying with SQL
SELECT, WHERE and ORDER BY, Joins, Aggregation and GROUP BY
- 316 h
Intermediate SQL
Subqueries and CTEs, Window functions, Dates and strings
- 414 h
Designing schemas
Normalisation, Constraints and indexes, Migrations
- 58 h
Writing data safely
INSERT, UPDATE, DELETE, Transactions, Common mistakes
- 68 h
Performance basics
Reading EXPLAIN, When an index helps
- 718 h
Capstone
Schema design, Analytical queries, Write-up
Who can enroll
No prior database experience needed. Basic spreadsheet familiarity helps.
To earn the certificate
- Complete every module of the curriculum
- Submit a capstone project: a normalised relational schema for a small business, loaded with sample data, with ten documented analytical queries
- Pass a final review by a Foundryy reviewer
- Follow Foundryy’s academic-integrity policy: the work you submit must be your own
Issued by Foundryy after the team has reviewed your capstone against the requirements.