This data analysis session focuses on the introduction of SQL, specifically installing the necessary software and understanding fundamental database concepts.

Software Installation

The session began with students working through the installation of the MySQL software suite. The facilitator guided participants through downloading the installer from the provided drive and performing a custom installation to ensure the workbench, server, and shell components were properly configured. Throughout the process, the facilitator provided troubleshooting support, advising students on how to manage previous installations, handle installation errors, and configure security settings such as the root account password.Introduction to SQL and Database Concepts

Once the installation phase concluded, the facilitator provided an overview of SQL and relational database management systems (RDBMS). Key themes included:

• Database Fundamentals: A database is an organized collection of structured data arranged in rows (records) and columns (attributes).
• DBMS Role: A database management system, such as MySQL, is software used to create and manage these databases.
• SQL Commands: The facilitator categorized SQL commands into five functional groups:
  • DDL (Data Definition Language): Manages the structure of database objects (e.g., create, alter, drop).
  • DML (Data Manipulation Language): Modifies data within tables (e.g., insert, update, delete).
  • DQL (Data Query Language): Used primarily by data analysts to retrieve information (e.g., select, from).
  • DCL (Data Control Language): Manages user permissions and security (e.g., grant, revoke).
  • TCL (Transaction Control Language): Manages transactions to ensure data integrity (e.g., commit, rollback).
• Analytical Workflow: The facilitator emphasized that in a professional environment, data analysts typically connect to existing databases rather than building them from scratch. Consequently, the course will focus heavily on DQL for data extraction and analysis.

The session concluded with a brief demonstration of the MySQL Workbench interface, noting that SQL exclusively accepts CSV format for importing datasets during practice sessions. The facilitator also addressed logistical concerns regarding group projects and announced plans for a future reshuffling of project groups.