1: Introduction
- Introduction
- Entity Relationship Model
- Practice 1-1: Introduction
2: Retrieving Data Using the SQL SELECT Statement
- Retrieving Data Using the SQL SELECT Statement
- Practice 2-1: Retrieving Data Using the SQL SELECT Statement
3: Restricting and Sorting Data
- Restricting and Sorting Data
- Practice 3-1: Restricting and Sorting Data
4: Using Single-Row Functions to Customize Output
- Using Single-Row Functions to Customize Output
- Number Functions
- Practice 4-1: Using Single-Row Functions to Customize Output
5: Using Conversion Functions and Conditional Expressions
- Using Conversion Functions and Conditional Expressions
- General Functions
- Practice 5-1: Using Conversion Functions and Conditional Expressions
6: Reporting Aggregated Data Using the Group Functions
- Reporting Aggregated Data Using the Group Functions
- Practice 6-1: Reporting Aggregated Data by Using Group Functions
7: Displaying Data from Multiple Tables Using Joins
- Displaying Data from Multiple Tables Using Joins
- Practice 7-1: Displaying Data from Multiple Tables by Using Joins
8: Using Subqueries to Solve Queries
- Using Subqueries to Solve Queries
- Practice 8-1: Using Subqueries to Solve Queries
9: Using Set Operators
- Using Set Operators
- Practice 9-1: Using Set Operators
10: Managing Tables Using DML Statements in Oracle
- Managing Tables Using DML Statements in Oracle
- State of Data
- Practice 10-1: Managing Tables by Using DML Statements
- Practice 10-1: Managing Tables by Using DML Statements….Cntd
11: Introduction to Data Definition Language in Oracle
- Introduction to Data Definition Language in Oracle
- FOREIGN KEY Constraint
- Practice 11-1: Introduction to Data Definition Language
12: Introduction to Data Dictionary Views
- Introduction to Data Dictionary Views
- Before you Begin Practice 12: Using SQL Developer
- Practice 12-1: Introduction to Data Dictionary Views
13: Creating Sequences, Synonyms, and Indexes
- Creating Sequences, Synonyms, and Indexes
- Sequence Information
- Practice 13-1: Creating Sequences, Synonyms, and Indexes
14: Creating Views
- Creating Views
- Practice 14-1: Creating Views
15: Managing Schema Objects
- Managing Schema Objects
- DROP TABLE
- Practice 15-1: Managing Schema Objects
- Practice 15-1: Managing Schema Objects….Cntd
16: Retrieving Data by Using Subqueries
- Retrieving Data by Using Subqueries
- Practice 16-1: Retrieving Data by Using Subqueries
17: Manipulating Data by Using Subqueries
- Manipulating Data by Using Subqueries
- Practice 17-1: Manipulating Data by Using Subqueries
18: Controlling User Access
- Controlling User Access
- Practice 18-1: Controlling User Access
19: Manipulating Data Using Advanced Queries
- Manipulating Data Using Advanced Queries
- MERGE Statement
- Practice 19-1: Manipulating Data
- Practice 19-1: Manipulating Data…Cntd
20: Managing Data in Different Time Zones
- Managing Data in Different Time Zones
- Practice 20-1: Managing Data in Different Time Zones
21: Conclusion