SQL (MySQL Database Operations)

📚 Introduction

My name is Stefano Caramagno, and I'm pleased to present this repository containing exercises on MySQL database operations implemented in SQL programming language.
These exercises were completed as part of the Database and Web Programming course during my Bachelor's Degree in Computer Science and Engineering at the University of Catania.

✨ Features

• Database Creation: Sets up and manages relational databases.
• Table Operations: Creates, modifies, and deletes tables and relationships.
• Data Manipulation: Inserts, updates, and deletes records efficiently.
• Query Execution: Retrieves and processes data using filtering and ordering techniques.
• Joins and Relationships: Combines and structures data across multiple tables.
• Views: Defines virtual tables to simplify data retrieval.
• Stored Procedures: Automates operations with reusable database routines.
• Triggers: Executes actions automatically based on predefined conditions.
• Transactions: Ensures data integrity and consistency in database operations.

🛠️ Tech Stack

• Query Language: SQL for defining, querying, and manipulating relational databases.
• Database Management System: MySQL for relational database creation and management.
• IDE: Visual Studio Code for development and debugging.
• Version Control: Git for tracking changes and managing project versions.
• Repository Hosting: GitHub for storing, sharing, and maintaining the project repository.

🚀 Getting Started

Prerequisites

Ensure you have the following tools installed on your system before proceeding:

• XAMPP: Required to provide a local server environment with MySQL.
• IDE: Required to read and understand code efficiently.
• Git: Used to clone the repository.

Installation Steps

1. Clone the Repository

   To download the repository and navigate to its directory:

   git clone https://github.com/stefanocaramagno/SQL_MySQL_DatabaseOperations.git
   cd SQL_MySQL_DatabaseOperations

2. Start MySQL Server via XAMPP

   To launch the MySQL server using XAMPP:

   • Windows

     C:\xampp\mysql\bin\mysqld --console

   • Linux

     sudo /opt/lampp/bin/mysql.server start

   • macOS

     sudo /opt/lampp/bin/mysql.server start

3. Access MySQL CLI

   To log into MySQL and access the command-line interface:

   • Windows

     C:\xampp\mysql\bin\mysql -u root -p

   • Linux

     /opt/lampp/bin/mysql -u root -p

   • macOS

     /opt/lampp/bin/mysql -u root -p

4. Run an SQL Script

   To execute an specific SQL script (e.g., exercise_01.sql):

   • Windows

     C:\xampp\mysql\bin\mysql -u root -p < "C:\path\to\SQL_with_MySQL_DatabasesManagement\exercise_01.sql"

   • Linux

     /opt/lampp/bin/mysql -u root -p < "/path/to/SQL_with_MySQL_DatabasesManagement/exercise_01.sql"

   • macOS

     /opt/lampp/bin/mysql -u root -p < "/path/to/SQL_with_MySQL_DatabasesManagement/exercise_01.sql"

🌐 Connect with Me

Feel free to explore my professional journey, check out my projects, or get in touch through the following platforms:

⚖️ License

© Stefano Caramagno

Personal and Educational Use Only
All content in this repository is provided for personal and educational purposes only.
Unauthorized actions without explicit permission from the author are prohibited, including but not limited to:

• Commercial Use: Using any part of the content for commercial purposes.
• Distribution: Sharing or distributing the content to third parties.
• Modification: Altering, transforming, or building upon the content.
• Resale: Selling or licensing the content or any derivatives.

For permissions beyond the scope of this license, please contact the author.

Disclaimer
The content is provided "as is" without warranty of any kind, express or implied.
The author shall not be liable for any claims, damages, or other liabilities arising from its use.