Course

Course Summary
Credit Type:
Course
ACE ID:
STAT-0017
Organization's ID:
360
Organization:
Statistics.com
Length:
4 weeks (60 hours)
Dates Offered:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 3 introduction to SQL programming
Description

Objective:

The course objective is to teach students how to manipulate a dataset in order to perform a desired calculation or answer a particular question, as well as to understand relational database files, load MySQL and read in .csv data. Students will also learn how to write and filter queries, incorporate functions, perform subqueries and how to join tables.

Learning Outcomes:

  • describe the relational database file model (as contrasted with the flat file)
  • load MySQL and read in .csv data
  • query databases to obtained desired data
  • incorporate functions in queries
  • add filtering to queries
  • join tables
  • perform subqueries
  • describe the principles of efficient SQL databases
  • able to visualize how to manipulate a dataset in order to perform a desired calculation or answer a particular question

General Topics:

  • Getting started with flat files and relational databases
  • Basic SQL procedures and functions
  • Joining tables and subqueries
  • Efficient SQL databases
Instruction & Assessment

Instructional Strategies:

  • Computer Based Training
  • Discussion
  • Practical Exercises

Methods of Assessment:

  • Quizzes

Minimum Passing Score:

70%
Supplemental Materials