Data Design Final Review

The exam will be in two parts

1. SQL and .NET questions
   1. This section will consist of multiple choice, true and false and short answer question. It should take about 20-30 mins.
2. Practical section you will need to build a page or two that connect in various ways the a sql db.
   1. The practical section will take the remained of class. It will be open book, open note, and open internet. The practical will be just long enough so that if you can;t find stuff quickly you won't be able to finish so be prepared and be ready to work fast.

• Web Forms
• Databinding
  • Nesting Controls
• SQL DataSource Controls
• SQL DataTypes
• Basic SQL Syntax
  • SELECT, UPDATE, INSERT, DELETE
• ADO
  • Basic Objects
  • Using a DAL
• Joins and Views
• Normal Forms
  • Up to Third
• Transactions
• User Controls
• Master Pages