IshayaJAyock/Women_in_Machine_Learning_presentation_2024

This repository keep track of my women in machine learning presentation document, Accra Branch # Women in Machine Learning Presentation 2024 This repository keeps track of my women in machine learning presentation document, Accra Branch. # Mastering SQL for Data Science - Project Files This repository contains all the necessary files for the **Masterign SQL for Data Science** presentation and practical session. Below is a detailed description of each file and its purpose. ## Overview The project demonstrates: - Normalize a dataset for machine learning into three separate tables. - Writing SQL queries to retrieve data for analysis. - Understanding the importance of database normalization and querying skills in data science workflows. The dataset represents a simulated customer purchase system. It includes information about customers, products, and purchases. ## File Descriptions ### 0. ** Presentation_wim.pdf** This is the presentation slide used during the program. It covers data, databases, Datawarehousing, OLAP, OLTP, Data Science, SQL etc. ### 1. **create_customerpurchase_dat.sql** - **Purpose**: Creates and populates a database for the customer purchase system. - **Tables Created**: - `Customer`: Stores customer information. - `Product`: Contains product details. - `Purchase`: Tracks purchase records, linking customers to the products they bought. - **Usage**: Execute this script to initialize and populate the database with sample data. ### 2. **customer.sql** - **Purpose**: Contains SQL commands specific to creating and managing the `Customer` table. - **Details**: - Includes table creation commands, data insertion, and constraints. - Ensures that customer data adheres to the schema. ### 3. **product.sql** - **Purpose**: Defines and manages the `Product` table. - **Details**: - Includes commands for creating the table and populating it with sample product data. - Establishes the schema for product-related information. ### 4. **purchase.sql** - **Purpose**: Focuses on the `Purchase` table. - **Details**: - Creates a table to link customers an …