Oracle 11g Online Training and Placement

  Oracle 11g Training for OPT CPT Students

Online Training Courses
.Net Online Training Courses Java Online Training Courses SAP Online Training Courses Oracle Online Training Courses Software Testing Online Training Courses C Programming Online Training Courses C++ Programming Online Training Courses jQuery Online Training Courses UI Design Online Training Courses UNIX Online Training Courses Javascript Online Training Courses SQL & PLSQL Online Training Courses SAS Online Training Courses BI Reporter Tool Online Training Courses Microstrategy Online Training Courses Mainframes Online Training Courses Business Objects Online Training Courses Business Analysis Online Training Courses BPM Online Training Courses Hadoop Online Training Courses DataStage Online Training Courses Android Online Training Courses Linux Online Training Courses OBIEE Online Training Courses IBM Tools Online Training Courses PHP Online Training Courses AJAX Online Training Courses BizTalk Online Training Courses Data Warehousing Online Training Courses Embedded Systems Online Training Courses Google Technologies Online Training Courses Microsoft Technologies Online Training Courses Oracle DBA Online Training Courses Oracle Datawarehouse Online Training Oracle E-Business Suite Online Training PeopleSoft Online Training Courses Project Management Online Training Courses Autocad Online Training Courses Salesforce Online Training Courses Sharepoint Online Training Courses Softskills Online Training Courses System Networking Online Training Courses Web Design Online Training Courses BizTalk Server Online Training Courses Database Online Training Courses iPhone App Development Online Training Ruby On Rails Online Training Courses SEO Online Training Courses Shell Scripting Online Training Courses VMWare Online Training Courses Webmethods Online Training Courses Websphere Online Training Courses Visual Basic Online Training Courses TIBCO SOA Online Training Courses COGNOS Online Training Courses Perl Scripting Online Training Courses Hyperion Online Training Courses Informatica Online Training Courses Python Online Training Courses QlikView Course Contents QA Online Training Courses Tableau Tool Online Training Courses Basic .Net Training Course
More    


Oracle 11g Online Training Course

Oracle 11g Course Content:

Oracle 11g – SQL & PL/SQL

The Oracle database environment

  • 1.Reviewing basic architecture concepts
  • 2.Oracle 10g Architecture
  • 3.Main features of 9i and 10g

Basic SQL*PLUS commands

  • 1.Using script files, START, @, GET, SAVE, LIST, PROMPT, PAUSE, ACCEPT, DEFINE, SPOOL

Basic SELECT Statement

  • 1.Writing the statement in sql plus, Running the SELECT statement

Ordering the output

  • 1.Single Column, Descending order, multiple column sorts

Conditional retrieval of data

  • 1.Working with complex conditions, AND OR NOT LIKE BETWEEN

Working with variables

  • 1.Creating and using variables, Command substitution

Pseudo columns and functions

  • 1.Pseudo Columns, Row num, Sys date, User & UID, the Dual Table
  • 2.Working with character functions
  • 3.UPPER, LOWER, INITCAP, RPAD(), RTRIM(), SUBSTR(), INSTR(),
  • 4.TRANSLATE(), REPLACE(), GREATEST(), LEAST(), DECODE
  • 5.Working with date functions
  • 6.TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY()

Using non-character function

  • 1.ROUND (), TRUNC (), SIGN (), Working with multiple tables, Different type of Joins, Writing Outer Joins

Using the SET operators

  • 1.Union, Intersect, minus

Aggregating data using group functions

  • 1.GROUP BY, HAVING

Creating Sub queries

  • 1.Single Row sub queries, Multiple row Sub queries

Enhancing groups function

  • 1.ROLLUP, CUBE

Transaction Control Language

  • 1.Rollback, Commit, save point

Processing hierarchies

  • 1.creating the Tree structure, LEVEL, CONNECT BY

Data Manipulation Language

  • 1.INSERT, UPDATE, DELETE

Data Definition Language

  • 1.CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE

Using Declarative Constraints

  • 1.Views, Sequences, Synonyms, Indexes, USER_TABLES, USER_TAB_COLUMNS,
    USER_OBJECTS, USER_IND_COLUMNS, USER_UPDATEABLE_COLUMNS, 
  • Materialized
  • Views, Other Data dictionary views

Database Security

  • 1.Object Privileges, Granting access to objects

Improving query performance

  • 1.Planning and managing the tuning process, Employing tuning tools,
    Running EXPLAIN PLAN and auto trace, SQL Trace and TKPROF output,
    Optimizer concepts, Fundamentals of access paths, Gathering object and system
    statistics with DBMS_STATS, Utilizing hints and optimizer mode,
    Specifying first-rows optimization, Determining the driving table

Other Concepts

  • 1.The Relational Database Model, The system Development Lifecycle, Overview of normalization

PL/SQL

Blocks

  • 1.Structure, Writing Anonymous Blocks

Variables

  • 1.Oracle Data types, TYPE and ROWTYPE declarations, Value assignments

Control structures

  • 1.IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement,
  • 2.LOOP END , LOOP statement, WHILE condition, FOR condition

Cursors

  • 1.Implicit and Explicit Cursors, Cursor Manipulation statements,
  • 2.OPEN FETCH CLOSE EXIT WHEN

Printing Values to Screen

Procedures

  • 1.Creating and Calling Procedures

Functions

  • 1.Creating and Calling Functions

Packages

  • 1.Package Header, Package Body

Design Tips and Techniques

  • 1.Format of standard packages in an application, Spec and Body, NOCOPY hint

Triggers

  • 1.Database triggers, calling procedures from triggers

Dynamic SQL

  • 1.EXECUTE IMMEDIATE, DBMS_SQL package

Oracle Supplied packages

  • 1.DBMS_OUTPUT, UTL_FILE

Collection data types

  • 1.Associative Arrays, Nested tables, VARRAYs


Signup


Name: 

Phone No: 

Email:  

Password: 

Need Resume Preparation:     

 
Select Skills:
select skills and click ok to confirm
 
Select Sub Skills:    
select sub skills and click ok to confirm

Available Time:     (hold Ctrl to select multiple)

Register Now!

Free Demo Class
Register for a FREE DEMO class to attend IT Training courses with our experts online trainers. Register now by filling the below form. Take a DEMO and see how our online training courses work for you.






Which course is right for me?


Speak to an IT online learning consultant today


on 844-OPTGHAR for FREE Tailored Advice.

get free advice
course