Find the best tutors and institutes for Oracle Database

Find Oracle Database Tutors & Institutes

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Search for topics

Feed

Ask a Question

Post a Lesson

All

All

Lessons

Discussion

Lesson Posted on 29/09/2017 IT Courses/Oracle Training/Oracle Database/Oracle 10g DBA

Basic understanding of DBMS and RDBMS and Database and its Architecture

Ghanshyam M

I am Consultant and Trainer, with over 7 years of experience as Oracle Technical Consultant and trainer...

What is Data:- The data is stored representation of objects and events which has the meaning .It can be structured or unstructured. What is Information:-It is the data in the processed form which will increase the knowledge of end user. What is Metadata:-It is the data which describes the properties... read more

What is Data:-

The data is stored representation of objects and events which has the meaning .It can be structured or unstructured.

What is Information:-It is the data in the processed form which will increase the knowledge of end user.

What is Metadata:-It is the data which describes the properties or characteristics of the user data and its context.

What is database:-Database is the collection of data in one or more data file.

DBMS:-Database management system is the software which is used to create or manage the database and provides the controlled access to the database.

Database from Oracle point of View:-Database is the collection of data in one or more data file.

It is the collection of Logical structure and Physical Structure which are configured to maintain the integrity of the system.

Logical structured:-In the database State, The Logical structured are the representation of the actual metadata which are in the form of Table space, data dictionary.

Table space:- It is invisible in nature and bridge between the oracle database and Data File structure.

Data dictionary: - It is also a logical structure which basically captures the metadata of the Objects.

Physical Structure: - In the database State, The Physical structure are in the form of Table,synonym,view etc.

read less
Comments
Dislike Bookmark

Asked on 05/09/2017 IT Courses/Oracle Training/Oracle Database/Oracle 10g DBA

Im a DBA with just the basic skills hence I got no confidence to face an interview. As a result Im stuck... read more
Im a DBA with just the basic skills hence I got no confidence to face an interview. As a result Im stuck in the same company for 4.5 yrs with no progress Financially or Technology skills. Please help me in deciding what to do next etc. read less

Answer

Asked on 19/08/2017 IT Courses/Oracle Training/Oracle Database/Oracle 11g DBA

I am Oracle database 11g, 12c and RAC trainer looking for an opportunity as trainer.

Answer

Looking for Oracle Database

Find best Oracle Database in your locality on UrbanPro.

FIND NOW

Answered on 15/09/2017 IT Courses/Oracle Training/Oracle Forms IT Courses/Oracle Training/Oracle Database/Oracle 11g DBA

I am looking to learn oracle forms and reports not in terms of theoretical training, As I want to work... read more
I am looking to learn oracle forms and reports not in terms of theoretical training, As I want to work in a project base training. Those who have completed a Oracle project on your own can please guide me how to work in a real time project? read less

Prakash Reddy

Yes, Oracle Forms is front-end tool for rapid development and it uses PL/SQL code in forms . You should know pl/sql before jumping to Forms and even it supports Java beans, jars etc.. It's tight integration with Oracle Database. Now Forms is part of Oracle Fusion Middle, latest version is 12c. By default... read more
Yes, Oracle Forms is front-end tool for rapid development and it uses PL/SQL code in forms . You should know pl/sql before jumping to Forms and even it supports Java beans, jars etc.. It's tight integration with Oracle Database. Now Forms is part of Oracle Fusion Middle, latest version is 12c. By default for basic DML operations without any code also it will take care by itself to insert, update, delete etc,,, it can be called as intelligent Tool. read less
Answers 1 Comments
Dislike Bookmark

Lesson Posted on 14/06/2017 IT Courses/Oracle Training/Oracle Database IT Courses/Oracle Training/Oracle Database/Oracle 11g DBA IT Courses/IT Certifications/Oracle Certification/Oracle DBA OCA

How To Prepare For OCA Exam?

Anupam Thakur

I am a Technical Architect having 14 years of experience in Oracle database and currently working in...

Oracle Certified Associate certification programs are very costly to take the exam. They really deserve it because you get a high value of this certification in the job market. This Article is meant for ideas or steps you can take while preparing for the exam.Most of us keep on preparing ourselves to... read more

Oracle Certified Associate certification programs are very costly to take the exam. They really deserve it because you get a high value of this certification in the job market. This Article is meant for ideas or steps you can take while preparing for the exam.

