Database Programming Using Matlab

Nonfiction, Computers, Database Management, Data Processing, Programming, Programming Languages

• Author: Agus Kurniawan
• ISBN: 1230000140369
• Publisher: PE Press
• Publication: June 8, 2013
• Language: English

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**
1. Preparing Development Environment
1.1 Database Toolbox
1.2 Testing Environment
2. Hello World - Connecting to Database Server
2.1 Database Configuration
2.1.1 MySQL
2.1.2 Microsoft SQL Server
2.1.3 Oracle
2.2 Connectivity Testing
2.2.1 Testing for Matlab and MySQL
2.2.2 Testing for Matlab and Microsoft SQL Server
2.2.3 Testing for Matlab and Oracle
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.1.1 MySQL
4.1.2 SQL Server
4.1.3 Oracle
4.2 Executing a Stored Procedure
4.2.1 MySQL and MS SQL Server
4.2.2 Oracle
4.3 Stored Procedure with Parameters
4.3.1 Creating A Stored Procedure
4.3.2 Executing Matlab and MySQL/SQL Server
4.3.3 Executing Matlab and Oracle
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