|
Training Syllabus
|
NCORC010
-
Oracle 11g Introduction To SQL
|
|
Durasi : 5 hari
- Introducing Oracle Database 11g
- Retrieving Data Using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single-Row Functions to Customize Output
- Using Conversion Functions and Conditional Expressions
- Reporting Aggregated Data Using the Group Functions
- Displaying Data From Multiple Tables
- Using Sub-queries to Solve Queries
- Using the SET Operators
- Manipulating Data
- Using DDL Statements to Create and Manage Tables
- Creating Other Schema Objects
- Controlling User Access
- Managing Schema Objects
- Managing Objects with Data Dictionary Views
- Manipulating Large Data Sets
- Managing Data in Different Time Zones
- Retrieving Data Using Sub-queries
- Regular Expression Support
|
|
|