Database-Table-Operations

DDL Operations Lab: Building and Managing Tables

Project Status: Completed successfully as part of the AWS re/Start program.

Hello! This project documents my hands-on work with Data Definition Language (DDL) to manage database and table structures. I used a controlled MariaDB environment on an AWS Command Host to solidify my understanding of database schema management.

Lab Goals The main goal was to practice foundational skills for a Database Operations role. I focused on:

• CREATE: Building a new database and defining tables with correct data types and constraints.
• SHOW: Verifying my work by listing databases and inspecting table structures.
• ALTER: Modifying existing table structures, like correcting a spelling mistake.
• DROP: Safely deleting tables and cleaning up the database.

My Lab Environment & Tools

• Database: MariaDB Server (v10.5.29) - where I performed DDL operations.
• Environment: AWS EC2 (Command Host) - my remote workstation.
• Interface: Terminal / SQL Client - how I connected and sent SQL commands.
• Language: SQL (DDL) - my essential tool for defining and manipulating database structures.

My Step-by-Step Experience

1. Connecting to the Host: I securely connected to the AWS Command Host and logged into the MariaDB server.
2. Creating My Database & Tables: I created the "world" database and built two tables: "country" and "city".
3. Fixing Mistakes with ALTER: I corrected a typo in the "country" table using ALTER TABLE.
4. Cleaning Up with DROP: I deleted the tables and database using DROP TABLE and DROP DATABASE.

Key Commands I Practiced

• CREATE DATABASE world;
• CREATE TABLE world.country (Code CHAR(3) NOT NULL PRIMARY KEY, Name CHAR(52) NOT NULL, Continent ENUM('Asia', 'Europe', 'North America', 'Africa', 'Oceania', 'Antarctica', 'South America'));
• ALTER TABLE world.country RENAME COLUMN Conitinent TO Continent;
• DROP TABLE world.city;
• DROP DATABASE world;

About Me My name is [Mokgadi Selepe], and this project was completed as part of the AWS re/Start program. This lab helped me move from theory to practical application, and I'm proud of the outcome. Feel free to reach out with questions or to chat about database operations! (mokgadi9939@gmail.com)