COURSE OVERVIEW
This is an introductory course offered by Harvard University that teaches the fundamentals of working with relational databases using SQL. It is part of the renowned CS50 series and is designed for beginners.
↚
KEY DETAILS:
* Duration: October 1, 2023 - December 31, 2025
* Length: 7 weeks
* Time Commitment: 6 - 12 hours per week
* Pace: Self-paced
* Price: Free*
* Language: English (with English video transcripts)
* Difficulty: Introductory
* Platform: edX
↚
WHAT YOU'LL LEARN
* SQL Basics:
* CREATE TABLE
* SELECT
* INSERT
* UPDATE
* DELETE
* DROP
* Database Design:
* Modeling real-world entities and relationships using tables
* Applying triggers and constraints
* Normalizing data to reduce redundancies and errors
* Advanced SQL Techniques:
* Joining tables using primary and foreign keys
* Automating searches with views
* Expediting searches with indexes
* Integration:
* Connecting SQL with programming languages like Python and Java
* Tools:
* SQLite for portability
* PostgreSQL and MySQL for scalability
↚
COURSE DESCRIPTION
This course introduces relational databases and SQL, focusing on creating, reading, updating, and deleting data. It covers real-world applications, such as modeling entities and relationships, normalizing data, and optimizing database performance. The course begins with SQLite and progresses to PostgreSQL and MySQL, providing a comprehensive understanding of database management.
Assignments are inspired by real-world datasets, ensuring practical learning.
↚
HOW TO ENROLL
You can enroll in the course for free on the official course page Click here.
↚