SQL & Oracle Database Training

Relational concepts like table, keys, constraints

Introduction and Architecture

Introduction to SQL

LAB and VM setup

Applying Rules of precedence for operators in an expression

Limiting Rows Returned in a SQL Statement

Using Substitution Variables

Using the DEFINE and VERIFY commands

Sorting Data

SELECT statement, WHERE clause

Applying Rules of precedence for operators in an expression

Limiting Rows Returned in a SQL Statement

Using Substitution Variables

Using the DEFINE and VERIFY commands

Sorting Data

Manipulating strings with character functions in SQL SELECT and WHERE clauses

Performing arithmetic with date data

Manipulating numbers with the ROUND, TRUNC and MOD functions

Manipulating dates with the date function

Applying the NVL, NULLIF, and COALESCE functions to data

Understanding implicit and explicit data type conversion

Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions

Nesting multiple functions

Restricting Group Results

Creating Groups of Data

Using Group Functions

Using Various Types of Joins

Using Natural Join

Using OUTER joins

Using Self joins

Understanding and Using Cartesian Products

Using Single Row Subqueries

Using Multiple Row Subqueries

Update and delete rows using correlated subqueries

Matching the SELECT statements

Using the ORDER BY clause in set operations

Using The INTERSECT operator

Using The MINUS operator

Using The UNION and UNION ALL operators

Perform Insert, Update and Delete operations

Managing Database Transactions

Controlling transactions

Describing and Working with Tables

Describing and Working with Columns and Data Types

Creating tables

Dropping columns and setting column UNUSED

Truncating tables

Creating and using Temporary Tables

Creating and using external tables

Managing Constraints

Managing Indexes

Managing Synonyms

Managing Sequences

Managing Views

Use Case

Total