Database Programming Using Matlab

Learn how to build Matlab program with database interaction. If you have experience with database, this book will help you how to write Matlab and to access database server. This book covers three database servers: MySQL, SQL Server, and Oracle.

**TOC (short)**

1. Preparing Development Environment

2. Hello World - Connecting to Database Server

2.1 Database Configuration

2.2 Connectivity Testing

3. Database Table Operations

3.1 What are Table Operations?

3.2 Inserting Data

3.3 Reading Data

3.4 Updating Data

3.5 Deleting Data

3.6 Finding Data

4. Stored Procedures

4.1 Creating Stored Procedure

4.2 Executing a Stored Procedure

4.2.1 MySQL and MS SQL Server

4.2.2 Oracle

4.3 Stored Procedure with Parameters

5. Working with Image and Binary Data

5.1 Image and Binary Data

5.2 Inserting Data

5.3 Reading Data

6. Transactions

6.1 What is a Transaction?

6.2 Case 1 - Transaction without Committing

6.3 Case 2 - Transaction with Committing

6.4 Case 3 - Rollback