Home / Documentation / FAQ / Support / Download Mckoi SQL Database Manual

1. Tutorials

1.1. Getting Started

1. Before You Begin
2. Creating A Database
3. Database Configuration

1.2. Mckoi SQL Database as an embedded application

1. Using an embedded Mckoi Database from within your Java(TM) application
2. Using the JDBC Query Tool on a local database

1.3. Mckoi SQL Database as a multi-user server

1. Starting the Database Server
2. Using JDBCQueryTool to access the database server
3. Accessing the server from a Java client application

2. Language Reference

2.1. SQL Syntax

1. SQL Syntax Introduction
2. CREATE TABLE syntax
3. ALTER TABLE syntax
4. DROP TABLE syntax
5. CREATE VIEW syntax
6. DROP VIEW syntax
7. COMPACT TABLE syntax
8. CREATE SCHEMA syntax
9. DROP SCHEMA syntax
10. INSERT syntax
11. DELETE syntax
12. UPDATE syntax
13. SELECT syntax
14. COMMIT and ROLLBACK syntax
15. CREATE USER, ALTER USER and DROP USER syntax
16. GRANT/REVOKE syntax
17. SET syntax
18. DESCRIBE syntax
19. SHOW syntax
20. SHUTDOWN syntax

2.2. Internal SQL Functions

1. Functions Introduction
2. Mathematical Functions
3. String Functions
4. Aggregate Functions
5. Security Functions
6. Branch Functions
7. Date/Time Functions
8. Misc Functions

3. The Database Engine

3.1. Transactions

1. Transactions Introduction
2. Serializable Isolation and the Multi-Version Data Model
3. Concurrent Commit conflicts
4. Failure recovery
5. Using transactions with the Mckoi JDBC driver
6. Transaction performance
7. Transaction Examples

3.2. Mckoi JDBC(TM) Driver

1. The JDBC(TM) Interface
2. Installing the Driver
3. The Connection URL
4. How ResultSet works
5. Driver Concurrency

3.3. Database Control API

1. Control API Introduction
2. The Basics - Starting and Closing a database session
3. Binding a TCP/IP JDBC server to a database session
4. Advanced uses of the Control API