COURSE HIGHLIGHTS :

  • Faculty : All faculty members are having rich IT industry experience, in a number of technical and managerial roles at senior positions.
  • Extensive discussions and experience sharing by trainers.
  • The Course material is been developed in accordance with Oracle University pattern.
  • Complete theoretical and practical knowledge will be delivered.
  • Students will get opportunities to work on live projects and get acquainted with real time industry scenario.
  • Complete course content strictly as per syllabus of paper 1.
  • Complete handís on training on sql.
  • Numerous case studies.
  • Concept of database management system, special benefits.
  • Placement Assistance for certified students.
  • Test series (over 2000 question,20 papers).
  • Training certificate directly from ORACLE university.
  • Authorized training kit & study material from ORACLE.
  • Experienced + certified faculties.


Oracle Database 11g Certification


Step 1-
Exam Number: 1Z0-051
Duration:120 minutes
Number of Questions:64
Passing Score:60%



Oracle Database 11g: SQL Fundamentals

Course Content


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 that are 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 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 a single query
  • Control the order of rows returned


Manipulating Data

  • Describe each DML statement
  • Insert rows into a table
  • Update rows in a table
  • Delete rows from a table
  • Merge rows in 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



COURSE CONTENT


Oracle Database 11g: SQL Fundamentals 1Z0-051 Oracle Database 11g: Administration 1Z0-052