This repository contains my solutions and notes for the CS50's Introduction to Databases with SQL course offered by HarvardX on edX. In this course, I learned the fundamentals of databases, including how to create, read, update, and delete data using SQL (Structured Query Language). The course covers topics such as data normalization, table relationships, indexing, and connecting SQL with programming languages like Python and Java.
Course Link: CS50's Introduction to Databases with SQL
- SQL Commands: I gained proficiency in SQL commands, including
CREATE TABLE
,SELECT
,INSERT
,UPDATE
,DELETE
,DROP
,CREATE INDEX
, andCREATE VIEW
. - Database Management: I learned how to design and manage relational databases, understanding real-world entities, relationships, and data normalization techniques.
- Database Connectivity: Explored connecting SQL databases with popular programming languages, including Python and Java.
- Database Scalability: Explored database scalability concepts using PostgreSQL and MySQL.
- Data Modeling: I acquired skills in modeling real-world entities, creating appropriate tables, triggers, and constraints to maintain data integrity.
- Performance Optimization: Learned techniques to optimize database performance, including indexing and query optimization.
- Institution: HarvardX
- Instructor: David J. Malan (Gordon McKay Professor of Computer Science, Harvard University) and Carter Zenke (Preceptor, Harvard University)
- Level: Introductory
- Language: English
- None
- Foreign Keys, SQL (Programming Language), Relational Databases, Data Store, Python (Programming Language), SQLite, Scalability, Java (Programming Language), PostgreSQL, MySQL
-
Clone the repository:
git clone https://github.com/Inv1nc/CS50-Introduction-to-Databases-SQL.git
-
Navigate to the specific problem set or topic folder to view the solutions.
The course starts on October 1. Enroll now to enhance your skills in databases and SQL: Enroll in the course.