Yash Kumar yadav

Current Location :- Narnaul,Haryana

Date of birth June :- 16/06/2002

Gender :- Male

• Python 101 for Data Science
• SQL Injection Attacks
• Ethical Hacking Essentials
• Foundations of Cybersecurity
• The Complete SQL Bootcamp

Keylogger :   

• Developed a python based keylogger application for windows .
• Utilized the ".pyw" extension to ensure the program runs silently in the background.
• Program records user keystrokes and saves them to a file. Sends recorded keystrokes to a specified email address.
• Primarily designed for monitoring purposes, including parental control.

Registration Page  

• It involved creating User Registration and Sign-Up page using MERN Stack.
• Designed a responsive user interface to enhance user experience across devices.
• Enabled local host database connectivity for efficient data storage and retrieval.

SQL :  

 Key points what I am learned in SQL projects:-    

• SQL queries using SELECT, WHERE, JOIN, GROUP BY, and ORDER BY to extract meaningful insights from large datasets
• Used INNER JOIN, LEFT JOIN,RIGHT JOIN and FULL JOIN to combine data from multiple tables for reporting and analysis
• Applied DISTINCT and LIMIT clauses to refine datasets and improve performance
• Utilized aggregate functions like SUM(), AVG(), COUNT(), MAX(), and MIN() to generate KPIs and summary statistics
• Built summary tables to track trends over time using EXTRACT() functions.
• Ensured data quality by applying validation rules, normalization (up to 3NF), and implementing constraints such as PRIMARY KEY, UNIQUE, and FOREIGN KEY.
• Managed data updates and integrity through INSERT, UPDATE, and DELETE operations in both staging and production environments.