Supplemental Resources

C175 – Supplemental Resource List

For Data Modeling (section 4 on coaching report) - watch one or more of the following Lynda.com videos from the Programming Foundations: Databases (by Scott Simpson) series:

Access to LinkedIn Learning with Lynda.com Content is provided for all WGU students.  The best way to reach it is to   Go to the WGU Library: 

http://wgu.libguides.com.wgu.idm.oclc.org/libhome 

After you get to the main library page, click on on the Resources By College button, and then select I.T. from the drop-down menu: 

Next, click on the Database Support button:

Then, click on the LinkedIn Learning tab.

Next, click on the Linked In Learning link:

Once at LinkedIn Learning, enter Programming Foundations: Databases (by Scott Simpson) into the Search box at the top. Watch one or more of the videos in this series:

Database Foundations
Tables
Relationships
Database Optimization
Querying a database

For SQL, any of these resources will be helpful:

Watch the SQL related videos listed above.

SQL Practice Exercises - SQL Practice exercises that will prepare you for the questions you’ll see on the OA.

Lynda.com - MySQL Essential Training series

SQL tutorial at w3schools.com

The Relational Model of Data - This video covers the course material found in uCertify Lesson 4 (section 2 on coaching report).

For Normalization, you could review the Normalization and denormalization video listed above from the Programming Foundations: Databases, complete the 11 practice questions below, and check your answers with the answer key or watch a video review of the answers to the questions:

Normalization Examples PowerPoint

Normalization Practice Questions, Answer Key, or Video - Review of Answers to questions

Normalization Webinar recording

For the Business Intelligence section, you can review Lesson 6 or take a look at this supplemental resource:

Business Intelligence:  The Savvy Manager’s Guide

Business Intelligence – Video tutorial

Miscellaneous

Short video – Difference between Superkeys, Candidate keys, Primary keys, and Alternate Keys

Dr. Daniel Soper – Database Series on YouTube

Introduction to Databases

The Relational Model

The structured Query Language