Jump to content

Exam 98-361: Software Development Fundamentals/Understanding Databases

From Wikiversity

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

[edit | edit source]

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

[edit | edit source]

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

[edit | edit source]

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.

References

[edit | edit source]