Oracle 10g/11g Online Training

We introduce you to oracle in our module I, module II will assist you with oracle database management products, etc. Each and every session is well planned beforehand and is executed in the same manner.

Oracle 10g/11g Online Training

Course Duration

6 hours of live training by qualified professionals with more than 5 years of experience

Training Materials

  1. High quality recorded video lectures of every session
  2. Access to remote server to practice assignments
  3. Soft copy of the course material
  4. 24*7 guidance by faculty

What’s Needed To Join This Course?

Students must have little knowledge about SQL and must be familiar with basics of Oracle.

Who Are Ideal Candidates?

Freshers or professionals with little knowledge on database and willing to see themselves in higher positions by enhancing their skills.

Course Info

We introduce you to oracle in our module I, module II will assist you with oracle database management products, etc. Each and every session is well planned beforehand and is executed in the same manner.

Highlights Of The Course

  1. Perfection in oracle based courses
  2. Hands experience with practical examples and real time projects
  3. Overview of different application of Oracle 10g and 11g
  4. Complete set of course material and life time access to course recordings

Why BLUELINESOFT?

Our institute is one of the leading platforms in producing experts in oracle database domains. We provide free demo classes so that you can understand the format of teaching and join the institute based on your convenience. Our qualified and experienced faculty will teach all aspects of oracle to give you complete understanding of it and to prepare you for the job. Some of the notable features of our institute include:

  1. Live training by experienced professionals in the field
  2. Expert lectures by professionals serving the IT industries in Oracle domain
  3. Affordable fee structure
  4. Career guidance
  5. Quizzes to help students enhance their knowledge
  6. Certificate on course completion

Oracle 10g/11g Course Details

The Oracle database environment

Reviewing basic architecture concepts Oracle 10g Architecture Main features of 9i and 10g

Basic SQL*PLUS commands

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

Basic SELECT Statement

Writing the statement in sql plus, Running the SELECT statement

Ordering the output

Single Column, Descending order, multiple column sorts

Conditional retrieval of data

Working with complex conditions, AND OR NOT LIKE BETWEEN

Working with variables

Creating and using variables, Command substitution

Pseudo columns and functions

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

Using non-character function

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

Using the SET operators

Union, Intersect, minus

Aggregating data using group functions

GROUP BY, HAVING

Creating Sub queries

Single Row sub queries, Multiple row Sub queries

Enhancing groups function

ROLLUP, CUBE

Transaction Control Languag

Rollback, Commit, save point

Processing hierarchies

creating the Tree structure, LEVEL, CONNECT BY

Data Manipulation Language

INSERT, UPDATE, DELETE

Data Definition Language

CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE

Using Declarative Constraints

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

Object Privileges, Granting access to objects

Improving query performance

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

The Relational Database Model, The system Development Lifecycle, Overview of normalization

PL/SQL Blocks

Structure, Writing Anonymous Blocks

Variables

Oracle Data types, TYPE and ROWTYPE declarations, Value assignments

Control structures

IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement, LOOP END , LOOP statement, WHILE condition, FOR condition

Cursors

Implicit and Explicit Cursors, Cursor Manipulation statements, OPEN FETCH CLOSE EXIT WHEN

Printing Values to ScreenProcedures

Creating and Calling Procedures

Functions

Creating and Calling Functions

Package

Package Header, Package Body

Design Tips and Techniques

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

Triggers

Database triggers, calling procedures from triggers

Dynamic SQL

EXECUTE IMMEDIATE, DBMS_SQL package

Oracle Supplied packages

DBMS_OUTPUT, UTL_FILE

Collection data types

Associative Arrays, Nested tables, VARRAYs

Oracleonline_training

“Your courses are outstanding. I cannot even imagine anyone doing better than this.” – Peter B
“The demonstrations were most valuable since there isn’t an option to use free software where I work.” – Dana Bolender
Most of our courses are designed to get you a job first and are also geared for you to get certified. After the course completion, your trainer will provide all details about the certification you can appear for the qualifications of each. We also provide you with Certification faqs and dumps from past certification exams. Our trainers help each and every student in getting them certified.
Since we are a Consulting company, we make money when you do get placed by us so we prefer that you get placed as early as possible. But normally we start our marketing and placement process during your “After the training” Phase.
Yes, you will be working on the case-studies/project which helps you to implement the gained skills and knowledge practically towards the end of the training workshop.

Most of our courses are designed to get you a job first and are also geared for you to get certified. After the course completion, your trainer will provide all details about the certification you can appear for the qualifications of each. We also provide you with Certification faqs and dumps from past certification exams. Our trainers help each and every student in getting them certified

We do our best to our trainees who ever reaching us for placement assistance. Trainees they themselves get placed and market themselves during the training itself. Most of the trainees will not give chance to us to market them. Because they don’t want to sign a contract and work on ratio basis. But 100% we provide placement assistance to the trainees who reach us.

Course Details
Start Date 18-Dec-2017
Duration 40 Hrs (5 Weeks)
Time (CDT) 07:30 PM - 09:30 PM
Type Online
Mode of Training INSTRUCTOR-LED LIVE
Enroll Enroll

Quick Enquiry

Copyrights @2018-All rights reserved