Enquiry

Oracle Database 12c SQL 1Z0-071


Share this page:

Overview

Become an Oracle Database SQL Certified Associate and demonstrate understanding of fundamental SQL concepts needed to undertake any database project. Passing the exam illustrates depth of knowledge of SQL and its use when working with the Oracle Database server. Gain a working knowledge of queries , insert, update and delete SQL statements as well as some Data Definition language and Data Control Language, the optimizer, tales and indexes, data modeling and normalization. By passing this exam, a certified individual proves fluency in and a solid understanding of SQL language . data modeling and using SQL to create amd manipulate tables in an Oracle Database.

Qualified candidates have knowledge of general computing concepts, knowledge of command line interfaces and experience working in command line.


Exam Details

Duration:100 minutes
Number of Questions:

73

Passing Score:63%
View passing score policy
Validated Against:

This exam was validated against 11g Release 2 version 11.2.0.1.0 and up to 12c Release 1 version 12.1.0.1.0.

Format:Multiple Choice
Exam Price:Rs 9701 More on exam pricing

Course Content / Exam(s)


Retrieving Data Using the SQL SELECT Statement

  • List the capabilities of SQL SELECT statements.
  • Execute a basic SELECT statement.

Restricting and Sorting Data

  • Limit the rows that are retrieved by a query
  • Sort the rows that are retrieved by a query
  • Use ampersand substitution to restrict and sort output at runtime

Using Single-Row Functions to Customize Output

  • Describe various types of functions available in SQL
  • Use character, number, and date functions in SELECT statements

Using Conversion Functions and Conditional Expressions

  • Describe various types of conversion functions that are available in SQLL.
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions.
  • Apply conditional expressions in a SELECT statement.

Reporting Aggregated Data Using the Group Functions

  • Identify the available group functions.
  • Describe the use of group functions.
  • Group data by using the GROUP BY clause.
  • Include or exclude grouped rows by using the HAVING clause.

Displaying Data from Multiple Tables

  • Write SELECT statements to access data from more than one table using equijoins and nonequijoins.
  • Join a table to itself by using a self-join.
  • Generate a Cartesian product of all rows from two or more tables.

Displaying Data from Multiple Tables

  • Write SELECT statements to access data from more than one table using equijoins and nonequijoins.
  • Join a table to itself by using a self-join.
  • Generate a Cartesian product of all rows from two or more tables.

Using Subqueries to Solve Queries

  • Define subqueries
  • Describe the types of problems that the subqueries can solve .
  • List the types of subqueries .
  • Write single-row and multiple-row subqueries.

Using the Set Operators

  • Describe set operators
  • Use a set operator to combine multiple queries into a single query .
  • Control the order of rows returned.

Manipulating Data

  • Describe each data manipulation language (DML) statement.
  • Insert rows into a table .
  • Update rows in a table .
  • Delete rows from a table .
  • Control transactions.

Using DDL Statements to Create and Manage Tables

  • Categorize the main database objects.
  • Review the table structure.
  • List the data types that are available for columns.
  • Create a simple table.
  • Explain how constraints are created at the time of table creation.
  • Describe how schema objects work.

Creating Other Schema Objects

  • Create simple and complex views.
  • Retrieve data from views.
  • Create, maintain, and use sequences.
  • Create and maintain indexes.
  • Create private and public synonyms.

Controlling User Access

  • Differentiate system privileges from object privileges.
  • Grant privileges on tables and on a user.
  • Distinguish between privileges and roles.

Managing Schema Objects

  • Describe how schema objects work.
  • Create simple and complex views with visible/invisible columns.
  • Create, maintain, and use sequences.
  • Create and maintain indexes including invisible indexes and multiple indexes on the same columns.
  • Perform flashback operations.

Managing Objects with Data Dictionary Views

  • Query various data dictionary views.

Manipulating Large Data Sets

  • Describe the features of multitable INSERTs.
  • Merge row in a table.

Retrieving Data By Using Subqueries

  • Multiple-Column Subqueries.
  • Column Comparisons.
  • Pairwise Comparison Subquery.
  • Nonpairwise Comparison Subquery.
  • Scalar Subquery Expressions.
  • Correlated Subqueries.
  • Using the EXISTS & NOT EXISTS Operator.
  • Correlated Update.
  • Correlated Delete.
  • WITH Clause.
  • Recursive WITH Clause.


Testimonials

Ruchi Patil

Ruchi Patil

Unisoft happen to be my first professional training place. I did BCA earlier and was looking for a professional training . I decided that MCA would 3 more years of academic labyrinthine and a professional course may take me to the league. OCP -DBA did the same for me. I am JDBA at Zeon and very soon i am joining AMDOCS pune. It was a bliss that i took bold decision of NOT doing MCA and i am sincerely thankful to team Unisoft ...
Lalit Koche

Lalit Koche

I am learning Oracle database track since last one month. In Nagpur if you want to learn database in broader way so join unisoft technologies Nagpur. The faculty of Oracle Mr. Saurabh Joshi is very excellent, practical are made to do very strictly and regularly by him . The administrative staff is also very co-operative.
Ameya Linge