Most of us keep on preparing ourselves to take the test month after month and even a year passes but really do not get the confidence to sit for the exam. I am also among these types of guys. So whatever I am going to say here is fully from my personal experiences. After I went on preparing for OCA day after day, month after month I realise that I am not able to get the good percentage of marks in the self-assessments mock tests. The reason is that I followed many OCA books and exhaustively studied each of the books. Following so many books at the same time actually confused my conceptions in Oracle! Now preparing for the OCA exam in between my daily works and job became difficult for me, so I just consulted one of my seniors and we came up with great ideas.

We decided to follow the following rules to prepare for the OCA Exam so that I go to the track and take the test very soon and accurately:

  • Do not follow many books at the same time. Just read only one book prescribed for the OCA Exam.
  • Keep aside at least 2 hours for the preparation, from your busy schedule.
  • Concentrate on each Chapter very clearly and make notes for the important tips mentioned in each chapter.
  • Take the self-assessment test provided at the end of each chapter very honestly.
  • Proceed to the next chapter only if you feel that you are comfortable with the previous chapter.
  • Make notes with step by step instructions for the exercises in each chapter, separately. So you now have two types of notes, one for the Important Tips and the other for Exercises.
  • Now as you proceed chapter by chapter, do always remember to overview the exercises at a later stage. This will help you memorise the commands used in your exercises.

If you sincerely follow the steps above, I hope you can find yourself in a good position to take the OCA Exam.

read less
Comments
Dislike Bookmark

Answered on 24/04/2017 IT Courses/Oracle Training/Oracle Database

Indranil Basak

Trainer

Yeah you can. But Oracle DBA certification 5 years back will not help you. DBA is completely dependent on hand on exercise. You can try Oracle plsql or Oracle Business Intelligence(OBIEE) or you can try to Big data Analytics. Atleast you can showcase Oracle plsql knowledge and OBIEE knowledge or any... read more
Yeah you can. But Oracle DBA certification 5 years back will not help you. DBA is completely dependent on hand on exercise. You can try Oracle plsql or Oracle Business Intelligence(OBIEE) or you can try to Big data Analytics. Atleast you can showcase Oracle plsql knowledge and OBIEE knowledge or any other ETL tools which help you switch your jobs. read less
Answers 10 Comments
Dislike Bookmark

Looking for Oracle Database

Find best Oracle Database in your locality on UrbanPro.

FIND NOW

Lesson Posted on 13/01/2017 IT Courses/Oracle Training/Oracle Database IT Courses/Tableau IT Courses/Data Warehouse +1 IT Courses/BI Reporting less

Data Warehousing - End to End

EduGuys - Formerly Stay Ahead

Quality is what we believe in. We @EduGuys (Formerly Stay Ahead) working towards it. Real-time business...

Data warehouse - An Idea Subject Oriented - A data warehouse is subject oriented because it provides information around a subject rather than the organization's ongoing operations. These subjects can be product, customers, suppliers, sales, revenue, etc. A data warehouse does not focus on the ongoing... read more

Data warehouse - An Idea

Subject Oriented - A data warehouse is subject oriented because it provides information around a subject rather than the organization's ongoing operations.

These subjects can be product, customers, suppliers, sales, revenue, etc.

A data warehouse does not focus on the ongoing operations, rather it focuses on modelling and analysis of data for decision making.

Integrated - A data warehouse is constructed by integrating data from heterogeneous sources such as relational databases, flat files, etc.

This integration enhances the effective analysis of data.

Time Variant - The data collected in a data warehouse is identified with a particular time period.

The data in a data warehouse provides information from the historical point of view.

Non-volatile - Non-volatile means the previous data is not erased when new data is added to it.

A data warehouse is kept separate from the operational database and therefore frequent changes in operational database is not reflected in the data warehouse.

Function of data warehouse tools and utilities

Data Extraction - Involves gathering data from multiple heterogeneous sources.

Data Cleaning - Involves finding and correcting the errors in data.

Data Transformation - Involves converting the data from legacy format to warehouse format.

Data Loading - Involves sorting, summarizing, consolidating, checking integrity, and building indices and partitions.

Refreshing - Involves updating from data sources to warehouse.

 

read less
Comments
Dislike Bookmark

Lesson Posted on 09/01/2017 IT Courses/Oracle Training/Oracle Database

To find duplicate records in a table (SQL Server)

Arti

