• LOGIN
  • No products in the cart.

Oracle : DBA Master

The Miracle that happens behind your Team’s performance
Have you ever imagined about what goes on behind the scenes when you see the statistics on your screen when a Manchester United’s match is live or a military secret mission is being planned ?
It’s all about data organization and relative representation, which empowers easy understanding.
This is how Oracle based Database Management System empowers your plan, your strategies and your representations.
This winter give yourself the chance to plan, prod and produce the new level of integrated database designs

122 STUDENTS ENROLLED

This Oracle DBA Training Course intends to provide you an in-depth understanding of the Oracle Database Server Administration.

Course Format :

A Hybrid ( PhyGital) mode of offering spread as an Online-Offline-Online model.

Online Preplants: 5 days of Pre Learning via our customized E-learning platform with the Understanding of You

Hands-On Workshops: 10 days of Campus-based, physical Interactions

Online SufPlants: 4 days of Post Learning via Industry Connects, Live Projects, Parallel “avenue” Identification on the portal

Followed by the certification examination and assessment clearance.

 

Description

What you will learn in this Oracle DBA Training Course?

You will learn about the Oracle DBA Architecture, various concepts, database structures, memory and process architecture, security, schema objects, data backup and recovery.

  • Learn about the core database concepts
  • Role of a database administrator
  • Understanding of SQL and PL/SQL
  • The physical and logical structure of the database
  • Introduction to tablespace
  • Configuring and managing the Oracle Network
  • Database configuration and programming
  • Installation, harnessing cloud, storage management
  • Database best practices and scripts
  • Prepare for the Oracle DBA Certification

Who should take this Oracle DBA Training Course?

  • Software developers and IT professionals
  • Database analysts and administrators
  • SQL programmers and architects
  • Project Managers
  • Those aspiring for a career in Oracle DBA

Certification

The students will be certified by IandWe, NSDC, NIPP, NASSCOM and StartupIndia

 +

 Authorized standards of repute for the aforesaid training (Oracle), post clearing assessments

Prerequisite

Anybody can take this Training Course. Basic knowledge of database can be helpful.

Why should you take this Oracle DBA Training Course?

  • Oracle is the market leader in the relational database with a 48.35% market share – Gartner
  • An Oracle Database Administrator can earn $94,000 in the United States – indeed.com
  • Being an Oracle Certified Professional (OCP)is crucial to work as an Oracle DBA – Oracle

The Oracle DBA is associated with the relational database management system. The role of the Database Administrator is crucial to managing the huge volumes of data in large enterprises. Hence Oracle DBA professionals are in huge demand. This Training Course will provide you with the necessary skills to take up jobs as Database Administrators in top companies for big salaries.

Venue :

8th January 2018,Kolkata

*Registration amount to be paid online. Remaining amount to be paid on the first day of training. Registration fee will be deducted from the total fee. Registration fee is non-refundable, if any person does not intend to take that course after the payment, that money can be used in any other training.

Contact Details

Contact Us in case of any Queries

Email :[email protected]

Phone :+91-9916638787

Course Curriculum

