020 3397 3290

Selenium  Java Basics
Latest Course

Training

Software Testing Courses

http://www.kpsglobal.co.uk/sap-sales-distribution-sd.html
Phone: 020 3397 3290 , Email: info@kpsglobal.co.uk

Oracle SQL

Duration

4-6 WEEKENDS

Mode of Training

Class room

Make a deposit (£ 50)



Content and Learning
Relational Database Concepts
  • What is an Oracle Database
  • Relational Database Structures
  • Tables, Rows and Columns
  • Indexes, Primary Keys and Foreign Keys
  • Supported Datatypes
  • The Data Dictionary
Using SQL*Plus
  • What is SQL*Plus
  • Getting Started
  • Entering and Executing SQL Statements
  • Editing SQL Statements
  • Creating, Editing and Executing SQL Files
Using SQL Developer
  • What is Oracle SQL Developer
  • Starting SQL Developer
  • Configure a Connection
  • Navigation Tabs
  • SQL Worksheet
Retrieving Data with the SELECT 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 Built In 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 Date Functions
  • Function Types
  • Using the Table dual to try out Functions
  • Numeric Functions
  • Character Functions
  • String Concatenation
  • Date Arithmetic and Date Functions
Conversion and Miscellaneous Functions
  • Conversion Functions
  • The NVL and NVL2 Functions
  • The DECODE Function
  • CASE Expressions
  • The COALESCE and NULLIF Functions
SQL*Plus 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
Managing Tables
  • Creating Tables
  • Specifying Constraints
  • Altering Tables, Columns and Constraints
  • Dropping Tables, Columns and Constraints
  • Copying Tables
Managing Indexes and Views
  • Creating Indexes
  • Dropping Indexes
  • Listing Indexes
  • Creating and Using Views
  • Dropping Views
  • Listing Views
Managing Sequences and Synonyms
  • Create a Sequence
  • View Sequence Details
  • Create a Synonym
  • List Synonyms