Learning Outcomes

Overview of Information Technology in Workplace

Contributions of IT to the Workplace.

Information Technology and the Manager

The Challenge of Change

Six Major Trends and Implications for Management

Lesson Summary

This module discusses, what its meant by Information Technology. You will learn about how IT contributes to the workplace, major trends of IT and how IT can change your business.

What is Information?

Interpreting Information

Characteristics of Information

From Information to Knowledge

Decision Making

This module discusses information, you will learn about what information is, what influences peoples interpretation information, information's characteristics and how turn you information into knowledge.

First Assessment

You must score 80% or more to pass this assessment.

Frameworks for Information Technology

A Framework Based on IT

The Basics of Information Systems

This module discusses frameworks available to a business organisation, various applications IT adds to a business, and you will learn about different types of information systems.

Modern Organizations

Organizational Flexibility

Strategic Issues of Information Technology

This Module discusses, IT making your organisation more modern, informal and formal organisations, factors that influence structure and design of modern organisation. You will learn about variable in IT and the importance of IT in determining a corporate strategy.

Second Assessment

Management Control

Information and Control

Management Issues and Security Issues

This module discusses managerial control of a business organisation, tools for control to different levels of management, importance of auditing information system.

The Impact of Globalization on Business

International Business Strategies

Transnational Virtual Firms and IT

Managing Information Technology Internationally

In this module you will learn about the globalisation of a company, impacts it has, global business strategies, government requirements and problems of global organisations.

Third Assessment

Managerial Concerns

Programming Languages

The Operating System

Mobile Technologies

This module will teach you about the choice of software been important to a business, the difference between system and application software, programming languages and characteristics of a operating system.

File Elements

