Day 2 of cyber security roadmap As I continue through the Google Cybersecurity Professional Certificate, today's learning focused on security auditing, a critical yet often overlooked component of an organization’s defense strategy. This blog capture...
If you’re preparing for a SQL, backend or data engineering role, it’s not enough to just know SQL — you’ll need to understand how PostgreSQL works behind the scenes. In my latest blog, I share: The real SQL queries I was asked in interviews, from re...
Over the past few months since the start of new year, I’ve been actively interviewing for technical roles, and each conversation proved to be both challenging and rewarding. In this post, I’ll share some of the SQL questions I was asked, along with d...
When it comes to SQL Server performance issues, parameter sniffing is one of those topics that both frustrates and fascinates. It’s often subtle, intermittently problematic, and notoriously tricky to explain to people who aren't knee deep in query pl...
My Notes & Thoughts From Today Hey friends 👋🏼 Today’s study was about Cybersecurity Foundations — and honestly, it gave me a lot of clarity. If you're someone trying to make sense of what cybersecurity is, or you’re just starting your journey (like...
🚀 What is LabStack? LabStack is a cloud-native platform that lets developers and students spin up disposable, browser-accessible labs in seconds — no local setup, no messy installs. Think VS Code or a Linux terminal in your browser, running in an is...
When working with data I often run into situations where the available information varies. Sometimes I get a clean patientid, which makes the lookup easy. Other times, all I have is a date of birth and ZIP code or even just an invoice number from bil...
Question: I'm wondering if it's possible to create a custom SQL group by function. For example, I often need to find the most common value within a group. While I can achieve this using CTEs or subqueries, having a custom group by function like the e...
Question: I have a table books : Name of columnType idint (PK) nametext nb_pagesint And a table book_modifications : Name of columnType idint (PK) old_datajsonb new_datajsonb book_idint (FK) Now let's imagine I have a row in my...
Question: Currently, I having a query SELECT al.category, IFNULL(jt.name, 'Ungrouped Devices') AS device_group_name, IFNULL(jt.id, '00000000-0000-0000-0000-000000000000') AS device_group_id, jt.color_code AS color_code, COUNT(*) AS total FR...
