Database Engineering & Grid Computing

Relational databases often drive company-critical and Web-enabled applications. This course provides a comprehensive foundation for designing, building, and working with relational databases. In addition it also focuses on Grid computing which is a new IT architecture that adapts to your changing business needs. With enterprise grid computing you can build a powerful data center with a variable cost structure that can be adjusted as per the requirement.

In-depth practical exposure to Spatial database management through Oracle 10g will be provided for GIS Customization.

Database Essentials

• File Oriented Approach Vs Database Oriented Approach
• Data Independence
• Data Dictionary and its importance

Data Model & Relation Data Model

• Hierarchical Model
• Network Data Model

Database Design

• Entity-Relationship Data Model

Normalization

• Normal Forms

Embedded SQL and APIs

• The Guest Book Program
• Handling Windows Events
• Handling Errors And Exception

ACID property

• Database Concurrency

Database Recovery

• Transaction logs
• Shadow paging

Distributed Database

• Data Fragmentation
• Data Replication

Overview of SQL Server

• Integration with Windows 2000

Exploring Transact-SQL

Designing and Implementing Databases

• Estimating the Space Requirements for Databases
• Configuring the Default

Creating and managing Tables

Designing and Implementing Data Integrity

• Declarative Data Integrity
• Implementing Constraints

Designing Advanced Queries

• Designing Correlated Sub queries

Implementing Distributed Queries

• Establishing Linked Servers
• Modifying Data Through Distributed Queries

Optimizing Queries

• Exploring the Query Optimizer
• Using Indexes to Optimize Queries

Designing Views

• Nested Views
• Creating a View Based on Joined Tables

Creating stored Procedures

• System and Extended Stored Procedures

Using Functions

• Working with Aggregate Functions
• Designing and Creating User-defined Functions

Creating Triggers

• Designing and Implementing Triggers

Understanding Transactions and Locks

• Designing Transactions
• Creating Explicit Transactions
• Managing Locks

Transaction and XML Web Services

• Updating SQL Server Data by Using XML
• Using DiffGrams

Performance Tuning and Optimization

• Designing Federated Database Servers
• Optimizing Utility and Tool Performance
• Optimizing Server Performance

Replication

• Administering and Monitoring Replication

Web Assistant Wizard

Oracle 10g Reporting Services

Object-Relational database

• Naming Conventions for Objects
• System Functions

SQL Functions

Advance SQL Function

SQL Queries

Joining Tables

Sub Queries

Creating and maintaining tables

Create Views and indexes

Database security

PL/SQL Introduction

SQL * Plus

Data Type

Building a Report in SQL * Plus

Module Objective:

• Apply normalization to data for effective, stable database design
• Build a relational database from the logical database design
• Access data in a relational database using simple SQL queries
• Getting Hand-On with Oracle 10g
• Flexibility to meet changing business needs with the help of Grid Computing