Hello guys, if you want to improve your coding skills, learn to refactor and other coding best practices, and look for the best online courses to improve your coding skills, refactoring, and other best practices, then you have come to the right place. Earlier, I shared the best design pattern courses and best Data Structure and Algorithms courses, and today, I will share the best online courses you can join to improve your coding and programming skills. Coding skill is one of the most important differentiators when it comes to getting a programming job. It's simple, if you can't code, you can't go up the ladder, and you can't get better jobs.
Blog to learn about SQL, database, Oracle, SQL Server, MySQL, PostgreSQL concepts and much more.
Saturday, October 3, 2026
Tuesday, August 27, 2024
Don't use SELECT * in Production Query
Hello guys, if you are doing a code review and see a SELECT * in production code, would you allow it? Well, its not a simple question as it looks like but let's find out pros and cons about using SELECT * in a production SQL query and then decide. I have read many articles on the internet where people suggest that using SELECT * in SQL queries is a bad practice and you should always avoid that, but they never care to explain why? Some of them will say you should always use an explicit list of columns in your SQL query, which is a good suggestion and one of the SQL best practices I teach to junior programmers, but many of them don't explain the reason behind it.