PDF Version Available
This document is also available in PDF format: wk11sqlscaling.pdf
The PDF version includes bookmarks for easy navigation and is optimized for printing.
Accessibility Notice
This document is also available in HTML format at:
https://aholdengouveia.name/AdvData/labs/wk11sqlscaling.html
The HTML version provides enhanced accessibility features including keyboard navigation, screen reader support, responsive design, dark mode support, and high contrast options.
Objectives:
- Learn more about SQL and how it can be used.
- Learn how to evaluate data sets for scalability including business logic
Complete the following problems
References, a video, a PowerPoint and some notes are available at my website https://www.aholdengouveia.name/AdvData/SQLscaling.html
SQL Challenges HackerRank
- From https://www.hackerrank.com You'll be doing 3 challenges that are listed as Medium difficulty or higher. Make sure you pick NEW challenges. Take screenshots of each solution making sure to include your name and the term in each screenshot.
- Each screenshot should include a short explanation of how you solved it, and what resources you used. If you needed hints, include that and where you found the hint.
- Screenshot of your HackerRank profile that includes the completed challenges. Make sure I can see all your completed challenges so I can tell that you have done enough new ones
SQL Challenges
- From case study number 1, the diner, you need to solve all 10 questions. Each one should be done with a single SQL statement. Make sure to include a screenshot of your solution, and a short explanation of how you solved it.
- From case study number 2, pizza runner, solve the first 5 problems under Pizza Metrics. Make sure to include a screenshot of your solution, and a short explanation of how you solved it.
SQL Scalability
Answer the following questions about the scalability of each SQL challenge from the 8 week SQL challenge case studies. For each case study, write a short paragraph explaining how you think this might work at scale. Make sure to answer each of the following.
- How do you think your queries would change?
- Would you continue to use a relational database? Explain why or why not.
- Does the dataset need to stay with SQL because of ACID transactions?
- Would the schema have to change?
- Do you think node consistency would be an issue for the data set? What about the Business?
Deliverables
A text document that contains the answers to the above questions, and requested screenshots. Make sure you include both the SQL challenges from HackerRank and the ones from the 8 week SQL challenge