Search Courses

Explore courses for Harvard Extension School degree, certificate, or premedical programs below.
CSCI S-151
Section 1, CRN 35696
Introduction to Databases with SQL
Term: Harvard Summer School 2024
Part of Term: Full Term
Format: Online
Credit Status: Undergraduate, Graduate, Noncredit
Section Status: Open
Credits: 4

Deadlines

  • Last day to register: June 20, 2024
  • Last day to make course and credit status changes, and drop for 100% refund: June 26, 2024
  • Last day to drop for 50% refund: July 03, 2024
  • Last day to withdraw for WD grade: July 26, 2024

Instructor Info

Carter Zenke, EdM
Senior Preceptor, Harvard Extension School

Meeting Info

(6/24 to 8/9)
Participation Option: Online Asynchronous

Additional Time Commitments

Required sections to be arranged.

Description

This course is an introduction to databases using a language called SQL. Students learn how to create, read, update, and delete data with relational databases, which store data in rows and columns, and how to model real-world entities and relationships among them using tables with appropriate types, triggers, and constraints. The course covers how to normalize data to eliminate redundancies and reduce potential for errors and how to join tables together using primary and foreign keys. Students learn how to automate searches with views and expedite searches with indexes, as well as how to connect SQL with other languages like Python and Java. The course begins with SQLite for portability's sake and ends with introductions to PostgreSQL and MySQL for scalability's sake. Assignments are inspired by real-world datasets.

Tuition

All Sections in this Term

Last Updated 11/21/2024, 9:10:05 PM

Welcome to DCE Course Search and Registration

Explore and register for Extension School and Summer School courses offered through Harvard Division of Continuing Education (DCE).

Need help?

Check out our complete help guide for account creation tips, FAQs, and registration troubleshooting.

446.102.88