About Trainer

  • 8 years of Oracle DBA experience
  • Oracle Database Certified
  • Working as a Senior Core DBA
  • Sound Technical skills
  • Teaching from 4+ years

About SQL Fundamentals

 
 
 
 
ONLINE TRAINING IN SQL FUNDAMENTALS BY OUR REALTIME/CERTIFIED PROFESSIONALS

Course Pre-requisites: None

Lab setup:

  • RHEL 32/64 bit
  • Oracle 32/64 bit

Training Material:

  • Class PPT’s (Soft Copy)
  • Class recordings (optional)

SQL FUNDAMENTALS ONLINE TRAINING Course Content:

RELATIONAL DATABASE CONCEPTS

  • What is an Oracle Database
  • Relational Database Structures
  • Tables, Rows and Columns
  • Indexes, Primary Keys & Foreign Keys
  • Supported Data types
  • The Data Dictionary

USING SQL*PLUS

  • What is SQL*Plus
  • Getting Started
  • Enter/Execute SQL Statements
  • Editing SQL Statements
  • Create, Edit and Execute SQL Files

USING SQL DEVELOPER

  • What is Oracle SQL Developer
  • Starting SQL Developer
  • Configure a Connection
  • Navigation Tabs
  • SQL Worksheet

RETRIEVING DATA WITH THESELECT STATEMENT

  • The SELECT Statement
  • The SELECT and FROM Clauses
  • Conditions and the WHERE Clause
  • Other Conditional Operators
  • Logical Operators
  • The ORDER BY Clause
  • Column Aliases
  • Arithmetic Expressions
  • Precedence of Operators

AGGREGATE FUNCTIONS

  • Overview of Aggregate Functions
  • The GROUP BY Clause
  • The HAVING Clause

JOINING TABLES

    `
  • Overview of Table Joins
  • Inner Joins
  • Table Aliases
  • Outer Joins
  • Self Joins
  • ANSI Standard Joins
  • Set Operators

NUMERIC, CHARACTER AND DATEFUNCTIONS

  • Function Types
  • Using Table dual to try out Functions
  • Numeric Functions
  • Character Functions
  • String Concatenation
  • Date Arithmetic and Date Functions

CONVERSION AND MISCELLANEOUSFUNCTIONS

  • Conversion Functions
  • NVL and NVL2
  • DECODE
  • CASE Expressions
  • COALESCE and NULLIF

SQL PARAMETERS

  • Command Line Substitution Parameters
  • The Accept Command
  • The Define and Undefine Commands

USING SUBQUERIES

  • Overview of Subqueries
  • In-Line Views
  • Top-N Queries
  • Complex Subqueries
  • Multi Column Subqueries
  • Correlated Subqueries
  • Subquery Rules
  • Using the ANY, ALL and SOME Operators

MANAGING DATA

  • Inserting Rows
  • Updating Rows
  • Deleting Rows
  • Verifying Updates
  • Transaction Control
  • Commit and Rollback
  • Savepoints
  • Commits and Constraints
  • Amending Data in SQL Developer

 
 
 
 

Testimonials

  • The fact that they have a set format of teaching, which creates a schedule for a student, and a step-by-step process that covers the entire Netezza syllabus. I can surely assure eTraining provides a great help for Netezza curriculum.
    - Shannon D.

  • The BEST I liked about the tutors in eTraining is the amount of practical knowledge these guys have and the way they bring in the same to students perspective while Teaching. Glad I took DB2 course from eTraining.
    - Rubeena Khan

  • I found classes very helpful. What you Teach is AWESOME
    - Gopal