DATA SCIENCE WITH

1
SQL AND TABLEAU
Online Certificate Program

OVERVIEW
This certificate program is designed to help you analyze data in a relational
database and develop your understanding of the relationship between SQL and data
visualizations. You will use SQL and fundamental database concepts to create a
normalized database, manipulate the data within the database, and extract the data
from the database, discovering how to convert business questions into SQL queries
that extract answers from your data.

After developing your skills working with databases, you will take raw data and
create robust data visualizations using Tableau. You’ll explore a wide variety of
charts and learn how to select the best chart to convey the meaning in your data. This
combination of being able to both work with and present data to key stakeholders will
prepare you to bring value to any data-centric organization.

COURSES COURSE LENGTH FORMAT

5 2 weeks 100% online

COURSES
• Querying Relational Databases
• Working with Data Using SQL
• Creating Data Visualizations with Tableau
• Enhancing Data Visualizations with Tableau
• Telling a Data-Driven Story with Tableau

Visit ecornell.cornell.edu
7 COURSES

2 INSIDE the PROGRAM

100% ONLINE

KEY TAKEAWAYS
• Write SQL queries for a relational
database
• Manipulate data in a relational database
using SQL
• Create visualizations that transform raw
data into actionable information that
drives decisions
• Improve data visualizations to ensure
they resonate with the target audience
• Tell a compelling story with your data to
gain stakeholder buy-in

WHO SHOULD ENROLL

• Data scientists • Marketing analysts
• Business analysts • Career starters
• Developers
• Professionals who work with databases
or data warehouses

WHAT YOU’LL EARN

• Data Science with SQL and Tableau Certificate from
Cornell University Center for Advanced Computing
• 50 Professional Development Hours (5 CEUs)

Visit ecornell.cornell.edu
7 COURSES

3
COURSE
DESCRIPTIONS
100% ONLINE

QUERYING RELATIONAL DATABASES

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.

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.

CREATING DATA VISUALIZATIONS WITH TABLEAU

In this course, you will explore how to create common visualizations based on
your data and goals. We will learn the steps you must take to successfully create a
great chart. These include planning the chart, collecting and preparing your data,
and choosing an appropriate chart type. You’ll examine the different categories of
visualizations and determine the best chart for your purposes.

Visit ecornell.cornell.edu
7 COURSES

4
COURSE
DESCRIPTIONS
100% ONLINE

ENHANCING DATA VISUALIZATIONS WITH TABLEAU

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.

It is recommended to only take this course if you have completed Creating Data
Visualizations with Tableau or have equivalent experience.

TELLING A DATA-DRIVEN STORY 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.

It is recommended to only take this course if you have completed Creating Data
Visualizations with Tableau and Enhancing Data Visualizations with Tableau or have
equivalent experience.

Visit ecornell.cornell.edu