My Work and Projects
Welcome to My Work and Projects page! Here, I'll be showcasing my recent ventures into the world of computer science. As I continue learning and refining my skills, stay tuned for more exciting projects to come!
MySQL
Experienced in SQL functions after reading "SQL for Data Scientists" by Renee M.P. Teate.
SELECT, WHERE, CASE, JOINS, GROUP BY,ORDER BY,MIN, MAX, COUNT, AVG, BETWEEN, IN, IS NULL, ROW_NUMBER, RANK, LAG, LEAD, EXTRACT, DATE_ADD, DATE_SUB, CTEs, and UNION.
After going through the above book, I was eager to put my newfound skills into practice. I developed a project to solve a common, yet time-consuming problem we encounter in our daily lives. Check out the project codes and a video explanation in the link below.
Microsoft Excel
Pivot Table, Pivot Charts, Slicers, Timelines, Heat Maps, etc.
Python
Currently diving into "Python Crash Course" by Eric Matthes, where I've already grasped fundamental Python functions such as variables, conditionals, loops, functions, file handling, and object-oriented programming. Excited to continue learning and applying these skills in real-world projects
Digital Literacy
Enhanced my tech skills through Digital Literacy course under the guidance of Sheba Philip George; mastered Google advanced search, credible resource evaluation, email etiquette, and basics of HTML/CSS. Gained practical skills in Excel and webpage creation using HTML elements and CSS styling
Linux
Currently diving into "LINUX BASICS FOR HACKERS," I've acquired foundational Linux skills, including essential commands like ls, cd, pwd, rmdir, rm, mk, cp, ifconfig, adding controlling file and directory permissions, process management ,and Nmap. These skills have expanded my understanding of Linux for networking, scripting, and security in Kali Linux.
I recently completed a bash script project using nmap, which allows users to input an IP address, the last octet of the IP address, and a port number. The script then performs a targeted scan for open ports on the specified IP address.