---
title: "Getting Started - Database Build and Preparation"
slug: "getting-started-database-build-and-preparation"
updated: 2023-09-26T07:59:33Z
published: 2023-09-26T07:59:34Z
canonical: "docs.datajet.app/getting-started-database-build-and-preparation"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# Database Build and Preparation

### Definitions

- Definition Files
  - [LoadDefinition](/v1/docs/createtablefromfile)
  - [Metadata](/v1/docs/getting-started-categories-and-metadata)
  - [Decodes](/v1/docs/bulkdecode)
  - [Banding](/v1/docs/bulkbanding)

### Data Preparation

- Data Sources
- [RemoteFileManager](/v1/docs/remote-file-manager)

### Loading

- [CreateTableFromFile](/v1/docs/createtablefromfile)
- [LoadTableFromFile](/v1/docs/loadtablefromfile)
- [UpdateTableFromFile](/v1/docs/updatetablefromfile)
- [CreateTableFromWorkbook](/v1/docs/createtablefromworkbook)
- [Merging Data Sources](/v1/docs/deep-dive-merging-data-sources)
- [ScriptEditor](/v1/docs/script-editor)
- BulkLoading
- [Sampling](/v1/docs/qq-how-do-i-create-a-sample-table)
- [Data Source Configuration](/v1/docs/data-source-management)

### Auditing and Inspection

- [Data Audit Report](/v1/docs/data-audit)
- [Field Analyzer](/v1/docs/field-analyzer-introduction)
- [Inspection Reports](/v1/docs/inspection-reports)
- [API: Audit - Summary Report](/v1/docs/audit)
- [API: Audit - Penetration/Profile Report](/v1/docs/audit)

### Joins

- [Joining data](/v1/docs/joins)
- [Join restrictions](/v1/docs/deep-dive-datajet-joins)
- [Join Layers](/v1/docs/addjoinlayer)
- [Casting](/v1/docs/qq-how-do-i-cast-between-different-data-types)

### Derived Data

- Rename
- [Functions](/v1/docs/basic-engineering-functions)
- [Expressions](/v1/docs/expression-field)
- [User Defined Functions](/v1/docs/programmed-field)
- [Decode](/v1/docs/decode-field-custom)
- [Banding](/v1/docs/banded-fields-custom)
- [Aggregates](/v1/docs/aggregate)
- Bulk Processing

### Merge, Append and Filter

- [CopyUp](/v1/docs/copyup)
- [CopyDown](/v1/docs/copydowndiscrete)
- [Appending Data](/v1/docs/loadtablefromfile)
- [UPSERT](/v1/docs/how-to-upsert-data)

### Resolution Levels

- [Resolution Levels](/v1/docs/deep-dive-resolution-levels)
- [Key Tables](/v1/docs/make-key-table)

### Metadata

- [Metadata Properties and Definition](/v1/docs/getting-started-categories-and-metadata)
- [Configuring Metadata](/v1/docs/setprojectproperties)
- [Attaching Metadata](/v1/docs/setpropertiesfromworkbook)
- Auditing Metadata

### Publishing

- [CopySourceTable](/v1/docs/copysourcetable)
- [CreatePackage](/v1/docs/createpackage)
- [Injecting Data](/v1/docs/deep-dive-sharing-data-by-injection)
- [Controlling Data Visibility](/v1/docs/getting-started-controlling-the-display-of-data)