PDF Version Available
This document is also available in PDF format: week2.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/week2.html
The HTML version provides enhanced accessibility features including keyboard navigation, screen reader support, responsive design, dark mode support, and high contrast options.
Objectives:
- Demonstrate the use of some basic SQL queries
- Explain how SQL queries work, and practice using them
Complete the following problems
References, a video, a PowerPoint and some notes are available at my website https://www.aholdengouveia.name/AdvData/sqlpt1.html
The tutorial site we'll be using is https://sqlbolt.com/ We'll be going through several sections of this tutorial, go through the first 4 sections and the review
Please include
- Screenshots of each section after you complete the challenges at the end. Make sure you have the green checkmark on each problem.
- Which, if any, questions did you find challenging? Why?
- How many of the questions did you need a hint on? Why?
- What is your review of this tutorial? What would you change or fix?
Deliverables
A document with the answers to each question and all 5 screenshots. Make sure each screenshot has your name and term on it.