6 Week Industrial Training in Oracle in Karnal Haryana

Course Duration: 6 week

Classes time period: 2 hrs(1 hr practical/1hr theory)

Classes’ schedule: Mon-Friday(separate weekend batches are also available)

Course Fees: Contact Consultant

Course material/Syllabus: See below

OCA Oracle Database 11g: SQL Fundamentals I

• SQL SELECT statements

• Restricting and sorting data

• Single-row functions

• Conversion functions and conditional expressions

• Group functions

• Displaying data from multiple tables

• Subqueries

• Set operators

• DML and DDL statements

• Schema objects

 Course Content

SQL SELECT Statements

List the Capabilities of SQL SELECT Statements

Execute a Basic SELECT Statement 2

Restricting and sorting data

Limit the Rows Retrieved by a Query

Sort the Rows Retrieved by a Query

Ampersand substitution

Conversion functions and conditional expressions

Describe Various Types of Conversion Functions Available in SQL

Use the TO_Char. TO_Number. and TO_Date Conversion Functions

Apply Conditional Expressions in a SELECT Statement

Group Functions

Describe the group functions

Identify the Available the Group Functions

Group Data Using the GROUP BY Clause

Include or Exclude Grouped Rows 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 Using a Self-join

View Data that Does not meet a join condition

Generate a Carresian Product of two or more tables


Define Subqueries

Describe the types of problems that the Subqueries can solve

List the type of Subqueries

Write Single-Row and Multiple-Row Subqueries

Set Operators

Describe the Set Operators

Use a Set Operator to Combine Multiple Queries

Control the order of rows returned

DML and DDL statement

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

Schema Objects

Create simple and complex views

Retrieve Data from views

Create private and public Synonyms

Create, Maintain and use Sequences

Create and maintain Index3