6 docs tagged with "SQL"

Window functions, CTEs, subqueries, recursive queries, lateral joins, pivot/unpivot, pagination patterns, EXPLAIN, and advanced SQL for senior engineers.

A comprehensive list of real technical interview questions and answers from a Cognizant Java Developer campus interview for freshers. Covers Core Java, Collections Framework, OOPs, and SQL.

Deep dive into the 7 universal database tables that organically emerge in production systems, technical debt blast radius, and zero-downtime schema hygiene runbooks.

Core concepts of relational databases — tables, keys, joins, SQL basics, and the relational model.

Essential SQL interview questions covering window ranking functions, B-Tree vs Hash indexing, composite index left-prefix rules, and EXPLAIN execution plan analysis.

A comprehensive list of technical interview questions and answers from a real Wipro and ICICI Bank client interview for a Java Developer (3-4 years experience).