SQL Basics

SQL databases are the traditional way of handling data. SQL databases are well structured, using tables to store data. Now, let's talk about MariaDB—an important SQL database that you've encountered as a Docker image. It's like a well-organized storage system using tables to keep data neat and tidy. This structure is great for many applications. MariaDB handles data efficiently and reliably, which is really useful. So, if you want to learn the basics of a traditional data management system, MariaDB is your go-to choice!

In this lab, we'll dive into the fundamentals of SQL by working with MariaDB using Docker. We'll cover essential operations like:

- Pulling the official MariaDB Image from Docker Registry.

- Using the MySQL Shell for executing commands.

- Performing Create, Read, Update, and Delete (CRUD) operations on a Database.

Prerequisites:

No specific prerequisites are needed for this lab, but having a basic understanding of Docker will make the initial steps clearer. You can refer to this lab for an introduction to Docker: Docker Basics.

Basic Architecture of a SQL Database:

Tables:

• In SQL databases like MariaDB, data is stored in tables. Think of a table as a structured storage unit for related information.

• Tables are organized with rows and columns, creating a clear and organized format for storing data. 

Data Types:

Data types define the kind of data each column can hold. They range from numbers and text to dates and more specialized types.

Primary Keys:

A primary key is a unique identifier for each row in a table. It ensures that each record is distinct and can be easily accessed.

Relationships:

SQL databases excel at managing relationships between tables. Foreign keys establish connections between different tables' data.

Scaling a Database:

SQL databases can be scaled vertically by upgrading hardware. This means boosting memory, CPU, or other resources on a single server.

Refer to these to learn more about SQL Databases:

1. SQL Introduction (w3schools.com)

2. MariaDB Server (SQL Database Server) — MariaDB Documentation

Benefits of MariaDB:

1. Structured Data Management:

   MariaDB's structured approach is perfect for applications that require organized and consistent data storage.

2. Relational Power:

   Learning MariaDB teaches you the art of designing relational databases. This skill is widely used in various jobs involving data.

3. Wide Applicability:

   MariaDB's relational model is utilized in numerous industries, making it an essential skill for many types of projects.

Summary:

Learning SQL Databases like MariaDB introduces you to the world of traditional data management. It's like mastering an organised filing system where data is stored in tables. This skill is valuable for many careers, as it's used in various fields. Now, let's dive into the Lab and get hands-on experience. Get ready to explore the structured world of SQL data management!