• No products in the cart.

0

Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications.

4,001.00
 

Syllabus

Oracle Database 11g Architecture Options:

Oracle db 11g architecture, databases and instances, programmatic oracle structures, storing and guarding the data, installing the oracle database and creating a database.

SQL Basics:

Structured query language, ddl, dml, dcl and tcl commands, select statements, arithmetic operators, alias, writing sql statements and literal characters.

Accessing Remote Data:

Sql development environment, database connection and sql worksheet.

Using Oracle Text for Text Searches:

Sql wildcards, comparison and logical conditions, sorting and variables.

SQL Functions:

sql functions.

Subquery and Joins:

Groups of data, joins, non equijoins, sql clauses, subqueries and its types.

Changing Data:

Set operators, script creation, updating rows, delete statement, database transcations, read consistency, database objects and data types.

Creating and Managing Tables, Views, Indexes and Sequences:

Constraints, views, sequences, indexes, data dictionary structure, constraint and view information.

Procedures, Functions and Packages:

pl/sql introduction, procedures, parameters, functions, packages and records, persistent state of packages, oracle supplied packages, job creation, dynamic sql, sql execution flow, pl/sql block and dbms_sql package.

Using Native Dynamic SQL and DBMS_SQL:

Using Native Dynamic SQL and DBMS_SQL.

Triggers:

lob datatypes, bfiles, triggers, database triggers, native compilation and pl/sql warnings.

Implementing Object Types, Object Views, and Methods:

oracle sequences, tablespace, security, replication and backup.

JDBC Programming:

jdbc programming.

Course Currilcum

                • Diploma in Oracle (Online Certification Courses) 02:00:00
              © All rights reserved
              Open chat