SQL Lab — Database Reconnaissance

🖥️

MySQL Terminal

📊

Schema Viewer

📋

Data Dictionary

📌 OBJECTIVES

○Show all databases

○Select logistics_db

○List all tables

○DESCRIBE each table

○Query information_schema

○Document all findings

0 / 6 complete

MYSQL TERMINAL — root@logistics-db

MySQL 8.0.36 — Lucent Grid Data Lab Connected to: logistics_server (127.0.0.1:3306) Type SQL queries below. Commands are case-insensitive. ──────────────────────────────────────────────

mysql>

SCHEMA VIEWER — logistics_db

Visual overview — updates as you explore the database

DATA DICTIONARY — notes

MISSION BRIEFING

DATABASE RECONNAISSANCE — GLOBEFREIGHT LOGISTICS

SCENARIO

You have just joined GlobeFreight Logistics as a junior data analyst. The previous DBA left no documentation. You have been handed database credentials and told to map the entire schema and produce a data dictionary before the team meeting tomorrow.

DATABASE

Host: 127.0.0.1:3306

User: root (already connected)

Target DB: logistics_db

OBJECTIVES

Run SHOW DATABASES to see what exists
Run USE logistics_db to select it
Run SHOW TABLES to list all tables
Run DESCRIBE <table> on each table
Query information_schema for column metadata
Document everything in the Data Dictionary notepad

USEFUL COMMANDS

SHOW DATABASES;
USE logistics_db;
SHOW TABLES;
DESCRIBE shipments;
DESC customers;
SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'logistics_db';
SELECT TABLE_NAME, TABLE_ROWS FROM information_schema.TABLES WHERE TABLE_SCHEMA='logistics_db';

TIP

The Schema Viewer window updates automatically as you explore. Use the Data Dictionary notepad to record column names, types, and what each table represents.

Display Mode