Introduction to SQL

Accessibility Notice

This document is also available in HTML format at:

https://aholdengouveia.name/IntroData/labs/dbsql1.html

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

Objectives:

• The objective of this lab is to introduce students to the basic concepts of Structured Query Language (SQL). No prior knowledge of SQL is assumed. Students will gain a basic understanding of SQL through interactive methods utilizing a free online tutorial and other resources.

Instructions

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

The tutorial you will be following is here: https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/v/welcome-to-sql You will be going through of SQL basics. You should be able to sign up for free, do not pay money. If you run into issues let me know.

Please include answers to the following questions

• Have you used SQL before? If yes, for what and how much experience do you have with it?
• After completing this, what are your opinions on the difficulty?
• What is one thing you liked about this tutorial? What is one thing you think they could have done better?
• If you want to attempt more on Kahn Academy you can, did you try it? If yes, why? If no, why not?
• Take screenshots of each completed challenge that you solve, make sure to have a note with your name and the term in the screenshot, screenshot should be focused on the note and answer, not the full desktop. Any screenshots that don't include the note, or are full desktop, or taken with a camera instead of a screenshot won't count and will earn no points. This is an example of what it should look like: figure[h!] [scale=.2]{ExampleScreenshot.png} This is an image of what each of your screenshots should look like Example screenshot showing a text document with student name and term/year alongside data visualization figure

Tutorial Recommendation

You should find a tutorial that you would recommend to another person that wanted to learn SQL. The tutorial can be interactive or not. Videos that you can follow along with count as tutorials for this. You should find at least 3 options for tutorials/videos that you also include here. In your recommendation you should explain why you picked the one you did over the other two including pros and cons of each.

You may not include any of the links I've shared anywhere on Blackboard or my website in your list, they must be new to you materials and tutorials/videos.

Deliverables

• A document containing all requested screenshots
• Answers to the above questions
• Your tutorial Recommendation. Review should be at least a paragraph but no more then two pages.