Versicle Institute of Technology
In Kolkata

Compare this course with other similar courses
See all

Important information

  • Course
  • Beginner
  • Kolkata
  • 2 hours of class
  • Duration:
    16 Weeks
  • When:

Oracle Database software is a relational database management system that efficiently tackles the challenges of constant change inherent in complex, often heterogeneous environments and also the additional challenge to deliver tangible value from their database investments. It delivers the high level of reliability, performance and scalability. Its tools reduce the manual, time-intensive tasks associated with development, administration and performance management.

Oracle's Database Management capabilities make DBA lives easier as it endows with a full-lifecycle solution covering change and configuration management, patching, provisioning, testing, masking/subsetting and automatic tuning. It provides the most extensive self-management capabilities in the industry. Why would you go for oracle database management?

For answer please go through the following paragraphs:-
Oracle delivers a higher quality of service by clustering and consolidating enterprise application databases onto fast, reliable and scalable private clouds. It accelerates the performance of system by compressing data onto low-cost storage partitions. With the help of oracle database management DBA productivity gets doubled and also the risk of change also gets reduced. It is used by the industries that range from zero-overhead instrumentation to integrate self-healing and business-driven management.

It maximizes the availability of data by eliminating idle data center redundancy. It provides securely protecting information and enables fast compliance. Actually it is totally revolutionized the field of enterprise database management systems with the release of Oracle Database 10g as introduced the industry's first self-management capabilities built right into the database kernel.

Important information

Where and when

Starts Location Timetable
96L, S.P. Mukherjee Road, 2nd Floor, Hazra More, Kolkata, 700026, West Bengal, India
See map

What you'll learn on the course

Query Basics
Creating Databases
Specifying Field Data Types
E R diagrams

Teachers and trainers (1)

Versicle Institute TechnoloGY
Versicle Institute TechnoloGY

Course programme

Database Management System (DBMS)
  1. Introduction
  2. Identifying Keys in Tables
  3. E R diagrams
  4. Data types
  5. Events
  6. Data dictionary
  7. Integrity
  8. Converting E R diagrams to normalized tables
  9. Normalization
Structure Query Language (SQL)
  1. Query Basics
  2. Computation with queries
  3. Sub totals and Group by command
  4. Queries with multiples
  5. Sub queries
  6. Join
  7. DDL and DML
  8. Testing queries
  • What is Database ?
  • Understanding an RDBMS
  • Understanding Tables, Records, and Fields
  • SQL Language
Working with Oracle
  • Creating Databases
  • Types of Databases
  • Specifying Field Data Types
  • Altering Table and Field Names
  • Altering Field Properties
  • Altering Table Types
  • Backing Up Databases and Tables
  • Restoring Databases and Tables from Backup
  • Dropping Databases and Tables
  • SQL Queries and sub queries
  • Using Built-In Functions
  • Joining Tables
  • Using Table and Column Aliases
PL/SQL Tables
  • Basics of PL/SQL
  • PL/SQL architecture
  • PL/SQL Basics, Variables, Constants, data types & error handling
  • Dynamic SQL in PL/SQL
  • PL/SQL wrapper utility
  • Control structures
  • Declaring Variables and Constants
  • Executing a PL/SQL Block
  • Error checking – exception handling
  • Defining exceptions
  • Cursors in PL/SQL
  • Triggers in PL/SQL
  • Stored procedures, functions and packages
  • Bulk queries
  • Bulk DML (for all statement)
  • Using cursor attributes
  • Analyzing impact of bulk operations

Compare this course with other similar courses
See all