|
Training Syllabus
|
NCORC001
-
Oracle 10g SQL Fundamental
|
|
Durasi : 4 hari
- Introduction
Oracle10g, Framework
Relational Database Concept
Definition of a Relational Database
Data Models
- Retrieving Data Using the SQL SELECT Statement
Basic SELECT Statement
Column Heading Defaults
Using Arithmetic Operators
Defining a Column Alias
Literal Character Strings
SQL Statements Versus iSQL*Plus Commands
Displaying Table Structure
- Restricting and Sorting Data
Limiting Rows Using a Selection
Using Comparison Conditions
Logical Conditions
Using the ORDER BY Clause
Substitution Variables
- Using Single-Row Functions to Customize Output
SQL Functions
Character Functions
Number Functions
Working with Dates
Conversion Functions
General Functions
Conditional Expressions
- Reporting Aggregated Data Using the Group Functions
What Are Group Functions?
Creating Groups of Data: GROUP BY Clause Syntax
Using the HAVING Clause
- Displaying Data from Multiple Tables
Obtaining Data from Multiple Tables
Joining Tables Using SQL:1999 Syntax
Creating Natural Joins
Retrieving Records with the USING Clause
Creating Joins with the ON Clause
Non-Equijoins
Outer Joins
- Using Subqueries to Solve Queries
Subquery Syntax
Types of Subqueries
Single-Row Subqueries
Multiple-Row Subqueries
- Using the Set Operators
UNION Operator
UNION ALL Operator
INTERSECT Operator
MINUS Operator
The Oracle Server and Set Operators
- Manipulating Data
Inserting New Rows
Changing Data in a Table
Removing a Row from a Table
TRUNCATE Statement
Database Transactions
- Using DDL Statements to Create and Manage Tables
CREATE TABLE Statement
Datetime Data Types
Including Constraints
ALTER TABLE Statement
Dropping a Table
- Creating Other Schema Objects
What Is a View?
Sequences
Indexes
Synonyms
- Managing Objects with Data Dictionary Views
The Data Dictionary
USER_OBJECTS View
|
|
|