|
SQL Workshop 1:
- Introduction to Oracle DB Architecture.
- Introduction to Oracle RDBMS
- Data Retrieval and filtering and sorting.
- Using Single Row Functions to Customize output
- Reporting Aggregate Data Using Group Functions
- Displaying Data from Multiple tables
- Using Sub queries to Solve queries
- Using Set Operators
- Data Manipulation
- Controlling User Access
- Managing Schema Objects
SQL Workshop 2:
- Hierarchical Queries
- Decode and Case
- Advanced Group Operation
- Using DDL Statements to Create and Manage Tables
- Creating Other Schema Objects
- Managing Objects with Data Dictionary View.
- Manipulating Large Data Sets
|