你将学到什么
Data Analysis
MySQL
Teradata
SQL
课程概况
This course is an introduction to how to use relational databases in business analysis. 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 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 also learn how to execute the most useful query and table aggregation statements for business analysts, and practice using them with real databases. 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!
By 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. Businesses are collecting increasing amounts of information with the hope that data will yield novel insights into how to improve businesses. Analysts that understand how to access this data – this means you! – will have a strong competitive advantage in this data-smitten business world.
课程大纲
周1
完成时间为 1 小时
About this Specialization and Course
完成时间为 5 小时
Understanding Relational Databases
周2
完成时间为 8 小时
Queries to Extract Data from Single Tables
周3
完成时间为 10 小时
Queries to Summarize Groups of Data from Multiple Tables
周4
完成时间为 11 小时
Queries to Address More Detailed Business Questions
周5
完成时间为 11 小时
Strengthen and Test Your Understanding