Job Seekers   Employers
dbapool: Authors | Submissions | Contact Us
   Forgot password? | Sign up
  Home   Discussion Forum   Articles   Interview Questions   FAQs   Scripts   Rewards   Analyzer   White Papers   Blog   Certification   Downloads   Tools
 

Topic: Oracle Certified Professional Exams (OCP & OCA) >> Syllabus for oracle 11g certification

Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property. You may review the entire Oracle Certification Program Candidate Agreement online Here.



  


 Title: Syllabus for oracle 11g certification
 affu  Posted: Jan 10, 2012 08:02:48 AM

 Total Post: 1
 Joined: Jan, 2012






 Hi.Plz send the syllabus for oracle 11g certification to my e-mail addresses aroshanafroz@gmail.com

 reaper
Posted: Jan 10, 2012 03:23:36 PM  

 Total Post: 1
 Joined: Jan, 2012






 
Please send the syllabus for oracle 11g certification to my e-mail addresse: stentorianlover@gmail.com.

Thanks.

 paula
Posted: Jan 14, 2012 03:17:12 AM  

 Total Post: 331
 Joined: Jul, 2008






 
If you aren't capable of finding the Oracle Uni website,

http://education.oracle.com/certification

you are probably not well enough prepared to take any exams. Have downloaded and installed the software and created a dastabase yet? Have you read the documentation, starting with the Concepts Guide?

 sandrab
Posted: Jan 30, 2012 03:45:18 AM  

 Total Post: 25
 Joined: Jul, 2011






 
agree...look at oracle university site and try to find things your self...

 sanju
Posted: Feb 01, 2012 12:02:50 AM  

 Total Post: 2
 Joined: Jan, 2012






 
Hi All,

Syllabus for the oracle 11g certification is as follows :-

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 SQL
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
View data that generally does not meet a join condition by using outer joins
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

 sanju
Posted: Feb 01, 2012 12:03:03 AM  

 Total Post: 2
 Joined: Jan, 2012






 
Hi All,

Syllabus for the oracle 11g certification is as follows :-

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 SQL
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
View data that generally does not meet a join condition by using outer joins
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

Thanks and regards
Sitam

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

 ajay
Posted: Feb 10, 2012 01:04:27 PM  

 Total Post: 1
 Joined: Feb, 2012






 
thanks

 Time Zone: EDT

  




Forum Rules & Description


Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user




 








Get FREE Magazines

Top 10 Forum User

  Murtuja Khokhar857
  Mohammed Taj746
  menon srivalsala kumar639
  positive fanatic615
  Gitesh Trivedi580
  Jayanta Sur480
  Vinoth Kumar436
  Vishant Sanghavi409
  Vigyan Kaushik403
  Gopu Gopi367






oracle Mag



  About Us Advertise Terms of Use Privacy Newsletters Contact Us    

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads 

Our Premium Sponsor