Oracle

Our Oracle tutorial includes all topics of Oracle database such as insert record, update record, delete record, select record, create table, drop table etc.

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management.

Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation.

Syllabus:

• SQL:
• Retrieving data using the SQL select statement - Restricting and sorting data - Using single row function to customize output. - Reporting aggregated data using the grout function. - Displaying data from multiple tables –I - Displaying data from multiple tables-II - Using sub queries to solve problems - Using set operators - Manipulating data - Using DDL statements to create and manage tables - Creating other schema objects - Managing objects with data dictionary - Controlling User access - Managing schema objects - Manipulating large data sets - Generating report by grouping related data - Managing data in different time zones - Retrieving data using sub queries - Hierarchical retrieval - Regular expression support.
• PL-SQL:
• Introduction - Declaring Variables - Writing Executable Statements - Interacting with Oracle Server - Writing Control Structures - Working with Composite Data Types - Writing Explicit Cursors - Writing Implicit Cursors - Handling Exceptions - Creating Procedures - Creating Functions - Managing Subprograms - Creating Packages - More Package concepts - Oracle supplied Packages - Manipulating Large Objects - Creating Database Triggers - More Trigger concepts - Managing Dependents.
• DBA:
• Introduction - Installing the Oracle Database Structure - Creating an Oracle Instance - Managing the Oracle Instance - Managing Database Storage Structure - Oracle managed file(OMF) - Creating a table space - Administering security - Managing Schema Objects - Types of Indexes - Managing Data and Concurrency - Locking Mechanism - Managing Undo Data - Implementing Oracle Database Security - Configuring the Oracle Network environment - Performance Management - Backup and Recovery Concept.