Database Management Systems (DBMS's)

Databases in System Design

This module will teach you about databases,  important aspects of their design, Functions of a database management system, and about SQL.

Fourth Assessment

The Design Task

A Systems Design Life Cycle

User-Oriented Design

Structured versus Object-Oriented Design

This module will teach you about building information systems, you will learn about stages of a software design task, systems life cycle, different types of design and Object-oriented design.

Systems Analysis

Survey and Feasibility Study

Identifying System Alternatives

Undertaking Systems Design

This module discusses the early stages of systems design and why they are the most crucial stages. you will learn about costs, benefits, problems, solutions in the early stage of designing a system.

Fifth Assessment

Diploma in Information Technology Management - Final assessment

Boost your knowledge of modern Information Technology Management in just a few hours with this free online course.

Diploma in Information Technology Management

This free online course in Information Technology management will introduce you to the core concepts and best practices of the trade. The course will also teach you how to implement and control IT in both small and large organisations. Given the importance of Information Technology management today, people with IT management skills make for highly valuable employees. This course will bring your IT management skills to the next level, for free.

What is an Information System?

Networking Communication

Can Information Systems Bring Competitive Advantage?

This module introduces the concept of information systems, it consists of topics that cover the following: Definition of Information systems, information systems components such as hardware, software and data, networking and communication, processes components and how it relates with business management and finally the  competitive advantage brought about by using information systems.

What is a Management Information System?

The Role of Information Systems

This module introduces Management Information Systems, it covers the following concepts: Definition of Management Information Systems, types of management information systems and how we use them day to day, the role of information systems in an organization, information systems advancement and progression phases in information systems: The Mainframe Era, The PC Revolution, Client-Server, The World Wide Web and E-Commerce, Web 2.0 and The Post-PC World.

Hardware

Other Computing Devices

Types of Software

Productivity, Utility and Programming

Applications for the Enterprise

Mobile Applications and Cloud Computing

This module expounds more on information systems hardware and software components. It consists of topics that cover the following: Hardware components, Software components, Types of Software, Software for organizational productivity, Utility and programming software, Applications for the enterprise, Mobile applications, Cloud computing, Open-source and closed source models.

A Brief History of the Internet

Wi-Fi and Mobile Networks

Organizational Networking

The Information Security Triad and Tools for Information Security

Backups, Firewalls and Physical Security

Security Policies and Personal Information Security

This module discussed information systems network and security in depth. It consists of interactive topics that will cover the following introduces the concept of information systems, it consists of topics that cover the following: Brief History of the Internet, Wi-Fi and mobile networks, organizational networking, the information security triad, tools for information security, backups, firewalls and physical security and finally security policies and personal information security.

Introduction to Data Management

Designing a Database

Database Management Systems

This module introduces the concept of data and databases. It consists of topics that cover the following concepts: Definitions of data, information and knowledge, hierarchical relationship and the DIKW pyramid, introduction to relational databases, designing databases, database normalization, an introduction to Structured Query Language(SQL), Database Management System (DBMS), big data and enterprise databases.

Data Warehouse

Data Mining

Knowledge Management

This module discusses data warehouses and data mining. It covers the following: Introduction to data warehouse, bottom-up and top-down approaches to data warehouse design, benefits of setting up a data warehouse, the process of data mining, business Intelligence and business analytics and organizational knowledge management and its role in decision making.

Introduction to Management Information Systems - Course assessment

This free online course provides a solid introduction to management information systems in business.

Diploma in Management Information Systems - An Introduction

The foundational concepts relating to management information systems will be outlined and explained in this free online course, along with the various management information systems available. By the end of the course, you will be in a position to explain the components and implementation of management information systems and its importance in an organization.

Information Management Strategies

Database Management and Data Protection

In this module, you will be introduced to the concept of information and how information can be managed. You will learn how to distinguish between information, data and knowledge. Upon that, you'll be taught the strategies used to manage information as well as database management and intellectual property rights.

Information Management: Strategy and Data Protection - Course Assessment

Learn about the concept of information management, its benefits and its applications in this free online course.

Information Management: Strategy and Data Protection

With the volume of data available at our fingertips, one could wonder why we need to manage information. This course explores the principles of information management used in this organisational activity. We will show you how creators and inventors can protect their hard-earned creative inventions, ideas and work. We explore database management, different management systems, data protection regulation and how computers process data.

Getting Started With JIRA

Using Jira for Business Projects

Using Jira for Agile Projects

This module is an introduction to the fundamental concepts of JIRA architecture. You will discover the basic purpose of the architecture and learn about the various system requirements for implementing JIRA. Application services, required browsers, and data storage will be addressed, as will the installation and configuration processes.

Issue Management

Field Management

Screen Management

Workflow and Business Process

Emails and Notifications

This lesson will teach you several management practices for JIRA projects. You will learn about challenges that may develop in various projects and how to address them. Understanding the system and custom fields in JIRA and screen management will also be covered. Workflow management and business procedures will also be covered.

An Introduction to JIRA Architecture - Course Assessment

Learn how JIRA is used to enhance project management and track bugs in this free online software development course.

An Introduction to JIRA Architecture

This JIRA tutorial explores the fundamental concepts and architecture of JIRA, the leading project management and issue-tracking tool used in software development. We explore JIRA's core components, from databases and workflows to plugins and user interactions, to provide the skills you need to optimise its performance and tailor it to your needs. Sign up to learn how to unleash the full potential of JIRA for seamless project management.

Core Database Concepts - Introduction

SQL Server Management Studio

Learn more about the fundamental concepts of database. You will be introduced to databases, SQL, DBMS and RDMS. You will also learn about SSQL Server Management Studio and how GUI can be used to manage an SQL Server, its databases, and the content contained within the databases.

Normalization

Referential Integrity

Constraints

In this module, you will study the relational concepts of database. You will begin by studying Normalization and you will see how the various normal forms impact upon the organization of data in a database. You will also study referential integrity and constraints.

Datatypes

Database Objects

DDL Statements

Learn about what a datatype is and then learn about some of the categories of datatypes. You will also learn about unicode, implicit and explicit datatypes before moving onto database objects and DDL statements.

SELECT Statement

SELECT Statement Demonstration

INSERT, UPDATE and DELETE Statements

In this module, you will be learning about Data Manipulation Language and you will be introduced to the SELECT statement. You will learn the significance of this statement and its applications in database. The INSERT, UPDATE and DELETE statements will also be discussed.

Securing Databases and Objects

Database Backups and Restores

Study the fundamentals of Sql Server Administration Fundamentals and learn about Securables, Principals and Permissions. You will learn about the three-tiered approach to accessing content and about how Databases and Objects are secured.

Diploma in Databases and T-SQL - First Assessment

Introducing Transact-SQL - Course Introduction

Introduction to Transact-SQL

The SELECT Statement

Data Types and Working with NULL

In this module, you will be introduced to Transact-SQL and you will learn about Structured Query Language, Data Manipulation Language, Data Definition Language and Data Control Language.

Removing Duplicates and Sorting

Filtering and Using Predicates

In this module, you will learn how to query tables with select. You will look at removing duplicates and sorting as well as filtering and using predicates.

Join Concepts and Syntax

Inner Joins

Cross Joins

Self Joins

Union Queries

Intersect Queries and Except Queries

Outer Joins

This module will introduce you to Joins and Queries, you will learn about how to use a join and the various types of joins that are used.

Scalar Functions

Logical Functions

Window and Aggregate Functions

Group By and Filtering with Having

This module will introduce you to various functions such as Scalar Functions and Logical Functions. You will also gain a greater understanding of GROUP BY and Filtering with HAVING.

Subqueries

APPLY Operator

Views

Temporary Tables and Table Variables

Table Valued Functions

Derived Tables

Common Table Expressions

Grouping Sets

Pivoting Data

This module will introduce you to Subqueries as well as showing you how certain table expressions work. You will also learn more about Grouping Sets and Pivoting Data.

Inserting Data

Update and Delete

Batches, Comments and Variables

Conditional Branching and Looping

Stored Procedures

In this module, you will learn more about the practicalities of working with data. You will learn about how to input data and also about how to update and delete data in a table. You will also study Batches, Comments and Variables and take a look at Conditional Branching and Looping.

Error Message and Raising Errors

Catching and Handling Errors

Transactions

In this module, you will learn about Error Messages and Raising Errors. Following on from this, you will study how errors are caught and handled and you will learn about Transactions.

Diploma in Databases and T-SQL - Second Assessment

Diploma in Databases and T-SQL - Assessment

Learn about the core concepts of database including the structure by studying this free Databases and T-SQL course.

Diploma in Databases and T-SQL

This free online Databases and T-SQL course will teach you the core concepts of databases and their structure. It will teach you how to retrieve data from a database using Structured Query Language (SQL) and Microsoft's variant Transact-SQL (T-SQL). You will learn about queries and the different constraints and clauses you can include in them. You will also study administrative tasks you can perform on a database.

Introduction to Database Concepts  - Final Assessment

Learn the core concepts of relational databases for storing data with this free online Database Concepts course.

Introduction to Database Concepts

This free online Introduction to Database Concepts course will teach you the process of storing, managing, and retrieving information in a database. A database is an organized collection of data in rows and columns, typically stored in tables. These tables are then stored on database servers that host the database files. With this course, you will learn how databases can provide high-level performance for a diverse set of users.

Overview Of Information Technology In The Workplace

Contributions Of Information Technology To The Workplace

Information Technology And The Manager

The Challenge Of Change

Six Major Trends And Implications For Management

Learn more about information technology for managers

Characteristics Of Information

From Information To Knowledge

Learn more about information and how to interpret it.

Introduction To Information Technology For Managers - Course Assessment

Learn how information technology can help companies and managers succeed, with this free online course.

Introduction To Information Technology For Managers

This free online information technology course for managers will introduce you to the characteristics and uses of IT systems. Effective management and implementation of IT resources have now become routine tasks for many middle and senior managers. This means that a solid understanding of Information Technology is of vital importance for any manager in the modern workplace. Start this free online course today to grow your management skills today.

Manipulating Records in Tables

Creating Tables

Reports and Controls

Working With Queries

Types of Queries

In this module, you will learn how to navigate existing tables, edit records, sort data, filter records and use the find and replace features in Access. You will be taught the fundamentals of creating new tables and how to set field properties and what look-ups are used for. On top of this, you will learn how to define, create and manage controls, reports and queries.

Learn the principles for the creation and proficient use of databases with Microsoft Access in this free online course.

Microsoft Access Masterclass

Databases are an important part of the information landscape and this free online Microsoft Access tutorial will show you how to proficiently leverage data with the use of Microsoft Access. You will learn how to design and build tables, forms, reports, controls and queries that work efficiently, access macros and program control structures in Visual Basic for Applications (VBA) as well as fix Excel data import errors.