Querying, Relating, Designing, Writing, Viewing, Optimizing, and Scaling — my CS50 SQL journey through data exploration and relational design.
A collection of my work and practice files from Harvard’s CS50 SQL course, covering the fundamentals and advanced concepts of databases, queries, and data design.
- Querying: Writing SQL statements to retrieve and manipulate data
- Relating: Modeling relationships among multiple tables using foreign keys and joins
- Designing: Structuring databases through normalization and entity-relationship design
- Writing: Building efficient and readable SQL code
- Viewing: Creating and managing SQL views to simplify complex queries
- Optimizing: Improving performance using indexes, query planning, and constraints
- Scaling: Handling larger datasets and applying principles of scalability in SQL systems
- SQLite (via CS50 IDE)
- PostgreSQL / MySQL (for extended practice)
- Command-line tools and DB visualizers
To master SQL concepts through hands-on practice and build a solid foundation for data analysis, backend development, and database architecture.