Data Design Final Review

The exam will be in two parts

1. SQL and .NET questions
2. Practical section you will need to build a page or two that connect in variious ways the a sql db.

• 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