Ameya Linge

Learning Oracle Database Administration here. Experiencing a nice way of teaching from Saurabh Joshi(Oracle guru) Sir. A good feature is that it is more practical oriented rather than theorotical. Definitely recommended for learning Oracle based subjects.
Hrudayraj Khanke

Hrudayraj Khanke

I studied ORACLE Database Administration, n completed my OCP certification from Unisoft technologies. Best Experienced Faculty,Best Infrastructure. Best practicing environment. every thing is best ,best n best .Must join Unisoft Technologies for a bright future..
Sonal Jain

Sonal Jain

In Unisoft technologies I have completed SQl training and felt that the faculty Mr.Saurabh Joshi is best for it according to me, apart from faculty the other staff members are also very generous.I am also learning Advance JAVA taught by Ms.Pratibha Bansod is runnig smoothly.
Rajesh Dahat

Rajesh Dahat

Hi...I am Rajesh Student, Unisoft. It is the place where student can bank upon... it is everything for everyone (IT) who would like to grab the best of knowledge and Experience Recently it has got the Award for Education Excellence -2012. It...Tells the Story of it. Its not an easy thing to happened.That has been its quality over the years. Its being pleasure to be the part of Unisoft Technologies. Thanks Rajesh
Gaurav Mangalkar

Gaurav Mangalkar

Faculties for ORACLE(DBA) is VERY GOOD... with there teaching.. and experience... i m not satisfied with the systems.... overall all my experience till now is GOOD...
Monica Behl

Monica Behl

Guys the best place to get really good teaching and training!!! i m student here speaking by experience Nagpur good institute for certification.....:)
Khyati Makode

Khyati Makode

Why to go anywhere out for certified course when its in our city Nagpur itself. The UT is the best institute for all mentioned above certified courses. Faculties are well qualified. People who are seeking for certified courses I would suggest UT, coz it is the best institute.
Mangesh Hedaoo

Mangesh Hedaoo

About UNISOFT I can say one thing and it is based on my experience that, for the first time I got the faculty about whom I can say that he has the knowledge of Oracle and most importantly he got teaching techniques. For those guys who do not have knowledge of Oracle and eagerly want to learn Oracle then I strongly recommends UNISOFT
Suraj Ingole

Suraj Ingole

Hi I am Oracle certified OCA,OCP and OCE. And i achieved this because of only unisoft technologies Nagpur. Management is great. Management is great this i know. coz when I was doing the certification course there. I insisted them for a particular trainer..n they provided me! After few days when i found my queries not getting solved. so i again insisted them to change the trainer. n they did. I must say I found knowledgeable, friendly great trainer after that! Thanks to Unisoft Management. n thanks to Saurabh Sir (Saurabh Joshi)...for those awesome sessions..I still remember!
Sanket Walanj

Sanket Walanj

Best Oracle Certification and Training Center / Institute in Nagpur. I have completed Oracle Certified Expert (OCE) and Oracle Certified Associate (OCA) with good percentage.
Rajat Lakhe

Rajat Lakhe

I have join Unisoft Technologies Nagpur training center recently. I have join the institute for Oracle Training in OCP DBA. My 1st module is running smoothly. And i am very much satisfied with my faculty and the support staff at Unisoft Nagpur. Unisoft is really provides quality Oracle Training in Nagpur.
anurag sonule

anurag sonule

Unisoft technology is a great coaching institute for studying any courses regarding to IT. Facult staff is also very good , especially faculty like pooja mam very good and also teaching staff is very good,especially suarabh joshi sir ,its helping for any kind of query.
Akshay Godhane

Akshay Godhane

Fantastic training institute..The best you can get in Nagpur....The best working faculty...i will recommend this institute to all under graduates or working faculty willing to learn and explore
Abhinav Chandrakar

Abhinav Chandrakar

I joined UNISOFT TECHONOLOGIES just for study but now i m able to say that i "LEARNED" OCA Oracle Database Knowledge from here , Its a great pleasure to say that my faculty Mr. Saurabh Joshi sir taught me so well that i can understood each n every things which comes under OCA Oracle Database and Unisoft Administration staff is also good & helps me in every phase.A Quality teaching that i am looking forward to study further in "UNISOFT TECHONOLOGIES" to achieve my goals. Thank you UNISOfT TECHNOLOGIES & Mr. SAURABH JOSHI Sir
Parag Meshram

Parag Meshram

faucalty of unisoft technologies are very supportive and very experience and teaching was excellent.
Ankit Bhimte

Ankit Bhimte

unisoft technologies provided a good environment for skill development. the faculty was good. admin co-ordination was also good. classrooms are a bit compact and usually get heated up. overall the experience was good and got 100% satisfaction.
DEVI SINGH

DEVI SINGH

I have pursued linux and SQL training from unisoft technologies. there are very highly quailified diverse products and they focus on each and every student in the class and after class and there admin also very co-operate and they provide guide lines related to the career options. thanks to unisoft technologies, MR.SAURABH JOSHI AND MR.ANUSHRESH BHAWNE
Kaustubh Deshmukh

Kaustubh Deshmukh

