Learning Outcomes

Introduction to Document Control

Document Control Life Cycle

Document Control Strategies and Instruments

Document Numbering

Document Templates

Quality Assurance and Control

Project Document Control

Lesson Summary

This module investigates the approaches and tools used in a document management system that boosts workflow efficiency. We explore the life cycle of a document, various document numbering methods, quality assurance and control procedures, and the project document control phases.

Document Control: From Principles to Practice - Course Assessment

Learn how organisations implement document control strategies to manage and protect data in this free online course.

Document Control: From Principles to Practice

Document control systems benefit organisations by enhancing productivity and security and reducing the amount of paper used. This course explains how to use document control practices and software. We establish the importance of a robust document control system and compare it to analogue methods. We also provide document control strategies and instruments, including the Master Document Register (MDR) and the Document Distribution Matrix (DDM).

Introduction to Data Protection

General Data Protection Regulation (GDPR) and UK GDPR

Privacy Policies and Procedures in the UK and EU

Data Breaches and Incident Response in the UK and EU

Risk Management in the UK and EU

Data Protection Impact Assessments (DPIAs) in the UK and EU

Collaboration and Communication in the UK and EU

UK and EU Data Protection Landscape After Brexit

In this module, we will look at the principles of data protection laws and regulations in the UK and EU. We will also go through the process of developing and implementing data policies within these jurisdictions. Collaboration between UK and EU will be discussed in managing risk, carrying out impact assessments, and incident response plans.

The Role of a Data Protection Officer (DPO)

DPO and Other Job Responsibilities

Why a Company Needs a DPO

Data Transfers and International Data Protection

Data Protection Audits and Compliance Monitoring

Data Protection in Emerging Technologies

Data Privacy Impact on Marketing and Advertising

In this module, we will look at the primary role of a DPO, their responsibilities, and their importance shall be examined. International data protection standards and data audit compliance will be discussed along with challenges posed by technological advances in the modern landscape. We will also look at the impact of data privacy on marketing.

Data Protection Officer Training - Course assessment

Train as a data protection officer in this free online course that explains how to protect the integrity of information.

Data Protection Officer Training

This data protection course takes an in-depth look at the basic skills and information you need to become a trained data protection officer who safeguards the information stored by organizations. We outline the current trends in the field to equip you with the ability to cope with these challenges. In a data-driven world, competent data protection officers are in high demand. Sign up to acquire this valuable skill and advance your career.

Introduction to Data Management

Data Warehousing - Types and Components

Data Warehousing - Best Practices and Implementation

CDMP Certification - Demystified

This module introduces you to the field of data management. You will learn its basics, such as data collection and storage, data quality, and data governance. The module also mentions best practices related to data management and the concept of data warehousing. Last, the main aspects of the CDMP examination and certification are also explained.

Fundamentals of Certified Data Management Professional (CDMP) - Course Assessment

Learn about the data management profession, its essential elements, and the CDMP examination and certification.

Fundamentals of Certified Data Management Professional (CDMP)

Information Technology is a very vast field. It has a lot of subsequent branches, and data management is one of them. Data management professionals are widely sought after across the world. They are must haves for any business and organization dealing with large amounts of crucial information. For these professionals, one of the ways to demonstrate their expertise in data management is having a CDMP certification from DAMA International.

Introduction to Connect Care and Clinical Information Sharing

Privacy, Security, and Consent in Digital Healthcare Systems

Ethical Management of Access and Use of Medical Information

Equity, Accessibility, and Empowerment through Connect Care

Managing Patient Data in Digital Healthcare: Privacy, Consent, and Equity - Course Assessment

This free online course teaches how to protect data, ensure privacy, and ensure fairness in modern healthcare systems.

Managing Patient Data in Digital Healthcare: Privacy, Consent, and Equity

Develop the competencies to manage the ethical, legal, and practical difficulties of working with patient data in the digital era. This course will offer real-world solutions to safeguarding patients' privacy, maintaining informed consent, and promoting fairness in healthcare systems. As a result, you can boost patient confidence and propel good, ethical, data-driven transformation in medical management settings.

Business Intelligence

Starting Case

Decision-Making Process

Problem Structure

BI Application

Dashboard Presentation

This module explains what business intelligence is and how it can be used to make useful decisions. In this module, you will see the various reasons why managers need IT supports, types of problem structures, and business intelligence applications used for analyzing data.

Types of Charts

Good Dashboard

Common Mistakes

KPI Development

Overview of Data Warehouse

Data Warehouse

This module discusses the data warehouse and how it works to manage data. In this module, you will see the different types of charts used in the BI dashboard and the common mistakes made when designing a dashboard.

