Technical Books

We are working on the detailed description of this book, we will update this section soon.

This book covers everything developers need to know about indexes and nothing more. To be more precise, the book covers the most important index type only: the B-tree index. The structure of the book is tailor made for developers; most chapters correspond to a particular part of an SQL statement.

This note covers the following topics: relational databases overview, SQL overview, dml data retrieval select statement examples, dml data retrieval select statement criteria, sql for select exercises with criteria, ddl create table statement from existing table, ddl create table statement with column definitions, ddl create table statement syntax, dml insert statement, ddl create index statement, ddl alter table statement, ddl drop statement, dml update statement, dml delete statement.

This note explains the following topics: Basic Sql Statements, Restricting and Sorting, Join Statements, Multiple Column Subqueries, isqlPlus, Types of Sql Functions, Character Functions, Number Functions, Single Row Numeric Functions, Row Functions, Subqueries, Conversion Functions, Union, Alter Table and Create Table.

This note covers the following topics: Multiple simultaneous changes to data, Uses of Databases, Ways to Use SQL, Some Relational Database Concepts ,Variable Types, CREATE TABLE statement, Entering observations into a table, Comparison Operators, Updating a Table , The SELECT statement, Selecting based on Summaries, Subqueries, Making Tables from Queries, SELECT with multiple tables.

This note explains the following topics: Structured Query Language, Advanced SQL, PLSQL, Control Structures, Stored Procedures, Dynamic SQL.

We are working on the detailed description of this book, we will update this section soon.

This note covers the following topics: Oracle Database deployment, Database Cloud Services, Database editions, Supported platforms, Database options and features, Oracle Certification Program, Market position, Physical and logical structures, Database schema, Process architectures, Oracle processes, User processes, connections and sessions, Concurrency and locking.

RAC Attack is a free curriculum and platform for hands-on learning labs related to Oracle RAC (cluster database). The goal of this workbook is to help students learn about Oracle RAC cluster databases through guided examples.

This note covers SQL, SQL Plus, Oracle data dictionary, Application programming, Integrity constraints and triggers and system architecture.

The contents include: Getting started with Oracle Database, Data Dictionary, Dates, Working with Dates, DUAL table, JOINS,Handling NULL values, String Manipulation, Update with Joins, Functions, Statistical functions,Window Functions, Creating a Context, Splitting Delimited Strings, Collections and Records, Object Types, Loop, Cursors, Sequences, Indexes, Hints, Packages, Exception Handling, Error logging,Database Links, Table partitioning, constraints, Autonomous Transactions, Oracle MAF, level query,Hierarchical Retrieval With Oracle Database C, Data Pump, Bulk collect, Real Application Security,Assignments model and language, Triggers, Dynamic SQL.

We are working on the detailed description of this book, we will update this section soon.

We are working on the detailed description of this book, we will update this section soon.

We are working on the detailed description of this book, we will update this section soon.

We are working on the detailed description of this book, we will update this section soon.