Oracle Training

Oracle

The Oracle Database SQL engine is the underpinning of all Oracle Database applications. Oracle SQL continually evolves to meet the growing demands of database applications and to support emerging computing architectures, APIs, and network protocols.

In addition to traditional structured data, SQL is capable of storing, retrieving, and processing more complex data Object types, collection types, and REF types provide support for complex structured data. A number of standard-compliant multiset operators are now supported for the nested table collection type.

Learn how to write SQL (Structured Query Language) from scratch with SQL Essentials training course. This course will easily step you through writing SQL using Microsoft's SQL Server Management Studio. SQL allows you to retrieve, sort, filter, group, aggregate and calculate data stored in a SQL Server database. This course is designed for people wanting to learn how to interrogate data from a relational database, how to manipulate this data (Insert, update, and delete records). Although we use SQL Server to interrogate data throughout this course, SQL is a common language easily adapted to other RDBMS (relational database management systems) such as MySQL, IBM DB2, PostgreSQL, Oracle, Ingres, Sybase and Microsoft Access

Why to enroll in oracle training at Trishana Technologies, Bangalore?

Oracle is one of the biggest database technology assets in the world. We provide enough knowledge on Oracle by highly experienced and real-time professionals and also various prestigious and worthy Oracle Certification courses, for students, freshers , employees and professionals who want to lead the IT industry. You can register for Oracle Training andopt from a wide range of Oracle Training Courses here. We have special trainers for each courses who are experts in specific domain.

However, notwithstanding the type of course, all our students get full access to the materials related to oracle and are free to practice in our lab. Our trainers are happy to help them whenever needed. We also provide software and hardware support to all our students to train at home.

We conduct webinars and video conferences to help our students understand the recent trends and expectations in the industry. We may well be the first institute to do that but we are always happy to cross extreme lengths for our students.

Syllabus

What is Oracle

  • The History of Oracle
  • Type of Oracle Versions
  • Features of Oracle Database 11g

SQL

  • Data types of SQL statements
  • Data Definition Commands –DDL
  • Interactive Data Manipulation Language (Interactive DML)
  • Data Transaction Control
  • Transactional Control Language
  • Save queries to files and use script files in SQL Developer

Operators

  • List the capabilities of SQL SELECT statements
  • Constraints
  • Relational Operators
  • Set Operators
  • Select Specific Columns
  • Use Arithmetic Operators
  • Use Logical Operators
  • Use Comparison Operators
  • Learn the DESCRIBE command to display the table structure

Learn to Restrict and Sort Data

  • Write queries that contain a WHERE clause to limit the output retrieved
  • List the comparison operators and logical operators that are used in a WHERE clause
  • Describe the rules of precedence for comparison and logical operators
  • Use character string literals in the WHERE clause
  • Write queries that contain an ORDER BY clause to sort the output of a SELECT statement
  • Sort output in descending and ascending order
  • Use Distinct and Unique

Usage of Single-Row Functions to Customize Output

  • Describe the differences between single row and multiple row functions
  • Manipulate strings with character function in the SELECT and WHERE clauses
    • Character Function
    • Character Manipulation Function
    • Case Manipulation Function
    • Number Function
    • Date Function
    • Conversion Function
    • General Function
    • Group Function
    • Analytical Function
    • Pseuducolumns

Joins

  • What is Join & Types of Joins
  • Cross Join
  • Inner Join
  • Outer Join
  • Self-Join

Use Sub-queries to Solve Queries

  • Define sub-queries
  • Describe the types of problem that sub-queries can solve
  • List the types of sub-queries
  • Write single-row and multiple-row sub-queries

Use Correlated Sub-queries to Solve Queries

  • Define Correlated sub-queries
  • Describe the types of problem that sub-queries can solve
  • Use IN and EXIST Keywords

Database Object

  • Create a simple and complex view
  • Retrieve data from views
  • Create, maintain, and use sequences
  • Create and maintain indexes

Type of Indexes

  • Unique Index
  • Non Unique index

View Types:

  • Simple View
  • Complex View

PLSQL

  • Anonymous block
  • Control statement

Cursor

  • Implicit
  • Explict
  • Dynamic Refcursor

Exception Types

  • Types
  • Predefined
  • User defined
  • Non predefined
  • Raise-application-error

Trigger

  • Statement level
  • Row level

Collection Types

  • Index by array
  • Nested Array
  • V Array

Career Opportunities in Oracle SQL Developer

  • Plsql developer
  • oracle Application server
  • Microsoft Sql server
Available for weekends
and weekdays
Register for Demo
Class