ITS 305 Software Development Training - OEM Certkit

The Software Development CertKit 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.

The Information Technology Specialist program is aimed at candidates who are considering or just
beginning a path to a career in information technology. The ITS program is taking over from the
Microsoft MTA program.

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, 2 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.

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.

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.

Track 4: Software Design and Development Fundamentals

In this track, the focus will be on software design and development principles that empowers you to recognize why software engineering is always the base for any sort of application development and to embrace the patterns, principles, models, and tools used in the development.
Courses (5 hours +)

Software Design and Development: Software Engineering & SDLC Phases

Course: 52 Minutes

• Course Overview
• Software Engineering as a Concept
• Evolution of Software and Methodologies
• Software Development Life Cycle (SDLC) Phases
• Software Planning and Requirements Analysis
• Software Design and Prototyping
• Implementation and Development of the Application
• Software Testing and Deployment
• Software Maintenance
• Project Management
• Course Summary

Software Design and Development: Methodologies

Course: 54 Minutes

• Course Overview
• The Software Development Process
• SDLC Models and Uses
• The Waterfall Model
• The Incremental Model
• The Spiral Model
• The V-Model
• The Agile Model
• SDLC Model Comparison
• SDLC Best Practices
• Course Summary

Software Design and Development: Object-oriented Analysis and Design

Course: 39 Minutes

• Course Overview
• Introduction to Object-oriented Analysis and Design
• OOAD versus Traditional Approaches
• Conceptual Ideas in Object-oriented Programming
• OOAD Models and Methods
• Object-oriented Approach to Problem Solving
• Object-oriented Design
• OOP Design Patterns
• OOP Relationships
• Course Summary

Software Design and Development: Modeling with UML

Course: 52 Minutes

• Course Overview
• Unified Modeling Language (UML)
• Purpose of UML
• Architecture of UML
• UML Models and Diagrams
• UML Notations
• Static Diagrams
• Static Diagrams Use Cases
• Dynamic Diagrams in UML
• Dynamic Diagrams Use Cases
• Course Summary

Software Design and Development: Design Patterns & SOLID Principles

Course: 1 Hour

• Course Overview
• Need for Design Patterns
• Three Basic Types of Design Patterns
• Creational Patterns
• Structural Patterns
• Behavioral Patterns
• SOLID Design Principles
• Need for SOLID Design Principles
• SOLID Design Principles in Practice
• Software Design Best Practices
• Course Summary

Software Design and Development: Version Control System

Course: 55 Minutes

• Course Overview
• The Three-tier Architecture
• The History of Version Control
• Popular Version Control Systems
• Git Features
• Installing Git on Linux
• Configuring a Project with Git
• Creating a Workflow with Git
• GitHub Features
• Version Control Activities
• Course Summary
• Privacy and Cookie PolicyTerms of Use

Assessment:
     •  Final Exam: Software Design and Development Fundamentals.

MeasureUp Official ITS Exam Simulation:
     •  120+ questions