# Guides

> The concepts of API Maker explained one by one - schema and data, your code and its tools, security and access, settings, performance and operations with Index Maker, the connection strings of every database and the deprecated UI Maker.

Source: https://docs.apimaker.dev/v1/docs/guides/index.html

The [APIs](/v1/docs/apis-all/overview.html) tab tells what each API does. These guides tell how the pieces around them work, in the order you meet them.

    <a class="am-card am-card--green" href="/v1/docs/schema/schema.html">{ }Schema and dataThe schema of a table, auto increments, optimistic concurrency control, multi-tenant databases and migration scripts.</a>
    <a class="am-card am-card--purple" href="/v1/docs/pre-defined-terms/global-object-g.html">g.Your codeThe global object g, process initializers, test cases, developer tools, Git, developer accounts, code search and browsers with Playwright or Puppeteer.</a>
    <a class="am-card am-card--red" href="/v1/docs/secrets/secrets.html">⛨Security and accessSecrets, groups, API users, role based permissions, the security report, single sign-on and every auth provider.</a>
    <a class="am-card am-card--amber" href="/v1/docs/settings/databaseSettings.html">⚙SettingsCaching, access type and auth providers per database, table and API ; sandbox settings ; the configuration of API Maker.</a>
    <a class="am-card" href="/v1/docs/features/automatic-caching.html">↗Performance and operationsCaching, Index Maker and automatic indexes, logs, dashboards, internationalization, deploying a new version of API Maker.</a>
    <a class="am-card am-card--green" href="/v1/docs/Database-connection-string/mongodb-connection-strings.html">⛁Connection stringsThe connection string of MongoDB, MySQL, MariaDB, PostgreSQL, Oracle and SQL Server, with SSL and cloud examples.</a>
    <a class="am-card am-card--amber" href="/v1/extensions/ui_maker/introduction.html">▦UI MakerGrids and forms generated from your tables, configured in JSON. Kept for the projects which use it.deprecated</a>

## Read in this order

1. [Table schema](/v1/docs/schema/schema.html) : how a table is described and what the schema APIs do with it.
2. [Global object g](/v1/docs/pre-defined-terms/global-object-g.html) : the one object your code gets.
3. [Secrets](/v1/docs/secrets/secrets.html), then [API group permission](/v1/docs/apis-security/api-group-permission.html) and [Handle role based permissions](/v1/docs/authorization/handle-role-based-permissions.html) : who may do what.
4. [Settings](/v1/docs/settings/databaseSettings.html) : caching, access type and auth providers at every level.
5. [Automatic caching](/v1/docs/features/automatic-caching.html), [Index Maker](/v1/extensions/index_maker/introduction.html), [Log profile](/v1/docs/logs/log-profile.html) and the dashboards : running it.
6. [Git integration](/v1/docs/Git/git.html) and [Deploy API Maker](/v1/docs/features/deploy-api-maker.html) : shipping it.