Webucator Logo
Home
Course Catalog
Training Delivery Methods
Live Online Classes
Private Classes
Self-Paced Training
Enterprise Training
All Training Options
Purchase Courseware
Pricing & Savings
About Us
Sign In
Contact Us
  1-877-932-8228
© 2023 Webucator, Inc. All Rights Reserved.
Courses
Webucator Logo
Browse Courses
SIGN IN
Toggle Contact Dropdown
Contact Us 1-877-932-8228
Toggle More Dropdopwn
Course Catalog Live Online Classes Private Classes Self-Paced Training Enterprise Training All Training Options Pricing & Savings
Purchase Courseware
About Us
  1. Home
  2. Catalog
  1. Catalog

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.
    • All students should download the following class files:
      • SQL106-1.0.5.zip

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.

Training Options

  • Live Online
  • Self-Paced Courses
  • Customized Onsite
  • Enterprise Solutions
  • All Training Options

Course Catalog

  • Full Catalog
  • Pricing & Savings

About Us

  • Contact Us
  • About Webucator
  • Client Testimonials
  • Client List
  • Privacy Policy
  • In The Community
  • Train for Us
  • Cancellation Policy
  • Make a Payment

Microsoft

  • Microsoft Training
  • Certified Microsoft Course List
  • Software Assurance Training

Resources

  • Newsletter
  • Setup Pages
  • Articles

Courseware

  • Purchase Courseware
© 2004-2023 Webucator, Inc. All Rights Reserved.