A tech blog built to scale ,covers essential topics in networking ,IT support ,security,operating systems and real world troubleshooting -written from my hands on experience.

Config files for my GitHub profile.

This repo is for a a web-based version using HTML, CSS, and JavaScript with a clean, modern interface for an electronic ticket generation system

This repo is about SQL views which are virtual tables created from the result of a SELECT query. They don't store data themselves but provide a way to simplify complex queries, enhance security, an…

This repository contains SQL scripts focused on practicing and demonstrating Data Manipulation Language (DML) operations. These statements are used to insert, update, delete, and retrieve data from…

A comprehensive compound growth calculator designed specifically for the Kenyan market, helping investors plan their passive income strategies with realistic local economic parameters.

This repository provides examples and explanations on how to perform conditional calculations in SQL using the IF statement (or equivalent functions such as CASE and IFNULL). These techniques help …

This README provides an overview of commonly used SQL functions for data type conversion and NULL value handling. These functions are essential for data cleaning, transformation, and logic control …

This repository contains examples, explanations, and use cases of common SQL string functions. These functions are essential for text processing, data formatting, cleaning, and extraction tasks in …

This repository contains practical examples demonstrating how to use the `CASE` statement in SQL. The `CASE` statement is a powerful tool for performing conditional logic within your queries, allow…

This project demonstrates the use of value-based SQL window functions to analyze temporal trends in access to basic services, focusing on the percentage of the population with managed drinking wate…

This repository contains SQL queries for performing Top N Analysis—a common data analysis technique used to retrieve the highest or lowest N records based on specific metrics, such as GDP, populati…

This SQL script contains a collection of Data Definition Language (DDL) statements used for practicing the creation and management of database structures. The script is designed for learners and da…

This repo is about sql windows function query practice .It's exhibits exercises done on windows function practise exercises.