Description

 Vannakkam,I bought this DVD at a much higher price assuming that the media quality would be good.But it seems this Pebbles company had burned the data in some low-quality disc. Further adding up to my frustration they have write-protected the disk,so that no one can make a copy of it.If they think they are smart. They should also know that MUCH-SMARTER people are in this world.I am not a kind of person who would normally encourage piracy.But this stupid(moron,worthless...what everrrrr)company had frustrated me a lot to do like this.At least here after let those people burn the data in a good quality DVD.  Till then folks, enjoy downloading... and at least keep seeding till you get the share ratio as 1.000  NO CONDITIONS APPLY.  ENJOY THIS AT YOUR FREE WILL.  PASS-IT ON TOO.TOTAL CHAPTERS        : 11TOTAL NUMBER OF FILES          : 64UNNECESSARY ADVERTISEMENT FILES : 02                               ------                         TOTAL : 66                               ------CHAPTER-1***********Fundamentals of Oracle1.1 History of oracle. What is oracle?1.2 Why we need oracle10g1.3 What is grid computingCHAPTER-2***********Setting up Environment2.1 Steps to open SQL*plus for the First time2.2 Steps to open iSQL*plusCHAPTER-3***********Introduction to Database3.1 What is Database? 3.2 Types of Database3.3 What is Normalization?3.4 What is Object Relational Database3.5 Management System (RDBMS & ORDBMS)? CHAPTER-4***********Structured Query Language (SQL) Essentials4.1 Introduction to SQL4.2 Simple “SELECT” statement4.3 SQL Data types4.4 Oracle 10g new Data types4.5 SQL operators and their precedence4.6 Alias Concatenation and Distinct KeywordCHAPTER-5*********** Data definition language5.1 Simple “TABLE” Creation, 5.2 Table creation with “DEFAULT” option5.3 Altering a Table5.4 Table creation with “Sub query” &5.5 “NOT NULL”, “UNIQUE”,”PRIMARY KEY”-I 5.6 “NOT NULL”, “UNIQUE”,”PRIMARY KEY”-II5.7 Referential FOREIGN KEY & Check constraints5.8 Altering and Removing Constraints5.9 Dropping And Truncating TablesCHAPTER-6***********Data manipulation language6.1 Inserting Data 6.2 Copying Data 6.3 Deleting Data6.4 Select statement with “WHERE” clause6.5 Logical operators in “WHERE” clause6.6 Working with “ORDER BY” clause6.7 Updating a table  6.8 Merge statement6.9 Transaction Control StatementsCHAPTER-7*********** SQL functions7.1 Aggregate Functions7.2 Character Functions & Date Functions - I7.3 Character Functions & Date Functions - II 7.4 “GROUP BY” and “HAVING” clause7.5 Set Operators, 7.6 Case and Decode Function7.7 Rollup and Cube Function7.8 NVL functionsCHAPTER-8*********** Working with Joins Subqueries & User Access8.1 Joins: CROSS JOIN or Cartesian product8.2 Equi Join and NonEqui join8.3 Join with “USING” and “ON” clause8.4 Outer Joins (LEFT, RIGHT and FULL)8.5 Controlling and Managing User Access8.6 Creating a Report in SQL Plus CHAPTER-9***********Procedural / Structured Query Language (PL/SQL)9.1 Introduction to PL/SQL9.2 Fundamentals of PL/SQL9.3 Datatypes in PL/SQL9.4 PL/SQL LOB Datatypes and Special Datatypes9.5 PL/SQL Declaration and executable block9.6 PL/SQL Conditional logics 9.7 Loops CHAPTER-10***********Cursor, trigger and handling exceptions10.1 PL/SQL Cursor, cursor types10.2 Implicit Cursor10.3 Explicit Cursor10.4 Triggers in PL/SQL10.5 Exception Handling in PL/SQLCHAPTER-11*********** Procedures, Functions and package11.1 Procedure Creation in PL/SQL11.2 Working with Function 11.3 Package in PL/SQL