Thank you for making us NO-1 IT Institute.Learn Beyond your Syllabus

Oracle Syllabus
(Duration 75 Hrs)
Start Date
(8th Jun)
Timing
(11:30-1:30pm)
Course Fee
(Rs:4000/- Only)

Oracle Syllabus Details


Module 1: Introduction

Oracle 11g
Oracle 11g Application Server
Oracle database
Relational and Object Relational
Database
Management system
Oracle internet platform
System Development Life cycle

Module 2: Writing basic SQL SELECT statements

Capabilities of SQL select statements
Basic select statement
Selecting all column
Selecting specific columns
Writing SQL statements
Column heading Defaults
Arithmetic expressions
Using Arithmetic Operator
Operator precedence
Overview of ISQL*PLUS
The ISQL*PLUS environment
Displaying the table structure
Interacting with script files

Module 3: Restricting and sorting Data

Limiting Row using a selection
Using where clause
Character strings and dates
Using the LIKE condition
Using NULL condition
Logical conditions
Using AND operator
Using OR operator
Using NOT operator
Rules of precedence
ORDER BY Clause
Sorting in Descending order

Module 4: Single-row function

Single-Row functions
Character functions
Using case Manipulation functions
Character-Manipulation functions
Number function
Working with dates
Conversion functions
Implicit Data Type Conversion
Explicit Data Type conversion
Using the NVL function
Using the NVL2 function
Using the NULLIF function
Using the COLAESCE function
Conditional Expression
Using the CASE Expressions
Using the DECODE Functions

Module 5: Displaying Data from Multiple Tables

Obtaining data from multiple tables
Generating a Cartesian product
Types of joins
Joining tables using Oracle Syntax
What is Equijoin?
Retrieving records with Equijoins
Joining more than two tables
Non-Equijoins
Retrieving records with Non-Equijoin
Using outer joins
Self joins

Module 6: Aggregating Data using Group functions

Types of Group functions
Using the AVG and SUM functions
Using the MIN and MAX functions
Using the COUNT functions
Using the DISTINCT keyword
Using NVL function with Group functions
Creating groups of Data: The Group by Clause
Syntax
Grouping by more than one column

Module 7: Sub-queries

Sub-query syntax
Guidelines for using sub-queries
Types of sub-queries
Single row sub-queries
Executing single row sub-queries
Using group functions in sub-queries
The HAVING clause with sub-queries
Using ANY operator in multi row sub queries

Module 8: Producing Readable Output with ISQL*PLUS

Using the command substitution variable
Character and data values with substitutions variables
Defining substitutions variable
DEFINE AND UNDEFINE command
Using DEFINE command with substitutions variable
Using the && substitutions variable
Using the VERIFY command
Customizing the ISQL*PLUS Environment
Set command variables
COLUMN Format Models
Using the BREAK command Using the TTITLE and BTITLE commands
Creating a script file to run a report

Module 9: Manipulating Data

Data manipulation language
Adding a New row to a table
The INSERT statement syntax
Inserting new rows
Inserting Rows with Null values
Inserting special values
Inserting specific Data values
Using the WITH CHECK OPTION keyword on DML statements
Using Explicit Default values
The MERGE statements syntax
Merging rows

Database transactions Advantages of COMMIT and ROLLBACK statements
Controlling Transactions
Rolling back to changes to a marker
Locking
Implicit Locking

Module 10: Creating and Managing tables

Database Objects
Naming Rules
The CREATE TABLE statement
Referencing another user’s tables
The DEFAULT option
Creating Tables
Tables in Oracle database
Querying the Data Dictionary
Date Time Data Types
The ALTER TABLE statement
Adding a column
Dropping a column
The SET UNUSED option
Dropping a Table
Changing the name of an Objects
Truncating a Table
Adding comments to a table

Module 11: Including Constraint

Define Constraints
The NOT NULL constraint
The UNIQUE constraint
The PRIMARY KEY constraint
The FOREIGN KEY constraint
The CHECK constraint
Adding a constraint
Dropping a constraint
Disabling constraints
Cascading constraints
Viewing constraints
Viewing the columns Associated with constraints

Module 12: Creating Views

What is view?
Simple views and complex views
Creating a view
Retrieving Data from a view
Querying a view
Modifying a view
Creating a complex view
Rules for performing DML operation on a view
Using the WITH CHECK OPTION clause
Denying DML operations
Removing a view
Inline Views
Top-N Analysis
Performing Top-N Analysis

Module 13: Other Database Objects

What is a sequence?
Creating sequence
Confirmation sequences
Guidelines for modifying a sequence
Removing a sequence
What is and index
Create an Index
When to create Index
When not to create Index
Confirming indexes
Synonyms
Creating and removing synonyms

Module 14: Controlling User Access

Controlling user access
System privileges
Creating users
User system privileges
Granting system privileges
What is role?
Creating and granting privileges to Role
Changing your password
Object privileges
Granting object privileges
Using the WITH GRANT OPTION and PUBLIC
Keywords

Module 15: Using SET operator

The SET operator
Table used in this Lesson
The UNION operator
The UNION ALL operator
The INTERSECT operator
The MINUS operator
The Oracle server and SET operators
Matching the SELECT statements
E Controlling the order of rows

Module 16: Oracle 11g Date time functions

Module 17: Enhancements to the GROUP BY clause

Review of Group functions
Review of GROUP BY clause
Review the HAVING clause
GROUP BY with ROLLUP AND CUBE Operators
CUBE Operators
Grouping functions
Grouping SETS
Composite columns: example
Concatenated Grouping Example

Module 18: Oracle 11g Extensions to DML and DDL Statements

Module 19: Joins and Nested Queries.

Natural Join/Eqijoin
Non-Eqijoin
Left Outer Join.
Right Outer Join.
Full Outer Join.
Inner Join/Self Joins

© 2011 LITSOLUTION . All Rights Reserved

Site designed and developed by LITSOLUTION