- 16 Sections
- 59 Lessons
- 24 Hours
Expand all sectionsCollapse all sections
- 1. PERSIAPAN2
- 2. PEMBELAJARAN12
- 2.1Oracle Server Technologies and the Relational Paradigm
- 2.2Data Retrieval Using the SQL SELECT Statement
- 2.3Restricting and Sorting Data
- 2.4Single-Row Functions
- 2.5Using Conversion Functions and Conditional Expressions
- 2.6Reporting Aggregated Data Using the Group Functions
- 2.7Displaying Data from Multiple Tables
- 2.8Using Subqueries to Solve Queries
- 2.9Using the Set Operators
- 2.10Manipulating Data
- 2.11Using DDL Statements to Create and Manage Tables
- 2.12Creating Other Schema Objects
- 3. PENUTUPAN2
- 1. ORACLE SERVER TECHNOLOGIES AND THE RELATIONAL PARADIGM4
- 2. DATA RETRIEVAL USING THE SQL SELECT STATEMENT2
- 3. RESTRICTING AND SORTING DATA4
- 4. SINGLE-ROW FUNCTIONS3
- 5. USING CONVERSION FUNCTIONS AND CONDITIONAL EXPRESSIONS3
- 6. REPORTING AGGREGATED DATA USING THE GROUP FUNCTIONS3
- 7. DISPLAYING DATA FROM MULTIPLE TABLES3
- 8. USING SUBQUERIES TO SOLVE QUERIES8
- 11.18.1. Use Conversion Functions
- 11.28.2. Describe the Types of Problems Subqueries Can Solve
- 11.38.3. Describe the Types of Subqueries
- 11.48.4. Use Correlated Subqueries
- 11.58.5. Update and Delete Rows using Correlated Subqueries
- 11.68.6. Use the EXISTS and NOT EXISTS Operators
- 11.78.7. Use the WITH Clause
- 11.88.8. Use Single-Row and Multiple-Row Subqueries
- 9. USING THE SET OPERATORS3
- 10. MANIPULATING DATA4
- 11. USING DDL STATEMENTS TO CREATE AND MANAGE TABLES5
- 12. CREATING OTHER SCHEMA OBJECTS2
- PENUTUPAN2