FreeBeginner
Programming Fundamentals
Learn how programs run and write your first Java code with variables, decisions, loops and methods.
5 lessonsAbout 1 hr 17 minFinal quiz
Database Fundamentals
Database Fundamentals
Almost every application stores its data in a database. This path explains how relational databases organise data in tables, how keys connect tables, and how to ask questions of your data with SQL. The examples use standard SQL that runs on PostgreSQL, and most of it works unchanged on MySQL and SQLite.
- Free
- Beginner
- 4 lessons
- About 1 hr 2 min
- Final assessment
Lessons in this path
Tables, rows, columns and data types
Learn how a relational database organises data into tables and how to choose column data types.
12 min Knowledge check Exercise
Primary keys, foreign keys and relationships
Identify every row with a primary key and connect tables with foreign keys to model one-to-many and many-to-many relationships.
15 min Knowledge check Exercise
SELECT, WHERE, ORDER BY and LIMIT
Retrieve exactly the columns and rows you need, sort them and limit the number of results.
15 min Knowledge check Exercise
Basic filtering and a mini SQL exercise
Combine conditions with AND, OR and NOT, use IN, BETWEEN, LIKE and IS NULL, and solve a set of SQL challenges.
20 min Knowledge check Exercise
Database Fundamentals assessment
8 questions covering the whole path
Optional next step: DevCrest Academy
PostgreSQL, Distributed SQL & Database Internals
Want to go deeper? The academy's PostgreSQL course moves from these fundamentals to query tuning, indexing, transactions and distributed SQL with hands-on labs.
- Intermediate
- 6 weeks • 45 hours
- Online Live
- From ₹7,500 per student
What you'll learn
- Read and interpret EXPLAIN ANALYZE output.
- Choose and design B-tree, GIN and partial indexes.
- Explain MVCC, isolation levels and common concurrency anomalies.
- Partition large tables and plan replication topologies.
Syllabus preview
- 01Storage & Query Execution
- 02Indexing Strategies
- 03Transactions & Concurrency
- 04Partitioning & Replication
+ 2 more modules
Prerequisites
- SQL basics
- One backend language
Upcoming batches
No batch is open right now. Ask us about the next one.
Hands-on project
A performance audit of a realistic PostgreSQL database with measured improvements and a written report.
Fees and batch dates are sample data pending confirmation
More free learning paths
- FreeBeginner
Web Development Basics
Learn how the web works and build a responsive personal page with HTML, CSS and JavaScript.
5 lessonsAbout 1 hr 33 minFinal quiz
- FreeBeginner
Introduction to Full-Stack Development
See how the frontend, backend, APIs and database of a real web application work together.
4 lessonsAbout 1 hr 3 minFinal quiz