Batch
Date: November
28th @ 4:00PM to 6:00PM
Faculty: Mr. Vijay Kumar
Duration: 45 days (Daily Two Hours)
Fee: 1000 INR
Location : S.R Nagar, Hyderabad.
CODD rules
Client / server Architecture
Oracle versions
Oracle Installation
Oracle architecture
About Table partitioning
Hierarchical queries
PL/SQL
Introduction
to PL/SQL
Advantages of PL/SQL
PL/SQL architecture
Datatypes in PL/SQL
PL/SQL program structure
Simple PL/SQL programs
Embedding SQL statements in PL/SQL
Conditional statements
Loops
Cursors :
Built-in packages in PL/SQL
Oracle 10g features
Oracle 11g features
DBA concepts
See more info....... http://www.durgasoft.com/Oracle%20add.asp
Faculty: Mr. Vijay Kumar
Duration: 45 days (Daily Two Hours)
Fee: 1000 INR
Location : S.R Nagar, Hyderabad.
Venue
:
DURGA SOFTWARE SOLUTIONS at S.R NAGAR
23/3RT IInd Floor,
Opp.Andhra Bank,
Near Umesh Chandra Statue,
S.R.Nagar,
Hyderabad - 500038,
Ph.No : 040 - 64512786, 09246212143
Syllabus:
DURGA SOFTWARE SOLUTIONS at S.R NAGAR
23/3RT IInd Floor,
Opp.Andhra Bank,
Near Umesh Chandra Statue,
S.R.Nagar,
Hyderabad - 500038,
Ph.No : 040 - 64512786, 09246212143
Syllabus:
Highlights
of the Course:
Indepth
syllabus coverage(ORACLE 11g,SQL, PL/SQL)
OCA(Oracle Certified Associate) oriented classes.
Special classes on Real Time Database Tools--TOAD,SQL * Loader
Interview FAQs discussion.
Work shops on Real Time scenorios.
OCA(Oracle Certified Associate) oriented classes.
Special classes on Real Time Database Tools--TOAD,SQL * Loader
Interview FAQs discussion.
Work shops on Real Time scenorios.
Syllabus:
ORACLE
11G
Introduction:
Definition of Database
Definition of DBMS
FMS
Advantage of DBMS over FMS
DB Life Cycle
DB Design:
Definition of Database
Definition of DBMS
FMS
Advantage of DBMS over FMS
DB Life Cycle
DB Design:
- ER MODEL
- NORMALIZATION
- Hierarchical
- Network
- Relational
- Object Relational
- Object Oriented
CODD rules
Client / server Architecture
Oracle versions
Oracle Installation
Oracle architecture
SQL
Introduction
to SQL
SQL standards
SQL sublanguages
About SQL*PLUS
Difference between SQL and SQL*PLUS
Datatypes in Oracle
Operators in Oracle
Schemas and Schema Objects
About Table Creation
Inserting Data
Data Retrieval:
SQL standards
SQL sublanguages
About SQL*PLUS
Difference between SQL and SQL*PLUS
Datatypes in Oracle
Operators in Oracle
Schemas and Schema Objects
About Table Creation
Inserting Data
Data Retrieval:
- SELECT statement
- Column alias, Table alias
- Clauses in SQL
- Data filtering using WHERE clause
- Data Sorting using ORDER BY clause
- Copying Data from one table to another
- INSERT command
- UPDATE command
- DELETE command
- INSERT ALL command
- MERGE command
- Creating Table from another Table
- ALTER command
- DROP command
- TRUNCATE command
- RENAME command
- Difference between DELETE and TRUNCATE
- Types of Integrity Constraints
- Declaring Constraints
- Column level
- Table level
- Adding Constraints to an Existing table
- Enabling & Disabling Constraints
- Getting information about Constraints
- Single Row functions
- String functions
- Date functions
- Mathematical functions
- Conversion functions
- Special functions
- Analytical functions
- Multi Row functions
- Group by clause
- Having clause
- Cube & Rollup
- Importance of Join Operation
- Equi Join
- Non-Equi Join
- Self Join
- Outer Join
- Left Outer
- Right Outer
- Full Outer
- Cross join
- ANSI joins
- UNION , UNION ALL
- INTERSECT
- MINUS
- ROWID , ROWNUM
- Importance of Subqueries
- Types
of Subqueries
- Single row subqueries
- Multi row subqueries
- Nested queries
- Multi column subqueries
- Co-related subqueries
- In-line views
- Scalar queries
- commit command
- rollback command
- savepoing command
- System privileges and Object privileges
- Granting and revoking privileges
- Creating users and roles
- Views
- Synonyms
- Indexes
- Clusters
- Materialized views
- Sequences
- Types
About Table partitioning
Hierarchical queries
PL/SQL
Advantages of PL/SQL
PL/SQL architecture
Datatypes in PL/SQL
PL/SQL program structure
Simple PL/SQL programs
Embedding SQL statements in PL/SQL
Conditional statements
Loops
Cursors :
- About cursors in PL/SQL
- Explicit cursors
- For loop cursor
- Cursor paramenters
- For update clause
- Where current of clause
- Ref cursors
- Implicit cursors
- System defined exceptions
- User defined exceptions
- Sqlcode & sqlerrm
- Pragma exception_init
- Introduction to subprograms
- Difference between anonymous & named blocks
- Creatng procedures
- Working with IN , OUT ,INOUT parameters
- Procedures with cursors
- Procedures returning records
- Pragma autotnomous transaction
- Difference b/w procedures and functions
- Inline functions
- Introduction to packages
- Package specification and package body
- Overloading package members
- Introduction to triggers
- DML triggers
- DDL triggers
- Db auditing using triggers
- DB level triggers
Built-in packages in PL/SQL
Oracle 10g features
Oracle 11g features
DBA concepts
See more info....... http://www.durgasoft.com/Oracle%20add.asp
No comments:
Post a Comment