CONTENUTI

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

• Conclusion
• Q&A Sessions