Mar 29, 2024  
2018-2019 Academic Catalog 
    
2018-2019 Academic Catalog [ARCHIVED CATALOG]

CSC* E238 - SQL Fundamentals (3 credits)


Code(s): BUS, COMP
Prerequisite(s): The ability to perform basic file management and word processing tasks on a personal computer
 
A comprehensive introduction to Structured Query Language (SQL), the industry standard computer language for manipulating information stored in relational databases. The course will emphasize the SQL select statement and the associated concepts of inner joins, outer joins, self joins, unions, data summarization, functions, data types, subqueries, and views. Other topics include the creation, deletion, and modification of tables; the insertion, deletion, and modification of rows and columns; and the implementation of indexes and constraints. Course content is continually updated to reflect the current state of the art in SQL programming. The course requires substantial hands-on computer work writing SQL code in a computerized classroom environment. Course Outline: CSC 238