---
title: "Read all of the ATA Learning tutorials on Databases here!"
---

# Read all of the ATA Learning tutorials on Databases here!

---

# ATA Learning Adam the Automator

Tap to hide

[

ATA Learning

](/)

*   [Home](/)
*   [Tutorials](/tutorials/)
*   [Instructors](/author/)
*   [Advertising](/advertising/)
*   [Recommended Resources](/resources/)
*   [About Adam](/about-adam/)

Search for:  

*   [](https://twitter.com/adbertram)
*   [](https://github.com/Adam-the-Automator)
*   [](https://www.linkedin.com/company/adam-the-automator-llc)
*   [](/feed/)

Show FilterReset Filters

×

Reset Filters

## Tag Search

Search tags

## Tags

*   Databases(12)
*   Microsoft SQL Server(3)
*   PostgreSQL(3)
*   Azure(2)
*   Azure SQL Database(2)
*   MySQL(2)
*   AWS(1)
*   Azure PowerShell(1)
*   Azure SQL(1)
*   Command Line(1)
*   DevOps(1)
*   Google Cloud(1)
*   Information(1)
*   Linux(1)
*   macOS(1)
*   Microsoft Azure(1)
*   Powershell Administration(1)
*   Security(1)

See 0 more

No posts match those tags. Reset the filters and try again.

[![](https://adamtheautomator.com/wp-content/uploads/publisher/2e05d9c85b2b8184bb24f8beaeb7f165/85751120c0fb4909afa44fc19e072a60152e0de73a44e1bba3c2dc4f2c71b424.webp)](/sql-server-upgrade-breaking-changes/)

*   [Databases](/tag/databases/)
*   [Microsoft SQL Server](/tag/microsoft-sql-server/)
*   [Security](/tag/security/)

[

## SQL Server 2025 Upgrades: Avoid These Breaking Changes

Avoid SQL Server 2025 upgrade failures. Master the breaking changes in encryption, TDS, and replication before you plan your migration.

](/sql-server-upgrade-breaking-changes/)

[![Adam Bertram Avatar](https://secure.gravatar.com/avatar/d0b9d42e21e5622713f8b693aa5c0f9244d5f7dd200ed29b8398f52dee5de337?s=192&d=mm&r=g)

Adam Bertram16 min. read

](/author/adam-bertram/)

[![](https://adamtheautomator.com/wp-content/uploads/publisher/3075d9c85b2b811696d7c3fb28215d5b/2632cbcaed949b31f4a9b4c4ea73d850076a5034cf55e309a5815dd451ab0388.webp)](/azure-sql-performance-tuning/)

*   [Azure](/tag/azure/)
*   [Azure SQL Database](/tag/azure-sql-database/)
*   [Databases](/tag/databases/)
*   [DevOps](/tag/devops/)

[

## Stop Scaling Azure SQL: Find Real Performance Issues

Use Azure's built-in diagnostics to find real performance bottlenecks in your Azure SQL Database instead of scaling up immediately.

](/azure-sql-performance-tuning/)

[![Adam Bertram Avatar](https://secure.gravatar.com/avatar/d0b9d42e21e5622713f8b693aa5c0f9244d5f7dd200ed29b8398f52dee5de337?s=192&d=mm&r=g)

Adam Bertram10 min. read

](/author/adam-bertram/)

[![](https://adamtheautomator.com/wp-content/uploads/2026/02/featured_image-20.webp)](/migrate-sql-server-azure-sql-database/)

*   [Azure](/tag/azure/)
*   [Azure PowerShell](/tag/azure-powershell/)
*   [Azure SQL Database](/tag/azure-sql-database/)
*   [Databases](/tag/databases/)

[

## How to Migrate SQL Server to Azure SQL Database

Learn how to migrate SQL Server to Azure SQL Database using Azure DMS and SqlPackage, covering assessment with Azure Arc, schema migration, data movement, and post-migration validation.

](/migrate-sql-server-azure-sql-database/)

[![Adam Bertram Avatar](https://secure.gravatar.com/avatar/d0b9d42e21e5622713f8b693aa5c0f9244d5f7dd200ed29b8398f52dee5de337?s=192&d=mm&r=g)

Adam Bertram6 min. read

](/author/adam-bertram/)

[![](https://adamtheautomator.com/wp-content/uploads/2024/01/mysql-indexes.jpg)](/mysql-indexes/)

*   [Databases](/tag/databases/)
*   [MySQL](/tag/mysql/)

[

## How To Use MySQL Indexes Through Examples

Supercharge your database with MySQL indexes. Optimize queries, boost speed—master the art effortlessly, and elevate performance in this tutorial!

](/mysql-indexes/)

[![Nicholas Xuan Nguyen Avatar](https://secure.gravatar.com/avatar/2788bb1a3f735603f81eca51d68daec56a9d97e805a10268fb2c20afcc76b81b?s=192&d=mm&r=g)

Nicholas Xuan Nguyen6 min. read

](/author/nicholas-xuan-nguyen/)

[![](https://adamtheautomator.com/wp-content/uploads/2023/01/install-postgresql-on-mac.jpg)](/install-postgresql-on-mac/)

*   [Databases](/tag/databases/)
*   [macOS](/tag/macos/)
*   [PostgreSQL](/tag/postgresql/)

[

## How to Install PostgreSQL on Mac

Get started with a powerful database solution and learn how to install PostgreSQL on Mac in this ATA Learning tutorial!

](/install-postgresql-on-mac/)

[![Michael Nguyen Tu Avatar](https://secure.gravatar.com/avatar/1bc5e1d52466fc3739f550c8d78be310684747bf1466a98d698320627ea243e2?s=192&d=mm&r=g)

Michael Nguyen Tu5 min. read

](/author/michael-nguyen-tu/)

[![](https://adamtheautomator.com/wp-content/uploads/2022/09/How-to-Secure-Your-Database-The-Right-Way-via-PostgreSQL-SSL.jpg)](/postgresql-ssl/)

*   [Databases](/tag/databases/)
*   [PostgreSQL](/tag/postgresql/)

[

## How to Secure Your Database The Right Way via PostgreSQL SSL

Learn the ins-and-outs of securing your database to protect information in transit via PostgreSQL SSL in this ATA Learning tutorial!

](/postgresql-ssl/)

[![Nicholas Xuan Nguyen Avatar](https://secure.gravatar.com/avatar/2788bb1a3f735603f81eca51d68daec56a9d97e805a10268fb2c20afcc76b81b?s=192&d=mm&r=g)

Nicholas Xuan Nguyen8 min. read

](/author/nicholas-xuan-nguyen/)

[![](https://adamtheautomator.com/wp-content/uploads/2022/06/How-To-Get-Started-with-Cloud-Databases-and-Amazon-RDS.jpg)](/amazon-rds/)

*   [AWS](/tag/aws/)
*   [Databases](/tag/databases/)

[

## How To Get Started with Cloud Databases and Amazon RDS

Learn to use cloud relational databases with the Amazon RDS service and migrate to the cloud in this ATA Learning tutorial!

](/amazon-rds/)

[![Nicholas Xuan Nguyen Avatar](https://secure.gravatar.com/avatar/2788bb1a3f735603f81eca51d68daec56a9d97e805a10268fb2c20afcc76b81b?s=192&d=mm&r=g)

Nicholas Xuan Nguyen11 min. read

](/author/nicholas-xuan-nguyen/)

[![](https://adamtheautomator.com/wp-content/uploads/2022/06/The-Definitive-Getting-Started-Guide-to-Google-Cloud-SQL.jpg)](/cloud-sql/)

*   [Databases](/tag/databases/)
*   [Google Cloud](/tag/google-cloud/)

[

## The Definitive Getting Started Guide to Google Cloud SQL

Move your databases from on-premise to the power of the cloud and learn how to use Google Cloud SQL to take reliability and performance to the next level!

](/cloud-sql/)

[![Inam Ul Haq Avatar](https://secure.gravatar.com/avatar/c33e3be4c378d7366050eb6c4da41523f27a6c41e9e9d8332a085f42adcdc8e3?s=192&d=mm&r=g)

Inam Ul Haq10 min. read

](/author/inam-ul-haq/)

[![](https://adamtheautomator.com/wp-content/uploads/2022/06/How-To-Back-Up-Restore-Databases-via-the-Mysqldump-Command.jpg)](/mysqldump-command/)

*   [Databases](/tag/databases/)
*   [MySQL](/tag/mysql/)

[

## How To Back-Up & Restore Databases via the Mysqldump Command

Learn how to use the mysqldump command to back-up and restore databases in MySQL to save the day and make sure you don’t lose any data!

](/mysqldump-command/)

[![Nicholas Xuan Nguyen Avatar](https://secure.gravatar.com/avatar/2788bb1a3f735603f81eca51d68daec56a9d97e805a10268fb2c20afcc76b81b?s=192&d=mm&r=g)

Nicholas Xuan Nguyen7 min. read

](/author/nicholas-xuan-nguyen/)

[![](https://adamtheautomator.com/wp-content/uploads/2022/03/Learn-How-to-Install-PostgreSQL-on-a-Ubuntu-Linux-Server.jpg)](/install-postgresql-on-a-ubuntu/)

*   [Command Line](/tag/command-line/)
*   [Databases](/tag/databases/)
*   [Linux](/tag/linux/)
*   [PostgreSQL](/tag/postgresql/)

[

## Install PostgreSQL on a Ubuntu Server for Security Configurations

Learn the different ways to install PostgreSQL on Ubuntu and perform initial configuration to setup a working RDBMS.

](/install-postgresql-on-a-ubuntu/)

[![Nicholas Xuan Nguyen Avatar](https://secure.gravatar.com/avatar/2788bb1a3f735603f81eca51d68daec56a9d97e805a10268fb2c20afcc76b81b?s=192&d=mm&r=g)

Nicholas Xuan Nguyen5 min. read

](/author/nicholas-xuan-nguyen/)

[![](https://adamtheautomator.com/wp-content/uploads/2021/07/Understanding-SQL-Server-Data-Types-And-When-to-Use-Them.jpg)](/sql-server-data-types/)

*   [Databases](/tag/databases/)
*   [Information](/tag/information/)
*   [Microsoft SQL Server](/tag/microsoft-sql-server/)

[

## The Amazing SQL Server Data Types (And When to Use Them)

If you’re storing SQL data, you must understand SQL Server data types. In this article, you’ll learn about all data types and when to use them.

](/sql-server-data-types/)

[![Mayowa Ogungbola Avatar](https://secure.gravatar.com/avatar/fe816d0935f5e3e2782537f1f7847325836b8801afb7051f93c1b715ab3c6f0e?s=192&d=mm&r=g)

Mayowa Ogungbola8 min. read

](/author/mayowa-ogungbola/)

[![](https://adamtheautomator.com/wp-content/uploads/2021/05/How-to-Create-an-Azure-SQL-Database-with-PowerShell.jpg)](/create-azure-sql-database/)

*   [Azure SQL](/tag/azure-sql/)
*   [Databases](/tag/databases/)
*   [Microsoft Azure](/tag/microsoft-azure/)
*   [Microsoft SQL Server](/tag/microsoft-sql-server/)
*   [Powershell Administration](/tag/powershell-administration/)

[

## How to Create Azure SQL Database with PowerShell

Need to automate creating an Azure SQL database and server? Look no further! You’ll learn how to set up all things Azure SQL with PowerShell!

](/create-azure-sql-database/)

[![Gijs Reijn Avatar](https://secure.gravatar.com/avatar/33c241a6b690cdbe352f5d33a308aad0e37d723a74e5d46c42ed6fd7a93e93f3?s=192&d=mm&r=g)

Gijs Reijn3 min. read

](/author/gijs-reijn/)

## Categories

*   [IT Ops](/category/it-ops/)
*   [Cloud](/category/cloud/)
*   [DevOps](/category/devops/)
*   [Home Ops](/category/home-ops/)
*   [Information Security](/category/infosec/)
*   [Software Development](/category/software-development/)

## Site

*   [Home](/)
*   [Tutorials](/tutorials/)
*   [Instructors](/author/)
*   [Advertising](/advertising/)
*   [Recommended Resources](/resources/)
*   [About Adam](/about-adam/)

Copyright 2026© ATA Learning | [Privacy Policy](/privacy/)
