Instant Oracle

Instant Oracle

This indispensable handy little book is a must have for programmers, database administrators and everyone working with Oracle databases. It is a portable guide that addresses the language’s complexity with an easy to follow format and numerous real world examples based on the most commonly used business database models. 

It serves as a concise and quick reference to those who are stuck and need an answer quickly. It also helps those who just want to be sure that they are applying the SQL syntax correctly.

Inside, you’ll find:
SQL Plus
Data types
Working with tables
Data constraints
Inserting, Viewing, Updating and Deleting data
Operators
Character/String, Numeric, Date functions
Grouping data
Subqueries
Joins
Union, Intersect And Minus

This small and handy book conveniently stays in your back pocket or somewhere near your keyboard. Instant Oracle efficiently condenses the details of its best selling companion book, Oracle For Professionals that delivers all of the basics and at the same time, serves those who want to harness the unexploited, overlooked power of Oracle SQL and PL/SQL.

Advertisements

Hibernate 3 For Beginners

Hibernate 3 For Beginners

Designed for beginners and intermediate developers, this book teaches Hibernate 3 from the ground up with an aim to get the reader up to speed with Hibernate as quickly as possible. It delves deeply into the core of the Hibernate 3 framework, providing a sound understanding of the components that make up the framework and the way they interact with each other.

This book uses the learning by doing pattern with a lot of ready-to-use examples. This pattern has proven to be best approach for beginners. Most [if not all] of the concepts that you will find in this book are demonstrated using well described and easy to understand examples, yet sophisticated enough to demonstrate Hibernate in a real-world context.

Finally, a web based application is developed to re-enforce all the learning that took place throughout the book. Not only this, the book also teaches porting the same application to another database, switching from Hibernate’s native API to Java Persistence API and integrating with Struts2. This will definitely help developers to quickly get started with building real-world Web applications using the Hibernate 3 framework.

ISBN 10: 81-8404-705-3

ISBN 13: 978-81-8404-705-9

Edition: First

THE TOPICS COVERED IN THE BOOK

Introduction

Persistence And Object/Relational Mapping, Introduction To Hibernate

Getting Started

Writing The First Application, Using Hibernate Plugins For NetBeans

Understanding Configuration And Mapping

Configuring Hibernate, Getting Started With Mapping, The Database Identity, Associations, Collections, Concurrency Control Using Versioning, Annotations

Working With Hibernate

Sessions, Transactions, Implementing Connection Pooling

The Hibernate Query Language

The Basics Of Hibernate Query Language, Joins In HQL, The Query Interface, Criteria, Pagination, Named Queries, Native SQL Queries, Filters

Application Development With Hibernate

Customer Database Using JSP, Using Java Persistence API With Hibernate, Customer Database Using Struts2, Switching The Database [MySQL To Oracle]

Appendix

Installing The NetBeans IDE

THE LEARNING THAT TAKES PLACE

Building a web application:

o Using Hibernate 3

o Using Java Persistence API with Hibernate 3

o Using Struts 2 with Hibernate 3

Using the NetBeans IDE to develop Hibernate based applications

Porting an application developed using Hibernate to another database [MySQL to Oracle]

Reverse Engineering POJOs and Mapping Documents from Database Tables

Pagination using Hibernate 3

Connection Pooling using:

o An Application Server [Glassfish] via JNDI

o Hibernate’s built-in mechanism [C3P0]

CONTENTS OF THE CD-ROM

Setup files for JDK 6

NetBeans IDE 6.5

Hibernate Core 3.x

Hibernate Annotations 3.x

Hibernate EntityManager 3.x

Struts 2.x

MySQL Community Server 6.x

Oracle Database 10g XE

JDBC Drivers

Library files for Display Tags

Source code for the examples covered in this book.

Struts 2 with Hibernate 3 Project For Beginners

This book aims serving students, developers, technical leads and to some extent project managers or consultants by demonstrating a structured documented modestly sized project.

