Oracle – SQL
Oracle is a Relational Database Management System(RDBMS). Oracle is the latest technology, today's system Designers and Developers can build 21st century enabled applications.
Oracle has also demonstrated a continuous ability to build products that help us exceed the demands of the information enabling age we live in.
SALIENT FEATURES
Oracle has sophisticated security mechanisms control access to sensitive data by an assortment of privileges.
Oracle provides sophisticated backup & recovery routines. Backup creates a second copy of Oracle Data, recovery restores a copy of data from back up.
Oracle provides flexible space management. It has special abilities that are capable of handling very large databases.
Oracle provides open connectivity to & from other vendor's software.
Oracle server supports a wide range of Development tools, end user query tools, off the shelf applications & office wide information tools.
APPLICATIONS
· Education Industry
· Software Development Industry
· Data warehouse and maintenance
· Domestic Air Services
· Production Industry
· Banking Industry
TOPICS COVERED
· Introduction to oracle products.
· SQL*plus features and commands.
· Data manipulation commands, data control commands.
· Altering tables, data definition commands, joins, types of functions.
· Process Transaction commands, SQL*plus set theory.
· Sub-queries and Co-related queries.
· Security in Oracle
· Locking
· Oracle Objects - Views, clusters, indexes, synonyms, snapshots.
· Formatting output of queries, Report creation.
· Implementing Object Oriented features in Oracle.
· Introduction to PL/SQL.
· Packages
· Creating Cursors, exceptions, procedures, functions and triggers.
· Understanding the Oracle Architecture.
· Features of Latest Oracle Version.
· Data Dictionary
· DBA - An Overview
