SayproCTR – Daily Report By Eva Sheron Kgosana,Data Analyst On 07 August 2025

Neftaly Daily Activity Report

NeftalyCode : NeftalyCTR

Position : DATA ANALYSIS

Internship/Learnership : Learnership

Full Name : Eva Kgosana

Date : 07/08/2025

In Partnership With : TVET SETA 

SETA/Funder : FOODBEV SETA

University/College : Tshwane South College TVET

1. Overview of the Day’s activities :

Today we focused on SQL coding (DDL + DML)

2. Key Tasks Completed

Task 1 – Creating a table
Task 2 – Insert content
Task 3 – Update
Task 4 – Delete the record
Task 5 – Select and Display

3. Skills Applied or Learned
   Data Manipulation Language.
4. Challenges Encountered

N/A

5. Support/Assistance Required

State if you need help or guidance with anything.

N/A

6. Reflection and Personal Growth

Learnt more new interesting task of Data Analysis.

7. Goals for tomorrow.

To learn more activities.

8.Task to prove my work :

–CREATE TABLE Students (StudentID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), Email VARCHAR(100), Age INT CHECK (16), EnrollmentDate DATE ) ;
–INSERT INTO Students (StudentID, FirstName, LastName, Email, Age, EnrollementDate)
–VALUES (1,’Alice’,’Johnson’,’alice.johnson@email.com’,’20’,’2023-03-10′);
–INSERT INTO Students (StudentID, FirstName, LastName, Email, Age, EnrollementDate)
–VALUES (2,’Bob’,’Smith’,’bob.smith@email.com’,’18’,’2023-03-10′);
–INSERT INTO Students (StudentID, FirstName, LastName, Email, Age, EnrollementDate)
–VALUES (3,’Carol’,’Davis’,’carol.davis@email.com’,’22’,’2023-03-10′);
–UPDATE Students SET FIRSTNAME = ‘Bob’ WHERE AGE = 19;
–DELETE FROM Students WHERE STUDENTID = 3;
SELECT FIRSTNAME,LASTNAME FROM Students WHERE EnrollementDate = ‘JANUARY 31,2023’;