Course

In Kolkata

Rs 10001-20000

Description

  • Type

    Course

  • Level

    Beginner

  • Location

    Kolkata

  • Class hours

    2h

  • Duration

    16 Weeks

  • Start date

    Different dates available

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.

Facilities

Location

Start date

Kolkata (West Bengal)
See map
96L, S.P. Mukherjee Road, 2nd Floor, Hazra More, Kolkata, 700026

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Query Basics
  • Creating Databases
  • Specifying Field Data Types
  • E R diagrams
  • Integrity
  • Normalization

Teachers and trainers (1)

Versicle Institute  TechnoloGY

Versicle Institute TechnoloGY

FACULTY

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
Introduction
  • 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

Oracle

Rs 10001-20000