SQL Training

What is Database
What is Database Management System
Difference between File System and DBMS
Learn Basics of Data modeling
Introduction to Data Models
Understand Different types of Data Model
1. Conceptual Data Model
2. Logical Data Model
3. Physical Data Model

Introducing the Structured Query Language (SQL)
Explain the features of SQL
Explain the structure of SQL
List the types of SQL
Explain the SQL operators
List the SQL data types

Column Heading Defaults
Arithmetic Expressions
Using Arithmetic Operators
Operator Precedence
Using Parentheses
Defining a Column Alias
Using Column Aliases
Concatenation Operator
Using the Concatenation Operator
Literal Character Strings
Using Literal Character Strings
Duplicate Rows
Eliminating Duplicate Rows
ORDER BY Clause
Sorting in Descending Order
Sorting by Column Alias
Sorting by Multiple Columns
Define/Undefine
Set Verify off

Displaying Tables available for an user
Displaying the structure of a table
Capabilities of SQL SELECT Statements
Basic SELECT Statement
Selecting All Columns/Specific Columns
Writing Simple SQL Statements
Limiting Rows Using a Selection
Limiting the Rows Selected
Using the WHERE Clause
Character Strings and Dates
Using Comparison Conditions
Other Comparison Conditions
Using the BETWEEN Condition
Using the IN Condition
Using the LIKE Condition
Using the NULL Conditions
Logical Conditions
Using the AND Operator
Using the OR Operator
Using the NOT Operator

What are Constraints?
Constraint Guidelines
Defining Constraints
The NOT NULL Constraint
The UNIQUE Constraint
The PRIMARY KEY Constraint
The FOREIGN KEY Constraint
The CHECK Constraint

Data Definition Language (DDL)
Data Retrieval Language (DRL)
Data Manipulation Language (DML)
Transaction Control Language (TCL)
Database Security and Privileges (DCL)

Column Heading Defaults
Arithmetic Expressions
Using Arithmetic Operators
Operator Precedence
Using Parentheses
Defining a Column Alias
Using Column Aliases
Concatenation Operator
Using the Concatenation Operator
Literal Character Strings
Using Literal Character Strings
Duplicate Rows
Eliminating Duplicate Rows
ORDER BY Clause
Sorting in Descending Order
Sorting by Column Alias
Sorting by Multiple Columns
Define/Undefine
Set Verify off

SQL Functions
Two Types of SQL Functions
Single-Row Functions
Character Functions
Case Manipulation Functions
Using Case Manipulation Functions
Character-Manipulation Functions
Using the Character-Manipulation Functions

Date Functions
Using Date Functions
Conversion Functions
Implicit Data Type Conversion
Explicit Data Type Conversion
Using the TO_CHAR Function with Dates
Elements of the Date Format Model
Using the TO_CHAR Function with Dates
Using the TO_CHAR Function with Numbers
Using the TO_NUMBER and TO_DATE Functions

NVL Function
Using the NVL Function
Using the NVL2 Function
Using the NULLIF Function
Using the COALESCE Function
Conditional Expressions
The CASE Expression
Using the CASE Expression
The DECODE Function
Using the DECODE Function

Min
Max
Sum
Avg
Using the GROUP BY Clause to Group Rows
Incorrect Usage of Aggregate Function Calls
Using the HAVING Clause to Filter Groups of Rows
Using the WHERE and GROUP BY Clauses Together
Using the WHERE, GROUP BY, and HAVING Clauses Together

Views –
Why use Views?
Simple Views and Complex Views
Creating a View
Retrieving Data from a View 1
Querying a View
Modifying a View
Creating a Complex View
Rules for Performing DML Operations on a View
Using the WITH CHECK OPTION Clause
Denying DML Operations
Removing a View
Inline Views
Sequence –
The CREATE SEQUENCE Statement Syntax
Creating a Sequence
Confirming Sequences
NEXTVAL and CURRVAL Pseudo columns
Using a Sequence
Modifying a Sequence
Guidelines for Modifying a Sequence
Removing a Sequence
Index –
How Are Indexes Created?
Creating an Index
When to Create an Index
When Not to Create an Index
Confirming Indexes
Function-Based Indexes
Removing an Index
Synonyms –
Creating and Removing Synonyms

IF Statement
Simple IF Statement
IF THEN ELSE Statement
IF ELSIF ELSE CLAUSE
CASE Expressions
CASE Expressions: Example
Searched CASE Expressions
CASE Statement