Faculty : saurabh joshi is excellent,savita mam who is in admin staff given me good guidance about course and certification.unisoft is good experience to learn. I tell my friend to do their IT related tranning from unisoft technologies.It is a best IT Tranning in Nagpur
Aashish

Aashish

Being in this institute,I feel gratitude for having an opportunity to be a part of Unisoft Family.Excellence and Opportunities exists in Unisoft.Practical skills have being given priorities.Whereas those high intellect faculties are highly efficient and technically skilled. The labs are well equipped with the latest software packages and full fledged network having high spieed.Quality Education is promoted thoroughly>
Satvik Shukla

Satvik Shukla

faculty:good teachers with excellent teaching experience. admin Ruhika:well managed,and very punctual
chetan

chetan

Best teache Saurabh joshi sir & cooperative admin staff Asha mam........
AKSHAY D. DANGE

AKSHAY D. DANGE

Excellent training by saurabh sir.faculties and other staff are very helpful. Thanks to UNISOFT TECHNOLOGY..... i will suggest my friends for DBA courses and other courses that are offered by unisoft technology. You can also do certication courses from here. My adviser vallery mam ,she provide a overall detail about DBA course and also about certification.
Akshay

Akshay

good quality of teaching and helpful admin staff . saurabh sir having great knowledge of SQL . This is the best IT training center in Nagpur :)
Rohit kumar

Rohit kumar

I attended SQL fundamental I 11g class in Unisoft Technologies This institute is running on behalf of oracle university Unisoft Technologies is very goad institute in Nagpur for learning of Database and developers . The faculty name is Saurabh sir of Unisoft Technologies is very goad in database. I am satisfied form SQL class in unisoft technologies . I am also operating C,C++ and JAVA in Unisoft Technologies .
Ayushi Dhomne

Ayushi Dhomne

All admin and pooja maan are very good in guiding. Unisoft IT training center is the best training center to get knowlegde. Tushar k. sir is very good teacher to teach us and well experienced.
Parag Dhande

Parag Dhande

Unisoft is th best IT training institute in nagpur i have known. Specially Saurabh sir is best for learning Oracle DBA from as his concepts are very clear and he guides very well.The admin is very cooperative and helpful. Overall a great and knowledgeable experience.I suggest to those who want to learn DBA should definitely join unisoft.
Pranali Bhanse

Pranali Bhanse

My faculty for training of SQL database was Mr. Saurabh Joshi ,for Linux from Mr. Anushesh Bhawne and C-Lang from Ms.Supriya Gabhane mam. It was good Experience with Unisoft Technologies.Ms. Pooja Chauhan and Ms. Asha Pandit mam is very helpful and all admin members were good and guided me allot.
Tushar Kottawar

Tushar Kottawar

For someone who is in dilemma and is asking any of the following questions: 1) "Whether this course is right for me?" 2) "I am a recent graduate. What should I do next?" 3) "I am working professional and I want change my domain. Which domain should I choose that would shape my professional career?" 4) "I am a Non-IT graduate. I want to change my career track to IT. Which course is more beneficial?" You should visit Unisoft Technologies for the RIGHT career guidance and also to get a deep insight about different IT technologies. Unisoft Technologies is a place full of professionally trained counselors and highly experienced faculties. I have been a part of Unisoft Technologies for over a year now. I started my journey with Unisoft as a C++ student and eventually learned Java and Oracle Database. Considering I am from a Non-IT background I was initially not sure which course to choose. I knew only about C, C++ and Java before i visited Unisoft. My counselor at the time was Asha Pandit madam. She introduced me to a whole new world that exists besides Java. No only that she also explained about different types of Certifications and its importance for the students and especially freshers. I learned C++ under the guidance of Shyam Nasre sir and Java under Leena Khawshi madam. Both these faculties are the best in their respective field. They make the subject look easy even for someone who is not from an IT background.! I learned Oracle Database under the guidance of Saurabh Joshi sir. He is the best faculty I have ever known. Highly experienced and with a vast ocean of knowledge he is the best when it comes to teaching Oracle Database. He is my teacher, my guide and my mentor till date. My other mentor in Unisoft is Pratigya madam. She is always the one who will constanlty motivate me and will keep on providing with lots of knowledge anout different technologies. At Unisoft its not just about giving our best, Its about bringing out the best in students. We have branches in Nagpur and Pune. Our excellent counselors include Trupti madam, Ashwini madam, Sonali madam, Anuradha madam, Priyanka madam, Akshay sir, Kirti madam, Shahid sir and Ankita mam. Each and every one of them will guide you CORRECTLY. I would recommend Unisoft to all the students, fresher graduates, job seekers as well as working professionals who are looking to change their domain or are looking to enhance their skillset.
Anuja Rananware

Anuja Rananware

Unisoft Technologies is the best Institute for training and courses. This is the best platform for getting the Global Certification Courses and for learning. Environment is good for practice and study. Faculty is good.My faculty Mr. Tushar sir is well experienced and good at his teaching. He is helpful in nature and always available for our queries..
© 2017 Unisoft Technologies - Pune, Nagpur, Bangalore(Bengaluru) | Developed By In House Team