Course

Course Summary
Credit Type:
Course
ACE ID:
STAT-0017
Organization's ID:
360
Organization:
Statistics.com
Location:
Online
Length:
4 weeks
Dates Offered:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 3 Introduction to Relational Databases
Description

Objective:

The course objective is to teach students how to extract data from a relational database using SQL, so that they can perform statistical operations. The focus is on structuring queries to extract structured data.

Learning Outcomes:

  • Add filtering to queries.
  • Load MySQL and read in .csv data.
  • Incorporate functions in queries.
  • Query databases to obtained desired data.
  • Join tables.
  • Perform subqueries.
  • Understand the principles of efficient SQL databases.
  • Understand the relational database file model (as contrasted with the flat file).

General Topics:

  • MySQL
  • Basic SQL Procedures and Functions
  • Joining Tables and Subqueries
  • Efficient SQL Databases
Instruction & Assessment

Instructional Strategies:

  • Discussion
  • Practical Exercises
  • Textbook readings

Methods of Assessment:

  • Other
  • Graded practical exercises and discussion forums

Minimum Passing Score:

73%
Supplemental Materials