Big Data Mgt

Managing Big Data with MySQL

Dr. Jana Schaich Borg, Duke University

WEEK 2 TERADATA PRACTICE EXERCISES GUIDE

I hope you enjoyed learning to write your own queries through the Jupyter interface that allowed

you to analyze Dognition’s data! With that practice under your belt, you are ready to try writing

queries more independently. The weekly "Teradata Practice Exercises," in combination with the

weekly graded quizzes, will guide you through how to do that using the SQL Scratchpad in

Teradata’s Viewpoint online user interface.

The reason you are learning SQL is so that you can retrieve whatever data you need to analyze

from a database, without having to ask somebody else in your company to do it for you.

Sometimes you will be making the judgment about what data are important to retrieve, while

other times your team members or bosses will be telling you what data they want you to retrieve.

In either case, you will need to be able to sit in front of a blank query screen and somehow get

the data you intend. That experience, emotionally, feels very different than writing queries

through the Jupyter interface, because you will not have any text or guidance to draw upon to

help you figure out how to interpret the database and generate a query.

The Teradata exercises you will complete in this course are designed to serve as a stepping stone

between these real-life situations and the Jupyter exercises. I want you to be able to try out

writing your own queries to answer real business questions with real business data just as you

would in a company, but be able to take as much time as you need to figure out how to arrive at

the correct answer, and be able to check your answers after you have finalized your query. I am

going to give you much less guidance in the Teradata exercises than I did in the Jupyter exercises

so that you can practice generating queries on your own. If you find it challenging to do this at

first, don’t...