Oracle Books

Apache

The world´s most commonly used Web Server.
Download, install, configure and use Apache yourself.
Modify the httpd.conf file to control Apache.
Create and control virtual domains.
Create user defined Apache Error Pages.
Manipulate Apache´s .htaccess file.

PHP

The internet´s extensively used programming language.
Download, install, configure and program in PHP yourself.
Access MySQL databases using mysqli.
Deliver dynamic HTML content on demand.
Manipulate the look and feel of any HTML page.
Grasp and master PHP coding techniques.

MySQL

An enterprise strength RDBMS
Cost of ownership is FREE.
Download, install, configure and use MySQL yourself.
Create databases. Create and manipulate tables.
View, Insert, Update and Delete table data.
Work with joins and tons more. . .

JoomlaVarsity

Learn to use Joomla.
Build / Customized websites using Joomla CMS
Well structured tutorials.
A helpfull user forum in which your queries get resolved.
Joomla extensions demystified.

WordpressVarsity

Learn to use Wordpress a Blog or CMS.
Build / Customize Blogs & Websites using Wordpress.
Well structured tutorials.
A helpfull user forum in which your queries get resolved.
Wordpress extensions demystified.

Apache PHP MySql Joomla Wordpress

Oracle Books

Please click on a book's thumbnail to read a bit about the book.

Understanding Oracle teaches the Oracle in any easy and interactive way and can be used as a reference book as well as a self-study guide to learn and master SQL and PL/SQL concepts and their implementation. It clearly discusses the RDBMS concepts and their implementation in Oracle. It teaches Oracle from the beginner’s level that can be understood by novices. It requires no previous knowledge of any RDBMS. The book provides examples that help in understanding the concepts and information about integrity constraints in Oracle.

It also provides in-depth discussion in PL/SQL programming and its implementation. It discusses object-oriented design of Oracle and implements various database objects, such as table, views, packages, functions, procedures, triggers, synonyms and sequences. It explains the installation of Oracle 9i Server and Client. The book has interesting exercises to test the theoretical as well as practical knowledge. It is accompanied by a CD that contains the source codes of programs in the chapters as well as in the exercises.

The Topics Covered

Introduction to Oracle and RDBMS
Introduction to SQL
DDL and DML Statements
Views in Oracle
Understanding DCL and TCL Statements
PL/SQL Programming
Exception Handling in Oracle
Cursors in Oracle
Procedures, Functions and Packages
Triggers in Oracle
Collections and LOB Types
Object Oriented Programming in Oracle

Oracle is constantly evolving, and getting better with each evolutionary cycle. Today the corporate world wants to Internet enable their commercial applications, hence Oracle has responded by offering Oracle 10g DS. The book has been written to provide genuine domain knowledge to programmers who wish to learn web based commercial application development using Oracle 10g Developer Suite as a front-end and Oracle 10g Database as the back-end.

Learning the Oracle 10g DS – Forms toolbox is done through the construction of a Supplier module belonging to an Inventory system. This is something application developers would definitely appreciate. Finally, the concepts learnt are reinforced by building and later deploying the Manufacturing And Sales System on the Application Server. When the examples in each chapter are worked through they will build a strong, forms based, application development foundation using Oracle 10g DS, as the toolbox of choice.

The Topics Covered

Setting Up the Framework
Understanding The Framework
Setting Up Oracle Database 10g
Setting Up Oracle 10g Developer Suite
Configuring Net Assistant
Developing Forms In Oracle 10g DS
An Introduction To Oracle 10g DS
Built-In Wizards
Handling Data
Starting With Oracle 10g DS – Forms
Working With A Master / Detail Form
Working With PL/SQL Libraries
Working With Menus
Developing Reports In Oracle 10g DS
Working With Reports
Working With A Master / Detail Report
Working With A Parameterized Report
Working With Graphs
Developing Projects In Oracle 10g DS
Project Specifications – Purpose, Modules, Designs
Project Planning – Specifications, Test Data, Validations, Micro Help
Project Processing
Project Deployment

Oracle is constantly evolving, and getting better with each evolutionary cycle. Today the corporate world wants to Internet enable their commercial applications, hence Oracle has responded by offering Oracle 10g with HTML DB. This is a combination of an excellent RDBMS and a Forms based RAD tool that uses a Browser as the client side runtime environment. All this at the cheapest cost of ownership to company for the rapid deployment of production quality, Forms based, commercial applications on the Internet / Intranet.

This book explains the latest, additional SQL and PL/SQL attributes that Oracle 10g brings to the programmers world. Then goes on to explain the Forms based, application development using HTML DB, Oracle’s Forms based RAD tool. Each topic is very liberally sprinkled with examples that are mapped to applications, which fit in the real world.

The Topics Covered

Understanding the framework
Setting up oracle database 10g
Setting up HTMLDB
Overview of oracle databases 10g
Interactive sql part-1
Interactive sql part-2
Interactive sql part-3
Interactive Isql plus
Introductions to pl/sql
Using regular expressions
Tablespaces DBA and user
Overview and getting started
Working with forms (The automatic way)
Working With Forms (The Manual Way)
Working with master details user interfaces
Building Reports And Charts

SQL / PL-SQL The Programming Lang of Oracle

The book has been written to provide an excellent grounding to those who wish to learn SQL and PL/SQL using Oracle. Like all his earlier books this book also has several illustrative examples, which have a logical link between them.

Each set of examples helps build skills that will take the reader to the next set of examples, which in turn leads upwards until a strong programming foundation using the natural language of Oracle has been established.

Learning of SQL & PL/SQL is done thought the construction of a Retail Banking System. The skills thus developed are implemented via hands on exercises based on the construction of a Sales Order System.

The Topics Covered

Setting Up Oracle 9i
Database Concepts
Installation Of Oracle
Post Installation Steps Setting Up The Interactive SQL*Plus Tool
Setting Up The Business Model
Business Model For Retail Banking
Project Planning For Retail Banking
Structural Querying Language
Using Interactive SQL To Create Tables& Insert& View& Modify or Delete Table Records
Using Interactive SQL To Set Data Constraints And Data Integrity
Performing Arithmetic& Logical or Search Operations& Create Functions And Manipulating Dates
Create Data Groups& Subqueries& Joins, Unions with the Intersect and Minus Clause
Advance Structural Query Language
SQL Performance Tuning Security Management Using SQL
OOPS In Oracle Advance Features In SQL*Plus
Procedure Language/ Structural Query Language
Introduction to PL/SQL PL/SQL Transactions
PL/SQL Security PL/SQL Database Objects

Breaking News

A training portal is going live shortly.

Learn With Ivan Bayross
Published author and tech addict. Sought after visiting faculty at Engineering and MBA colleges.

Well laid out, detailed tutorials, with practice exercises, crafted by Ivan Bayross will be available.

Current Topics covered:
Apache
PHP
MySQL
Joomla
Wordpress
More tutorials will be rolled out over time.

Learn from the best.

Access will be strictly via registration. Only the first 50 registrants will be accepted for mentoring by Mr. Ivan Bayross. Then registrations will close.

Create your account, adjacent.

Go from concept to competence.

Newsletter Subscription