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
4.7 (3,939 ratings)
- 5 stars78.80%
- 4 stars16.93%
- 3 stars2.64%
- 2 stars0.76%
- 1 star0.86%
SJ
Nov 5, 2016
It was an Awesome course. Really enjoyed doing all the exercises. Now I feel quite confident to write any queries.
Special Thanks to Professor Jana Schaich Borg for teaching so wonderfully!!!!!
KM
May 30, 2020
It is a good course and I have learnt managing the data which I always felt curious to know .I was difficult for me to understand teradata at first because their is not a lot information about it
From the lesson
Understanding Relational Databases
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. By the end of the week, you will be able to: (1) Describe the fundamental principles of relational database design (2) Interpret Entity Relationship (ER) diagrams and Entity Relationship (ER) schemas, and (3) 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. 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!
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.
Coursera Footer
