Data Science With SQL
and TableauCornell

Certificate Program

Data drives many real-world endeavors, which means that storing and accessing the data is foundational to success. Relational databases are an industry-standard data storage mechanism for maintaining data integrity while allowing flexible data retrieval.

You will begin this course by examining the basic table structures that form a relational database. Using the relational database format, you will define connections between your data fields and determine how those can be expressed. You will then practice normalizing a relational database to ensure data integrity and reduce redundancy. As this course concludes, you will use a relational database system called OmniDB along with structured query language (SQL) to retrieve specific information from the database.

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.

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

• Querying Relational Databases

After creating an initial version of a chart, how do you make it better? In this course, we'll explore the process for creating great charts. First, you'll explore how best to plan and draft your chart. Then, you'll need to eliminate distractions in the chart to make your visualization clear. It's also important to emphasize the most critical data in your chart. We'll look at how our brains process visualizations, and how you can use this information to better design your chart. Lastly, we'll examine how to adjust a chart to target your audience and the iterative process you can use to improve it.

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

• Creating Data Visualizations with Tableau

In this course, we will study how you can make a set of charts in Tableau that tell a story to help your audience understand and remember your message. We'll also talk about different approaches to handling technical or complicated content and techniques for getting feedback so that you can improve your presentation.

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

• Creating Data Visualizations with Tableau
• Enhancing Data Visualizations with Tableau