|
Chapter 1 : Author Mentoring
- Lesson 1.1 : Audience for this course
- Lesson 1.2 : Job Opportunities and Job Roles
- Lesson 1.3 : Pre-requisite knowledge and skills
- Lesson 1.4 : Inspire with News And Samples
Chapter 2 : Fundamentals of Oracle
- Lesson 2.1 : History of oracle
- Lesson 2.2 : What is oracle?
- Lesson 2.3 : What is Grid Computing?
- Lesson 2.4 : Why We Need Oracle10g
- Lesson 2.5 : Course Objective for Oracle 10g
Chapter 3 : Setting up Environment
- Lesson 3.1 : Checklist for Installation
- Lesson 3.2 : Oracle 10g Step by Step Installation
- Lesson 3.3 : Troubleshooting and Configuring the Environment
- Lesson 3.4 : How to Open SQL*plus
- Lesson 3.5 : How to Open iSQL*plus
Chapter 4 : Introduction to Database
- Lesson 4.1 : What is database?
- Lesson 4.2 : Types of database
- Lesson 4.3 : What is Normalization?
- Lesson 4.4 : What is Relational Database Management System (RDBMS)?
- Lesson 4.5 : What is Object Relational Database Management System (ORDBMS)?
Chapter 5 : SQL Basics
- Lesson 5.1 : Introduction to SQL
- Lesson 5.2 : Simple SELECT statement
- Lesson 5.3 : SQL Data types
- Lesson 5.4 : Oracle 10g new data types
- Lesson 5.5 : SQL operators and their precedence
- Lesson 5.6 : Alias names, Concatenation and Distinct keyword
Chapter 6 : Data Definition Language
- Lesson 6.1 : Simple TABLE creation
- Lesson 6.2 : Table Creation with DEFAULT Option
- Lesson 6.3 : Altering a Table
- Lesson 6.4 : Table creation with subquery
- Lesson 6.5 : Table creation with Not null, unique key and Primary key constraints I
- Lesson 6.6 : Table creation with Not null, unique key and Primary key constraints I I
- Lesson 6.7 : Table Creation with foreign key and check constraint
- Lesson 6.8 : Altering a constraints
- Lesson 6.9 : Dropping And Truncating a Table
Chapter 7 : Data Manipulation Language
- Lesson 7.1 : Inserting Data
- Lesson 7.2 : Copying Data
- Lesson 7.3 : Deleting Data
- Lesson 7.4 : Select statement with WHERE Clause
- Lesson 7.5 : Logical operators in WHERE clause
- Lesson 7.6 : Working with ORDER BY Clause
- Lesson 7.7 : Updating a table
- Lesson 7.8 : Merge statement
- Lesson 7.9 : Transaction Control Statements
Chapter 8 : SQL Functions
- Lesson 8.1 : Aggregate functions
- Lesson 8.2 : Character functions and Date functions I
- Lesson 8.3 : Character functions and Date functions II
- Lesson 8.4 : Group by and Having clause
- Lesson 8.5 : Set operators
- Lesson 8.6 : Case and Decode Function
- Lesson 8.7 : Rollup and Cube Function
- Lesson 8.8 : NVL functions
Chapter 9 : Joins and User Access
- Lesson 9.1 : Joins
- Lesson 9.2 : Equi join and Non equijoin
- Lesson 9.3 : Join with USING and ON clause
- Lesson 9.4 : Outer join (LEFT, RIGHT and FULL)
- Lesson 9.5 : Controlling and managing user access (Data Control Language)
- Lesson 9.6 : Creating a report in SQL* plus
Chapter 10 : Database Objects
- Lesson 10.1 : Index
- Lesson 10.2 : View
- Lesson 10.3 : Sequence
- Lesson 10.4 : Synonyms
Chapter 11 : PL/SQL
Basics
- Lesson 11.1 : Introduction to PL/SQL
- Lesson 11.2 : PL/SQL Fundamentals
- Lesson 11.3 : Data types in PL/SQL
- Lesson 11.4 : PL/SQL LOB Data types and Special Data types
- Lesson 11.5 : PL/SQL Declaration and Executable Block
- Lesson 11.6 : PL/SQL Conditional Logics
- Lesson 11.7 : PL/SQL Loops
Chapter 12 : Cursor, Trigger and Handling Exceptions
- Lesson 12.1 : PL/SQL Cursor and its types
- Lesson 12.2 : Explicit Cursor Attributes and loops
- Lesson 12.3 : Implicit cursor
- Lesson 12.4 : Triggers in PL/SQL
- Lesson 12.5 : Exception handling in PL/SQL
Chapter 13 : Procedures, Functions and Package
- Lesson 13.1 : Procedure Creation in PL/SQL
- Lesson 13.2 : Working with Function in PL/SQL
- Lesson 13.3 : Package in PL/SQL
Chapter 14 : Introduction to Object Relational Database
- Lesson 14.1 : Overview of Nested tables
- Lesson 14.2 : Varying Array (V-Array)
- Lesson 14.3 : Understanding LOB’s
- Lesson 14.4 : Using CLOB data type in a table
- Lesson 14.5 : DBMS_LOB package
Chapter 15 : Introduction to Database Administration (Database Architecture)
- Lesson 15.1 : Overview of Oracle 10g Database Architecture
- Lesson 15.2 : Logical structure of the oracle database
- Lesson 15.3 : Physical structure of the oracle database
- Lesson 15.4 : Oracle processes I
- Lesson 15.5 : Oracle processes II
- Lesson 15.6 : Oracle Memory Structures
- Lesson 15.7 : The Program Global Area (PGA)
- Lesson 15.8 : Oracle backup and recovery architecture
- Lesson 15.9 : The Oracle Data Dictionary and the Dynamic Performance Views
- Lesson 15.10 : Oracle Database Administration Tools
Chapter 16 : Schema Management
- Lesson 16.1 : What is Schema?
- Lesson 16.2 : Allocation of Extent and Dealloction
- Lesson 16.3 : Storage Parameters
Chapter 17 : Creating an Oracle Database
- Lesson 17.1 : Creating a New Database with executing the scripts
- Lesson 17.2 : Starting an Oracle Instance
- Lesson 17.3 : Creating the simplest Database
- Lesson 17.4 : Database Creation with oracle DBCA
Chapter 18 : Starting up and Shutting down the Database
- Lesson 18.1 : Starting Up the Database
- Lesson 18.2 : Shut down the database
- Lesson 18.3 : Suspending and Dropping a database
- Lesson 18.4 : Configuring and deleting database with DBCA
Chapter 19 : Administering Users and Security
- Lesson 19.1 : Overview of Database Security
- Lesson 19.2 : Database Administration Accounts and Profiles
- Lesson 19.3 : Viewing, Creating, Modifying and Dropping roles
- Lesson 19.4 : Administering Database Users
- Lesson 19.5 : Creating Users in DBCA
- Lesson 19.6 : Editing Users
- Lesson 19.7 : Granting and revoking Roles
- Lesson 19.8 : Dropping Users
- Lesson 19.9 : Controlling Access to Data
Chapter 20 : Database Administration using SQL*PLUS
- Lesson 20.1 : SQL*Plus and SQL Commands
- Lesson 20.2 : Using SQL*Plus and iSQL*Plus
- Lesson 20.3 : SQL*Plus Command-Line Options
- Lesson 20.4 : Key SQL*Plus Database Administration Commands
Chapter 21 : Loading and Transforming Data
- Lesson 21.1 : An Overview of Extraction, Transformation, and Loading
- Lesson 21.2 : Components for ETL
- Lesson 21.3 : SQL*Loader Control File
Chapter 22 : Backing up the Databases
- Lesson 22.1 : Introduction to database Backup
- Lesson 22.2 : Benefits of RMAN
- Lesson 22.3 : Connecting to RMAN through Database Authentication
Chapter 23 : Database Recovery
- Lesson 23.1 : Overview of Database Recovery
- Lesson 23.2 : Types of Database Failures
- Lesson 23.3 : Crash and Instance Recovery by Oracle
- Lesson 23.4 : Performing Recovery with RMAN
- Lesson 23.5 : Using the VALIDATE BACKUP Command to Validate
- Lesson 23.6 : Recovering a Data File without a Backup
Chapter 24 : Introduction to Network Administration
- Lesson 24.1 : Oracle Network Administration
- Lesson 24.2 : Configuring Oracle Net Service
- Lesson 24.3 : Connecting with the server using OEM
Chapter 25 : Performance Monitoring
- Lesson 25.1 : Introduction to Oracle Performance Tuning
- Lesson 25.2 : Collection of Statistics Using AWR
- Lesson 25.3 : Working with Advisor Central
|