Introduction to Oracle 11g SQL Programming

Octalsoft offers programs in alliance with global IT software vendors to make you certified specialist. Octalsoft premium alliance with leading software houses allow globally recognized certification programs with these vendors. At Octalsoft, you get the benefit of our teaching experience and rich faculty pool, together with the standardized content of these programs. In effect, you get the best of both the worlds.

Introduction:-

In this Introduction oracle 11g SQL Programming course , students will learn how to create, retrieve, and manipulate objects in Oracle 11g Structured Query Language (SQL). Students will also be introduced to Oracle 11g database features and tools.

Duration: 2 days

Program Contents:

• Relational Database and SQL Overview
  • Review of Relational Database Terminology
  • Relational Database Management Systems
  • Introduction to SQL
  • Oracle Versioning and History
  • Connecting to a SQL Database
  • Data types
  • Sample Database
  • Using Oracle SQL Plus

• SQL Queries - The SELECT Statement
• Scalar Functions
• SQL Queries - Joins
• The Aggregate Functions
• Data Manipulation and Transactions
• Data Definition and Control Statements

Audience:  Project Manager, Technical Consultant, Application developers, database administrators, system administrators and users who write applications and procedures that access an Oracle 11g database.

Pre Requisites:

Participants must be familiar with Data manipulation concepts and RDBMS concepts.

Exit Profile:

The candidate would learn how to use Data Server Technology.