Course

Course Summary
Credit Type:
Course
ACE ID:
PATH-0008
Organization:
Pathstream
Location:
Online
Length:
144 hours and 6 weeks
Dates Offered:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 3 SQL for analytics
Description

Objective:

The course objective is to introduce students to the fundamentals of SQL. Students will learn to identify the role and structure of relational databases as they apply to data analytics, apply the Structured Query Language (SQL) in MySQL for data manipulation language (DML), apply the Structured Query Language (SQL) in MySQL for data definition language (DDL), and apply normal forms (1NF, 2NF, and 3NF) for database normalization.

Learning Outcomes:

  • Explain the role and structure of relational databases as they apply to data analytics.
  • Extract meaningful insights from relational databases using Data Manipulation Language (DML).
  • Design industry-standard relational database schemas using Data Definition Language (DDL).
  • Revise database schema to meet criteria of normal forms (1NF, 2NF, & 3NF).

General Topics:

  • MySQL Workbench Relational Databases Data Manipulation Language Data Definition Language Database Normalization Data Integrity
Instruction & Assessment

Instructional Strategies:

  • Audio Visual Materials
  • Case Studies
  • Coaching/Mentoring
  • Computer Based Training
  • Discussion
  • Laboratory
  • Learner Presentations
  • Practical Exercises
  • Project-based Instruction

Methods of Assessment:

  • Case Studies
  • Performance Rubrics (Checklists)
  • Presentations
  • Quizzes

Minimum Passing Score:

70%
Supplemental Materials

Other offerings from Pathstream

Salesforce Sales Operations Professional Certificate
(PATH-0022)
View All Courses