Free Trial

You get to enjoy all premium features and unlimited course access in WingsLive.com for 1 day free trial.

It takes only 30 Seconds! Try now!

Membership

Get unlimited course access, exclusive features and learn on any device with our premium account that helps you to meet all your learning objectives.

Access Code

If you purchased an access code card in any outlet or if you have any of our Discount Code, Gift Code, Promo Code, Please Click here.

Login


Forgot password? Click here

Send us your Feedback

Forgot Password?

Please enter your registered email address to reset your password: you will receive an email with further instructions.

Free Trial Account

Sign up with:

Sign up with Facebook
Sign up with Google

Sign up with Email:

Share this course to your loved one

via Mail ID

Embed Link

Copy this link
www.wingslive.com/index.php/courses/Oracle_10g

Quick Links

  •   Buy Gift

    Give a Gift of Knowledge

    "It always remembers, Give a man a fish, and you feed him for a day;
    Show him how to catch fish, and you feed him for a lifetime."

    Three simple processes for ordering it.
    Step 1: Simply decide which subscription plan you would like to give as a gift
    Step 2: Tell us whom you want this to be send
    Step 3: Complete the payment and leave the reset to us!
    We will send our WingsLive Gift Voucher code, in an attractive gift wallet & envelope,
    bearing your individual gift message, to your selected delivery address within 3 working
    days (or) We will send our WingsLive Gift Voucher code, in an attractive E-Greeting card,
    bearing your individual gift message, to the given email address within few minutes of
    time.
      CBT Store   Contact Us
  • Search Result

    Oracle 10g

    133 Lessons      09:08:54 hrs

    ORACLE is the powerful relational database management system (RDBMS). Oracle provides a high-security Internet platform for managing enterprise applications, web sites, Java programs and Internet files. Most of the organizations and industries use the Oracle database for their data storage.

    Screen Resolution Available On
    CD/DVD-Rom's, Online, Apps

    Searched Keyword:
    << Back

    BM

    Lesson Plans

    Duration

    Status

    ABL

    Notes

    Excersice


    Collapse all Expand all

    • +

      Author Mentoring


       

      Audience for this course

      01:40

       

      N/A

       

      N/A


       

      Job Opportunities and Job Roles

      02:17

       

      N/A

       

      N/A


       

      Pre-requisite knowledge and skills

      01:13

       

      N/A

       

      N/A


       

      Inspire with News And Samples

      01:20

       

      N/A

       

      N/A


    • +

      Fundamentals of Oracle


       

      History of oracle

      02:19

       

      N/A

       

      N/A


       

      What is oracle?

      01:27

       

      N/A

       

      N/A


       

      What is Grid Computing?

      01:05

       

      N/A

       

      N/A


       

      Why We Need Oracle10g

      01:50

       

      N/A

       

      N/A


       

      Course Objective for Oracle 10g

      02:24

       

      N/A

       

      N/A


    • +

      Setting up Environment


       

      Checklist for Installation

      02:10

       

      N/A

       

      N/A


       

      Oracle 10g Step by Step Installation

      08:55

       

      N/A

       

      N/A


       

      Troubleshooting and Configuring the Environment

      02:04

       

      N/A

       

      N/A


       

      How to Open SQL*plus

      02:23

       

      N/A

       

      N/A


       

      How to Open iSQL*plus

      03:00

       

      N/A

       

      N/A


    • +

      Introduction to Database


       

      What is database?

      01:21

       

      N/A

       

      N/A


       

      Types of database

      02:58

       

      N/A

       

      N/A


       

      What is Normalization?

      03:39

       

      N/A

       

      N/A


       

      What is Relational Database Management System (RDBMS)?

      03:07

       

      N/A

       

      N/A


       

      What is Object Relational Database Management System (ORDBMS)?

      02:30

       

      N/A

       

      N/A


    • +

      SQL Basics


       

      Introduction to SQL

      02:40

       

      N/A

       

      N/A


       

      Simple SELECT statement

      04:06

       

      N/A

       

      N/A


       

      SQL Data types

      03:25

       

      N/A

       

      N/A


       

      Oracle 10g new data types

      02:04

       

      N/A

       

      N/A


       

      SQL operators and their precedence

      05:11

       

      N/A

       

      N/A


       

      Alias names, Concatenation and Distinct keyword

      04:38

       

      N/A

       

      N/A


    • +

      Data Definition Language


       

      Simple TABLE creation

      03:44

       

      N/A

       

      N/A


       

      Table Creation with DEFAULT Option

      07:44

       

      N/A

       

      N/A


       

      Altering a Table

      12:20

       

      N/A

       

      N/A


       

      Table creation with subquery

      07:59

       

      N/A

       

      N/A


       

      Table creation with Not null, unique key and Primary key constraints I

      03:40

       

      N/A

       

      N/A


       

      Table creation with Not null, unique key and Primary key constraints I I

      03:35

       

      N/A

       

      N/A


       

      Table Creation with foreign key and check constraint

      03:12

       

      N/A

       

      N/A


       

      Altering a constraints

      03:18

       

      N/A

       

      N/A


       

      Dropping And Truncating a Table

      03:33

       

      N/A

       

      N/A


    • +

      Data Manipulation Language


       

      Inserting Data

      08:48

       

      N/A

       

      N/A


       

      Copying Data

      01:29

       

      N/A

       

      N/A


       

      Deleting Data

      03:21

       

      N/A

       

      N/A


       

      Select statement with WHERE Clause

      12:50

       

      N/A

       

      N/A


       

      Logical operators in WHERE clause

      10:17

       

      N/A

       

      N/A


       

      Working with ORDER BY Clause

      04:42

       

      N/A

       

      N/A


       

      Updating a table

      02:11

       

      N/A

       

      N/A


       

      Merge statement

      04:14

       

      N/A

       

      N/A


       

      Transactional Control Statements

      10:57

       

      N/A

       

      N/A


    • +

      SQL Functions


       

      Aggregate functions

      06:35

       

      N/A

       

      N/A


       

      Character functions and Date functions I

      05:20

       

      N/A

       

      N/A


       

      Character functions and Date functions II

      09:44

       

      N/A

       

      N/A


       

      Group by and Having clause

      03:34

       

      N/A

       

      N/A


       

      Set operators

      05:42

       

      N/A

       

      N/A


       

      Case and Decode Function

      03:35

       

      N/A

       

      N/A


       

      Rollup and Cube Function

      03:18

       

      N/A

       

      N/A


       

      NVL functions

      02:38

       

      N/A

       

      N/A


    • +

      Joins and User Access


       

      Joins

      03:11

       

      N/A

       

      N/A


       

      Equi join and Non equijoin

      08:55

       

      N/A

       

      N/A


       

      Join with USING and ON clause

      03:27

       

      N/A

       

      N/A


       

      Outer join (LEFT, RIGHT and FULL)

      05:02

       

      N/A

       

      N/A


       

      Controlling and managing user access (Data Control Language)

      06:52

       

      N/A

       

      N/A


       

      Creating a report in SQL* plus

      07:09

       

      N/A

       

      N/A


    • +

      Database Objects


       

      Index

      05:12

       

      N/A

       

      N/A


       

      View

      03:55

       

      N/A

       

      N/A


       

      Sequence

      03:24

       

      N/A

       

      N/A


       

      Synonyms

      17:24

       

      N/A

       

      N/A


    • +

      PL/SQL Basics


       

      Introduction to PL/SQL

      05:33

       

      N/A

       

      N/A


       

      PL/SQL Fundamentals

      03:57

       

      N/A

       

      N/A


       

      Data types in PL/SQL

      11:03

       

      N/A

       

      N/A


       

      PL/SQL LOB Data types and Special Data types

      06:41

       

      N/A

       

      N/A


       

      PL/SQL Declaration and Executable Block

      02:53

       

      N/A

       

      N/A


       

      PL/SQL Conditional Logics

      04:42

       

      N/A

       

      N/A


       

      PL/SQL Loops

      04:24

       

      N/A

       

      N/A


    • +

      Cursor, Trigger and Handling Exceptions


       

      PL/SQL Cursor and its types

      07:00

       

      N/A

       

      N/A


       

      Explicit Cursor Attributes and loops

      04:11

       

      N/A

       

      N/A


       

      Implicit cursor

      02:55

       

      N/A

       

      N/A


       

      Triggers in PL/SQL

      05:40

       

      N/A

       

      N/A


       

      Exception handling in PL/SQL

      06:34

       

      N/A

       

      N/A


    • +

      Procedures, Functions and Package


       

      Procedure Creation in PL/SQL

      04:28

       

      N/A

       

      N/A


       

      Working with Function in PL/SQL

      04:21

       

      N/A

       

      N/A


       

      Package in PL/SQL

      07:55

       

      N/A

       

      N/A


    • +

      Introduction to Object Relational Database


       

      Overview of Nested tables

      03:10

       

      N/A

       

      N/A


       

      Varying Array (V-Array)

      03:15

       

      N/A

       

      N/A


       

      Understanding LOB’s

      05:10

       

      N/A

       

      N/A


       

      Using CLOB data type in a table

      01:23

       

      N/A

       

      N/A


       

      DBMS_LOB package

      07:36

       

      N/A

       

      N/A


    • +

      Introduction to Database Administration (Database


       

      Overview of Oracle 10g Database Architecture

      02:37

       

      N/A

       

      N/A


       

      Logical structure of the oracle database

      07:05

       

      N/A

       

      N/A


       

      Physical structure of the oracle database

      05:36

       

      N/A

       

      N/A


       

      Oracle processes I

      03:35

       

      N/A

       

      N/A


       

      Oracle Processes II

      04:41

       

      N/A

       

      N/A


       

      Oracle Memory Structures

      05:18

       

      N/A

       

      N/A


       

      The Program Global Area (PGA)

      02:38

       

      N/A

       

      N/A


       

      Oracle backup and recovery architecture

      03:21

       

      N/A

       

      N/A


       

      The Oracle Data Dictionary and the Dynamic Performance Views

      03:50

       

      N/A

       

      N/A


       

      Oracle Database Administration Tools

      02:37

       

      N/A

       

      N/A


    • +

      Schema Management


       

      What is Schema?

      02:08

       

      N/A

       

      N/A


       

      Allocation of Extent and Dealloction

      03:14

       

      N/A

       

      N/A


       

      Storage Parameters

      02:14

       

      N/A

       

      N/A


    • +

      Creating an Oracle Database


       

      Starting an Oracle Instance

      01:28

       

      N/A

       

      N/A


       

      Creating the simplest Database

      05:12

       

      N/A

       

      N/A


       

      Database Creation with oracle DBCA

      05:17

       

      N/A

       

      N/A


       

      Creating a New Database with executing the scripts

      02:53

       

      N/A

       

      N/A


    • +

      Starting up and Shutting down the Database


       

      Starting Up the Database

      03:10

       

      N/A

       

      N/A


       

      Shut down the database

      01:13

       

      N/A

       

      N/A


       

      Suspending and Dropping a database

      01:22

       

      N/A

       

      N/A


       

      Configuring and deleting database with DBCA

      05:59

       

      N/A

       

      N/A


    • +

      Administering Users and Security


       

      Overview of Database Security

      02:19

       

      N/A

       

      N/A


       

      Database Administration Accounts and Profiles

      04:00

       

      N/A

       

      N/A


       

      Viewing, Creating, Modifying and Dropping roles

      04:34

       

      N/A

       

      N/A


       

      Administering Database Users

      02:26

       

      N/A

       

      N/A


       

      Creating Users in DBCA

      02:28

       

      N/A

       

      N/A


       

      Editing Users

      03:09

       

      N/A

       

      N/A


       

      Granting and revoking Roles

      02:24

       

      N/A

       

      N/A


       

      Dropping Users

      00:36

       

      N/A

       

      N/A


       

      Controlling Access to Data

      05:21

       

      N/A

       

      N/A


    • +

      Database Administration using SQL*PLUS


       

      SQL*Plus and SQL Commands

      02:35

       

      N/A

       

      N/A


       

      Using SQL*Plus and iSQL*Plus

      01:53

       

      N/A

       

      N/A


       

      SQL*Plus Command-Line Options

      02:54

       

      N/A

       

      N/A


       

      Key SQL*Plus Database Administration Commands

      02:00

       

      N/A

       

      N/A


    • +

      Loading and Transforming Data


       

      An Overview of Extraction, Transformation, and Loading

      04:50

       

      N/A

       

      N/A


       

      Components for ETL

      04:02

       

      N/A

       

      N/A


       

      SQL*Loader Control File

      02:09

       

      N/A

       

      N/A


    • +

      Backing up the Databases


       

      Introduction to database Backup

      04:50

       

      N/A

       

      N/A


       

      Benefits of RMAN

      04:02

       

      N/A

       

      N/A


       

      Connecting to RMAN through Database Authentication

      02:09

       

      N/A

       

      N/A


    • +

      Database Recovery


       

      Overview of Database Recovery

      01:14

       

      N/A

       

      N/A


       

      Types of Database Failures

      02:27

       

      N/A

       

      N/A


       

      Crash and Instance Recovery by Oracle

      03:34

       

      N/A

       

      N/A


       

      Performing Recovery with RMAN

      01:49

       

      N/A

       

      N/A


       

      Using the VALIDATE BACKUP Command to Validate

      02:30

       

      N/A

       

      N/A


       

      Recovering a Data File without a Backup

      00:42

       

      N/A

       

      N/A


    • +

      Introduction to Network Administration


       

      Oracle Network Administration

      01:59

       

      N/A

       

      N/A


       

      Configuring Oracle Net Service

      05:54

       

      N/A

       

      N/A


       

      Connecting with the server using OEM

      01:19

       

      N/A

       

      N/A


    • +

      Performance Monitoring


       

      Introduction to Oracle Performance Tuning

      01:13

       

      N/A

       

      N/A


       

      Collection of Statistics Using AWR

      03:02

       

      N/A

       

      N/A


       

      Working with Advisor Central

      03:34

       

      N/A

       

      N/A


    BM

    Lesson Plans

    Status

    Excersice

    Oracle 10g - Tips


     

    SQL, SQL*plus, PL/SQL: What is the Difference?

     

    N/A


     

    How to run SQL in Command line interface?

     

    N/A


     

    How to delete duplicate rows without using DISTINCT keyword?

     

    N/A


     

    What are the different editor commands in SQL * PLUS?

     

    N/A


     

    How to search a string across several columns in a table?

     

    N/A


     

    How primary key and unique key differs and what’s the use ON DELETE CASCADE?

     

    N/A


     

    Truncate Vs Delete Alias Name Vs Rename

     

    N/A


     

    How to generate a sequence of numbers using SQL?

     

    N/A


     

    How INSTR (in string) and SUBSTR (substring) function differs?

     

    N/A


     

    Useful SQL Queries

     

    N/A


     

    How to monitor unused indexes?

     

    N/A


     

    Advantages and disadvantages of a Cursor

     

    N/A


     

    What are the use of cycle and no cycle while creating a sequence?

     

    N/A


     

    How to Discover PL/SQL Errors?

     

    N/A


     

    What are the differences between %type, %row type and other data types?

     

    N/A


     

    How to Get an IP Address and Host address using SQL?

     

    N/A


     

    PL/SQL procedure to update salary in the EMP table

     

    N/A


     

    PL/SQL program to find factorial of numbers using function

     

    N/A


     

    PL/SQL program to find palindrome and Fibonacci series

     

    N/A


     

    PL/SQL code to prevent unnecessary delete using TRIGGER

     

    N/A


    Self Assessment

    Attempts

    Status

    Introduction to SQL

    0

     


    Data Definition Language

    0

     


    Data Manipulation Language

    0

     


    SQL Functions

    0

     


    Joins

    0

     


    Database Objects

    0

     


    Introduction to PL/SQL

    0

     


    PL/SQL Procedure and Package

    0

     


    Introduction to Database Administration

    0

     


    Working with Oracle Database

    0

     


    Database Administration using SQL*PLUS

    0

     


    Starting up and Shutting down the Database

    0

     


    Loading and Transforming Data

    0

     


    Backing up the Databases

    0

     


    Database Recovery

    0

     


    Network Administration

    0

     


    Performance Monitoring

    0

     


    Lesson Plans

    Tips and Tricks

    Glossary

    A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

    ABS
    An SQL-99 keyword. The ABS function returns the absolute value of a number or an interval. Absolute values measure magnitude. Therefore they are always positive.

    AFTER trigger
    When defining a trigger, you can specify the trigger timing--whether the trigger action is to be executed before or after the triggering statement.AFTER triggers execute the trigger action after the triggering statement is executed.BEFORE and AFTER apply to both statement and row triggers.

    ALTER
    An SQL verb: to change a definition. SQL Objects that may be altered include: Tables, Domains.

    ASCENDING (ASC)
    Going up. In an ascending sort sequence, the number 5 comes after 4 in the number sequence, and the letter "K" comes after "G" in the alphabet. Opposite is descending. Short form (used in SQL) is ASC.

    AVG
    An SQL set function, short for "average", which returns the arithmetic mean for a columnar expression.