Practice coding MCQs, read bite-sized articles, and grab ready-to-use code snippets.
A complete, ordered SQL interview path for freshers: a 30-day roadmap, fundamentals, joins, subqueries, window functions, indexes, transactions, four quizzes and the 50 most-asked questions with answers.
12 articles · 4 quizzes · 9 snippets
Two ideas that shape everyday C# code, LINQ and async/await, each with a worked snippet, followed by a quiz on the language fundamentals.
2 articles · 1 quiz · 2 snippets
Four short quizzes across SQL, C# and web basics: a quick way to find out what to study next.
4 quizzes
What freshers are asked in SQL interviews, a 30-day study plan, a practice database you can create in a minute, and the habits that turn correct answers into offers.
Databases, tables, DBMS versus RDBMS, the five SQL command groups, constraints, primary versus unique keys, foreign keys, and DELETE versus TRUNCATE versus DROP.
Use ROW_NUMBER() to keep only the newest row in each group.
Join a table to itself to list each employee next to their manager, keeping the top-level employee who has no manager.
The order SQL really evaluates a query in, how NULL and three-valued logic change your results, ISNULL versus COALESCE, safe sorting and paging, and date-range filters.
An anti-join with NOT EXISTS: find rows in one table that have no match in another, safely, even when the other table contains NULLs.