1 Lecture 25: Final Review The Final is Thursday, June 11, 2010, 8:30-10:20 In this room Dan Suciu -- 444 Spring 2010What to Study for the Final • SQL • Conceptual Design (BCNF) • Transactions • Indexes • Query execution and optimization • Cardinality Estimation • Parallel Databases 2 Dan Suciu -- 444 Spring 20101. SQL • What are the main topics ? • What is hard ? • Why do we need to know this ? 3 Dan Suciu -- 444 Spring 20102. Conceptual Design • What are the main topics ? • What is hard ? • Why do we need to know this ? 4 Dan Suciu -- 444 Spring 20103. Transactions • What are the main topics ? • What is hard ? • Why do we need to know this ? 5 Dan Suciu -- 444 Spring 20104. Indexes • What are the main topics ? • What is hard ? • Why do we need to know this ? 6 Dan Suciu -- 444 Spring 20105. Query Execution/Optimization • What are the main topics ? • What is hard ? • Why do we need to know this ? 7 Dan Suciu -- 444 Spring 20106. Cardinality Estimation • What are the main topics ? • What is hard ? • Why do we need to know this ? 8 Dan Suciu -- 444 Spring 20107. Parallel Databases • What are the main topics ? • What is hard ? • Why do we need to know this ? 9 Dan Suciu -- 444 Spring
View Full Document