 |
|
|
|
|
|
|
Classifieds: Education / Training | | Sql plsql online trainings | | Posted By: Muralidhar Kamuni at: 11, Dec 2011 8:23:56 PM IST | Introduction & Basics
1) Introduction
History of relational database management systems.
Oracle vs other RDBMS
Editions and Versions of Oracle
Different development environments.
2) Oracle Setup
Oracle Binaries installation
Creating Sample database.
Connection setup through sqlplus and Sql developer.
3) Oracle Architecture
ACID rules
Concept of Normalization.
Different normal forms.
Oracle Architecture in detail
Logical & Physical structure of oracle database.
SQL
1) Introduction to SQL
DDL commands
DML commands
DCL commands
TCL Commands
Data types in oracle
Detail understanding on Select statement
2) Restricting and Sorting Data
Where clause
Between, In and Like operators
And, OR and Not operators
Order by clause
Defining and Assigning values to variables
3) Single Row functions
Character Manipulation functions
Case conversion functions
Number functions
Date functions
Round and Trunc with date functions
4) Conversion Functions
Data type conversion
To_char,to_date and to_number functions
Replacing null values (NVL2), Decode function
Conditional expressions ( Case)
5) Group functions
Group by clause
Sum, Avg, Min and Max functions
Group by clause on multiple columns
Restricting group results ( Having)
6) Oracle Joins
Type of joins
Join using On and Using clauses
Natural, self and equi joins
Outer joins (left, right and full)
Cross join ( Cartesian product)
7) Sub queries
Types of sub-queries
Single and multiple row sub-queries
Group functions on sub-queries
Using All and Any operators
8) Set operators
Union and union-all operators
Intersect and minus operators
Order by clause in set operators
9) More on DML statements and Data integrity
Inserting data from other table
Conditional insert ( Merge )
Select for update statement
Delete vs truncate
Data integrity ( Commit & Rollback)
10) More on DDL and Constraints
Creating tables and inserting default values
Primary and foreign key constraints
Unique and check constraints
Adding and dropping columns from a table
11) Creating other Schema objects
Simple and Complex views
B-tree and Bitmap indexes
Working with sequences
Creating synonyms
12) Controlling User Access
Creating users
Granting system & object privileges
Creating Roles
Granting and revoking privileges to and from a role
13) Managing other Schema Objects
1) Setting and Dropping UNUSED columns
2) Deleting data from Child Tables (on Delete)
3) Disable & Enable constraints
4) Drop Table…Purge
5) Flashback Table
6) Temporary Table
7) External Table
14) Miscellaneous
Multi Table Insert
Merge statement in detail
Flashback Versions Query
Interval data types
Exists & not exists operators
With Clause
Rollup and Cube operators
PLSQL
Introduction to PLSQL
Need and Benefits of PLSQL
Anonymous PLSQL Block
Declaring & Initializing variables
%Type attribute
INTO clause
Control Structures & loops
If and Case statements
For and While loops
Cursors
Implicit and Explicit cursors
Usage of Cursors in Loops
Cursors with parameters
Procedures
Anonymous PLSQL vs Procedure
Writing simple procedures
Exception Handling
Pre-defined exceptions
User defined Exceptions
Functions
Procedure vs Function
Creating simple functions
Usage of functions
Packages
Benefits of creating packages
Package spec and Body
Overloading of subprograms
Working with Oracle supplied Packages
DBMS_OUTPUT
DBMS_MAIL
DBMS_FILE
Triggers
Types of triggers
Creating and Managing triggers
Compound, DDL and Event based triggers
Miscelleneous
Bulk Collect
Partitioning
Different types of partitions
Partition examples
|
| |
More Education / Training classifieds |
|
|
|
|
|
| Advertisements |
|
|
|
|
| Advertisements |
|
