In this project, you will use SQL to explore a database related to movie rentals. You will write SQL code to run SQL queries and answer interesting questions about the database. As part of your project submission, you will run SQL queries and build visualizations to showcase the output of your queries
You will begin by getting familiar with the database. We have included Practice Quizzes that include a series of questions that will assure you have mastered the main concepts taught throughout the SQL lessons. These practice quizzes will not be "graded" by a reviewer, but they will help you self-assess and make sure you are on the right track. The quizzes are there to assist you in understanding the database before developing the questions that you wish to include for the project.
The project submission is a presentation, which will be reviewed, and for which you will need to Meet Expectations to pass. For the presentation component, you will create four slides. Each slide will:
Have a question of interest. Have a supporting SQL query needed to answer the question. Have a supporting visualization created using the final data of your SQL query that answers your question of interest. You will submit your project at the end of the project lessons. Your project will include:
A set of slides with a question, visualization, and small summary on each slide. A text file with your queries needed to answer each of the four questions.
In this project, you will make use of Python to explore data related to bike share systems for three major cities in the United States—Chicago, New York City, and Washington. You will write code to import the data and answer interesting questions about it by computing descriptive statistics. You will also write a script that takes in raw input to create an interactive experience in the terminal to present these statistics.
In this project, you will use data provided by Motivate, a bike share system provider for many major cities in the United States, to uncover bike share usage patterns. You will compare the system usage between three large cities: Chicago, New York City, and Washington, DC.
In this project you put together what you've learned about version control and GitHub into practice! In this project, you'll be simulating a realistic workflow to refactor your previous BikeShare project using Git. Here's an overview of your tasks for this project.
First, you'll fork a repository to get your own copy of a template for this project, and then clone it to your local computer. Your first task will then be to add your bikeshare.py file, data file, and a .gitignore file to exclude your data file from version control tracking. This is a common practice to avoid sharing your data publicly, to avoid tracking unnecessarily huge files on GitHub, and because changes in data don't often affect our code.
Next, you'll practice creating branches using Git to make some changes to your project. In the real world, it's common to use different branches to manage the development of separate features or changes to a project. The first branch you'll work on is documentation. In this branch, you'll add project documentation in a README file, and make improvements to your docstrings for your bikeshare.py file. Then you'll push your commits back up to the remote repository.
The next branch you'll be working on will be refactoring. Here, you can modify your bikeshare.py file to make improvements to the efficiency or readability of your code. You'll practice committing your code as you work on it, with at least three commits on this branch with meaningful messages. Notice that this branch touches the code in your bikeshare.py file, while the documentation branch touches the docstrings in your file. This means you can work on these branches simultaneously without any conflicts! This is a common practice in the real world.
Finally, once you are finished with your work, you can merge both branches to the master branch, and push it back up to the remote repository.
To complete this project, you will provide all the Git commands you used throughout this course in this template along with a link to your repository on GitHub.
bikeshare.py , sql_queries.sql, snapshots of results of queries and csv files in the .gitignore files