Introduction to SQL ITDB1400

This course provides an introduction to SQL (Structured Query Language) to create and maintain database objects, manipulate data, and to produce readable output displays and reports. Students will use the Oracle relational database management system along with DDL (Data Definition Language), DML (Data Manipulation Language), and SQL*Plus format commands. This course and ITDB 1405 Introduction to Oracle SQL/PL help students prepare for the Introduction to Oracle: SQL and PL/SQL certification exam. Although it is not a prerequisite for this course, students may benefit from taking a programming course prior to taking this course.

Correlated Learning Outcomes

  • IM-01 Contrast the difference between information and data. [Analyzing]
  • IM-02 Describe the advantages and disadvantages of central organizational control over data. [Understanding]
  • IM-04 Describe proven techniques  to secure data and information. [Understanding]
  • IM-06 Explain the characteristics that distinguish the database approach from the approach of programming with data files. [Understanding]
  • IM-07 Diagram the components of a database system and give examples of their use. [Applying]
  • IM-08 Explain the concept of data independence and its importance in a database system. [Understanding]
  • IM-09 Formulate queries in SQL or a similar query language to elicit information from a database. [Creating]
  • IM-11 Contrast appropriate data models, including internal structures for different data types. [Analyzing]
  • IM-13 Describe the differences among relational data models and other models. [Understanding]