Batch
Date: Jun
9th @ 10:45AM
Faculty: Mr. Dinesh Kumar
Duration:
30 Days (Daily one and half hour)
Fee: 1000/- INR Reg Fee 100/-INR
Location
: S.R Nagar, Hyderabad.
Venue
:
DURGA SOFTWARE SOLUTIONS at Maitrivanam
Canara bank building 2nd floor,
near S. R Nagar Ploce Station,
Hyderabad-500038.
Contact : 97 03 08 96 96 .
Syllabus:
Fundamentals of Database
DBMS Concepts
RDBMS Concepts
Roles of Oracle in info.mgt.
What is Object - Model?
Oracle versions
Features of Oracle 8i/9i/10g/11G
E-R Modeling
SQL
What is SQL?
Role of SQL in RDBMS
Sub-languages in SQL
What is SQL, SQL*PLUS and ISQL*PLUS
Oracle data types
Classification of SQL Commands
Types of commands
Data Definition Language (DDL) Commands
Create, alter-add, modify, drop column
and Drop
DATA INTEGRITY CONSTRAINTS
• KEY CONSTRAINTS
• DOMAIN CONSTRAINTS
• REFERENTIAL INTEGRITY CONSTRAINTS
Implementation of data integrity
Data integrity construction
DML Commands
INSERT:
INSERT Statement
Oracle Operators
Where clause
Update and Delete statements
SELECT:
Examples on Select using Where Clause
Special Operators
IN, BETWEEN, LIKE, IS NULL
Data Joining
What is join
Types of Joins
Cartesian Join
Equi join/Non-Equi join/Outer Join
OUTER JOINS
Left outer join, Right outer joins and Full outer join
Sub Queries
Simple/complex Sub Query on multiple data sources
Corelated Sub Query
Filters/Set operator Usage
Operators
Arithematic Operators
Relational Operators
Relational Negation Operators
Logical Operators
Set Operators
Database Objects
INDEXES
Index
Types of Indexes
Unique Index
Non Unique Index
Clustered indexes
VIEWS
Types of views
Simple views
Composite views
Force Views
Materialized views
SYNONYMS
Types of Synonyms
Private Synonym
Public Synonym
Security Aspect
SEQUENCE
Using various clauses
Pseudo columns
DATA DELETION
Simple and Critical data deletion
Using joining and Sub-query Concept
Using Co-related Sub-Queries
DATA UPDATION
Table updation
Multi-Column Updates
TRANSACTION CONTROL LANGUAGE
COMMIT/ROLLBACK/SAVEPOINT
Truncate, rename commands
Rename column and constraints
SQL Editor Commands
SQL Environment Settings
&, && - Substitution Operator
Sub Queries
Introduction and Examples
Sub Queries with delete and Update
SQL Reporting Commands
Special Operators in sub queries
..Exists, any, some, all
Correlated Sub Queries
Scalar Sub Queries
ORACLE FUNCTIONS
CATEGORIES
• GROUP OR AGGREGATE FUNCTIONS
• SCALAR OR SINGLE ROW FUNCTIONS
Types of functions
NUMERIC FUNCTIONS
STRING FUNCTIONS
CONVERSION FUNCTIONS
DATE FUNCTIONS
PL/SQL
Introduction to PL/SQL
Features, Structure and Architecture
Data types, Executable Stmts
Examples
CONDITIONAL STMTS
If, Case stmts
Iterative stmts
LOOPS-Simple, while and For
Using Labels
CURSORS
Introduction & Types
Operations and Attributes
Examples
Cursors with Parameters
Where Current of Clause
Implicit Cursors with Examples
Cursor Variables
Exceptions –Predefined &User defined
Non-Predefined Exception-
Pragma Exception_init
PL/SQL RECORDS AND TABLES
Composite Data Types
PL/SQL Records & Tables
Nested Records
Using Record in a Table
And Examples
STORED PROCEDURES
With out arguments
With arguments
FUNCTIONS
With arguments
Without arguments
TRIGGERS
Introduction & Types
Database Triggers
Row Triggers with Ex.
Statement Triggers
Instead of Triggers-Views with Ex.
Sub Programs-Features
Procedures, Functions with Ex.
Parameter Modes-IN,OUT, INOUT
NOCOPY with Examples
PACKAGES
Overloading of functions in Packages
Sharing Packages
Returning into clause
Using in Select, Update, Delete
Fetch Temporary Tables
DESIGNING
Database Designing
Need of Requirement & Analysis
E-R Diagrams
NORMALIZATION
Normal Forms with Examples
REF CURSORS
Autonomous Transactions
MISLLANEOUS
Analytical Functions
Rank, Dense Rank, Lag, Lead, First, Last