Blog
Exploring ping - Linux Commands
Learn how to use the Linux ping command to test network connectivity, troubleshoot issues, and measure response times in simple, easy steps.
Learning SQL: CASE
Learn how to use the SQL CASE statement for conditional logic in queries. Master categorization, custom labels, and conditional calculations with examples!
Learning SQL: HAVING
Master the SQL HAVING clause to filter grouped data. Understand how to apply conditions to aggregated results with practical examples and use cases.
February Reflection 2025
Reflecting on building tools to improve efficiency, recreating projects in new languages, and exploring Ansible for automation. Simplifying workflows, one project at a time.
Learning SQL: GROUP BY
Learn how to use the SQL GROUP BY clause to group and summarize data. Perfect for aggregating and analyzing datasets with clear examples and explanations.
Learning SQL: CROSS JOIN
Learn SQL CROSS JOIN: Combine every row from two tables, create all possible combinations, and understand its use cases for data analysis.
Learning SQL: FULL OUTER JOIN
Master SQL FULL OUTER JOIN: Combine data from two tables, retain all rows, handle NULL values, and optimize queries for better insights.
January Reflection 2025
Excited to expand my knowledge in OOP3, mobile app dev, Azure, AAA testing, and CI/CD pipelines. Ready to grow skills and embrace new tech trends in 2025!
Learning SQL: RIGHT JOIN
Learn how to use the RIGHT JOIN clause in SQL to combine tables, retain all data from the right table, and handle NULL values effectively with examples.
Learning SQL: LEFT JOIN
Learn about SQL LEFT JOIN: combine data from two tables, return all rows from the left table, and fill unmatched rows with NULL values. Clear examples included!