Course

Course Summary
Credit Type:
Course
ACE Course Number:
SDCM-0240
Organization Course Number:
Analytics 103
Organization:
Location:
Classroom-based
Length:
Self-paced. 10 weeks (35 hours)
Dates Offered:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 3 Introduction to Database Administration or Introduction to Database Analytics
Description

Objective:

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

Learning Outcomes:

  • Upon completion of this course, the student will be able to define what a relational database is and contrast it to other database types (flat file, hierarchical)
  • 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
  • Write commands to modify database table structure
  • Create joins to combine data across tables in a relational database
  • And create views and triggers using SQL
  • 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
  • Describe SQL joins

General Course Topics:

  • Introduction to general and relational databases
  • Relational database management systems
  • Relational database design fundamentals
  • Introduction to SQL syntax and queries
  • Database table design and SQL data types
  • Using SQL to populate and retrieve data
  • Modifying data in databases with SQL
  • Using SQL to remove data
  • Joins and subqueries using SQL
  • Using views, indexes, and triggers in SQL
Instruction & Assessment

Instructional Strategies:

  • Audio Visual Materials
  • Practical Exercises

Methods of Assessment:

  • Examinations
  • Quizzes

Minimum Passing Score:

70%
Supplemental Materials