Setup for Introduction to SQL Using PostgreSQL

Required Software

  • Windows 10 or later or Mac: OS X (version 10.12) or later.
  • Google Chrome

Instructions

Class Files

  1. The first step to setting up for your course package is to create the folder in which you will store your class files. Create a new folder named Webucator wherever you want, but make sure you remember where it is.
  2. Download the class files from the bottom of this page.
  3. Unzip the class files into the Webucator folder. This will create a folder called ClassFiles. 

Setup Instructions

  1. Download the latest version of PostgreSQL. Be sure to choose the version for your operating system.

    At this time, 12.4 is the latest version of PostgreSQL ready for production. 13 is a beta version.
  2. Once the installer has downloaded, run it by double-clicking on the download or by right-clicking and selecting Open:

  3. Run through the Setup Wizard. On the Select Components screen, uncheck Stack Builder. Leave the other options checked. Make note of the password you set for the database superuser.

  4. If pgAdmin doesn’t open automatically, open it.
  5. Set up a master password. This is how you will log into pgAdmin.

Setting up the jokesdb Database

  1. Open pgAdmin if it is not already open. You may be prompted to enter your master password. 
  2. Open Servers, right click on Databases, and select Create > Database…
  3. Name the database “jokesdb” and click Save.
  4. Right click on jokesdb and select Restore…
  5. Select the three dots to open a file explorer-like window:
  6. Navigate to jokesdb.backup file within the setup folder. Make sure that backup is the Format selected or you may not see the file. Click Select.
  7.  Click Restore.

  8. To test if the Restore worked:

    1. Right click on the jokesdb database, and select Query Tool.
    2. In the Query Editor, write SELECT * FROM jokes; and then press the Run button.
    3. In the Data Output, you should see information on various jokes. You should also get a success message that says “595 rows affected”.

      If you missed the success message, you can go to Messages:

Congratulations! You are all set for class.

Courses, Courseware, and Class Files

This setup page is used for the following course and courseware:

Courses

  1. Introduction to SQL Using PostgreSQL.

Courseware

This is for other training companies who are licensing Webucator courseware. If you are a student in a Webucator class, you should use one of the links above or (even better) the class files link on your company landing page or main class page. If you’re not sure, please email support@webucator.com.

  1. Courseware: Introduction to SQL Using PostgreSQL.