Write queries to verify and describe all the contents of the Dognition MySQL database and the Dillard’s Teradata database3. Use two different database user interfaces2. By the end of the week, you will be able to:1. The other data set, donated from a national US department store chain called Dillard’s, is a Teradata database containing tables with over a hundred million rows. 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. You will write SQL queries that query data from two real companies. Welcome to week 2! This week, you will start interacting with business databases.
#JUPYTER NOTEBOOK CONVERT TO PDF MAC HOW TO#
Analysts that understand how to access this data – this means you! – will have a strong competitive advantage in this data-smitten business world. Businesses are collecting increasing amounts of information with the hope that data will yield novel insights into how to improve businesses.
No more waiting 48 hours for someone else in the company to provide data to you – you will be able to get the data by yourself!īy the end of this course, you will have a clear understanding of how relational databases work, and have a portfolio of queries you can show potential employers. You will also learn how to execute the most useful query and table aggregation statements for business analysts, and practice using them with real databases. This knowledge will help you understand how data needs to be collected in business contexts, and help you identify features you want to consider if you are involved in implementing new data collection efforts. You will learn how relational databases work, and how to use entity-relationship diagrams to display the structure of the data held within them. This course is an introduction to how to use relational databases in business analysis.
0 kommentar(er)
