Jul 12, 2025  
College Catalog 2017-2018 
    
Catalog Navigation
  Catalog Home
  The RTC Experience
  Instructional Programs
  Admissions & Registration
  Student Services & Financial Aid
  Academic Regulations
  Career Training Programs
  Apprenticeship Programs
  Basic Studies
  Course Descriptions
  Advisory Council and Foundation
  Appendix
HELP
College Catalog 2017-2018 [ARCHIVED CATALOG]

CNA 330 - Network Databases and Structured Query Language (SQL)

Credits 5
This course acquaints the student with the concept of databases and queries using Structured Query Language (SQL). Students learn to create tables and databases and gain proficiency with SQL to create and use queries that are related to dates, strings, numbers, data aggregation, etc.    
Course Outcomes
  1. Use SQL to create tables and indexes.
  2. Compose SQL queries.
  3. Understand constraints, views, triggers, and indexes in databases.
  4. Explain how queries are processed, optimized and evaluated in a DBMS.
  5. Explain transaction processing.
  6. Recognize common SQL server issues (log space, performance problems, job failures).