(ecornell) Working with Data Using SQL

Relational databases are workhorses which form the backbone for much of the information we find at our fingertips on the internet. In this course, you will learn to create and modify databases using OmniDB and structured query language (SQL) to import data, create tables, and modify fields. You will also practice cleaning data to maintain your database and ensure that it provides accurate information. As the course progresses, you will identify questions you want answered and practice translating those questions into SQL. You will also examine different forms of outputting data from a database, including outputting to a program or text file and outputting CSV text. The course is provided by eCornell in partnership with Genashtim

What You'll Learn

Create a database with SQL

Load a database and clean data

Turn a question about data into an SQL query

Output data