- 11 Sections
- 35 Lessons
- 32 Hours
Expand all sectionsCollapse all sections
- A. PERSIAPAN DAN LINK ZOOM2
- 1. ORACLE SERVER TECHNOLOGIES AND THE RELATIONAL PARADIGM4
- 2. DATA RETRIEVAL USING THE SQL SELECT STATEMENT LIST THE CAPABILITIES OF SQL SELECT STATEMENTS2
- 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
- 10.18.1. Use conversion functions
- 10.28.2. Describe the types of problems subqueries can solve
- 10.38.3. Describe the types of subqueries
- 10.48.4. Use correlated subqueries
- 10.58.5. Update and delete rows using correlated subqueries
- 10.68.6. Use the EXISTS and NOT EXISTS operators
- 10.78.7. Use the WITH Clause
- 10.88.8. Use single-row and multiple-row subqueries
- 9. USING THE SET OPERATORS3
- C. Penutupan dan Pengisian Kuesioner2