| 주제 | 소개 |
|---|
| 주제 1 | - Creating And Using Temporary Tables
- Understanding Oracle Database Architecture
|
| 주제 2 | - Using The Automatic Diagnostic Repository (ADR)
- Deploying Oracle Database Space Management Features
|
| 주제 3 | - Creating, Altering And Dropping Tablespaces
- Displaying Data From Multiple Tables Using Joins
|
| 주제 4 | - Using Single-Row Functions To Customize Output
- Limiting Rows Returned In A SQL Statement
|
| 주제 5 | - Managing Oracle Database Users, Privileges, And Roles
- Applying The Principal Of Least Privilege
|
| 주제 6 | - Understanding Data Definition Language
- Managing Data In Different Time Zones
- Understanding Block Space Management
|
| 주제 7 | - Creating And Assigning Profiles
- Configuring The Oracle Net Listener
- Shutting Down Oracle Database Instances
|
| 주제 8 | - Understanding Oracle Database Memory And Process Structures
- Understanding Oracle Database Server Architecture
|
| 주제 9 | - Manipulating Strings With Character Functions In SQL SELECT And WHERE Clauses
- Using Racle Enterprise Manager Database Express
|
| 주제 10 | - Using Conversion Functions And Conditional Expressions
- Comparing Undo Data And Redo Data
|
| 주제 11 | - Using Concatenation Operator, Literal Character Strings, Alternative Quote Operator, And The DISTINCT Keyword
|
| 주제 12 | - Reporting Aggregated Data Using Group Functions
- Connecting To An Oracle Database Instance
|
| 주제 13 | - Understanding Oracle Database Instance Configurations
- Understanding Logical And Physical Database Structures
|
| 주제 14 | - Configuring Oracle Net Services
- Comparing Dedicated And Shared Server Configurations
|
| 주제 15 | - Using Oracle Net Services Administration Tools
- Administering User Authentication Methods
|
| 주제 16 | - Applying Rules Of Precedence For Operators In An Expression
- Manipulating Dates With The Date Function
|
| 주제 17 | - Using Arithmetic Expressions And NULL Values In The SELECT Statement
- Understanding Transactions And Undo Data
|
| 주제 18 | - Managing Tables Using DML Statements
- Using The TO_CHAR, TO_NUMBER, And TO_DATE Conversion Functions
|