Upon completion of this course, the student will be able to: Create tables and views. Use DML statements to insert, delete and update data from a database table. Use COMMIT, ROLLBACK, and SAVEPOINT to control transactions. Use the data dictionary to display the structures of a table and query the different views available. Use DDL statements to alter columns in a table and manage comments. Define various types of constraints. Use SQL statements to drop and manage constraints. Describe data dictionary and DDL statements.
Unit 1: Creating Tables and Views
- Oracle Datatypes
- Creating Tables
- Creating Tables From Other Tables
- Creating Views
- Modifying Views
Unit 2: Manipulating Data
- Inserting Rows into a Table
- Updating Rows in a Table
- Deleting Rows from a Table
- Controlling Transactions
Unit 3: Altering Tables
- Altering Columns in a Table
- Removing a Table
- Managing Comments
Unit 4: Altering Constraints
- Constraints
- Adding a Constraint
- Dropping a Constraint
- Managing Constraints