CST 258 - Introduction to Structured Query Language

1. Identify the parts of a Database table.
   1. Describe data formats in a table.
   2. Identify rows, columns, and cells.
   3. Describe primary keys.
   4. Demonstrate table designs in Access and Oracle.
   5. Create tables with the proper data types.
   6. Manipulate primary keys especially adding and changing.
2. Retrieve information from a table.
   1. Use the “Select” statement.
   2. Use the “Where” clause.
   3. Implement the “order by” clause.
3. Apply the proper syntax for various SQL commands.
   1. Define and use compound where clauses.
   2. Define and use not, in, between, like and is null.
   3. Express proper SQL syntax rules.
   4. Use constant values.
   5. Perform proper syntax punctuation and case sensitivity.
4. Save results.
   1. Create a new table from the results of the Select statement.
   2. Create a new view from the results of Select statement.
   3. Describe similarities and differences between tables and views.
   4. Manage the modifying of tables.
   5. Add, expand, and delete columns and rows.
5. Manipulate data in tables.
   1. Change data through a view.
   2. Set column formats using SQL Plus.
   3. Use a spool file.
   4. Define and implement a data dictionary.
   5. Locate tables, views, and primary keys.
6. Define and apply data integrity.
   1. Implement and discuss the concept of referential integrity.
   2. Implement and discuss delete and update rules.
   3. Implement and discuss constraints such as check, unique, not null.
   4. Perform functions dealing with numbers, text and date.
   5. Perform data joins from two tables.
   6. Describe the relationships-one to one, many to one, many to many and unmatched.
   7. Describe outer joins and inner joins.