Course Summary
Credit Type:
Organization's ID:
Analytics 103
Self-Paced. 35 hours (10 weeks)
Dates Offered:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 3 Introduction to Database Analytics


The course objective is to introduce students to relational databases and structured query language (SQL). It provides the knowledge and skill necessary to explain relational databases and common SQL commands. Students will also be able to build a basic database, and also learn to add, modify, and select data from the database.

Learning Outcomes:

  • Identify relational database management systems and install developer editions of database systems
  • Design a relational database, including schemas, entity, and perform normalization
  • Define SQL, explain different flavors of SQL (T-SQL, PL/SQL, Dynamic SQL, No SQL), create keys in SQL, and write basic SQL commands
  • Create a database table, describe a schema in SQL and define SQL data types (character, numeric, text, date)
  • Write SQL commands to insert, retrieve, modify, and delete data in a database; write commands to modify database table structure
  • Describe SQL joins; create joins to combine data across tables in a relational database; create views and triggers using SQL
  • Define what is a relational database and contrast it to other database types (flat file, hierarchical)

General Topics:

  • Introduction to General & Relational Databases
  • Relational Database Management Systems
  • Relational Database Design Fundamentals
  • Introduction to SQL Syntax & Queries
  • Database Table Design & SQL Data Types
  • Using SQL to Populate & Retrieve Data
  • Modifying Data in Databases With SQL
  • Using SQL to Remove Data
  • Joins & Subqueries Using SQL
  • Using Views, Indexes, & Triggers in SQL
Instruction & Assessment

Instructional Strategies:

  • Audio Visual Materials
  • Practical Exercises

Methods of Assessment:

  • Examinations
  • Quizzes

Minimum Passing Score:

Supplemental Materials