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.

References

This article is issued from Wikiversity - version of the Wednesday, August 19, 2015. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.