In this module, you will learn how relational databases are organized, and practice making and interpreting Entity Relationship (ER) diagrams and relational schemas that describe the structure of data stored in a database. This week’s exercises are donated from a well-known Database Systems textbook, and will help you deepen and strengthen your understanding of how relational databases are organized. This deeper understanding will help you navigate complicated business databases, and allow you to write more efficient queries. At the conclusion of the week, you will test your understanding of database design principles by completing the Week 1 graded quiz. To get started, please begin with the video “Problems with Having a Lot of Data Used by a Lot of People.” As always, if you have any questions, post them to the Discussions. I hope you enjoy this week's materials!

In this module, you will start interacting with business databases. You will write SQL queries that query data from two real companies. One data set, donated from a local start-up in Durham, North Carolina called Dognition, is a MySQL database containing tables of over 1 million rows. The other data set we'll learn about was donated from a national US department store chain called Dillard’s, is a Teradata database containing tables with over a hundred million rows. Make sure to watch the instructional videos about how to use the database interfaces we have established for this course, and complete the MySQL exercises. At the end of the week, you will test your understanding of the SQL syntax introduced this week by completing the graded quiz. As always, if you have any questions, post them to the Discussions. Enjoy this week's materials!

In this module, we are going to learn the SQL syntax that allows you to segment your data into separate categories and segment. We are also going to learn how to combine data stored in separate tables. Make sure to watch the videos about joins, and complete the MySQL exercises. At the end of the week, you will test your understanding of the SQL syntax introduced this week by completing the graded quiz. We strongly encourage you to use the course Discussions to help each other with questions.

In this module, you will practice integrating the SQL syntax you’ve learn so far into queries that address analysis questions typical of those you will complete as a business data analyst. Due to the extensive nature of the queries we will practice this week, we have put the graded quiz that tests your understanding of the SQL strategies you will practice in its own module at the end of this week. Make sure to complete the MySQL exercises, and we strongly encourage you to use the course Discussions to help each other with questions.

This module contains the final graded quiz for the course. This quiz are intended to hone and build your understanding of the last important concepts in the course!