Learning SQL: Subqueries
Master SQL subqueries & operators (ANY, ALL, EXISTS) with clear examples. Learn nested queries for WHERE, FROM, SELECT clauses—boost your SQL skills today!
- #backend
Blog
-
-
SSL and TLS Explained for Secure Communication
Learn how SSL/TLS secures online communication, protects your data, and ensures privacy. Understand the handshake process and its importance in simple terms.
- #platform
-
March Reflection 2025
March reflections: Learning Go with Gopher Learning and exploring Ansible for server automation. Exciting progress in coding & DevOps!”
- #monthly-log
-
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.
- #linux
-
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!
- #backend
-
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.
- #backend
-
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.
- #monthly-log
-
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.
- #backend
-
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.
- #backend
-
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.
- #backend