Blog

Insights, tutorials, and updates from a software engineer.

Showing 8 of 8 posts for "sql"
Beyond Autocomplete: The Rise of CLI-First AI Coding Agents
AI Jun 17, 2026

Beyond Autocomplete: The Rise of CLI-First AI Coding Agents

AI coding tools are evolving rapidly. In 2026, the focus has shifted from simple code autocomplete to autonomous CLI-first agents like Claude Code and Cursor Composer. This post breaks down how these agents operate, why they represent a major shift, and practical steps you can take to make your codebase ready for them.

Read More · 5m read
A Complete 60-Day Roadmap to Become a Data Engineer with Python
Data Engineering Feb 10, 2026

A Complete 60-Day Roadmap to Become a Data Engineer with Python

'This 60-day Data Engineer learning plan is designed for professionals transitioning into data engineering roles, especially those with ETL or support backgrounds.

Read More · 6m read
What to Prepare for an Informatica Admin Interview (PowerCenter + IDMC)
Data Engineering Feb 9, 2026

What to Prepare for an Informatica Admin Interview (PowerCenter + IDMC)

This post shares a complete and practical preparation guide for Informatica Admin interviews. It covers PowerCenter and IDMC administration topics including architecture, monitoring, troubleshooting, Secure Agent, IPU usage, and migration scenarios, with a strong focus on real production support responsibilities.

Read More · 4m read
Junior Data Engineer Skills Checklist
Roadmaps Feb 7, 2026

Junior Data Engineer Skills Checklist

This checklist is created after reviewing multiple junior data engineer job postings across startups and enterprises. If you’re preparing for your first data engineering role, these are the skills recruiters repeatedly look for.

Read More · 3m read
Part 1: SQL Skills You Need to Be a Data Engineer
SQL Jan 30, 2026

Part 1: SQL Skills You Need to Be a Data Engineer

The best way to learn SQL is through practice. Below, you will find a sample dataset and a list of questions. Make sure not to look at the answers; instead, try solving the questions yourself.

Read More · 5m read
The Only SQL Skills You Need to Be a Data Engineer
SQL Jan 26, 2026

The Only SQL Skills You Need to Be a Data Engineer

You do not need to know everything. You do not need to be a Database Administrator. You just need to know how to transform and move data.

Read More · 4m read
The Simple Guide: Learn Python for Data Engineering
Python Jan 25, 2026

The Simple Guide: Learn Python for Data Engineering

To become a data engineer, you only need a small part of Python. You need to know how to move data from one place to another.

Read More · 4m read
5 SQL Concepts That Will Change How You See Databases
SQL Jan 14, 2026

5 SQL Concepts That Will Change How You See Databases

This post will reveal five powerful, and sometimes surprising, concepts that showcase the depth, elegance, and hidden intelligence of SQL.

Read More · 6m read
Home Videos Blog