SQL (Fundamentals)
DDL & Schema Understanding
- CREATE, ALTER, DROP
- Understanding table design
All JOIN Types
- INNER, LEFT, RIGHT, FULL OUTER
- CROSS, SELF
Complex WHERE Clauses
- Compound conditions
- Subqueries in WHERE
Aggregate Functions & GROUP BY
- COUNT, SUM, AVG with grouping
- HAVING clause
Database Connectivity from Code
- JDBC, ADO.NET, database drivers
Parameterized Queries
- Preventing SQL injection
- Prepared statements
Transaction Basics
- BEGIN, COMMIT, ROLLBACK from code
Result Set Handling
- Mapping query results to objects
Database Schema Navigation
- Understanding ERDs
- Foreign keys, relationships
Indexes Awareness
- What they are, why they matter