Loading...

Course Description

Databases power things that we rely on every day of our lives, from displaying restaurant menus to processing payments to tracking likes and comments. These tasks require you to work with much more data than you may be used to, as real-life data sets can be extremely large and cumbersome. Using a database to organize your data allows you to work with it systematically and at scale.

This course provides you with the foundational knowledge for integrating databases into your programs and using them to read, write, store, and process data. You will cover the basics of working with files and complex data structures. You will explore important data formats like JSON and CSV, discover how to write database queries that extract information of interest from a database, and get an introduction to the SQL database programming language. With these new tools, you will be able to work with huge amounts of data that would otherwise be tedious and time consuming to process manually.

You are required to have completed the following courses or have equivalent experience before taking this course:

  • How to Write Programs That Make Choices With Control Flow
  • How to Write Functions to Automate Repetitive Tasks

Faculty Author

James Grimmelmann

Benefits to the Learner

  • Work with complex data in programs using nested lists and dictionaries
  • Get data in and out of programs using argv files
  • Store complex data in files using JSON
  • Organize complex data in databases using SQL and NoSQL

Target Audience

  • Aspiring web developers
  • Data analysts and database management professionals
  • Entrepreneurs
  • Any professional interested in strengthening problem-solving skills and better understanding technology fundamentals

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Type
2 week
Dates
Nov 06, 2024 to Nov 19, 2024
Total Number of Hours
16.0
Course Fee(s)
Contract Fee $0.00
Type
2 week
Dates
Jan 29, 2025 to Feb 11, 2025
Total Number of Hours
16.0
Course Fee(s)
Contract Fee $0.00
Type
2 week
Dates
Apr 23, 2025 to May 06, 2025
Total Number of Hours
16.0
Course Fee(s)
Contract Fee $0.00
Type
2 week
Dates
Jul 16, 2025 to Jul 29, 2025
Total Number of Hours
16.0
Course Fee(s)
Contract Fee $0.00
Type
2 week
Dates
Oct 08, 2025 to Oct 21, 2025
Total Number of Hours
16.0
Course Fee(s)
Contract Fee $0.00
Type
2 week
Dates
Dec 31, 2025 to Jan 13, 2026
Total Number of Hours
16.0
Course Fee(s)
Contract Fee $0.00
Required fields are indicated by .