CIS 2520 - Introduction to SQL (Structured Query Language)
Student Learning Outcomes
Create basic and advanced queries used to retrieve data from multiple tables utilizing proprietary and ANSI standard JOIN commands.
Construct queries with aggregate & grouping functions.
Compose DML queries that manipulate, sort, and restrict data.
Build DDL queries that can create or alter tables and utilize transaction control for saving objects and data.
Construct advanced Queries: rollup, cube, set operators, merge, subqueries, and correlated subqueries.
Build, maintain, and execute views.
Course Description Introduction to Structured Query Language (SQL) within the context of an Oracle database. Students will create basic and complex queries (joining, sub-queries, aggregate functions, grouping data), and learn to manipulate data using insert, update and delete statements. Students will create tables, views, constraints, indexes and sequences and benefit by learning the industry standards while utilizing the latest database software and online training materials. Credits: 3