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
Key Course Takeaways
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
Tessler Family Professor of Digital and Information Law, Cornell Tech
James Grimmelmann is the Tessler Family Professor of Digital and Information Law at Cornell Tech and Cornell Law School. He helps lawyers and technologists understand one another, applying ideas from computer science to problems in law and vice versa. Professor Grimmelmann studies how laws regulating software affect freedom, wealth, and power. He writes about search engines, social networks, data havens, hackers, trolls, copyright-infringing robots, and magical 3D printers, among other things. Professor Grimmelmann is the author of the casebook “Internet Law: Cases and Problems,” now in its fifth edition, as well as over 40 scholarly articles and essays.
Professor Grimmelmann holds a J.D. from Yale Law School and an A.B. in Computer Science from Harvard College. After teaching at New York Law School, Georgetown, and the University of Maryland, he joined Cornell Tech in 2016.