Course curriculum

    1. Information Systems & Databases Unit Overview

    1. Glossary of Key Terms: Information Systems & Databases

    1. What is an Information System?

    2. Characteristics of an Information System

    3. Different Types & Purposes for Information Systems

    4. Information System Example: Netflix

    5. Information Systems Quiz

    6. Test Your Knowledge: Information Systems

    7. Test Your Knowledge: Information Systems Answers

    1. School Databases

    2. The Roads & Maritime Services (RMS)

    3. Online Movie Stores

    4. Database Information Systems Quiz

    5. Test Your Knowledge: Database Information Systems

    6. Test Your Knowledge: Database Information Systems Answers

    1. Information Process: Organising

    2. Non-Computer Methods of Organising

    3. Computer Based Methods of Organising

    4. The Advantages & Disadvantages of Computer Based vs Non-Computer Based Organisation Methods

    5. The Logical Organisation of Flat-File Databases

    6. The Logical Organisation of Relational Databases

    7. Flat File vs. Relational Databases

    8. Introduction to Data Dictionaries - Student Details

    9. Data Dictionary Example: Driver's License Details

    10. Data Dictionary Example: Vehicle Details

    11. Schematic Diagrams (Schema's) & Database Relationships

    12. Normalisation

    13. Hypermedia: Nodes, Links & URL's

    14. Hypermedia: HTML Meta Tags

    15. Hypermedia: Tools for Organising Hypermedia

    16. Organisation Quiz

    17. Test Your Knowledge: Organisation

    18. Test Your Knowledge: Organisation Answers

    1. Information Process: Storing & Retrieving

    2. Database Management Systems (DBMS)

    3. Direct & Sequential Access of Data

    4. On-line & Off-line Storage

    5. Centralised & Distributed Databases

    6. Storage Media

    7. Backup Procedures

    8. Security Procedures

    9. Encryption & Decryption

    10. Tools for Database Storage & Retrieval

    11. Calculating Database File Size

    12. Introduction to Structured Query Language (SQL)

    13. Structured Query Language (SQL): Wildcards

    14. Structured Query Language (SQL): Operators

    15. Tools for Hypermedia Storage & Retrieval

    16. Query By Example (QBE)

    17. Storage & Retrieval Quiz

    18. Test Your Knowledge: Storage & Retrieval

    19. Test Your Knowledge: Storage & Retrieval

About this course

  • Free
  • 75 lessons
  • 3.5 hours of video content