Development Approaches

Basics of Data Mining

Data Mining - Classification

Data mining - Clustering

Data Mining - Applications

This module explains the basics of data mining. In this module, you will see the stages involved in data mining and the various areas where data mining can be applied.

Fundamentals of Managing and Using Data for Business Intelligence - Course Assessment

Learn about business intelligence, data mining, data management, and data warehousing with this free online BI course.

Fundamentals of Managing and using Data for Business Intelligence

This course introduces you to the application of business intelligence (BI) in making viable financial and strategic decisions. Learn about the roles of managers and the reasons why managers need IT support. You will explore data management, data mining and the mechanics of data analysis. If you are a business analyst or a small business owner or entrepreneur and want to enhance your ability to make important decisions, this course is for you.

Managerial Concerns

Programming Languages

The Operating System

Mobile Technologies

Learn more about software and database technologies.

File Elements

Database Management Systems (DBMs)

Databases In Systems Design

IT Management - Software and Databases - Assessment

Learn in this online course how to choose, maintain, and update Database Management Systems for IT management.

IT Management - Software and Databases

This free online IT management course will teach you about a manager's role in the building and implementation of an information systems. Information systems are critical in every business, and managers play a fundamental role in the initiation, design and implementation of a new Information System. This free online course will be invaluable for managers involved in the creation and design of new information systems.

Introduction to Data Governance

Managing Roles and Responsibilities in Data Governance

Challenges in Establishing a Data Governance Framework - Part A

Challenges in Establishing a Data Governance Framework - Part B

Fundamentals of Data Governance Strategies - Assessment

This course explains how to establish a well-functioning data governance framework for organizations.

Fundamentals of Data Governance Strategies

This course introduces Alison students to the basic concepts surrounding data governance, a discipline that a successful organization cannot avoid. By enrolling in this course, students will learn how a data governance framework is built, the roles assigned, and what sustains it. Moreover, they will also learn about various challenges faced by organizations in establishing this framework and the ways to overcome them.

Installing SQL Server 2019 Express

Installing SQL Server Management Studio

Downloading the AdventureWorks Sample Database

Course Environment Walkthrough

In this module, we review some of the essential details regarding programming in SQL. A guide on how to install SQL Server 2019 and SQL server management studio shall be provided. We will also go through the process of downloading the AdventureWorks sample database. A walkthrough of the course environment shall also be provided during the module.

Introducing Window Functions With OVER

PARTITION BY

ROW_NUMBER Function

RANK and DENSE_RANK

LEAD and LAG

In this module, we will get an introduction to the window functions with OVER across an entire data set. We will also be going through a detailed walkthrough of functions such as PARTITION BY, ROW NUMBER, and RANK along with Lead and lag. A brief guide will also be provided on subqueries.

Introducing Subqueries

Scalar Subqueries

Correlated Subqueries

EXISTS function

FOR XML PATH with STUFF

PIVOT for Data

This module will be dealing with everything related to subqueries. We will be dissecting the concepts of scalar and correlated subqueries. We will also be taking a look at the application of the EXIST function. A walkthrough on how to flatten multiple rows into one using the FOR XML PATH will be provided along with the use of PIVOT.

Data Analysis Using CTE's

CTEs Walkthrough

Recursive CTE's

This module breaks down the process of performing complex analyses on your data in a step-by-step manner using common table expressions or CTEs. We will be taking a detailed look at how to easily break down queries in a simple and linear manner. We will also examine the use of recursion in order to generate a series of values in SQL.

Temp Tables 1 and 2

CREATE and INSERT

TRUNCATE Application

Modifying Tables Using UPDATE

Removing Rows Using DELETE

In this module, we will be taking a detailed look at a more flexible alternative to common table expressions known as the temp tables. We will also be examining the CREATE and INSERT functions to manage complex data structures. The TRUNCATE and UPDATE functions for clearing, using and modifying tables will be discussed.

Optimizing With UPDATE

An Improved EXISTS with UPDATE

Introduction to Indexes

Lookup Tables

This module will be taking a look at all the things associated with optimizing queries using the UPDATE statements. An improved version of EXISTS with UPDATE will also be examined during the module. We will be taking a detailed look at database objects known as indexes and the utility of lookup tables to make something permanent.

The Use of Variables

Introduction to User Defined Functions

Stored Procedures

Control Flow with IF Statements

Dynamic SQL Programming

This module will be starting off by taking a detailed look at variables which can help streamline code. We will be going through the use of user-defined functions for situations where built-in functions are not enough. The use and application of dynamic SQL will be discussed which helps prevent repetition when constructing long strings of code.

