Database Design

  • Database Models
  • Beginnings
  • Some Introductory Terminology
  • Codd’s 12 Rules
  • Normalization
  • First Normal Form
  • Higher Order Normal Forms

Oracle Standard Interfaces

  • Sql
  • Viewing A Sample Table
  • The Graphical User Interface
  • The Sql Buffer
  • The Web-Based Interface
  • Describe

The Sample Database

  • The Entity Relationship Model
  • Entity Relationship Diagrams
  • The Sample Database
  • Er Diagram For Sample Database
  • Creating The Sample Data
  • Viewing Sample Data
  • Data Types Of The Sample Data

Data Definition Language

  • Categories Of Sql Statements
  • Oracle Datatypes
  • The Create Statement
  • The Drop Command
  • The Alter Command
  • Integrity Constraints
  • Entity Integrity Constraints
  • Referential Integrity Constraints
  • Modifying Table To Use Constraints
  • Checking Constraints
  • The Data Dictionary

Data Manipulation Language

  • Dml Statements
  • The Select Statement
  • The Insert Statement
  • The Delete Statement
  • The Update Statement
  • More Sql*Plus Commands

Transaction Control

  • Transactions
  • Command Classification
  • Savepoints
  • The Set Transaction Command

Sql Operators

  • Simple Selects
  • Comparison Operators
  • In And Not In Operators
  • Between Operator
  • The Like Operator
  • Logical Operators
  • Is Null And Is Not Null
  • Any
  • All

SQL FUNCTIONS

  • Introduction
  • The DISTINCT Keyword
  • Aliases
  • Miscellaneous Functions
  • Mathematical Functions
  • String Functions
  • Date Functions
  • Conversion Functions
  • Pseudo Columns

 Joining Tables

  • Joins
  • Cartesian Product
  • Inner Joins
  • Equi-Join
  • Table Aliases
  • Non-Equi Join
  • Non-Key Join
  • Reflexive Join
  • Natural Join
  • Outer Joins
  • Right Outer Join
  • Left Outer Join
  • Full Outer Join
  • Oracle-Specific Syntax for Outer Joins

 Set Operators

  • Introduction
  • Selection Criteria
  • Union
  • Union All
  • Intersect
  • Minus

 SQL Subqueries

  • Introduction
  • Using a Subquery with a DML Statement
  • Typical Subqueries
  • Subquery Operators
  • Standard vs. Correlated Subqueries
  • Correlated Subquery Example
  • Predicate Operators

 Groups

  • SQL Statements
  • GROUP BY Clause
  • HAVING Clause
  • Order of a SELECT Statement

STUDENT BENEFITS

  • Job Assistance
  • Pay Fees in Installments / EMI
  • Technical Support after Course Completion
  • Back up Classes Available
  • Attend Demo class
  • Course Complete Certificate
  •  Lab Facility
  • Real Time Project

ADDITIONAL HIGHLIGHTS

  • Total 60  hours Class
  • 1 on 1 Trining
  •  You Get In-Depth Practical Knowledge on each Topic
  • Free Study E-Material, PDFs, Video Trainings
  • Flexible Timimg
  •  Online Trainings provided

For More Information: Call us on +917411000877

Contact us on +917411000877