Learning the project development and documentation is done through the construction of an Online Shopping Cart [integrated with a payment gateway] using MySQL Community Server as the data store with Java Server Pages as the delivery mechanism, Struts 2 as the framework and Hibernate 3 as the Object Relational Mapping library.

Framework migration [Struts 2.0.x to 2.1.x] and the art of migrating the application across databases [with the help of Hibernate] is what the readers would definitely appreciate.

ISBN 10: 81-8404-696-0

ISBN 13: 978-81-8404-696-0

Edition: First

Downloads

Sample Chapter TOC

THE TOPICS COVERED IN THE BOOK

Understanding The Framework

Setting Up The Environment

About The Project

Software Design Documentation

End User Manual

Running The Project

Process Flow

Migration

Appendix

THE LEARNING THAT TAKES PLACE

Shopping cart

Google checkout

Tag clouds

Session management

Directory

Search

Sending emails

Files in BLOB

Validations

JavaDoc

Data Access Object design pattern

Access based user management

Hibernate based pagination

Restricted page access protection

User authentication interceptor

Custom error pages

Double form submission prevention

Application migration from Struts 2.0.x to 2.1.x

Database migration from MySQL to Oracle

CONTENTS OF THE CD-ROM

Setup files for JDK 6

MySQL Community Server 6

MySQL Connector/J

Oracle Database 10g XE

Oracle JDBC

Struts 2.0.x

Struts 2.1.x

Hibernate 3

Source code for the project [for Struts 2.0.x and Struts 2.1.x]

SQL Import Scripts for MySQL and Oracle

 

 

 

Designed for new and experienced developers, this book is an essential guide for putting Oracle SQL and PL/SQL to work. It provides all of the basics you would expect to find in an introductory text and at the same time serves those who want to harness the unexploited, overlooked power of Oracle SQL and PL/SQL with an easy to follow format and numerous real examples based on most commonly used business database models.

It delves deeply into new features found in Oracle Database 11g, the next incarnation of Oracle’s flagship database management system along with existing features found in Oracle Database 9i and 10g.

ISBN 10:81-8404-526-3
ISBN 13: 978-81-8404-526-0

Edition:
First

Downloads
Sample Chapter
                                                     TOC

THE TOPICS COVERED IN THE BOOK


Overview Of Oracle Database
Introduction, Architecture, Installation, Tablespace/User Management, SQL Plus, SQL Developer
 

Basics Of SQL
Entity Relationship Diagram, Data Types, Working With Database Tables, Multi-Table Insert Statements, Merging Rows, Altering Table Structures, Synonyms, External Tables, Data Constraints
Working With Data
Operators, Character/String Functions, Number Function, Date Functions, Grouping Data, Subqueries, Joins, Union, Intersect And Minus, Analytic Functions, Modeling Data, Hierarchical SQL Queries, If, then And Else, Pivot/Unpivot Operators, Regular Expressions, RowID And RowNum 

SQL Performance Tuning
Indexes, Views, Clusters, Sequences

Beyond The Basics
Flashback, Objects And Collections, Oracle Text, XML  

PL/SQL
Introduction To PL/SQL, Transactions, Cursors, Procedures And Functions, Packages, Triggers, Automatically Generating And Assigning Primary Key Values, Dynamic SQL, DML Error Logging

Backup, Restore And Data Loading
IMP And EXP, Data Pump – IMPDB And EXPDB, SQL*Loader

Application Development
Java, PHP, Pro*C/C++

Scripting In Oracle
SQL Scripts, PL/SQL Scripts

Data Warehouse
Oracle Warehouse Builder

Appendix
Sample Data, Installing Oracle Database 10g XE, Interview Questions

CONTENTS OF THE CD-ROM
Setup files for Oracle database 10g eXpress Edition.
Video Footage of Installing Oracle Database 10g [XE] and 11g.
Source code for examples in this book.