CONTENT
1. Oracle Server Technologies and the Relational Paradigm
1.1. Position the Server Technologies
1.2. Understand Relational Structures
1.3. Use the Client Tools
1.4. Create the Demonstration Schemas
2. Data Retrieval Using the SQL SELECT Statement List the Capabilities of SQL SELECT Statements
2.1. List the Capabilities of SQL SELECT Statements
2.2. Execute a Basic SELECT Statement
3. Restricting and Sorting Data
3.1. Use the ORDER BY clause to sort SQL query results
3.2. Limit the rows that are retrieved by a query
3.3. Sort the rows that are retrieved by a query
3.4. Ampersand Substitution
4. Single-Row Functions
4.1. Describe Various Types of Functions Available in SQL
4.2. Use Conversion Functions
4.3. Use Character, Number, Date, and Analytical Functions in SELECT Statements
5. Using Conversion Functions and Conditional Expressions
5.1. Describe Various Types of Conversion Functions Available in SQL
5.2. Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Function
5.3. Apply General Functions and Conditional Expression in a SELECT Statement
6. Reporting Aggregated Data Using the Group Functions
6.1. Describe the Group Functions
6.2. Group Data Using the GROUP BY Clause
6.3. Include or Exclude Grouped Rows Using The HAVING Clause
7. Displaying Data from Multiple Tables
7.1. Use SELECT Statements to Access Data from More Than One Table Using Equijoins and No equijoins
7.2. Join a Table to Itself Using a Self-Join
7.3. View Data that Does Not Meet a Join Condition by Using Outer Joins
8. Using Subqueries to Solve Queries
8.1. Use conversion functions
8.2. Describe the types of problems subqueries can solve
8.3. Describe the types of subqueries
8.4. Use correlated subqueries
8.5. Update and delete rows using correlated subqueries
8.6. Use the EXISTS and NOT EXISTS operators
8.7. Use the WITH Clause
8.8. Use single-row and multiple-row subqueries
9. Using the Set Operators
9.1. Describe the Set Operators
9.2. Use a Set Operator to Combine Multiple Queries into a Single Query
9.3. Control the Order of Rows Returned
10. Manipulating Data
10.1. Insert Rows into Table
10.2. Update Rows in a Table
10.3. Delete Rows from Table
10.4. Control Transactions
11. Using DDL Statements to Create and Manage Tables
11.1. Describe data types that are available for columns
11.2. Create a simple table
11.3. Create constraints for tables
11.4. Describe how schema objects work
11.5. Execute a basic SELECT statement
12. Creating Other Schema Objects
12.1. Create Simple and Complex Views
12.2. Create, Maintain, and Use Sequences
