Course tips and study guides
Study plans, exam and interview preparation, projects and placements, from people a year or two ahead and the UniCircle team. Every tip names its author and is checked by an editor before it appears.
Topics#javascript#html#java#sql#react#accessibility#dsa#interview#nodejs#arrays#error handling#forms#oop#placements#postgresql#abstract classes#acid#aggregates
23 tips
- GuideEngineeringUndergraduateHow to read EXPLAIN output and when an index helpsA student-friendly way to read a PostgreSQL query plan, spot a full table scan, and decide whether an index will actually make a query faster.#postgresql#explain#indexes#query performanceUniCircle team2 min
- GuideEngineeringUndergraduateSQL joins explained with two small tablesInner, left, right, full and self joins shown on the same two tiny tables, so you can see exactly which rows each one keeps.#sql#joins#left join#self joinUniCircle team2 min
- GuideEngineeringUndergraduateGROUP BY and HAVING without the confusionWhat GROUP BY actually does to your rows, why WHERE and HAVING are different, and the one rule about which columns you may select.#sql#group by#having#aggregatesUniCircle team2 min
- GuideEngineeringUndergraduateSQL filters and sorting: WHERE, IN, BETWEEN, LIKE and NULLHow to pick exactly the rows you want in SQL, including the NULL trap that catches most students, and how ORDER BY and LIMIT work together.#sql#where#null#order byUniCircle team2 min
- GuideEngineeringUndergraduatePostgreSQL commands you will use in your first weekThe psql shortcuts and SQL statements that cover almost everything a student does in a first DBMS lab: connect, look around, create a table, add rows, change them and clean up.#postgresql#sql#psql#dbms labUniCircle team2 min
Sponsored content is always labelled. Copied material is removed. If a tip is outdated or wrong, use “Report” on the tip.