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.
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.
- 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.
- Read ADO Tutorial.
References
This article is issued from Wikiversity. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.