Suppose the given table has 2 columns (id, phone_number): SELECT id, COUNT(id) FROM table_nameGROUP BY id HAVING COUNT(id)>1
Comments
Dislike Bookmark

Lesson Posted on 19/12/2016 IT Courses/Oracle Training/Oracle Database

Must know fact about DDL

Gavisiddappa Yatnalli

Have 5 years of experience as plsql developer on various domains including but not restricted to Banking,...

Hello everyone, This is again for beginners, as a Trainer, it's my duty to educate the beginners/learners. Let's take an example below, --Assume we already have 'EMP' table with the columns- id,name,Sal Insert into Emp (id,name,sal) Values(1,'xyz',2200); Create table test (Id number); --Now check... read more

Hello everyone,

This is again for beginners, as a Trainer, it's my duty to educate the beginners/learners. Let's take an example below,

--Assume we already have 'EMP' table with the columns-  id,name,Sal

Insert into Emp (id,name,sal) Values(1,'xyz',2200);

Create table test (Id number);

--Now check the contents of EMP in another session and you would that record is inserted even without committing. That is because there is a 'Create' statement after 'Insert', which is DDL and hence it auto commits the transaction.

-- Now try this in one of the sessions

Insert into Emp (id,name,sal) Values(2,'abc',1100); -- Inserts a record

Create table test (Id number); --This statement fails as 'test' already exists

--Don't commit anything here and check the contents of EMP in another session or rollback in the same session and check EMP table

 

So, how did that happen? If DDL got failed then who committed the transaction? It's a homework. Google it and find out.

read less
Comments
Dislike Bookmark

Looking for Oracle Database

Find best Oracle Database in your locality on UrbanPro.

FIND NOW

Lesson Posted on 19/12/2016 IT Courses/Oracle Training/Oracle Database

Interesting thing about Sequences in Oracle

Gavisiddappa Yatnalli

Have 5 years of experience as plsql developer on various domains including but not restricted to Banking,...

Let's not get into the very basic things like what is sequence?, What is Cache/Nocache, Cycle/NoCycle etc. My topic is something very interesting which many of the beginners might not have noticed. My question to you before you read further, let's say we have sequence in one session and its Currval... read more

Let's not get into the very basic things like what is sequence?, What is Cache/Nocache, Cycle/NoCycle etc.

My topic is something very interesting which many of the beginners might not have noticed. My question to you before you read further, let's say we have sequence in one session and its Currval is 10 and you query for the Currval of the same sequence in another session. will you get 10 or something else? Pls note that Sequences retain their values across sessions. i.e they are global in nature, at least till 11g and by default global even in 12c. Before you read further answer this question to yourself and see the truth below.

Let's create a sequence inside the schema A,

CREATE SEQUENCE Test_Seq
MINVALUE 1
START WITH 1
INCREMENT BY 1;

Grant select on Test_Seq to B; ---Another Schema

--Now run this under schema A

Select Test_Seq.nextval from dual;  --- You will get 1

Select Test_Seq.Currval from dual; --- So it's 1

-- Now run this under schema B

Select A.Test_Seq.nextval from dual;  --- You will get 2

Select A.Test_Seq.Currval from dual;  --- You will get 2

--Now under Schema A

Select Test_Seq.Currval from dual;  --- What did u answer? It's actually 1, not 2

Select Test_Seq.nextval from dual;  --- You will get 3 ofcourse as expected.

--Now under Schema B

Select A.Test_Seq.Currval from dual;  --- You will get 2, not 3.

Select A.Test_Seq.Nextval from dual;  ---you will ofcourse get 4 as expected

So guys, be aware of this fact while using Currval pseudo column. So, is there a way to find out the Currval without actually incrementing the sequence by calling Nextval?

Simple solution is to check this view- Select * from user_sequences for Schema A

and Select * from All_sequences for Schema B in this example. Last_number column gives you the Sequence value. This works fine with NoCACHE option. 

Homework: Recreate the above example of Sequence with CACHE option which is default also and then run the same set of above Currval and NextVal queries and check the above mentioned views.

Hope, you enjoyed it. Take care boys. Bye

read less
Comments
Dislike Bookmark

About UrbanPro

UrbanPro.com helps you to connect with the best Oracle Database in India. Post Your Requirement today and get connected.

Overview

Questions 19

Lessons 17

Total Shares  

Follow 15,344 Followers

Top Contributors

Connect with Expert Tutors & Institutes for Oracle Database

x

Ask a Question

Please enter your Question

Please select a Tag

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more