Exam 98-361: Software Development Fundamentals/Understanding Databases

From Wikiversity
Jump to navigation Jump to search
Software Development Fundamentals
  1. Understanding Core Programming
  2. Understanding Object-Oriented Programming
  3. Understanding General Software Development
  4. Understanding Web Applications
  5. Understanding Desktop Applications
  6. 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[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]

Retrieved from "https://en.wikiversity.org/w/index.php?title=Exam_98-361:_Software_Development_Fundamentals/Understanding_Databases&oldid=1693147"