Exam 98-361: Software Development Fundamentals/Understanding Databases
Appearance
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.
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.
- 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.
- Read ADO Tutorial.