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

2 tips tagged #postgresql

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
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.