Practice It: SQL Joins

This is the repository for the LinkedIn Learning course Practice It: SQL Joins. The full course is available from LinkedIn Learning.

In this course, instructor Nikiya Simpson guides you through four main types of SQL joins, with plenty of opportunities to try what you’re learning. Nikiya starts with schema description SQL commands, plus table and column description SQL commands. She goes over inner joins, then dives into left joins, self joins, and multiple complex joins. Nikiya also covers right joins, full outer joins, and cross joins.

This course is integrated with GitHub Codespaces, an instant cloud developer environment that offers all the functionality of your favorite IDE without the need for any local machine setup. With GitHub Codespaces, you can get hands-on practice from any machine, at any time—all while using a tool that you’ll likely encounter in the workplace. Check out the Using GitHub Codespaces with this course video to learn how to get started.

Installing

1. To use these exercise files, you must have the following installed:

   • The following VS Code extensions are used in this course and are helpful with viewing SQL results and PDFs.
     • SQLiteViewer
     • PDFViewer
     • You can install the HTML Preview or Open in Default Browser extensions in VS Code to open your html files to view.

2. Clone this repository into your local machine using the terminal (Mac), CMD (Windows), or a GUI tool like SourceTree.

3. To install the AdventureWorks database, open a new terminal session. Run ./create_database.sh on the command line.

4. If you recieve a "Permission denied" error on running any of your shell scripts (.sh files), run the following command on your file name (ex. create_documentation.sh): chmod +x create_documentation.sh

5. This course outputs files in HTML format in Chapter 1. You can also use .line or .column formats as well if you are not as familiar with HTML.

Instructor

Nikiya Simpson

Check out my other courses on LinkedIn Learning.