Sep 19, 2019  
2019-2020 Academic Catalog 
    
2019-2020 Academic 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