Course Content
Lesson 1: Introduction to Oracle Database
- Basic of relational database
- Different types of SQL statements
Lesson 2: SQL SELECT Statement
- List the capabilities of SQL SELECT statements
- Select All Columns, Select Specific Columns
- Arithmetic Operators and Operator Precedence
Lesson 3: Restrict and Sort Data
- Describe WHERE clause
- Comparison operators and logical operators
- Describe ORDER BY clause
Lesson 4: Single-Row Functions
- Differences between single row and multiple row functions
- String manipulation functions
- Describe ROUND, TRUNC, and MOD functions
- Arithmetic with date
- Manipulate dates with the DATE functions
Lesson 5: Conversion Functions and Conditional Expressions
- Describe TO_CHAR and TO_DATE functions, Handle NULL values
- Use conditional IF THEN ELSE logic in a SELECT statement
Lesson 6: Group Functions – Aggregate the data
- Describe the use of the aggregation functions
- Describe GROUP BY clause
- Describe HAVING clause
Lesson 7: Joins – Get data from multiple tables
- Access data from more than one table
- Type of joins – Self joins, Outer joins, equi joins
Lesson 8: Sub-queries
- Describe the types of problem that sub-queries can solve
- Describe sub-queries
- List the types of sub-queries
- Explain single-row and multiple-row sub-queries
Lesson 9: Data Manipulation Statements
- Describe different type of DML statement
- Describe INSERT statement
- Describe UPDATE statement
- Describe DELETE statement
- Describe COMMIT and ROLLBACK statements
- Explain read consistency
Lesson 10: DDL Statements - Create and Manage Tables
- Categorize the main database objects
- Review the table structure
- List the data types
- Add constraints to the table
Lesson 11: Schema Objects in Oracle
- Simple and Complex view
- Retrieve data from views
- Explain Sequences
- Explain Indexes
- Explain Synonyms
Lesson 12: Control User Access
- Type of privileges - system privileges and object privileges
- Describe Users and Roles
- Grant System Privileges
- Grant Object Privileges
- How to pass on privileges
- Revoke Object Privileges
Lesson 13: Schema Objects management
- Add, Modify, and Drop a Column
- Add, Drop, and Defer a Constraint
- Enable and Disable a Constraint?
Lesson 14: Data Dictionary Views
- Data dictionary - Overview
- USER_OBJECTS and ALL_OBJECTS Views
- Query the dictionary views for constraint information