Learning Outcomes

Managerial Concerns

Programming Languages

The Operating System

Mobile Technologies

Lesson Summary

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.

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!

Value and Reference Types

Deterministic Object Lifetimes

Instance and Static Members

Working with Objects

Working with Objects - Learning Summary

Working With Objects - Assessment

In this module, you will be introduced Working with Objects in C# Programming. The topic also explains value and reference types in various contexts and how to avoid some programming pitfalls. The module also discusses the concept of Instance and Static Members as well as how to effectively build your own custom objects.

Properties

Automatic Properties

Methods

Optional Param and Caller Info

Methods - Assessment

In this module, you will be introduced to working with Methods in C# Programming. This module takes us through the Characteristics and Identification of Properties, it discusses some classes of the .Net Framework that provide the ability to persist and retrieve information. It also talks about how methods make some properties come alive by performing useful actions

Methods in Classes

Save and Retrieve Info

Return and Pass Arrays

Expression Bodied Methods

Methods in Classes - Assessment

In this module, you will learn about standards associated with using Methods in Classes, as well as how to build a class to your specification. The module also discusses how to save and retrieve information in C#. You will also learn how to declare and initialize an array before passing it to a method. This topic also discusses how Expression Bodied Methods makes our codes more readable and concise.

Inheritance

Derived Classes

Override and Overload Members

Abstract Classes and Members

Inheritance - Assessment

In this module, you will learn about the concept of Inheritance in C# as well as the consideration you need to make when deciding how to design an object hierarchy. Next, you will learn about Derived classes and how to use them. You will also learn about Overriding and Overloading Members. Finally, you will learn about the Abstract Classes and Members in C#

Sealed Classes and Members

Interfaces

Interfaces in .NET Framework

Partial and Nested Classes

Namespaces

Interfaces - Assessment

This module outlines the standards of working with Interfaces in C# Programming. The module also discusses the benefits of using Sealed Classes as well as the differences between Sealed and Abstract Classes. You will also learn about the uses and implementations of  Interfaces, Namespaces and Partial/Nested Classes

Arrays

Initalize Array, Retrieve Data

Arrays as Method Parameters

Arrays in the .NET Framework

Manipulating Arrays

Allowing Flexible Sorting

Advanced Sorting

Searching Arrays

Creating Indexers

Arrays - Assessment

This module outlines the standards of using Arrays in C# Programming. The topic explains how to declare and initializing array before passing it to the method as an argument. You will also learn about the different ways of sorting an array as well as the exceptions of the methods. Then you will learn how  indexer values can be set or retrieved without explicitly specifying a type or instance member

Diploma in Programming C#: Advanced - Assessment

This free online course deals with working with objects, methods in classes, inheritance, interfaces and arrays in C#.

Diploma in Programming C#: Advanced

C# is a simple, modern, general-purpose, object-oriented programming language developed by Microsoft within its .NET initiative. This free online course will take you through various advanced concepts related to the C# programming language. Among the many learning outcomes, the course outlines how to work with objects and their various applications, and how to define a method in classes as well as how to implement them.

IDE Overview

IDE Basics

IDE Commands

Integrated Development Environment (IDE) - Assessment

This module analyses the Selenium testing tool suite as a tool for testing web applications, each tool uses, and the step-by-step means of using the functions of the Selenium IDE. This module also discusses the various Selenium IDE ways to tailor test scripts as well as different locator strategies. Assertions and test patterns will also be covered in this module.

Setup Projects

WebDriver Commands

WebDriver - Assessment

This module discusses the procedures of downloading and including the Selenium libraries in a program in addition to how drivers are used to control supported browsers. Study the procedures in configuring the web driver to control the browser along with the fetch, exercise, and verify web page elements procedures.

Selenium Fundamentals - Assessment

Master Selenium’s testing tool suite used in web applications with this free online programming course.

Selenium Fundamentals

This free online web development course offers a comprehensive guide to the principles and applications of the Selenium Integrated Development Environment (IDE). We explain step by step how to optimize the suite’s functionalities and demonstrate how to download and include the Selenium libraries in a program. This course lets you use Selenium to test web applications, which will boost the quality of your output and thus your career.

Basics of Scratch Programming

Conditionals and Iteratives

Creating Games, Animations and Songs

This module will introduce you to the basic concepts in the scratch programming language with how to use tempo, events and variables. We go through the use of coordinates, conditionals and how to draw with iteration. We will show you examples of iterative development, including how to use ask-and-answer blocks before diving into creating games.

Introduction to Scratch Programming - Course Assessment

Learn how to code with Scratch to easily create interactive stories, games and animations in this free online course.

Introduction to Scratch Programming

Scratch is a block-based programming language that lets children, young adults and digital art beginners create interactive stories, games and cartoons. This Scratch training course introduces the basics of working with sprites, costumes, event blocks and variables to design impressive scripts. We explain how to use coordinates and conditionals in Scratch before showing you how to use iterative drawing and update variables before creating games.

Setting Up and Navigation

Getting Help and Working with Files & Folders

In this module, you will be introduced to the course content, and learn the process of setting up and running some basic commands on the Bash terminal. You will also learn to search commands, check file type, locate files and display command history. Finally, you will learn to copy, move, rename and remove files and folders, using the Bash shell.

Text Files, Users and Programs

Bash Shortcuts

Working with Bash Files & Programming

In this module, you will learn to use file perusal filters, edit text files & switch users using the Bash terminal. You will also learn to kill processes, commands, and use shortcuts to carry out tasks. Finally, you will learn to write Bash scripts, and learn about comments, variables, strings & functions in the Bash scripting language.

Understanding Bash Scripting & Commands – Course assessment