Getting Started
Let the Game Begin FREE 00:05:00
To build the Nextgen data driven management system you have to understand the concepts of a Database Management System and immediately start creating one.  SO, don't wait and start learning
What is Database 00:08:00
Introduction to Database Management System. Details about data, information, Metadata etc.
Introduction to Oracle 00:07:00
A brief description of Oracle based Database Management Systems and it's different types.
Are you ready 00:15:00
Setup - SQL Development Environment (In Progress...)
Installing Apex 00:13:00
Oracle Database – The Basics
Entity Relation Model 00:07:00
a brief description of entity relationship model and it's types used to build a dbms system.
Relational Database Terminology 00:08:00
Description about terminologies of database table designs.
Database Objects 00:03:00
Database Objects used in Oracle systems.
Introduction to Structured Query Language 00:03:00
A brief description about structured Query Language.
Tables in Oracle 00:03:00
Details of Oracle System Tables
Data Types in Oracle 00:07:00
Description of Data Types available in Oracle.
Table Creation and Insertion of Data
Table Creation 00:09:00
A brief discussion and demonstration of creating a table in oracle sql.
Inserting Data into Table 00:05:00
Here we will be discussing about how datas are inserted into a table of a database management system. We will also do it through Oracle based environment APEX.
Inserting data into required columns 00:03:00
Inserting Datas or a set of data in table is not always very simple , sometimes the location more specific. here we will discuss about pushing datas into a required and specific columns of a data table of a database management system, with it's required query and APEX interface.
Insertion of Null Values 00:03:00
Sometimes it is required to keep some column value blank or null.In this video it is discussed with required query for sql based database systems and in APEX interface.
Multiple Insertion 00:03:00
This video describes about the procedure to insert multiple data sets or rows of data in a sql based database system by a query with an interface visualisation in Oracle's APEX system.
Insertion of Special Values 00:03:00
Sometimes it is required to insert special kind of data into a column for example a date. We will learn how these kind insertion through a sql query.
Conditional Insertion 00:03:00
This unit describes how to insert data in a table depending on some data already in there or some other condition through sql commands in Oracle APEX system.
Study Material for basics of sql 02:00:00
Document of sql queries and Oracle tricks, all basic you have learnt until now in an textual material.
Samples Set 1 ( Tables ) 00:12:00
Some sample statements are provided to learn basics of tables in Oracle pl-sql
Data Retrieval Languages (DQL/ DRL)
Select Statement 00:04:00
It is the most Basic clause to query any data or some specific data from a database system.
Comments within Sql 00:03:00
A comment is text that the PL/SQL compiler ignores. Its primary purpose is to document code, but you can also disable obsolete or unfinished pieces of code by turning them into comments.
Arithmetic Operators 00:05:00
In Pl SQl we can use some predefined operators to let the program perform mathematical operations.
Defining an alias 00:05:00
This unit describes about aliases that can be used in a sql query.
Concatenation Operator 00:06:00
Literals in Oracle 00:06:00
Eliminating Duplicate Rows 00:10:00
From Clause 00:07:00
Where Clause 00:10:00
Pivot Clause 00:06:00
Relational Operators 00:04:00
Other operators ( in, between,is null,is not null) 00:15:00
More operators ( likes) 00:14:00
Logical Operators ( and,or, not) 00:11:00
Oracle Quiz 2 00:05:00
Query Types (In Progress...)
Query Types 00:05:00
Discussion about different ways to put up a query statement in Oracle sql
Sub Query 00:06:00
Single Row Function
Single Row Functions 00:02:00
Character Functions 00:16:00
Number Functions 00:11:00
Date Functions 00:13:00
Conversion Functions 00:13:00
General Functions 00:22:00
Single Row Function: Demonstrated SQL Statements 00:15:00
Multiple Rows Function
Aggregating or Group Functions 00:06:00
AVG(), SUM(), MIN(), MAX() Functions 00:07:00
STDDEV(), VARIANCE(),COUNT() Functions 00:06:00
Group By Clause 00:06:00
Having Clause 00:07:00
GREATEST(), LEAST(), USER, UID Functions 00:06:00
USERENV(), VSIZE(), SOUNDEX() Functions 00:06:00
Multiple Rows Function: Demonstrated SQL Statements 00:15:00
Analytic Functions
CORR(), COVAR_POP(), COVAR_SAMP(), CUME_DIST() 00:14:00
Analytic Functions: Demonstrated SQL Statements 00:15:00
Integrity Constraints
Level of Constraints 00:01:00
NOT NULL Constraint 00:05:00
UNIQUE Constraint 00:10:00
PRIMARY KEY Constraint 00:11:00
FOREIGN KEY or REFERENTIAL INTEGRITY Constraint 00:09:00
CHECK Constraint 00:09:00
DEFAULT Option 00:03:00
Adding Constraint to a Table 00:09:00
DROPPING Constraints 00:06:00
DISABLING Constraint 00:03:00
ENABLE Constraint 00:04:00
VIEWING Constraints 00:04:00
Constraints: Demonstrated SQL Statements 00:15:00
Displaying Data from Multiple Tables i.e. JOINS
JOINS and their Categories 00:02:00
Equi Join or Inner Join 00:10:00
Non-Equi Join 00:06:00
Self Join 00:05:00
Outer Join 00:11:00
Cartesian Product 00:03:00
JOINS: Demonstrated SQL Statements 00:15:00
SET Operators usage
UNION operator 00:05:00
UNION ALL operator 00:05:00
INTERSECT operator 00:05:00
MINUS operator 00:05:00
SET Operators: Demonstrated SQL Statements 00:15:00
Working with Sequence
Sequence: What & Why 00:00:30
Sequence: Syntax 00:03:00
Sequence: Creation 00:05:00
Sequence: Modification 00:03:00
Sequence: Removal & View 00:01:00
Sequence: Demonstrated SQL Statements 00:15:00
Pseudo Columns
Pseudo Columns in Oracle 00:00:30
CURRVAL and NEXTVAL 00:07:00
LEVEL 00:06:00
ROWNUM 00:04:00
ROWID 00:04:00
Pseudo Columns: Demonstrated SQL Statements 00:15:00
Working with Indexes
Index: What & Why 00:02:00
Index: Create, Rename & Drop 00:20:00
Index: When to Create/ Not 00:01:00
Index: Demonstrated SQL Statements 00:10:00
Data Manipulation Language (DML)
UPDATE statement 00:10:00
MERGE statement 00:06:00
DELETE statement 00:04:00
DML: Demonstrated SQL Statements 00:10:00
Transaction Control Language (TCL)
Transaction Control 00:01:00
Commit 00:03:00
Rollback 00:02:00
Savepoint 00:02:00
TCL: Demonstrated SQL Statements 00:06:00
Data Definition Language (DDL)
Alter Table: ADD, MODIFY, RENAME & DROP 00:11:00
Drop Table 00:03:00
Truncate 00:03:00
DDL: Demonstrated SQL Statement 00:10:00
DUMPS : For Certification Exams (1Z0-061/ 071)
Exam 1: Oracle Database 12c: SQL Fundamentals (1Z0-061) 02:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • 3,500.00 2,500.00
  • UNLIMITED ACCESS
  • Wishlist
August 2019
M T W T F S S
« Oct    
 1234
567891011
12131415161718
19202122232425
262728293031  
X