CIS 122INTRO SQL & DATABASE DEVELOPMENT

Catalog

This course introduces the student to the concepts of structured query language (SQL) used to retrieve records from a relational database. Among covered concepts are set theory, Boolean logic, data normalization and table structure, SQL keywords and operators, primary and foreign keys, retrieval wildcards, and join types. At the conclusions of the course, students will be able to write complex queries which filter and summarize retrieved records. Course Note: Experience with spreadsheets and mathematical formulae will be helpful.