Learn to use the Bash scripting language to manipulate files and directories in this free online programming course.

Understanding Bash Scripting & Commands

Bash provides an efficient way to carry out computational tasks. This course explains how to use Bash scripts to efficiently carry out tasks like swapping users, automating tasks, and creating and modifying files and folders. While these tasks are cumbersome with the GUI, you can do them using a single line on the Bash shell.

Structure of ASP.NET Core

ASP.NET Core Code Demo

Application Startup Services and Middleware

Structure and Middleware

ASP.NET Core Structure and Middleware - Assessment

This module explores what is new about the fresh technology and what Asp.Net Core is all about. It goes further to tell us how ASP.NET Core app is 
a console application. ASP.NET Core apps requires a start up, at least one. This class is responsible for configuring the request pipeline that handles all request that comes into the application.

Dependency Injection

Dependency Injection Lifetimes

Introduction to Tag Helpers

Tag Helpers Scope and Demo

Using Tag Helpers with Forms

Building Custom Tag Helpers

Dependency Injection and Tag Helpers - Assessment

In this module, you will learn about Dependency Injection as a common software engineering design principle. It outlines the major functions of the dependency injection container. This module also explores how to build some simple tag helpers and explore their features.

Introduction to View Components

View Components Demo

View Components and Entity Framework

Building a View Component

Working with View Components - Assessment

In this Module, you will learn how to create and use View Components. In this demo, we will use a simple sample app from Microsoft to illustrate the basics. Learn how to re-use summary data throughout a website and pass information to a view component to customize what data it displays including how the view displays it.

Exploring ASP.NET Core: Intermediate - Assessment

Explore the intermediate-level concepts and functionalities of ASP.NET Core with this free online course

Exploring ASP.NET Core: Intermediate

‘Exploring ASP.NET Core: Intermediate’ is a course that builds on the foundation of ASP.NET to enhance your professional skills. Learn about the structure of ASP.NET Core, the application startup services and Middleware. Gain essential insights on new cross platforms, data management and database migrations from this course to build modern apps. Register for this course today and take your coding skills to the next level!

Angular 5 Update

Angular 5 Update - Assessment

In this module, Angular 5 Update, students will go over the various course objectives and have an overview of what will go into learning about Angular. This module will breakdown how this course works and what students can expect. The module will go over many of the various updates that are new to Angular 5.

Let's Get Started

Let's Get Started - Assessment

In this module, Let's Get Started, students will learn about using the Angular CLI tool to help install Angular and set up a project. It will also go over how the Angular CLI tool can help do some heavy lifting when coding a project in Angular. Students will gain an understanding of the structure and building blocks of Angular.

Angular Components

Angular Component - Assessment

In this module, Angular Component, students will learn about the many components of Angular. Students will learn about the application structure of Angular and how it can be viewed as a component tree. The module breaks down the class file and template file of a component. The module will then provide a demonstration.

Angular Routing

Angular Routing - Assessment

In this module, Angular Routing, students will learn about the navigation features of Angular routing. The module will show students how to implement routes like URL links. Students will also learn how to do this securely. Students will learn about the included services such as router module in this module.

Section Introduction

Accessing Services

Angular Services - Assessment

In this module, Angular Services, students will learn about services. The module starts by breaking down the structure of a service. The module then covers the getMovies( ) and getCharacters( ) services, how to add them to their respective list components  and how to properly execute them with a lifecycle event in Angular.

Angular Modules

Angular Modules - Assessment

In this module, Angular Modules, students will learn about the different classes of Angular Modules. Students will learn about the properties of a module including declarations, exports, and imports. This topic will also cover the different types of view classes for a module, like components, directives, and pipes.

Styling Angular

Styling Angular - Assessment

In this module, Styling Angular, students will learn about Material Components.  Students will lean how to use these components for the purpose of styling an designing web-pages that work on desktop and mobile. They will used these tools to design a page that looks good while having a functional layout.

Directives and Pipes

Directives and Pipes - Assessment

In this module, Directives and Pipes, students will learn about directives and pipes, and how they both relate to components. Students will learn about the three type of directives, directives with templates, students directives, and attributes directives. This module will also provide an introduction to pipes and how they can deliver a better UI.

Angular Forms

Angular Forms - Assessment

In this module, Angular Forms, students will learn about how forms work in Angular. Students will learn about approaching forms in Angular in two different ways. This module will also introduce students to the Angular Forms Module. Students will also learn about reactive forms and template-driven forms.

Course Conclusion

Course Conclusion - Assessment

In this module, Course Conclusion, the course concludes with a quick summary and review of the course before the final assessment.

Starting with Angular 5 - Assessment

Free online tutorial course about the structure and building blocks of coding with Angular 5.

Starting with Angular 5

This free online course on Getting started with Angular 5 will teach you about the basics of coding with Angular 5. The course will teach you about the angular components and its structure. You will also learn about the services and modules used by Angular, how to use them to create stylish and functional web pages as well as how routing works in Angular.

Introduction to Perl

Literals and Variables

String Functions

Variables

Conditionals

Loops

In this module, you will be introduced to the general-purpose programming language Perl. This module explores a brief history of Perl, string functions, variable interpolation, and how to use loops to iterate collections of items. It illustrates the uses of variables and distinguishes between single and double coated strings.

This free online course will teach you to program in Perl, a general-purpose programming language.

Perl Fundamentals

The Perl programming language is commonly used for file processing. This free online course will teach you about the various concepts used to manipulate Perl codes. You will learn how to use string functions, lists, conditional statements, different types of loops as well as subroutines. You will also learn about literals and variables in Perl. This course is useful in developing error-free programs, graphical user interfaces or managing data.