Data Analysis for Decision Making
At Magna Skills, we understand the critical role of data in today’s decision-driven environments. This course is meticulously designed to provide professional...
Browse our full course portfolio, filter by category, search by course title, and register for online or face-to-face training in leading destinations across Africa and beyond.
At Magna Skills, we understand the critical role of data in today’s decision-driven environments. This course is meticulously designed to provide professional...
This hands-on course, custom-designed by Magna Skills, equips professionals with the practical skills to perform data analysis using R—one of the most powerfu...
sql: SELECT COUNT(*) FROM `userlevels` WHERE `userlevelid` = -2, executionMS: 0.00058698654174805
sql: SELECT `userlevelid`, `userlevelname` FROM `userlevels`, executionMS: 0.00039005279541016
sql: SELECT COUNT(*) FROM `userlevelpermissions` WHERE `userlevelid` = -2, executionMS: 0.00071501731872559
sql: SELECT `tablename`, `userlevelid`, `permission` FROM `userlevelpermissions` WHERE `userlevelid` IN (-2), executionMS: 0.002824068069458
sql: SELECT cc.id, cc.Category_Name, COUNT(c.id) AS TotalCourses FROM course_categories cc LEFT JOIN courses c ON c.Category = cc.id WHERE cc.Active = 1 GROUP BY cc.id, cc.Category_Name ORDER BY cc.Category_Name ASC , executionMS: 0.0033450126647949
sql: SELECT COUNT(c.id) FROM courses c LEFT JOIN course_categories cc ON cc.id = c.Category WHERE 1=1 AND (c.Status = 1 OR c.Status = '1' OR c.Status = 'Active') AND c.Category = 815, executionMS: 0.00079107284545898
sql: SELECT c.id, c.Course_Title, c.Course_Code, c.Short_Description, c.Course_Outcomes, c.Course_Outline, c.Target_Audience, c.Price, c.Discount, c.TotalPrice, c.Thumbnail, c.Views, c.Featured, c.Category, cc.Category_Name, COUNT(a.Application_ID) AS TotalApplications FROM courses c LEFT JOIN course_categories cc ON cc.id = c.Category LEFT JOIN apply a ON a.Course_Title = c.id WHERE 1=1 AND (c.Status = 1 OR c.Status = '1' OR c.Status = 'Active') AND c.Category = 815 GROUP BY c.id, c.Course_Title, c.Course_Code, c.Short_Description, c.Course_Outcomes, c.Course_Outline, c.Target_Audience, c.Price, c.Discount, c.TotalPrice, c.Thumbnail, c.Views, c.Featured, c.Category, cc.Category_Name ORDER BY c.Featured DESC, TotalApplications DESC, c.Course_Title ASC LIMIT 10 OFFSET 20, executionMS: 1.0092539787292
sql: SELECT cc.id, cc.Category_Name, COUNT(c.id) AS TotalCourses FROM course_categories cc INNER JOIN courses c ON c.Category = cc.id WHERE cc.Active = 1 GROUP BY cc.id, cc.Category_Name ORDER BY TotalCourses DESC, cc.Category_Name ASC LIMIT 8 , executionMS: 0.0011708736419678
sql: SELECT COUNT(id) FROM courses, executionMS: 0.00043606758117676
sql: SELECT COUNT(id) FROM courses WHERE Featured = 1, executionMS: 0.00042200088500977
sql: SELECT COUNT(Application_ID) FROM apply, executionMS: 0.040302038192749