Introduction to Structured Query LanguageCST 258
Prerequisite: CST 257. Examines SQL (Structured Query Language) which is the standard database language. Creates, updates, and retrieves information from relational databases. (15-0)
Outcomes and Objectives
Identify the parts of a Database table.
- Describe data formats in a table.
- Identify rows, columns, and cells.
- Describe primary keys.
- Demonstrate table designs in Access and Oracle.
- Create tables with the proper data types.
- Manipulate primary keys especially adding and changing.
Retrieve information from a table.
- Use the "Select" statement.
- Use the "Where" clause.
- Implement the "order by" clause.
Apply the proper syntax for various SQL commands.
- Define and use compound where clauses.
- Define and use not, in, between, like and is null.
- Express proper SQL syntax rules.
- Use constant values.
- Perform proper syntax punctuation and case sensitivity.
- Create a new table from the results of the Select statement.
- Create a new view from the results of Select statement.
- Describe similarities and differences between tables and views.
- Manage the modifying of tables.
- Add, expand, and delete columns and rows.
Manipulate data in tables.
- Change data through a view.
- Set column formats using SQL Plus.
- Use a spool file.
- Define and implement a data dictionary.
- Locate tables, views, and primary keys.
Define and apply data integrity.
- Implement and discuss the concept of referential integrity.
- Implement and discuss delete and update rules.
- Implement and discuss constraints such as check, unique, not null.
- Perform functions dealing with numbers, text and date.
- Perform data joins from two tables.
- Describe the relationships-one to one, many to one, many to many and unmatched.
- Describe outer joins and inner joins.