Practical learning · 9 projects
SQL and Databases: projects and labs
Learn by doing: labs for each module, a project for each level, a capstone and a project exam. Every step is checked, and your work stays on this device.
Beginner
- Lab1.5 h · 5 stepsLab: tables for a kirana shopSharma General Store in Indore wants to stop writing sales in a notebook. Design its first three tables (products, customers and sales) with the right types, keys and rules, add the stock, and change a table when the owner asks for GST.Not started
- Lab1.5 h · 5 stepsLab: a train search like IRCTCWrite the queries behind a train search screen: trains to New Delhi, cheap trains from two cities, Express trains with no First AC, the three cheapest options and the list of starting cities for a drop-down.Not started
- Lab1.5 h · 5 stepsLab: maintenance dues for a housing societyThe treasurer of Green Meadows Co-operative Housing Society in Pune keeps September's maintenance in a messy table. Clean the names, mask phone numbers, count days late, label each flat, pick a contact for reminders and work out GST on the larger bills.Not started
- Lab1.5 h · 4 stepsLab: where did my UPI money go?Two months of UPI payments from a payments app. Work out the headline numbers, the spend per category, the shops you pay again and again, and a month-by-month summary that also counts failed payments.Not started
- Project4 h · 7 stepsProject: a college results reportThe exam cell of an engineering college has first-semester marks in one table. Build the full results report: absentees, subject grades, totals and percentages, backlogs, subject and branch analysis, and each student's final class.Not started
Expert
- Project6 h · 7 stepsProject: a database for a family clinicSunrise Family Clinic in Lucknow books appointments in one wide spreadsheet. Design a normalised schema with keys and rules, move the old data into it, then add an index, a view for the reception desk, an audit trigger and a weekly doctor report.Not started
- Capstone10 h · 11 stepsCapstone: a sales database for a kirana chainAnnapurna Kirana runs three shops in Bengaluru and Mysuru and wants one database instead of three billing exports. Design the schema with keys and rules, load the exports, write the owner's reports with joins, CTEs and window functions, then add a view, an index, a stock trigger and a safe transaction for new bills.Not started
- Project exam1.25 h · 6 tasksProject exam: fees at a coaching instituteA coaching institute in Kota needs its fee records sorted out. In 75 minutes, write six pieces of SQL against its batches, students and payments: a dues list, a batch collection report, top payers, monthly collections, a dues view and a receipt trigger. No hints or answers are shown; every task is checked when you hand in.Not taken