SQL & RDB - Basic

It is assumed people taking the JDBC Basic exam know basic SQL and database concepts. This exam tests that knowledge. The exam only covers standard SQL - nothing database specific or SQL standard specific.

Note that DDL (creates, drops, alters) is out of scope. Also out of scope is more complex SQL like nested queries and outer joins.

Sample learning resources are http://sqlcourse.com/ and http://www.w3schools.com/sql/

	Released	Beta	Frozen
Table structure 2 questions Be able to define basic database terms: schema table row column primary key foreign key index	30	91	52	Add a question Beta questions
SQL - Selects 3 questions Write and understand basic SQL queries using `SELECT` Use standard comparison operators: like in between Use aggregate SQL functions: count max min sum avg Understand how adding `DISTINCT` or `COUNT(DISTINCT)` affects a query Implement inner joins across two tables Be able to use `GROUP BY` and `ORDER BY` in a query Know the difference between the `WHERE` and `HAVING` clauses Identify valid SQL statements from examples Distinguish between `UNION` AND `UNION ALL`	53	350	35	Add a question Beta questions
SQL - Insert/Update/Delete 3 questions Write and understand basic SQL statements using: update insert delete Identify valid SQL statements from examples. Note that more complex and DB-specific (that are not covered in SQL-92 standard) constructions are out of the scope.	34	10	81	Add a question Beta questions
Nulls 1 question Write queries involving nulls Know that null does not match on = or != or <> in SQL	11	56	19	Add a question Beta questions
CRUD 1 question Identify the CRUD operations: create read update delete Map CRUD operations to SQL keywords Note that knowledge of DDL is out of scope for this topic	15	8	28	Add a question Beta questions