Exam 98-361: Software Development Fundamentals/Understanding Databases

This lesson covers Understanding Databases. It looks at relational database management systems, database query methods, and database connection methods.

Activity 1 - Understand Relational Database Management Systems
This objective may include but is not limited to: characteristics and capabilities of database products; database design; Entity Relationship Diagrams (ERDs); normalization concepts.
 * 1) Read Designing Relational Database Tables.

Activity 2 - Understand Database Query Methods
This objective may include but is not limited to: structured query language (SQL), creating and accessing stored procedures, updating data and selecting data.
 * 1) Read SQL Tutorial.

Activity 3 - Understand Database Connection Methods
This objective may include but is not limited to: connecting to various types of data stores such as flat file; XML file; in-memory object; resource optimization.
 * 1) Read ADO Tutorial.