Use SQL select queries to read, search, write, update and delete records. |
|
|
19 |
|
|
|
19 |
Write SQL queries involving joins. |
|
|
10 |
|
|
|
10 |
Describe real-world objects using Entity Relationship Diagrams. |
|
|
19 |
|
|
|
19 |
Use GROUP BY and aggregate functions to calculate statistics. |
|
|
10 |
|
|
|
10 |
Use subqueries. |
|
|
10 |
|
|
|
10 |
Create normalized database tables based on an Entity Relationship Diagram. |
|
|
10 |
|
|
|
10 |
Use indexes to enhance query performance. |
|
|
10 |
|
|
|
10 |
Use foreign keys to guarantee data consistency. |
|
|
10 |
|
|
|
10 |
Use views to simplify complicated database queries. |
|
|
5 |
|
|
|
5 |