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. CREATE SEQUENCE syntax
8. DROP SEQUENCE syntax
9. COMPACT TABLE syntax
10. CREATE SCHEMA syntax
11. DROP SCHEMA syntax
12. INSERT syntax
13. DELETE syntax
14. UPDATE syntax
15. SELECT syntax
16. COMMIT and ROLLBACK syntax
17. CREATE USER, ALTER USER and DROP USER syntax
18. GRANT/REVOKE syntax
19. SET syntax
20. DESCRIBE syntax
21. SHOW syntax
22. 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

2.3. SQL Data Types

1. SQL Data Types Introduction
2. SQL Data Types Supported

3. The Database Engine

3.1. Database Configuration Reference

1. Configuration Reference Introduction
2. General Features Settings
3. File System Settings
4. Log Settings
5. Network Configuration Settings
6. Performance/Cache Settings

3.2. 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.3. 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.4. 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