Oracle Database 11g
Structure of the Module
Introduction to DBMSSyllabus
- What is DBMS
- Relational Data Models
- Data integrity rules
- Normalization
- Introduction to data processing methods - Client/Server
- Oracle Architecture
- What is grid computing?
SQL
- Creating Tables
- Integrity Constraints
- Adding, updating and dropping columns
- Transaction and locking
- Functions
- Grouping data
- Using ROLLUP and CUBE
- Joing tables
- ANSI Join
- Sub queries
- Working with TOPn analysis
- Views
- Materialized Views
- Using indexes and clusters
- Index Skip Scan
- Secutiry
- Report generation using SQL*Plus commands
- Distributed databases
- Partitioning
- List partitioning
- Lobs
PL/SQL Programming
- What is PL/SQL
- Structure of PL/SQL block
- Control statement
- CASE expression
- Exception handling
- Cursor handling
- Writing stored procedures and functions
- Definer rights vs. Invoker's rights
- Autonomous transactions
- Database triggers
- Native dynamic SQL
- Flashback query
- MERGE statement
- Multitable insert
- Using Regular Expressions
Object Features
- Object types
- Object Inheritance
- Varrays
- Nested tables
- Object views
New Features Of Oracle Database 11g
- Audit Vault and Hot patching
- Security enhancements - case sensitive passwords
- Query result cache and PL/SQL function result cache
- Fine grained depedency tracking
- Enhancements related to Triggers
- PL/SQL sequences
- Virtual Columns & readonly tables
For more Info Catch Me : :
Mail : techtrainin@gmail.com
Mob : 91-9912326989
Note : Course Through Online or Offline .
No comments:
Post a Comment