INSERT INTO `courses` VALUES
(60009,'Certificate in Community Development',2,4,6,'KNEC',1,'KCSE Mean Grade D+ (Plus).','A certificate program covering community mobilization, project management, social welfare, and advocacy.',1,'2026-06-09 13:14:44','2026-06-09 13:14:44'),
(120003,'Certificate in Information Communication Technology',2,6,1,'CDACC',1,'KCSE Mean Grade D (Plain) or equivalent','Foundation course in computer applications, basic networking, and ICT support skills.',1,'2026-06-11 13:52:28','2026-06-11 14:25:23'),
(120004,'Diploma in Business Management',2,6,2,'KASNEB',1,'KCSE Mean Grade C- or equivalent','Comprehensive business management program covering accounting, marketing, HR, and entrepreneurship.',1,'2026-06-11 13:52:28','2026-06-11 14:09:38'),
(120005,'Certificate in Business Studies',2,6,2,'CDACC',0,'KCSE Mean Grade D or equivalent','Introductory course to business principles, office administration, and basic accounting.',1,'2026-06-11 13:52:28','2026-06-11 14:27:30'),
(120006,'Diploma in Mechanical Engineering',6,6,3,'KNEC',0,'KCSE Mean Grade C- with at least C- in Mathematics and Physics','Advanced mechanical engineering program covering thermodynamics, fluid mechanics, and CAD.',1,'2026-06-11 13:52:28','2026-06-11 13:52:28'),
(120007,'Certificate in Mechanical Engineering',4,6,3,'KNEC',0,'KCSE Mean Grade D with at least D in Mathematics','Foundation mechanical engineering skills including workshop practice and basic mechanics.',1,'2026-06-11 13:52:28','2026-06-11 13:52:28'),
(150002,'Diploma in Building Technology',6,6,120002,'CDACC',1,'C and Above in KCSR','',1,'2026-06-25 18:09:38','2026-06-25 18:09:38'),
(180002,'Electrical Engineering (Diploma - Level 6)',3,8,150002,'CDACC',1,'KCSE Mean Grade C- and above','Advanced electrical engineering covering power systems, industrial controls, and renewable energy.',1,'2026-06-27 19:19:42','2026-06-27 20:32:48'),
(180003,'Electrical Installation (Diploma - Level 6)',3,8,150002,'CDACC',1,'KCSE Mean Grade C- and above','Advanced electrical installation, wiring, and maintenance for commercial and industrial systems.',1,'2026-06-27 19:19:42','2026-06-27 20:32:48'),
(180004,'Electronics (Diploma - Level 6)',3,8,150002,'CDACC',1,'KCSE Mean Grade C- and above','Diploma in electronics covering analog and digital circuits, microprocessors, and telecommunication systems.',1,'2026-06-27 19:19:42','2026-06-27 20:32:48'),
(180005,'Electrical Engineering (Certificate - Level 5)',2,5,150002,'CDACC',1,'KCSE Mean Grade D and above','Certificate course in electrical engineering fundamentals and basic power systems.',1,'2026-06-27 19:19:42','2026-06-27 19:19:42'),
(180006,'Electrical Installation (Certificate - Level 5)',2,5,150002,'CDACC',1,'KCSE Mean Grade D and above','Certificate in electrical installation for domestic and light industrial environments.',1,'2026-06-27 19:19:42','2026-06-27 19:19:42'),
(180007,'Electrical Installation (Craft - Level 4)',1,4,150002,'CDACC',1,'KCSE Mean Grade D- and above','Craft certificate focusing on practical electrical installation and wiring.',1,'2026-06-27 19:19:42','2026-06-27 20:32:50'),
(180008,'Electrical Installation (Artisan - Level 3)',1,3,150002,'CDACC',0,'KCPE','Artisan certificate in basic electrical installation and maintenance.',1,'2026-06-27 19:19:42','2026-06-27 19:19:42'),
(180009,'Computer Science (Diploma - Level 6)',3,8,1,'CDACC',1,'KCSE Mean Grade C- and above','Diploma in computer science covering programming, algorithms, and systems development.',1,'2026-06-27 19:19:45','2026-06-27 20:32:48'),
(180010,'Computer Science (Certificate - Level 5)',2,5,1,'CDACC',1,'KCSE Mean Grade D and above','Certificate in computer science fundamentals and programming basics.',1,'2026-06-27 19:19:45','2026-06-27 19:19:45'),
(180011,'ICT Technician (Diploma - Level 6)',3,8,1,'CDACC',1,'KCSE Mean Grade C- and above','Advanced ICT technician diploma in networking, security, and system administration.',1,'2026-06-27 19:19:45','2026-06-27 20:32:48'),
(180012,'ICT Technician (Certificate - Level 5)',2,5,1,'CDACC',1,'KCSE Mean Grade D and above','Certificate in ICT support, hardware, and networking fundamentals.',1,'2026-06-27 19:19:45','2026-06-27 19:19:45'),
(180013,'ICT Technician (Craft - Level 4)',1,4,1,'CDACC',1,'KCSE Mean Grade D- or equivalent','Craft certificate for ICT maintenance and troubleshooting.',1,'2026-06-27 19:19:45','2026-06-27 19:19:45'),
(180014,'Civil Engineering (Diploma - Level 6)',3,8,120002,'CDACC',1,'KCSE Mean Grade C- and above','Diploma in civil engineering covering structural design, surveying, and infrastructure.',1,'2026-06-27 19:19:48','2026-06-27 20:32:48'),
(180015,'Civil Engineering (Certificate - Level 5)',2,5,120002,'CDACC',1,'KCSE Mean Grade D+ and above','Certificate in civil engineering fundamentals and construction supervision.',1,'2026-06-27 19:19:48','2026-06-27 19:19:48'),
(180016,'Building Technician (Diploma - Level 6)',3,8,120002,'CDACC',1,'KCSE Mean Grade C- and above','Advanced building technology covering construction management and materials testing.',1,'2026-06-27 19:19:48','2026-06-27 20:32:48'),
(180017,'Building Technician (Certificate - Level 5)',2,5,120002,'CDACC',1,'KCSE Mean Grade D+ and above','Certificate in building technology and basic construction skills.',1,'2026-06-27 19:19:48','2026-06-27 19:19:48'),
(180018,'Masonry (Craft - Level 4)',1,4,120002,'CDACC',1,'KCSE Mean Grade D-','Craft certificate in bricklaying, blockwork, and concrete structures.',1,'2026-06-27 19:19:48','2026-06-27 20:32:50'),
(180019,'Masonry (Artisan - Level 3)',1,3,120002,'CDACC',0,'KCPE','Artisan certificate in basic masonry and wall construction.',1,'2026-06-27 19:19:48','2026-06-27 19:19:48'),
(180020,'Plumbing (Craft - Level 4)',1,4,120002,'CDACC',1,'KCSE Mean Grade D-','Craft certificate in plumbing, pipe fitting, and water system installation.',1,'2026-06-27 19:19:48','2026-06-27 20:32:50'),
(180021,'Plumbing (Artisan - Level 3)',1,3,120002,'CDACC',0,'KCPE','Artisan certificate in basic plumbing and sanitary works.',1,'2026-06-27 19:19:48','2026-06-27 19:19:48'),
(180022,'Carpentry and Joinery (Craft - Level 4)',1,4,120002,'CDACC',1,'KCSE Mean Grade D-','Craft certificate in carpentry, cabinet making, and joinery.',1,'2026-06-27 19:19:48','2026-06-27 20:32:50'),
(180023,'Carpentry and Joinery (Artisan - Level 3)',1,3,120002,'CDACC',0,'KCPE','Artisan certificate in basic carpentry and woodwork.',1,'2026-06-27 19:19:48','2026-06-27 19:19:48'),
(180024,'Welding and Fabrication (Certificate - Level 5)',2,5,150003,'CDACC',1,'KCSE Mean Grade D and above','Certificate in welding, fabrication, and metal structure construction.',1,'2026-06-27 19:19:50','2026-06-27 19:19:50'),
(180025,'Welding and Fabrication (Craft - Level 4)',1,4,150003,'CDACC',1,'KCSE Mean Grade D-','Craft certificate in basic welding and metal joining techniques.',1,'2026-06-27 19:19:50','2026-06-27 19:19:50'),
(180026,'Mechanical Engineering - Production Technology (Certificate - Level 5)',2,5,150003,'CDACC',1,'KCSE Mean Grade D and above','Certificate in production engineering and manufacturing processes.',1,'2026-06-27 19:19:50','2026-06-27 19:19:50'),
(180027,'Mechanical Engineering - Production Technology (Craft - Level 4)',1,4,150003,'CDACC',1,'KCSE Mean Grade D-','Craft certificate in production technology and machine operations.',1,'2026-06-27 19:19:50','2026-06-27 19:19:50'),
(180028,'Mechanical Engineering - Automotive (Craft - Level 4)',1,4,150003,'CDACC',1,'KCSE Mean Grade D-','Craft certificate in automotive mechanics and vehicle repair.',1,'2026-06-27 19:19:50','2026-06-27 19:19:50'),
(180029,'Banking and Finance (Diploma - Level 6)',3,8,2,'CDACC',1,'KCSE Mean Grade C- and above','Diploma in banking, finance, and financial management.',1,'2026-06-27 19:19:53','2026-06-27 20:32:48'),
(180030,'Banking and Finance (Certificate - Level 5)',2,5,2,'CDACC',1,'KCSE Mean Grade D and above','Certificate in banking and finance fundamentals.',1,'2026-06-27 19:19:53','2026-06-27 19:19:53'),
(180031,'Sales and Marketing (Diploma - Level 6)',3,8,2,'CDACC',1,'KCSE Mean Grade C- and above','Diploma in sales, marketing, and consumer behavior.',1,'2026-06-27 19:19:53','2026-06-27 20:32:48'),
(180032,'Sales and Marketing (Craft - Level 4)',1,4,2,'CDACC',1,'KCSE Mean Grade D-','Craft certificate in sales and marketing principles.',1,'2026-06-27 19:19:53','2026-06-27 19:19:53'),
(180033,'Sales and Marketing (Artisan - Level 3)',1,3,2,'CDACC',0,'KCPE','Artisan certificate in basic sales techniques.',1,'2026-06-27 19:19:53','2026-06-27 19:19:53'),
(180034,'Clerical Operations (Certificate - Level 5)',2,5,2,'CDACC',1,'KCSE Mean Grade D and above','Certificate in clerical and administrative office operations.',1,'2026-06-27 19:19:53','2026-06-27 19:19:53'),
(180035,'Clerical Operations (Craft - Level 4)',1,4,2,'CDACC',1,'KCSE Mean Grade D-','Craft certificate in office clerical work.',1,'2026-06-27 19:19:53','2026-06-27 19:19:53'),
(180036,'Store Keeping (Diploma - Level 6)',3,8,2,'CDACC',1,'KCSE Mean Grade C- and above','Diploma in inventory management, warehousing, and supply chain.',1,'2026-06-27 19:19:53','2026-06-27 20:32:48'),
(180037,'Store Keeping (Artisan - Level 3)',1,3,2,'CDACC',0,'KCPE','Artisan certificate in basic store keeping and stock control.',1,'2026-06-27 19:19:53','2026-06-27 19:19:53'),
(180038,'Front Office Operations (Certificate - Level 5)',2,5,2,'CDACC',1,'KCSE Mean Grade D and above','Certificate in front office management and customer service.',1,'2026-06-27 19:19:53','2026-06-27 19:19:53'),
(180039,'Front Office Operations (Craft - Level 4)',1,4,2,'CDACC',1,'KCSE Mean Grade D-','Craft certificate in front office and reception operations.',1,'2026-06-27 19:19:53','2026-06-27 19:19:53'),
(180040,'Office Assistant (Artisan - Level 3)',1,3,2,'CDACC',0,'KCPE','Artisan certificate in office assistance and support.',1,'2026-06-27 19:19:53','2026-06-27 19:19:53'),
(180041,'Office Administration (Diploma - Level 6)',3,8,2,'CDACC',1,'KCSE Mean Grade C- and above','Diploma in office administration and management.',1,'2026-06-27 19:19:53','2026-06-27 20:32:48'),
(180042,'Human Resource Management (Certificate - Level 5)',2,5,2,'CDACC',1,'KCSE Mean Grade D and above','Certificate in HR management, recruitment, and employee relations.',1,'2026-06-27 19:19:53','2026-06-27 19:19:53'),
(180043,'Human Resource Management (Craft - Level 4)',1,4,2,'CDACC',1,'KCSE Mean Grade D-','Craft certificate in basic HR and payroll administration.',1,'2026-06-27 19:19:53','2026-06-27 19:19:53'),
(180044,'Supply Chain Management (Diploma - Level 6)',3,8,2,'CDACC',1,'KCSE Mean Grade C- and above','Diploma in supply chain, logistics, and procurement.',1,'2026-06-27 19:19:53','2026-06-27 20:32:48'),
(180045,'Supply Chain Management (Certificate - Level 5)',2,5,2,'CDACC',1,'KCSE Mean Grade D and above','Certificate in supply chain and logistics fundamentals.',1,'2026-06-27 19:19:53','2026-06-27 19:19:53'),
(180046,'Co‑Operative Management (Diploma - Level 6)',3,8,2,'CDACC',1,'KCSE Mean Grade C- and above','Diploma in cooperative management and enterprise development.',1,'2026-06-27 19:19:53','2026-06-27 20:32:48'),
(180047,'Co‑Operative Management (Certificate - Level 5)',2,5,2,'CDACC',1,'KCSE Mean Grade D and above','Certificate in cooperative management and governance.',1,'2026-06-27 19:19:53','2026-06-27 19:19:53'),
(180048,'Fashion and Design (Diploma - Level 6)',3,8,9,'CDACC',1,'KCSE Mean Grade C- and above','Diploma in fashion design, garment construction, and textiles.',1,'2026-06-27 19:19:55','2026-06-27 20:32:48'),
(180049,'Fashion and Design (Certificate - Level 5)',2,5,9,'CDACC',1,'KCSE Mean Grade D and above','Certificate in fashion design and pattern making.',1,'2026-06-27 19:19:55','2026-06-27 19:19:55'),
(180050,'Fashion and Design (Craft - Level 4)',1,4,9,'CDACC',1,'KCSE Mean Grade D-','Craft certificate in basic fashion and garment production.',1,'2026-06-27 19:19:55','2026-06-27 19:19:55'),
(180051,'Fashion and Design (Artisan - Level 3)',1,3,9,'CDACC',0,'KCPE','Artisan certificate in introductory fashion and sewing.',1,'2026-06-27 19:19:55','2026-06-27 19:19:55'),
(180052,'Food and Beverage (Diploma - Level 6)',3,8,150005,'CDACC',1,'KCSE Mean Grade C- and above','Diploma in food production, beverage service, and kitchen management.',1,'2026-06-27 19:19:59','2026-06-27 20:32:48'),
(180053,'Food and Beverage (Certificate - Level 5)',2,5,150005,'CDACC',1,'KCSE Mean Grade D and above','Certificate in food and beverage service and preparation.',1,'2026-06-27 19:19:59','2026-06-27 19:19:59'),
(180054,'Food and Beverage (Craft - Level 4)',1,4,150005,'CDACC',1,'KCSE Mean Grade D-','Craft certificate in basic food handling and beverage service.',1,'2026-06-27 19:19:59','2026-06-27 19:19:59'),
(180055,'Food and Beverage (Artisan - Level 3)',1,3,150005,'CDACC',0,'KCPE','Artisan certificate in introductory food preparation.',1,'2026-06-27 19:19:59','2026-06-27 19:19:59'),
(180056,'Hair Dressing (Diploma - Level 6)',3,8,150004,'CDACC',1,'KCSE Mean Grade C- and above','Diploma in advanced hairdressing, styling, and salon management.',1,'2026-06-27 19:20:01','2026-06-27 20:32:48'),
(180057,'Hair Dressing (Certificate - Level 5)',2,5,150004,'CDACC',1,'KCSE Mean Grade D and above','Certificate in hairdressing, cutting, and styling.',1,'2026-06-27 19:20:01','2026-06-27 19:20:01'),
(180058,'Hair Dressing (Craft - Level 4)',1,4,150004,'CDACC',1,'KCSE Mean Grade D-','Craft certificate in basic hairdressing and salon skills.',1,'2026-06-27 19:20:01','2026-06-27 19:20:01'),
(180059,'Hair Dressing (Artisan - Level 3)',1,3,150004,'CDACC',0,'KCPE','Artisan certificate in introductory hairdressing.',1,'2026-06-27 19:20:01','2026-06-27 19:20:01'),
(180060,'Beauty Therapy (Diploma - Level 6)',3,8,150004,'CDACC',1,'KCSE Mean Grade C- and above','Diploma in beauty therapy, skincare, and cosmetology.',1,'2026-06-27 19:20:01','2026-06-27 20:32:48'),
(180061,'Beauty Therapy (Certificate - Level 5)',2,5,150004,'CDACC',1,'KCSE Mean Grade D and above','Certificate in beauty therapy and cosmetics.',1,'2026-06-27 19:20:01','2026-06-27 19:20:01'),
(180062,'Beauty Therapy (Craft - Level 4)',1,4,150004,'CDACC',1,'KCSE Mean Grade D-','Craft certificate in basic beauty therapy.',1,'2026-06-27 19:20:01','2026-06-27 19:20:01'),
(180063,'Beauty Therapy (Artisan - Level 3)',1,3,150004,'CDACC',0,'KCPE','Artisan certificate in introductory beauty therapy.',1,'2026-06-27 19:20:01','2026-06-27 19:20:01'),
(180064,'Solar Installation',0,0,150002,'Internal',0,'Open','3‑week short course in solar panel installation and maintenance.',1,'2026-06-27 19:22:06','2026-06-27 19:22:06'),
(180065,'CCTV Installation',0,0,150002,'Internal',0,'Open','3‑week short course in CCTV system setup and troubleshooting.',1,'2026-06-27 19:22:06','2026-06-27 19:22:06'),
(180066,'Domestic Wireman',0,0,150002,'Internal',0,'Open','3‑week short course in domestic electrical wiring and safety.',1,'2026-06-27 19:22:06','2026-06-27 19:22:06'),
(180067,'Electronic Repairs',0,0,150002,'Internal',0,'Open','3‑week short course in basic electronic device repair.',1,'2026-06-27 19:22:06','2026-06-27 19:22:06'),
(180068,'Computer Packages',0,0,1,'Internal',0,'Open','3‑week short course covering basic computer applications and packages.',1,'2026-06-27 19:22:08','2026-06-27 19:22:08'),
(180069,'Internet',0,0,1,'Internal',0,'Open','3‑week short course on internet navigation, email, and online safety.',1,'2026-06-27 19:22:08','2026-06-27 19:22:08'),
(180070,'Pipe Fitting and Installation',0,0,120002,'Internal',0,'Open','3‑week short course in pipe fitting, plumbing, and water system installation.',1,'2026-06-27 19:22:11','2026-06-27 19:22:11'),
(180071,'Painting',0,0,120002,'Internal',0,'Open','3‑week short course in interior and exterior painting techniques.',1,'2026-06-27 19:22:11','2026-06-27 19:22:11'),
(180072,'Tiling',0,0,120002,'Internal',0,'Open','3‑week short course in tile laying and finishing.',1,'2026-06-27 19:22:11','2026-06-27 19:22:11'),
(180073,'General Repair and Grinding',0,0,150003,'Internal',0,'Open','3‑week short course in general mechanical repair and grinding techniques.',1,'2026-06-27 19:22:13','2026-06-27 19:22:13'),
(180074,'Make Up',0,0,150004,'Internal',0,'Open','3‑week short course in professional make‑up application.',1,'2026-06-27 19:22:16','2026-06-27 19:22:16'),
(180075,'Agriculture Extension Level 4',1,4,150006,'CDACC',1,'A mean grade of D- (minus) and above in KCSE, or CBET L3, L3 Modular in related course or equivalent qualification as determined by KNQA','Craft certificate in agricultural extension services focusing on basic farming techniques and community outreach.',1,'2026-06-27 19:34:34','2026-06-27 19:34:34'),
(180076,'Agriculture Extension Level 5',2,5,150006,'CDACC',1,'A mean grade of D (plain) and above in KCSE, or CBET L4, L4 Modular in related course or ARTISAN KNEC Certificate or equivalent qualification as determined by KNQA','Certificate in agricultural extension, covering advanced crop and livestock management, extension communication, and project planning.',1,'2026-06-27 19:34:34','2026-06-27 19:34:34'),
(180077,'Agriculture Extension Level 6',3,8,150006,'CDACC',1,'A mean grade of C- (minus) and above in KCSE, or CBET L5, L5 Modular in related course or CRAFT KNEC Certificate or equivalent qualification as determined by KNQA','Diploma in agricultural extension, preparing graduates for professional roles in agricultural advisory services, agribusiness management, and rural development.',1,'2026-06-27 19:34:34','2026-06-27 19:34:34');
