PDF Version Available

This document is also available in PDF format: week3.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/week3.html

The HTML version provides enhanced accessibility features including keyboard navigation, screen reader support, responsive design, dark mode support, and high contrast options.

Objectives:

Complete the following problems

References, a video, a PowerPoint and some notes are available at my website https://www.aholdengouveia.name/AdvData/sqlpt2.html

The tutorial you'll be using is at https://sqlbolt.com/ The challenges are at {https://www.hackerrank.com/domains/sql?filters

Both are free, but HackerRank needs you to register so you'll have a profile to save your work.

  1. Fromhttps://sqlbolt.com/ go through the sections on Table joins and nulls, Sections 6-8. Take screenshots of each challenge at the end after you complete it, making sure each problem has a green checkmark.
  2. From {https://www.hackerrank.com/domains/sql?filters
  3. Each screenshot from both websites 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.
  4. Screenshot of your HackerRank profile that includes the completed challenges.

Deliverables