ORACLE Course
RELATIONAL DATABASES & DATA MODELS
SELECTION & SETUP OF THE DATABASE INTERFACE
USING THE DATABASE INTERFACE
INTRODUCTION TO THE SQL LANGUAGE
THE SELECT STATEMENT
ENHANCING GROUPS WITH ROLLUP & CUBE
USING THE CASE EXPRESSION SQL FUNCTIONS: CHARACTER HANDLING
SQL FUNCTIONS: NUMERIC HANDLING
SQL FUNCTIONS: DATE HANDLING
DATABASE OBJECTS: ABOUT DATABASE OBJECTS
PROGRAM INSTRUCTORS
DATABASE OBJECTS: SECURITY
USING THE DATABASE INTERFACE
- RELATIONAL DATABASES & DATA MODELS
- ABOUT DATA MODELS
- ABOUT THE RELATIONAL MODEL
- THE ELECTRONICS DATA MODEL
- ABOUT THE RELATIONAL DBMS
training tools, and networking opportunities to increase workplace performance.
- SELECTION & SETUP OF THE DATABASE INTERFACE
- CONSIDERING AVAILABLE TOOLS
- SELECTING THE APPROPRIATE TOOL
- ORACLE NET DATABASE CONNECTIONS
- ORACLE PAAS DATABASE CONNECTIONS
- SETUP SQL DEVELOPER
- SETUP SQL*PLUS
- SETUP JDEVELOPER
- USING THE DATABASE INTERFACE
- ABOUT BIND & SUBSTITUTION VARIABLES
- USING SQL DEVELOPER
- USING SQL*PLUS
- INTRODUCTION TO THE SQL LANGUAGE
- ABOUT THE SQL LANGUAGE
- CHARACTERISTICS OF SQL
- INTRODUCING SQL USING SELECT
- SQL RULES
- THE SELECT STATEMENT
- THE SELECT STATEMENT
- DI
- ENHANCING GROUPS WITH ROLLUP & CUBE
- USING ROLLUP
- The GROUPING() Function
- USING CUBE
- USING THE CASE EXPRESSIONSQL FUNCTIONS: CHARACTER HANDLING
- WHAT ARE THE SQL FUNCTIONS?
- STRING FORMATTING FUNCTIONS
- UPPER(), LOWER() Example
- INITCAP() Example
- CHARACTER CODES FUNCTIONS
- CHR(), ASCII() Examples
- PAD & TRIM FUNCTIONS
- RPAD() Example
- RTRIM() Example
- TRIM() Example
- STRING MANIPULATION FUNCTIONS
- DECODE() Example
- SUBSTR() Example
- INSTR() Example
- TRANSLATE() Example
- REPLACE() Example
- STRING COMPARISON FUNCTIONS
- LEAST() Example
- PHONETIC SEARCH FUNCTION
- SOUNDEX() Example
SQL FUNCTIONS: NUMERIC HANDLING
- ABOUT THE NUMERIC DATA FUNCTIONS
- GREATEST() Example
- ABS() Example
- ROUND() Example
- TRUNC() Example
- SIGN() Example
- TO_NUMBER() Example & Data Type Conversions
- NULL VALUES FUNCTIONS
- NVL() & NVL2() Function
- NVL() Example (Character)
- NVL() Example (Numeric Loss Of Data)
- NVL() Example (Numeric Output)
- NVL2() Example
- COALESCE() Function
- NULLIF() Function
ORACLE Course
ORACLE Course
ORACLE Course
SQL FUNCTIONS: DATE HANDLING
- DATE FORMATTING FUNCTIONS
- TO_CHAR() & TO_DATE() Format Patterns
- TO_CHAR() Examples
- TO_DATE() Examples
- EXTRACT() Example
- DATE ARITHMETIC FUNCTIONS
- MONTHS_BETWEEN() Example
- ADD_MONTHS() Example
- LAST_DAY() Example
- NEXT_DAY() Example
- TRUNC(), ROUND() Dates Example
- NEW_TIME() Example
- About V$TIMEZONE_NAMES
- CAST() FUNCTION & TIME ZONES
DATABASE OBJECTS: ABOUT DATABASE OBJECTS
- ABOUT DATABASE OBJECTS
- ABOUT SCHEMAS
- MAKING OBJECT REFERENCES
DATABASE OBJECTS: RELATIONAL VIEWS
- ABOUT RELATIONAL VIEWS
- THE CREATE VIEW STATEMENT
- WHY USE VIEWS?
- ACCESSING VIEWS WITH DML
- MAINTAINING VIEW DEFINITIONS
- ALTER VIEW
- DROP VIEW
- DDL Using SQL Developer
DATABASE OBJECTS: CREATING OTHER OBJECTS
- ABOUT SEQUENCES
- Referencing NEXTVAL
- Referencing CURRVAL
- Within The DEFAULT Clause
- ALTER SEQUENCE & DROP SEQUENCE
- ALTER SEQUENCE
- DROP SEQUENCE
- ABOUT IDENTITY COLUMNS
- CREATE TABLE … GENERATED AS IDENTITY
- ALTER TABLE … GENERATED AS IDENTITY
- START WITH LIMIT VALUE
- ALTER TABLE … DROP IDENTITY
- ABOUT SYNONYMS
- CREATE & DROP SYNONYM Statements
- CREATE SYNONYM
- DROP SYNONYM
- Public Vs. Private Synonyms
- CREATE SCHEMA AUTHORIZATION
DATABASE OBJECTS: CREATING OTHER OBJECTS
- ABOUT SEQUENCES
- Referencing NEXTVAL
- Referencing CURRVAL
- Within The DEFAULT Clause
- ALTER SEQUENCE & DROP SEQUENCE
- ALTER SEQUENCE
- DROP SEQUENCE
- ABOUT IDENTITY COLUMNS
- CREATE TABLE … GENERATED AS IDENTITY
- ALTER TABLE … GENERATED AS IDENTITY
- START WITH LIMIT VALUE
- ALTER TABLE … DROP IDENTITY
- ABOUT SYNONYMS
- CREATE & DROP SYNONYM Statements
- CREATE SYNONYM
- DROP SYNONYM
- Public Vs. Private Synonyms
- CREATE SCHEMA AUTHORIZATION
DATABASE OBJECTS: OBJECT MANAGEMENT USING DDL
- THE RENAME STATEMENT
- TABLESPACE PLACEMENT
- CREATE TABLE … TABLESPACE
- THE COMMENT STATEMENT
- THE TRUNCATE TABLE STATEMENT
DATABASE OBJECTS: SECURITY
- ABOUT OBJECT SECURITY
- GRANT OBJECT PRIVILEGES
- REVOKE OBJECT PRIVILEGES
- OBJECT PRIVILEGES & SQL DEVELOPER
- USING THE DATABASE INTERFACE
- ABOUT BIND & SUBSTITUTION VARIABLES
- USING SQL DEVELOPER
- USING SQL*PLUS