Developer Fundamentals 2022 E-Learning

The Developer Fundamentals Learning Kit focuses on the prerequisites for every software development-related Journey or learning path. This learning is primarily designed for those who are new to programming and will help you acquire a stronger and better understanding of software development before getting deeply into learning any core programming language. Among the topics covered in this Journey are key programming fundamental concepts such as Object-Oriented Programming (OOP), databases, and Software Development Life Cycle (SDLC) phases and models. In addition, the Developer Fundamentals learning kit introduces concepts related to software design and development principles.

Learning Kits are structured learning paths, mainly within the Emerging Tech area. A Learning Kit keeps
the student working toward an overall goal, helping them to achieve your career aspirations. Each part takes the student step by step through a diverse set of topic areas. Learning Kits are
made up of required tracks, which contain all of the learning resources available such as Assessments (Final Exams), Mentor, Practice Labs and of course E learning. And all resources with a 365 days access from first activation.

This Learning Kit with more than 16 hours of learning is divided into three tracks:

Course content

Track 1: Programming Fundamentals

In this track, the focus will be on programming fundamentals where one can learn to build program logic with pseudocode, the purpose of the algorithm, Object-oriented concepts, and the best programming practices.

Courses (5 hours +)

Programming Fundamentals : Command Line Interface & Operating System Commands

Course: 1 Hour, 7 Minutes

• Course Overview
• The Windows Command Line Interface Tool
• Working with Windows Folders
• Working with Windows Files
• Handling Multiple Operations in One Windows File
• Executing a Program Using the Windows CLI
• Windows PowerShell Features and Components
• Executing Basic PowerShell Commands
• The Linux Command Line Interface Tool
• Working with Linux Folders and Files
• Working with Linux Terminal Miscellaneous Commands
• Course Summary

Programming Fundamentals: Introduction to Programming

Course: 1 Hour, 1 Minute

• Course Overview
• The Evolution of a Computer Program
• Computer Program Structure
• Data Origins and Storage
• Types of Variables
• Computer Program Functionality
• How Data Processing Works
• Standard I/O Operations
• Compiling a Written Program
• The Roles of Hardware and Software
• Different Programming Languages
• Course Summary

Programming Fundamentals: Systematic Design with Pseudocode

Course: 55 Minutes

• Course Overview
• Planning and Designing with Pseudocode
• The Input Process Output Cycle
• Controlling Program Flow
• Complex Data Design
• Handling Complex Data
• The Computer Program Life Cycle
• The Use of Program Modularity
• The Elements of Robust Programming
• The Purpose of Error Handling
• Course Summary

Programming Fundamentals: Algorithms, Sorting, & Searching

Course: 34 Minutes

• Course Overview
• Program Planning with Algorithms
• Algorithms as a Problem-solving Tool
• Algorithm Types
• The Simple Linear Search
• The Binary Search
• The Bubble Sort
• The Insertion Sort
• Course Summary

Programming Fundamentals: Object-oriented Programming

Course: 54 Minutes

• Course Overview
• Concepts Behind Object-oriented Programming (OOP)
• Features of Object-oriented Programming (OOP)
• OOP vs. Procedural Programming
• The Class, the Root of OOP
• Modularity Cohesion and Coupling
• Object-oriented Programming (OOP) Languages
• Using the C++ Programming Language
• Using the Java Programming Language
• Using the C# Programming Language
• Course Summary

Programming Fundamentals: Programming Best Practices

Course: 45 Minutes

• Course Overview
• The Need for Best Practices in Programming
• Programming Best Practices
• The Importance of Documentation in Programming
• The Purpose of Integrated Development Environments
• Error Types and Exception Handling
• Handling Exceptions with an IDE
• The Need for Programming Style and Consistency
• The Code Review Process
• Course Summary

Assessment:

Final Exam: Programming Fundamentals, will test your knowledge and application of the topics presented throughout the Programming Fundamentals courses.

Track 2: Web Fundamentals

In this track, the focus will be on web development essentials that cover the core elements and features of HTML, styling techniques with CSS, and the staples of everlasting scripting language JavaScript.

Courses (4 hours +)

Web Fundamentals: Web Development with HTML

