This is CS50's introduction to databases using a language called SQL. Learn how to create, read, update, and delete data with relational databases, which store data in rows and columns. Learn how to model real-world entities and relationships among them using tables with appropriate types, triggers, and constraints. Learn how to normalize data to eliminate redundancies and reduce potential for errors. Learn how to join tables together using primary and foreign keys. Learn how to automate searches with views and expedite searches with indexes. Learn how to connect SQL with other languages like Python and Java. Course begins with SQLite for portability's sake and ends with introductions to PostgreSQL and MySQL for scalability's sake as well. Assignments inspired by real-world datasets.
Overview
Taught by
David J. Malan and Carter Zenke
Tags
Related Courses
Related articles
Reviews
4.0 rating, based on 2 Class Central reviews
-
Good Course. The preceptor explains in a simpler way and the most attractive part of cs50's course is its problems sets. By solving psets you will build concepts
-
The "CS50's Introduction to Databases with SQL" course by Harvard University via edX is an outstanding resource for anyone interested in databases and SQL. The course covers a broad range of essential topics such as creating and managing databases, writing complex queries, and optimizing performance. The lectures are clear and engaging, with hands-on exercises that solidify the learning process. Whether you're a beginner or have some experience, this course provides valuable insights and practical skills. The instructors are knowledgeable, and the pace is well-suited for self-paced learning. Highly recommended for all learners!
