Background Image

Pick your Program and enter Student numbers

(You will add in student names on the next page)

Training and Certification tests Price Students
*SSCA® 'Elite' SIP training + Certification test (includes for Free.. SIP & Cloud Advanced Sales +SSSP™ test)
$451.25
SSCA® 'Elite' SIP training (no test access)
$375.00
Networking 4 VVoIP + access to the SSVVP™ Certification test
$384.00
SSCA® 'Elite' SIP training + test and Networking 4 VVoIP + SSVVP™ test - (Discounted package)
$773.10
SIP & Cloud - Advanced Sales training + SSSP™ certification test
$149.00

Certification tests only

SSCA® 'Elite' Certification test access only
$100.00
SSVVP™ Certification test access only
$75.00

We take

(default) 85 queries took 546 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `shopping_carts`15151
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';1175
3SHOW FULL COLUMNS FROM `licences`191919
4SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';116
5SHOW FULL COLUMNS FROM `users`28281
6SHOW FULL COLUMNS FROM `clients`441
7SHOW FULL COLUMNS FROM `clients_users`2279
8SHOW FULL COLUMNS FROM `logs`992
9SHOW FULL COLUMNS FROM `projects`6649
10SHOW FULL COLUMNS FROM `courses`11111
11SHOW FULL COLUMNS FROM `course_modules`18183
12SHOW FULL COLUMNS FROM `languages`881
13SHOW FULL COLUMNS FROM `tests`26261
14SHOW FULL COLUMNS FROM `questions`991
15SHOW FULL COLUMNS FROM `answers`661
16SHOW FULL COLUMNS FROM `questions_tests`221
17SHOW FULL COLUMNS FROM `languages_tests`228
18SHOW FULL COLUMNS FROM `courses_login_logs`661
19SHOW FULL COLUMNS FROM `modules`15151
20SHOW FULL COLUMNS FROM `servers`991
21SHOW FULL COLUMNS FROM `modules_login_logs`773
22SHOW FULL COLUMNS FROM `course_modules_modules`221
23SHOW FULL COLUMNS FROM `origins`222249
24SHOW FULL COLUMNS FROM `vouchers`12123
25SHOW FULL COLUMNS FROM `origins_vouchers`221
26SHOW FULL COLUMNS FROM `projects_vouchers`221
27SHOW FULL COLUMNS FROM `payments`32324
28SHOW FULL COLUMNS FROM `purchasers`19191
29SHOW FULL COLUMNS FROM `projects_users`222
30SHOW FULL COLUMNS FROM `domains`551
31SHOW FULL COLUMNS FROM `countries`881
32SHOW FULL COLUMNS FROM `taxes`881
33SHOW FULL COLUMNS FROM `email_settings`12124
34SHOW FULL COLUMNS FROM `voips`991
35SHOW FULL COLUMNS FROM `tickets`551
36SHOW FULL COLUMNS FROM `results`19195
37SHOW FULL COLUMNS FROM `tax_reports`242476
38SHOW FULL COLUMNS FROM `preferences_projects`661
39SHOW FULL COLUMNS FROM `preferences`10105
40SHOW FULL COLUMNS FROM `pdf_files`14149
41SHOW FULL COLUMNS FROM `quotes`883
42SHOW FULL COLUMNS FROM `addresses`24241
43SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_general_ci';111
44SHOW FULL COLUMNS FROM `theme_configs`661
45SHOW FULL COLUMNS FROM `groups`881
46SHOW FULL COLUMNS FROM `menu_items`7739
47SHOW FULL COLUMNS FROM `design_configs`995
48SHOW FULL COLUMNS FROM `messages`771
49SHOW FULL COLUMNS FROM `online_exams`13131
50SHOW FULL COLUMNS FROM `profiles`884
51SELECT `Domain`.`id`, `Domain`.`project_id`, `Domain`.`domain`, `Domain`.`created`, `Domain`.`modified`, `Project`.`id`, `Project`.`name`, `Project`.`alias`, `Project`.`is_admin`, `Project`.`created`, `Project`.`modified` FROM `domains` AS `Domain` LEFT JOIN `projects` AS `Project` ON (`Domain`.`project_id` = `Project`.`id`) WHERE domain = 'dev.thesipschool.com' LIMIT 1110
52SELECT `PreferencesProject`.`id`, `PreferencesProject`.`preference_id`, `PreferencesProject`.`project_id`, `PreferencesProject`.`value`, `PreferencesProject`.`created`, `PreferencesProject`.`modified`, `Project`.`id`, `Project`.`name`, `Project`.`alias`, `Project`.`is_admin`, `Project`.`created`, `Project`.`modified`, `Preference`.`id`, `Preference`.`key`, `Preference`.`type`, `Preference`.`options`, `Preference`.`name`, `Preference`.`desc`, `Preference`.`sort_order`, `Preference`.`enabled`, `Preference`.`created`, `Preference`.`modified` FROM `preferences_projects` AS `PreferencesProject` LEFT JOIN `projects` AS `Project` ON (`PreferencesProject`.`project_id` = `Project`.`id`) LEFT JOIN `preferences` AS `Preference` ON (`PreferencesProject`.`preference_id` = `Preference`.`id`) WHERE `Project`.`id` = '2' AND `Preference`.`key` = 'themeroller' LIMIT 1000
53SELECT `ThemeConfig`.`id`, `ThemeConfig`.`alias`, `ThemeConfig`.`key`, `ThemeConfig`.`value`, `ThemeConfig`.`created`, `ThemeConfig`.`modified` FROM `theme_configs` AS `ThemeConfig` WHERE `ThemeConfig`.`alias` = 'sipschool' 18180
54SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE id = 94 LIMIT 1110
55SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE id = 101 LIMIT 1110
56SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE id = 147 LIMIT 1110
57SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE id = 226 LIMIT 1110
58SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE id = 97 LIMIT 1110
59SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE `PdfFile`.`category` = 'bannergroup' ORDER BY RAND() ASC LIMIT 1112
60SELECT `DesignConfig`.`id`, `DesignConfig`.`alias`, `DesignConfig`.`group`, `DesignConfig`.`key`, `DesignConfig`.`value`, `DesignConfig`.`params`, `DesignConfig`.`enabled`, `DesignConfig`.`created`, `DesignConfig`.`modified` FROM `design_configs` AS `DesignConfig` WHERE `DesignConfig`.`alias` = 'sipschool' 33335
61SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE `PdfFile`.`id` = 264 LIMIT 11152
62SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE `PdfFile`.`id` = 228 LIMIT 1111
63SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE `PdfFile`.`id` = 446 LIMIT 1110
64SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE `PdfFile`.`id` = 430 LIMIT 1110
65SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE `PdfFile`.`id` = 479 LIMIT 1110
66SELECT `PdfFile`.`id`, `PdfFile`.`type`, `PdfFile`.`category`, `PdfFile`.`name`, `PdfFile`.`display_name`, `PdfFile`.`description`, `PdfFile`.`header`, `PdfFile`.`footer`, `PdfFile`.`orientation`, `PdfFile`.`secure`, `PdfFile`.`enabled`, `PdfFile`.`sort_order`, `PdfFile`.`created`, `PdfFile`.`modified` FROM `pdf_files` AS `PdfFile` WHERE `PdfFile`.`id` = 432 LIMIT 1110
67SELECT `PreferencesProject`.`id`, `PreferencesProject`.`preference_id`, `PreferencesProject`.`project_id`, `PreferencesProject`.`value`, `PreferencesProject`.`created`, `PreferencesProject`.`modified`, `Project`.`id`, `Project`.`name`, `Project`.`alias`, `Project`.`is_admin`, `Project`.`created`, `Project`.`modified`, `Preference`.`id`, `Preference`.`key`, `Preference`.`type`, `Preference`.`options`, `Preference`.`name`, `Preference`.`desc`, `Preference`.`sort_order`, `Preference`.`enabled`, `Preference`.`created`, `Preference`.`modified` FROM `preferences_projects` AS `PreferencesProject` LEFT JOIN `projects` AS `Project` ON (`PreferencesProject`.`project_id` = `Project`.`id`) LEFT JOIN `preferences` AS `Preference` ON (`PreferencesProject`.`preference_id` = `Preference`.`id`) WHERE alias = 'sipschool' 53530
68SELECT `Message`.`id`, `Message`.`key`, `Message`.`message`, `Message`.`enabled`, `Message`.`html`, `Message`.`created`, `Message`.`modified` FROM `messages` AS `Message` WHERE 1 = 1 33330
69SELECT `Country`.`id`, `Country`.`iso`, `Country`.`name`, `Country`.`printable_name`, `Country`.`iso3`, `Country`.`numcode`, `Country`.`tax_id`, `Country`.`sorting`, `Tax`.`id`, `Tax`.`name`, `Tax`.`local_name`, `Tax`.`code`, `Tax`.`rate`, `Tax`.`message`, `Tax`.`created`, `Tax`.`modified` FROM `countries` AS `Country` LEFT JOIN `taxes` AS `Tax` ON (`Country`.`tax_id` = `Tax`.`id`) WHERE iso = 'US' LIMIT 1110
70SHOW FULL COLUMNS FROM `projects_quotes`221
71SELECT `Quote`.* FROM `quotes` AS `Quote` LEFT JOIN `projects_quotes` AS `ProjectsQuote` ON (`ProjectsQuote`.`quote_id` = `Quote`.`id`) WHERE `ProjectsQuote`.`project_id` = 2 AND enabled = 1 AND sort_order < 99 ORDER BY `sort_order` ASC 16160
72SELECT `Quote`.* FROM `quotes` AS `Quote` LEFT JOIN `projects_quotes` AS `ProjectsQuote` ON (`ProjectsQuote`.`quote_id` = `Quote`.`id`) WHERE `ProjectsQuote`.`project_id` = 2 AND enabled = 1 AND sort_order = 99 ORDER BY RAND() ASC 001
73SELECT `MenuItem`.`id`, `MenuItem`.`key`, `MenuItem`.`name`, `MenuItem`.`link`, `MenuItem`.`style`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `menu_items` AS `MenuItem` WHERE 1 = 1 20200
74SELECT `ShoppingCart`.`id`, `ShoppingCart`.`project_id`, `ShoppingCart`.`session_id`, `ShoppingCart`.`origin_id`, `ShoppingCart`.`licence_id`, `ShoppingCart`.`price`, `ShoppingCart`.`currency_code`, `ShoppingCart`.`user_id`, `ShoppingCart`.`firstname`, `ShoppingCart`.`lastname`, `ShoppingCart`.`email`, `ShoppingCart`.`ordered`, `ShoppingCart`.`renewal`, `ShoppingCart`.`created`, `ShoppingCart`.`modified` FROM `shopping_carts` AS `ShoppingCart` WHERE `ShoppingCart`.`session_id` = 'ah57epq12bvd26sec90n3947q4' AND `ShoppingCart`.`project_id` = '2' AND `ShoppingCart`.`ordered` = 0 003
75SHOW FULL COLUMNS FROM `origins_projects`221
76SELECT `Project`.`id`, `Project`.`name`, `Project`.`alias`, `Project`.`is_admin`, `Project`.`created`, `Project`.`modified` FROM `projects` AS `Project` WHERE `Project`.`alias` = 'sipschool' LIMIT 1110
77SELECT `Origin`.`id`, `Origin`.`origin_type_id`, `Origin`.`name`, `Origin`.`alias`, `Origin`.`description`, `Origin`.`valid_months`, `Origin`.`price`, `Origin`.`usd`, `Origin`.`gbp`, `Origin`.`eur`, `Origin`.`sip_enabled`, `Origin`.`ontap_enabled`, `Origin`.`tech_access`, `Origin`.`enabled`, `Origin`.`limit_to_emails`, `Origin`.`referer`, `Origin`.`accounting`, `Origin`.`agent_id`, `Origin`.`ordering`, `Origin`.`buyable`, `Origin`.`created`, `Origin`.`modified`, `OriginsProject`.`origin_id`, `OriginsProject`.`project_id` FROM `origins` AS `Origin` JOIN `origins_projects` AS `OriginsProject` ON (`OriginsProject`.`project_id` = 2 AND `OriginsProject`.`origin_id` = `Origin`.`id`) ORDER BY `ordering` ASC 18180
78SELECT `Origin`.`id`, `Origin`.`origin_type_id`, `Origin`.`name`, `Origin`.`alias`, `Origin`.`description`, `Origin`.`valid_months`, `Origin`.`price`, `Origin`.`usd`, `Origin`.`gbp`, `Origin`.`eur`, `Origin`.`sip_enabled`, `Origin`.`ontap_enabled`, `Origin`.`tech_access`, `Origin`.`enabled`, `Origin`.`limit_to_emails`, `Origin`.`referer`, `Origin`.`accounting`, `Origin`.`agent_id`, `Origin`.`ordering`, `Origin`.`buyable`, `Origin`.`created`, `Origin`.`modified` FROM `origins` AS `Origin` WHERE `Origin`.`id` = 265 LIMIT 1110
79SELECT `Origin`.`id`, `Origin`.`origin_type_id`, `Origin`.`name`, `Origin`.`alias`, `Origin`.`description`, `Origin`.`valid_months`, `Origin`.`price`, `Origin`.`usd`, `Origin`.`gbp`, `Origin`.`eur`, `Origin`.`sip_enabled`, `Origin`.`ontap_enabled`, `Origin`.`tech_access`, `Origin`.`enabled`, `Origin`.`limit_to_emails`, `Origin`.`referer`, `Origin`.`accounting`, `Origin`.`agent_id`, `Origin`.`ordering`, `Origin`.`buyable`, `Origin`.`created`, `Origin`.`modified` FROM `origins` AS `Origin` WHERE `Origin`.`id` = 46 LIMIT 1110
80SELECT `Origin`.`id`, `Origin`.`origin_type_id`, `Origin`.`name`, `Origin`.`alias`, `Origin`.`description`, `Origin`.`valid_months`, `Origin`.`price`, `Origin`.`usd`, `Origin`.`gbp`, `Origin`.`eur`, `Origin`.`sip_enabled`, `Origin`.`ontap_enabled`, `Origin`.`tech_access`, `Origin`.`enabled`, `Origin`.`limit_to_emails`, `Origin`.`referer`, `Origin`.`accounting`, `Origin`.`agent_id`, `Origin`.`ordering`, `Origin`.`buyable`, `Origin`.`created`, `Origin`.`modified` FROM `origins` AS `Origin` WHERE `Origin`.`id` = 6 LIMIT 1110
81SELECT `Origin`.`id`, `Origin`.`origin_type_id`, `Origin`.`name`, `Origin`.`alias`, `Origin`.`description`, `Origin`.`valid_months`, `Origin`.`price`, `Origin`.`usd`, `Origin`.`gbp`, `Origin`.`eur`, `Origin`.`sip_enabled`, `Origin`.`ontap_enabled`, `Origin`.`tech_access`, `Origin`.`enabled`, `Origin`.`limit_to_emails`, `Origin`.`referer`, `Origin`.`accounting`, `Origin`.`agent_id`, `Origin`.`ordering`, `Origin`.`buyable`, `Origin`.`created`, `Origin`.`modified` FROM `origins` AS `Origin` WHERE `Origin`.`id` = 15 LIMIT 1110
82SELECT `Origin`.`id`, `Origin`.`origin_type_id`, `Origin`.`name`, `Origin`.`alias`, `Origin`.`description`, `Origin`.`valid_months`, `Origin`.`price`, `Origin`.`usd`, `Origin`.`gbp`, `Origin`.`eur`, `Origin`.`sip_enabled`, `Origin`.`ontap_enabled`, `Origin`.`tech_access`, `Origin`.`enabled`, `Origin`.`limit_to_emails`, `Origin`.`referer`, `Origin`.`accounting`, `Origin`.`agent_id`, `Origin`.`ordering`, `Origin`.`buyable`, `Origin`.`created`, `Origin`.`modified` FROM `origins` AS `Origin` WHERE `Origin`.`id` = 58 LIMIT 1110
83SELECT `Origin`.`id`, `Origin`.`origin_type_id`, `Origin`.`name`, `Origin`.`alias`, `Origin`.`description`, `Origin`.`valid_months`, `Origin`.`price`, `Origin`.`usd`, `Origin`.`gbp`, `Origin`.`eur`, `Origin`.`sip_enabled`, `Origin`.`ontap_enabled`, `Origin`.`tech_access`, `Origin`.`enabled`, `Origin`.`limit_to_emails`, `Origin`.`referer`, `Origin`.`accounting`, `Origin`.`agent_id`, `Origin`.`ordering`, `Origin`.`buyable`, `Origin`.`created`, `Origin`.`modified` FROM `origins` AS `Origin` WHERE `Origin`.`id` = 26 LIMIT 1110
84SELECT `Origin`.`id`, `Origin`.`origin_type_id`, `Origin`.`name`, `Origin`.`alias`, `Origin`.`description`, `Origin`.`valid_months`, `Origin`.`price`, `Origin`.`usd`, `Origin`.`gbp`, `Origin`.`eur`, `Origin`.`sip_enabled`, `Origin`.`ontap_enabled`, `Origin`.`tech_access`, `Origin`.`enabled`, `Origin`.`limit_to_emails`, `Origin`.`referer`, `Origin`.`accounting`, `Origin`.`agent_id`, `Origin`.`ordering`, `Origin`.`buyable`, `Origin`.`created`, `Origin`.`modified` FROM `origins` AS `Origin` WHERE `Origin`.`id` = 77 LIMIT 1110
85SELECT `PreferencesProject`.`id`, `PreferencesProject`.`preference_id`, `PreferencesProject`.`project_id`, `PreferencesProject`.`value`, `PreferencesProject`.`created`, `PreferencesProject`.`modified`, `Project`.`id`, `Project`.`name`, `Project`.`alias`, `Project`.`is_admin`, `Project`.`created`, `Project`.`modified`, `Preference`.`id`, `Preference`.`key`, `Preference`.`type`, `Preference`.`options`, `Preference`.`name`, `Preference`.`desc`, `Preference`.`sort_order`, `Preference`.`enabled`, `Preference`.`created`, `Preference`.`modified` FROM `preferences_projects` AS `PreferencesProject` LEFT JOIN `projects` AS `Project` ON (`PreferencesProject`.`project_id` = `Project`.`id`) LEFT JOIN `preferences` AS `Preference` ON (`PreferencesProject`.`preference_id` = `Preference`.`id`) WHERE `Project`.`alias` = 'bootstrap' AND `Preference`.`key` = 'vat_message' LIMIT 1110