peer graded assignment coursera sql for data science

SQL for Data Science on Coursera

Created by UC Davis Continuing and Professional Education and hosted on the Coursera platform, this online course consists of pre-recorded video lectures, auto-graded and peer-reviewed assignments and community discussion forums. This course is self-paced and designed to teach you a new skill in as little as 4-6 weeks.

As data collection has increased exponentially, so has the need for people skilled at using and interacting with data—in order to think critically and provide insights that enable better decision making in organizations. Data scientists are “part mathematician, part computer scientist and part trend spotter” and are in higher demand than ever before (SAS Institute, Inc.). Good data scientists must be able to retrieve and work with data, and to do that, you must be well versed in SQL, the standard language for communicating with database systems.

This course is designed to give you a primer in the fundamentals of SQL and working with data so you can begin analyzing it for data science purposes. You will begin to ask the right questions and come up with good answers to deliver valuable insights for your organization. This course starts with the basics and assumes you do not have any prior knowledge or skills in SQL. It will build on that foundation and gradually have you write both simple and complex queries to help you select data from tables.  You'll start to work with different types of data like strings and numbers and discuss methods to filter and pare down your results.

You will create new tables and be able to move data into them. You will learn common operators and how to combine the data. You will use case statements and concepts like data governance and profiling. You will discuss topics on data, and practice using real-world programming assignments. You’ll also interpret the structure, meaning and relationships in source data and use SQL as a professional to shape your data for targeted analysis purposes.

Although we do not have any specific prerequisites or software requirements to take this course, a simple text editor is recommended for the final project. So what are you waiting for? This is your first step in what could be a great new career.

• Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers
• Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand
• OverflowAI GenAI features for Teams
• OverflowAPI Train & fine-tune LLMs
• Labs The future of collective knowledge sharing
• About the company Visit the blog

Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Get early access and see previews of new features.

How to create / integrate the Yelp Dataset in SQLite (Coursera SQL for Data Science)

I am doing the Coursera course SQL for Data Science . Logically I am a bloody beginner.

For the final assignment you have to analyze the Yelp dataset . However, there is no description on how to obtain the dataset, how to transform it, how to integrate it etc.

If I am downloading the dataset from here: https://www.yelp.com/dataset/download , Which I think is the correct one, I receive a handful of *.json files.

How would I create a SQLite database from this? Or is there somewhere already an SQLite-ready Yelp database to download ?

Thanks for your help.

• Surely this is a question your instructor could answer?? –  Mark Benningfield Commented Apr 22, 2021 at 10:53
• 1 Did you read the documentation hosted on the same site? It also provides links to example code hosted in github. yelp.com/dataset/documentation/main –  MatBailie Commented Apr 22, 2021 at 11:17
• You were both right. It was hidden in plain sight. It was under reading material, which I normally read AFTER I finished the tests. Therefore, I just oversaw it. Thanks for taking the time to comment. Have a nice day. –  Towlie Commented Apr 22, 2021 at 14:22

You can find the dataset included in the Coursera material within the

Week 4: Reading:Yelp Dataset SQL Lookup (5min)

It is the last of the 4 sections in the Peer Review Assignment panel

Good luck with the assignment

Not the answer you're looking for? Browse other questions tagged sql database sqlite yelp or ask your own question .

• The Overflow Blog
• This developer tool is 40 years old: can it be improved?
• Unpacking the 2024 Developer Survey results
• Featured on Meta
• We've made changes to our Terms of Service & Privacy Policy - July 2024
• Introducing an accessibility dashboard and some upcoming changes to display...
• Tag hover experiment wrap-up and next steps

Hot Network Questions

• Applying a Little Artificial Intelligence to a Patched Titlecaps Algorithm
• Why did all countries converge on the exact same rules for voting (no poll tax, full suffrage, no maximum age, etc)?
• Does the volume of air in an air tight container affect food shelf life?
• Can an MBA help somehow in reaching academic positions?
• What purpose did the lower-right "Enter" key serve on the original Mac 128k keyboard?
• How different is Wittgenstein's Language game from Contextuality?
• Why is a datetime value returned that matches the predicate value when using greater than comparison
• A spaceship travelling at speed of light
• How do the Fremen harvest spice?
• Feynman famously criticized the Space Shuttle program for not delivering any value to science. Did things improve in that regard since the 1980s?
• Is a realist mindset necessary for certain knowledge?
• Electrons in Nernst equation depend on how it is balanced
• Do academic researchers generally not worry about their work infringing on patents? Have there been cases where they wish they had?
• Tritone substitution in Haydn string quartet?
• What would "doctor shoes" have looked like in "Man on the Moon"?
• Schengen visa expires during my flight layover
• Why is my single speed bike incredibly hard to pedal
• How to get this fencing wire at a [somewhat] equal tension
• Does a cancellation of an accepted review request before the due date happen often?
• I want to control a light with two switches, but not a three way
• Connect electric cable with 4 wires to 3-prong 30 Amp 125-Volt/250-Volt outlet?
• Can I add a PCIe card to a motherboard without rebooting, safely?
• What role can scrum master have/take when product owners differ from opinion?
• How to measure out fresh herbs when the recipe calls for 'a tablespoon of chopped herb'?

Instantly share code, notes, and snippets.

MarzioMT / Assignment.ipynb

• Download ZIP
• Star ( 0 ) 0 You must be signed in to star a gist
• Fork ( 1 ) 1 You must be signed in to fork a gist
• Embed Embed this gist in your website.
• Share Copy sharable link for this gist.
• Clone via HTTPS Clone using the web URL.
• Learn more about clone URLs
• Save MarzioMT/85f712e6f7b307147ac13f286fb64a40 to your computer and use it in GitHub Desktop.