Database & SQL Programming — OTHM Vocational Digital Skills & IT
Learning outcomes
- Understand data and its storage importance, traditional storage systems and its challenges
- understand importance of modern relational database and management systems (RDBMS)
- Understand the relational database installation and configuration, role of client and DBMS server.
Show all 12 objectives
- Understand basics of SQL programming language to communicate with relational database and management systems (RDBMS)
- understand relational table structures and SQL Data Definition Language (DDL)
- Understand various data manipulation techniques, queries to manipulate data - SQL data manipulation language (DML)
- understand database transactions and use of SQL Transaction Control Language (TCL)
- Understand data retrieval techniques, data transformations, SQL commands to query database (DQL)
- understand data summarisation and its support in SQL program
- Understand how to query metadata
- understand significance of data quality and data auditing, RDBMS techniques to enforce data quality and data auditing.
- 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…