Skip to content

This is a code repository for the LinkedIn Learning course Practice It: SQL Joins.

License

Notifications You must be signed in to change notification settings

LinkedInLearning/practice-it-sql-joins-3085459

Repository files navigation

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.

1666987275307

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.

About

This is a code repository for the LinkedIn Learning course Practice It: SQL Joins.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •