Workshop: Information Technology: Systems Development

Course Overview:

This certificate provides learners with the foundational knowledge and practical skills required to begin a career in software development. Students will learn to analyze requirements, design systems, write code, manage databases, and rigorously test applications using modern methodologies.

Target Audience:

Aspiring software developers, career changers, and IT professionals seeking to move into a development role.

Outline

Module 1: Software Development Principles

• Introduction to Programming Logic and Algorithms
• Variables, Data Types, and Operators
• Control Structures (Conditionals and Loops)
• Functions, Methods, and Modular Programming
• Basic Data Structures (Arrays, Lists, Dictionaries)
• Introduction to Object-Oriented Programming (OOP) Concepts
• Principles of Clean Code and Readability
• Introduction to a Programming Language (e.g., Python, C#, Java)

Module 2: System Analysis and Design

• The Role of a Systems Analyst
• Gathering and Documenting User Requirements
• Creating Use Cases and User Stories
• Modeling System Processes (Data Flow Diagrams)
• Designing User Interfaces (UI) and User Experiences (UX)
• Introduction to UML Diagrams (Class, Sequence Diagrams)
• Creating Technical Specification Documents

Module 3: Databases and SQL

• Introduction to Relational Database Concepts
• Database Normalization Principles
• Entity-Relationship (ER) Diagramming
• SQL Fundamentals: Data Definition Language (DDL)
• SQL Fundamentals: Data Manipulation Language (DML)
• Writing Advanced Queries (Joins, Unions, Aggregations)
• Integrating Applications with Databases

Module 4: Development Methodologies (Agile, Waterfall)

• Introduction to the Software Development Lifecycle (SDLC)
• The Traditional Waterfall Methodology
• The Agile Manifesto and Principles
• The Scrum Framework (Roles, Artifacts, Ceremonies)
• Kanban and Lean Development Principles
• Project Management Tools (e.g., Jira, Trello)
• Version Control with Git (Basics)

Module 5: Application Testing and Debugging