Learners describe primary keys and how to select them. Learners explain normalization and its role in the database design process. Learners apply normalization rules to evaluate and correct table structures. Learners use SQL Server and retrieve information from data tables. Learners use to SQL queries to join tables, aggregate data, and restrict data retrieval.

Conditions

Pre/Corequisite: 10-152-531 DATA CONCEPTS A.