Diploma in Advanced SQL Server - Course assessment

Develop an in-depth understanding of the concepts and functions of an advanced SQL server with this free online course.

Diploma in Advanced SQL Server

In this course, we will be taking your basic database skills up a notch and providing you with a refined understanding of coding in SQL 2019. We will be going through essential coding concepts such as carrying out advanced analyses, using subqueries, common table expressions and data optimisation. All these techniques can help you become a more efficient programmer and take your skills and career to the next level. So enrol now to keep learning!

Data Science

Machine Learning

Data Science Opportunities

R and R Studio Essentials

R Studio and Tidyverse

In this module on Introduction to Data Science, you will learn about the data science life-cycle stages and the fundamentals of machine learning. You will also gain insight into the milestones and current trends in data science and study the examples of Tidyverse R packages.

Data Types in R

Vectors in R

Vector Coercion and Naming

Matrices and Lists

Fundamentals of Data Frames

Helper Functions and Tibbles

In this module on Data Types and Structures in R, you will learn about the common data types in R and how to represent their missing values. In addition, gain insight into data frame helper functions and examples of one-dimensional data types in R.

Intermediate R Overview

Operators and Statements

Loops, Functions and Packages

Factors and Support

Functional Programming

Data Import, Export and Databases

In this module on Intermediate R, you will learn how to install R packages and all the components of these packages. You will also master the three ways of creating a date or time in R and the process of importing and exporting data in R.

Advanced Diploma in Data Science with R - First Assessment

This assessment enables you to review your learning so you can determine your knowledge and understanding of Modules 1 - 3. You must score 80% or more to pass this assessment.

Data Manipulation

Tidy Data and Pipe Operator

Filter and Select Verbs

Mutate, Arrange and Summarize Verb

Data Pivoting and String Manipulation

Web Scrapping and JSON Passing

In this module on Data Manipulation in R, you will learn about the examples of {stringr} verbs that work with patterns and the classification of tidy data. You will also learn how to use the key {dplr} verbs and the pipe operator to manipulate data in R.

Introduction to Data Visualization

Aesthetics Mappings and Layering

Single and Two Variable Plots

Layering and Styling

Using R Markdown

In this module on Python Libraries, you will learn how to plot single and two variables in R. You will also learn how to use the ggplot function to create objects and coordinate the system.

Introduction to R Shiny

Basic Web App

R Shiny Examples

Career in Data Science

Branding and Networking

In this module on Object-Oriented Programming, you will learn about the two main components of an R Shiny app and the examples of R Shiny output functions. You will also discover the advantages and disadvantages of using freelance websites and master the art of writing a resume.

Advanced Diploma in Data Science with R - Second Assessment

This assessment enables you to review your learning so you can determine your knowledge and understanding of Modules 4 - 6. You must score 80% or more to pass this assessment.

Advanced Diploma in Data Science with R - Course Assessment

In this free online course, learn about the important concepts and essential factors involved in data science with R.

Advanced Diploma in Data Science with R

Discover the fundamental aspects of how data science helps businesses make objective and influential decisions in this free online data science with R course. Master the real-world applications of all the data various business sectors accumulate and use it for your clients or employers. You will also gain practical experience on how to discover patterns from raw data and the many career opportunities available in the field of data science.

The Design Task

A Systems Design Life Cycle

User-Oriented Design

Structured Vs Object-Oriented Design

Learn more about building information systems.

Systems Analysis

Survey And Feasibility Study

Identifying Systems Alternatives

Undertaking Systems Design

Learn more about the early stages of systems design.

IT Management - Building Information Systems - Course Assessment

Learn more about building information systems in industry, from a managerial network perspective.

IT Management - Building Information Systems

This free online course explores the critical role of managers in initiating, designing, and implementing information system infrastructures. It covers the stages of system design, emphasizing the manager's impact and the user's role. The course introduces tools for Information Systems design and addresses costs, benefits, and challenges throughout the lifecycle of information systems. Ideal for business, IT, and information systems professionals

Data Entry Essentials and Skills

This module will introduce you to data entry and essential tools, data entry in Microsoft Word, and Microsoft Excel. Then you will learn about advanced data entry techniques and tools, data entry best practices and accuracy, and building your data entry career and portfolio.

Learn how to enter data into Microsoft Word and Excel in this free online course that provides data entry training.

Data Entry Tools and Techniques

Before insights can be derived from data analysis, raw information needs to be fed into databases at low transactional levels. Various tools and techniques are used to make this happen. This data entry training course explains how to ensure proper storage and retrieval of essential information using technical, analytical and soft skills. We show you how to quickly input, update and validate data while maintaining accuracy and integrity.