Course: 1 Hour, 19 Minutes

• Course Overview
• Desktop vs. Web Applications
• Parts of a Web Application
• Anatomy of an HTML Document
• HTML and Its Contribution to Web Development
• Using HTML Syntax and Structure to Build a Web Page
• HTML Tags and Attributes
• Displaying Form Controls on a Web Page
• Adding Menu Items to a Web Page
• The Elements of the Document Object Model (DOM)
• HTML Standards and Features
• Inserting a Table into a Web Page
• Adding Combo Boxes and Radio Buttons to Forms
• Semantic Tags and Their Advantages
• Course Summary

Web Fundamentals: Cascading Style Sheets for Web Pages

Course: 50 Minutes

• Course Overview
• How CSS Add Style to HTML
• Customizing Text and Fonts Using CSS
• Using CSS Selector Types
• Using CSS to Achieve Page Layout
• Styling Element Borders Using CSS
• Adding Color to HTML Elements
• Adding Transformational Styles to HTML Elements
• Adding Animation Styles Using CSS
• Course Summary

Web Fundamentals: Web Fundamentals: Dynamic Web Pages with JavaScript

Course: 1 Hour, 24 Minutes

• Course Overview
• The Client-Server Environment
• The History and Purpose of JavaScript
• Variables in JavaScript
• Programming Concepts in JavaScript
• Manipulating Data with Arrays and String Functions
• Using Functions to Modify and Print Variable Values
• Making HTML Dynamic Using JavaScript
• User Input and Form Validation
• Using JavaScript for Form Validation
• Using Pattern Recognition for Form Validation
• Working with JavaScript Date Operations
• Performing Mathematical Functions with JavaScript
• Using Classes to Build JavaScript Objects
• Course Summary

Assessment:

Final Exam: Web Fundamentals, will test your knowledge and application of the topics presented throughout the Web Fundamentals courses

Track 3: Database Fundamentals

In this track, the focus will be on database concepts, RDBMS with a handful of demos on various SQL commands using MySQL.

Courses (7 hours +)

Database Fundamentals: Database Concepts

Course: 44 Minutes

• Course Overview
• The Origin of Data
• The Structure of Data
• The Storage of Data
• Working with a Database Management System (DBMS)
• Features of a DBMS
• Characteristics of a Reliable DBMS
• DBMS User Roles and Fields
• Course Overview

Database Fundamentals: Understanding Relational Database Management Systems

Course: 1 Hour, 5 Minutes

• Course Overview
• The Purpose of an RDBMS
• Popular RDBMSs on the Market
• The Feature History of Oracle RDBMS
• SQL Server RDBMS History and Features
• MySQL Database History and Features
• Working with MySQL Workbench
• Database Terminology
• Normalization of Data
• Structuring Data with Normalization
• E.F. Codd and His Contribution to RDBMSs
• Course Summary

Database Fundamentals: Getting started with SQL

Course: 56 Minutes

• Course Overview
• Concepts in Structured Query Language (SQL)
• SQL Commands
• Reserved Words Used in SQL
• Common Data Types
• Database Definition Language (DDL)
• Creating and Altering Tables
• Using Tables as Objects
• Constraint Creation
• Applying Constraints
• Violating Constraints
• Course Summary

Database Fundamentals: Working with SQL Commands

Course: 49 Minutes

• Course Overview
• Data Control Language (DCL) Commands
• Data Manipulation Language (DML)
• Inserting Multiple Records
• Data Query Language (DQL)
• Executing a DQL Statement
• Filtering and Sorting Data
• Aggregating and Grouping Data
• Creating Subqueries
• Using Different Join Types
• Joins vs. Subqueries
• Course Summary

Database Fundamentals: Database Administration Basics

Course: 55 Minutes

• Course Overview
• The Database Administrator (DBA)
• Roles and Responsibilities in the RDBMS
• Exploring GUI Admin Tools
• Performing User Administration
• Configuring Database Security
• Migrating Data
• Backing up and Restoring Databases
• Performance Tuning
• Course Summary

Assessment:

Final Exam: Database Fundamentals, will test your knowledge and application of the topics presented throughout the Database Fundamentals courses.