Skip to topic
    ← Back to course topics

    Database & SQL Programming — OTHM Vocational Digital Skills & IT

    Learning outcomes

    1. Understand data and its storage importance, traditional storage systems and its challenges
    2. understand importance of modern relational database and management systems (RDBMS)
    3. Understand the relational database installation and configuration, role of client and DBMS server.
    Show all 12 objectives
    1. Understand basics of SQL programming language to communicate with relational database and management systems (RDBMS)
    2. understand relational table structures and SQL Data Definition Language (DDL)
    3. Understand various data manipulation techniques, queries to manipulate data - SQL data manipulation language (DML)
    4. understand database transactions and use of SQL Transaction Control Language (TCL)
    5. Understand data retrieval techniques, data transformations, SQL commands to query database (DQL)
    6. understand data summarisation and its support in SQL program
    7. Understand how to query metadata
    8. understand significance of data quality and data auditing, RDBMS techniques to enforce data quality and data auditing.
    9. Understand the importance of data access control, security of sensitive data and SQL commands to enforce data access control and security

    Database & SQL Programming assessment help

    Unit assessment details

    Loading assessment details…