Level 7 Diploma in Information Technology

Unit 1: Computer Networks

7 Parts

Min

Attachments:

Read

Models of data communication and computer networks: Analyse the models used in data communication and computer networks.

Min

Attachments:

Read

Hierarchical computer networks: Analyse the different layers in hierarchical computer networks.

Min

Attachments:

Read

IP addressing in computer networks: Set up IP addressing in a computer network.

Min

Attachments:

Read

Static and dynamic routing: Set up static and dynamic routing in a computer network.

Min

Attachments:

Read

Network traffic management and control: Manage and control network traffic in a computer network.

Min

Attachments:

Read

Network troubleshooting: Diagnose and fix network problems.

Min

Attachments:

Read

Unit 2: Data Analytics

9 Parts

Introduction

Min

Attachments:

Read

Concepts and sources of big data.

Min

Attachments:

Read

Recommendation systems, sentiment analysis, and computational advertising.

Min

Attachments:

Read

Big data types: streaming data, unstructured data, large textual data.

Min

Attachments:

Read

Techniques in data analytics.

Min

Attachments:

Read

Problems associated with large data sets used in applied analytical models.

Min

Attachments:

Read

Approaches to visualize the output from an enforced analytical model.

Min

Attachments:

Read

Big data processing platforms and tools.

Min

Attachments:

Read

Performing simple data processing tasks on a big data set using tools

Min

Attachments:

Read

Unit 3: Database Management Systems

13 Parts

Introduction

Min

Attachments:

Read

Relational Database Management Systems: Analyze the concepts and architecture of a relational database management system.

Min

Attachments:

Read

Entity Relationship Model: Analyze the components of an entity relationship model.

Min

Attachments:

Read

Relational Model: Analyze relation, record, field, and keys in a relational model.

Min

Attachments:

Read

ER to Relational Model Conversion: Perform a conversion from an ER model to the relational model.

Min

Attachments:

Read

Functional Dependency: Analyze the concepts of closure sets, closure operation, trivial, non-trivial, and semi-trivial functional dependencies.

Min

Attachments:

Read

Normal Forms: Analyze the concepts of lossless, attribute-preserving, and functional-dependency-preserving decomposition, and first normal form.

Min

Attachments:

Read

Installation of Programming Languages and Databases: Install MySQL and phpMyAdmin and install Java and Python programming languages.

Min

Attachments:

Read

CRUD Operations: Perform create, read, update, delete (CRUD) operations in MySQL.

Min

Attachments:

Read

MySQL Operations: Perform MySQL operations using CONCAT, SUBSTRING, REPLACE, REVERSE, CHAR LENGTH, UPPER, and LOWER commands.

Min

Attachments:

Read

Aggregate Functions: Perform MySQL operations using count, group by, min, max, sum, and average functions.

Min

Attachments:

Read

Conditional Statements and Operators: Perform MySQL operations using not equal, not like, greater than, less than, logical AND, logical OR.

Min

Attachments:

Read

Join Operations: Perform MySQL operation.

Min

Attachments:

Read

Unit 4: Management Information Systems

10 Parts

Introduction

Min

Attachments:

Read

Historical development of databases: Analyze the evolution of technological infrastructures in relation to the development of databases.

Min

Attachments:

Read

Impact of the internet, the world-wide web, cloud computing, and e-commerce: Analyze the impact of these technologies on modern organizations.

Min

Attachments:

Read

Strategic management information system (MIS): Analyze the characteristics and impact of a strategic MIS.

Min

Attachments:

Read

Information systems for value-added change: Analyze how information systems can support value-added change in organizations.

Min

Attachments:

Read

Functionality of information communication technology: Analyze the functionality offered by information communication technology and its implications.

Min

Attachments:

Read

International, ethical, and social problems of managing information systems: Define the international, ethical, and social problems associated.

Min

Attachments:

Read

Security and legislative issues in building management information systems: Define the security and legislative issues related to building MIS.

Min

Attachments:

Read

Security and legislative issues in implementing management information systems: Define the security and legislative issues related to implementing MIS.

Min

Attachments:

Read

Security and legislative issues in maintenance.

Min

Attachments:

Read

Unit 5: Computers and Society

10 Parts

Introduction

Min

Attachments:

Read

Ethical concepts in computing: Analyse common ethical concepts and theories in computing.

Min

Attachments:

Read

Laws and social issues in information technology: Analyse laws and social issues in areas including privacy, encryption, and freedom of speech.

Min

Attachments:

Read

Intellectual property and computer crime: Analyse the laws relating to trade secrets, patents, copyright, fair use and restrictions, peer-to-peer.

Min

Attachments:

Read

Data privacy: Define data privacy and analyse the types of data included in data privacy.

Min

Attachments:

Read

Ethical theories and the U.S. legal system: Analyse philosophical perspectives such as utilitarianism versus deontological ethics and the basics.

Min

Attachments:

Read

Ethical dilemmas in information technology: Apply ethical concepts and an analytical process to common dilemmas found in the information technology.

Min

Attachments:

Read

Impacts of intellectual property theft and computer crime: Analyse the impacts of intellectual property theft and computer crime.

Min

Attachments:

Read

Ethics in artificial intelligence (AI): Analyse the ethics in AI, including autonomous vehicles and autonomous weapon systems.

Min

Attachments:

Read

Ethics in robotics: Analyse the ethics in robotics, including robots in healthcare.

Min

Attachments:

Read

Unit 6: Computing Projects

10 Parts

Introduction

Min

Attachments:

Read

Technologies involved in building a secure e-commerce site.

Min

Attachments:

Read

Common problems faced by e-commerce sites.

Min

Attachments:

Read

Requirements analysis and specification for an e-commerce project.

Min

Attachments:

Read

Writing a project proposal and creating a presentation.

Min

Attachments:

Read

Front-end development tools, frameworks, and languages.

Min

Attachments:

Read

Back-end development languages, frameworks, and databases.

Min

Attachments:

Read

Application of software development methodologies.

Min

Attachments:

Read

Creating a project report and user documentation.

Min

Attachments:

Read

Delivering structured presentations on the software solution.

Min

Attachments:

Read

Level 7 Diploma in Information Technology

About this course

Comments (0)

Reviews (0)

Course specifications

Report course

Share

Buy with points