The latest articles on DEV Community by youssef jablaoui (@yojablao). https://dev.to/yojablao https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3902266%2F34700966-a5fb-4db6-8ae0-f9bcd0b4fd5f.jpeg https://dev.to/yojablao en youssef jablaoui Tue, 28 Apr 2026 11:27:51 +0000 https://dev.to/yojablao/learning-with-sql-with-practice-sqlboltcom-3e1n https://dev.to/yojablao/learning-with-sql-with-practice-sqlboltcom-3e1n <p>Learning SQL (Day 1). Keeping it practical.</p> <p>3 core things I learned today:</p> <ol> <li><p>Filtering (WHERE)<br> SELECT city FROM north_american_cities WHERE country = 'Canada';</p></li> <li><p>Sorting (ORDER BY)<br> SELECT city FROM north_american_cities ORDER BY population DESC;</p></li> <li><p>Limiting results (LIMIT + OFFSET)<br> SELECT city FROM north_american_cities ORDER BY population DESC LIMIT 2 OFFSET 2;</p></li> </ol> <p>Key insight:<br> SQL is not hard — translating the problem correctly is the real skill.</p> beginners database learning sql