Price: ZMW 350.00

Enrolled learners: 303

Graduates: 224

Description:
This certificate course equips learners with the creative, technical, and practical skills needed to produce professional visual communication materials. Students will learn design principles, typography, colour theory, image editing, logo creation, branding, poster design, and digital marketing graphics.

Learners will complete practical projects and develop a portfolio demonstrating their graphic design skills.

Duration: 3 weeks

Requirements:
A laptop or desktop running Windows 10 (64-bit) or macOS.

Certificate: Yes

---

Course Structure

Introduction to Graphic Designing

Colour Theory and Typography

Image Editing and Manipulation

Vector Graphics and Logo Design

Print Design and Layout

Digital and Social Media Design

Branding and Visual Identity

• Meaning and importance of graphic design
• Types of graphic design

Final Project and Portfolio

Price: ZMW 500.00

Enrolled learners: 301

Graduates: 3

Description:
This course provides a comprehensive introduction to Database Management Systems (DBMS), equipping learners with the knowledge and practical skills needed to design, create, manage, and maintain databases. Learners will explore database concepts, relational database models, entity-relationship diagrams, database architecture, and normalization techniques.

The course covers SQL fundamentals, including creating databases and tables, inserting and updating records, retrieving information, deleting data, and writing advanced queries using joins, aggregate functions, and subqueries. Learners will also study database constraints, transactions, security, backup and recovery, and performance optimization.

Through practical exercises and hands-on projects using MySQL, learners will develop the skills to build and manage relational databases for real-world applications, including student management systems and other information systems.

By the end of the course, learners will be able to design efficient databases, write SQL queries confidently, maintain data integrity, and apply database management principles to practical computing and business problems.

Duration: 1 month

Requirements:
Prerequisites:
- Basic computer literacy and familiarity with using computers.
- Basic understanding of data and information management.
- Basic knowledge of mathematics and logical thinking.
- No prior database programming experience is required.
Requirements:
- A computer or laptop with internet access.
- A modern web browser for accessing learning materials.
- Access to a database management system such as MySQL.
- MySQL Workbench, phpMyAdmin, or another database management tool.
- A text editor or code editor, such as Visual Studio Code, for writing SQL queries.
- Willingness to participate in practical exercises, assignments, and database projects.

Certificate: Yes

---

Course Structure

Introduction to Database Management Systems

Database Models and Architecture

Database Design and ER Modelling

SQL Fundamentals

Advanced SQL Queries

Database Normalization

Transactions, Security and Recovery

Practical Database Project

Price: ZMW 500.00

Enrolled learners: 306

Graduates: 1

Description:
The Web Development course provides students with practical knowledge and skills required to design, develop, and maintain modern websites and web applications. The course introduces learners to the fundamental technologies used on the web, including HTML, CSS, JavaScript, databases, and server-side programming.

Students will learn how to structure web pages, create responsive and user-friendly interfaces, add interactive functionality, work with databases, and develop dynamic web applications. The course combines theoretical concepts with practical exercises and projects to help learners build real-world web solutions.

By the end of the course, students will be able to create complete websites and functional web applications from the ground up. They will also understand basic web hosting, website deployment, security principles, and best practices for maintaining web applications.

### What Students Will Learn

* HTML and semantic web page structure
* CSS and responsive website design
* JavaScript and interactive web functionality
* User interface and user experience fundamentals
* PHP and server-side web development
* MySQL database design and management
* Connecting websites to databases
* Forms, authentication, and user management
* CRUD operations in web applications
* Introduction to modern web development frameworks
* Website security and basic security practices
* Web hosting and application deployment
* Building and managing real-world web projects

Practical Project

Students will complete a practical web development project where they design and develop a functional website or web application. The project will allow learners to apply the concepts covered throughout the course and demonstrate their ability to build a complete web solution.

Career Opportunities

After completing the course, learners can pursue opportunities such as:

Junior Web Developer
Front-End Developer
Back-End Developer
Full-Stack Web Developer
Website Designer
WordPress/Web Content Developer
Freelance Web Developer
Junior Software Developer
Web Application Developer
Digital Solutions Developer

Duration: 2 months

Requirements:
Before starting the Web Development course, students should have:

Basic computer literacy and familiarity with using a computer.
Basic knowledge of operating systems and file management.
Ability to use a web browser and navigate the internet.
Basic understanding of typing and working with files and folders.
Basic knowledge of Microsoft Office or similar productivity software is helpful but not mandatory.
No prior programming experience is required.
A computer or laptop with access to a code editor and web browser is recommended.
An interest in learning programming, website design, and web technologies.

Certificate: Yes

---

Course Structure

Introduction to web development

• Getting started with web development
• Understanding the web
• Web page

Introduction to html

• Basic HTML elements
• Advanced HTML elements
• Links and Inputs

Introduction to CSS

• Basic of css
• How to Style a morden website
• How to style Morden website part 2
• How to style modern website part 3
• Summary on CSS