Oracle Administration
This course is designed to give delegates a firm foundation in basic administration of Oracle Database 11g. In this class, delegates learn how to install and ma...
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.
This course is designed to give delegates a firm foundation in basic administration of Oracle Database 11g. In this class, delegates learn how to install and ma...
Handling complex Databases is a skill that is very much in demand all around the world. Validating that you have that skill with a certification such as SQL ser...
In collaboration between Magna Skills and ShaFrost, we present the "Digital Marketing Mastery" course. This comprehensive program is designed to equip individua...
Like Software Development Life Cycle (SDLC) best practices, and Project Management (PMP) best practices ITIL focuses on IT Service best practices ITIL has now b...
Magna Skills proudly presents this intensive, practice-oriented programme designed for national telecommunications regulators and policy professionals across Af...
The Linux Server Management course offered by Magna Skills is designed to equip individuals with the knowledge and skills required to effectively manage and mai...
The ITIL® v4 Foundation course offered by Magna Skills provides participants with a comprehensive understanding of the ITIL framework and its modern, agile, an...
Planning and Administering SharePoint 2016
In this course you will learn how to secure user access to your organization’s resources. The course covers user password protection, multi-factor authenticat...
sql: SELECT COUNT(*) FROM `userlevels` WHERE `userlevelid` = -2, executionMS: 0.00048303604125977
sql: SELECT `userlevelid`, `userlevelname` FROM `userlevels`, executionMS: 0.00025296211242676
sql: SELECT COUNT(*) FROM `userlevelpermissions` WHERE `userlevelid` = -2, executionMS: 0.00074291229248047
sql: SELECT `tablename`, `userlevelid`, `permission` FROM `userlevelpermissions` WHERE `userlevelid` IN (-2), executionMS: 0.0028321743011475
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.002190113067627
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 = 809, executionMS: 0.0005950927734375
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 = 809 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 30, executionMS: 2.0874991416931
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.001967191696167
sql: SELECT COUNT(id) FROM courses, executionMS: 0.00068998336791992
sql: SELECT COUNT(id) FROM courses WHERE Featured = 1, executionMS: 0.00065493583679199
sql: SELECT COUNT(Application_ID) FROM apply, executionMS: 0.061599016189575