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.
Database Design Tools That Will Help You Learn SQL Faster
Skills You'll Learn
Data Analysis, MySQL, Teradata, SQL
Reviews
AZ
Feb 01, 2016
Great course! It takes you from zero knowledge of SQL to being able to write quite complicated queries, and being ready for most of standard SQL questions in job interviews. Strongly recommended!
PI
Dec 26, 2017
I recommend this course although the exercise requires more time than the average courses in Coursera. If you complete it seriously on your own you will learn a lot in order to apply it at work.
Welcome to week 1! This week 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. <p>By the end of the week, you will be able to:<ul><li>Describe the fundamental principles of relational database design <li>Interpret Entity Relationship (ER) diagrams and Entity Relationship (ER) schemas, and</li><li>Create your own ER diagrams and relational schemas using a software tool called ERDPlus that you will use to aid your query-writing later in the course.</li></ul><p>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.</p> <p>To get started, please begin with the video “Problems with Having a Lot of Data Used by a Lot of People.” <p>As always, if you have any questions, post them to the Discussions. <p>I hope you enjoy this week's materials!
Taught By
Daniel Egger
Executive in Residence and Director, Center for Quantitative Modeling
Jana Schaich Borg
Assistant Research Professor
Explore our Catalog
Join for free and get personalized recommendations, updates and offers.
