NP URI: www.nobleprog.co.cr/en/cc/adsql?participants=1&how=public Undefined property: stdClass::$excluded_sites /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php:108 Array
(
    [0] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 108
            [function] => myErrorHandler
            [args] => Array
                (
                    [0] => 2
                    [1] => Undefined property: stdClass::$excluded_sites
                    [2] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
                    [3] => 108
                )

        )

    [1] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 195
            [function] => hrquery_outline_load_all
            [args] => Array
                (
                    [0] => adsql
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [2] => Array
        (
            [file] => /apps/nobleprog-website/includes/functions/course-functions.php
            [line] => 37
            [function] => hrquery_outline_load_for_fe
            [args] => Array
                (
                    [0] => adsql
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [3] => Array
        (
            [file] => /apps/nobleprog-website/modules/course/course.php
            [line] => 160
            [function] => hrquery_outline_load_all_v2
            [args] => Array
                (
                    [0] => adsql
                )

        )

    [4] => Array
        (
            [file] => /apps/nobleprog-website/modules/course/course.php
            [line] => 13
            [function] => course_get_outline
            [args] => Array
                (
                    [0] => adsql
                )

        )

    [5] => Array
        (
            [file] => /apps/nobleprog-website/core/routes.php
            [line] => 19
            [function] => course_menu_callback
            [args] => Array
                (
                    [0] => /en/cc/adsql?participants=1&how=public
                )

        )

    [6] => Array
        (
            [file] => /apps/nobleprog-website/__index.php
            [line] => 103
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/core/routes.php
                )

            [function] => require_once
        )

    [7] => Array
        (
            [file] => /apps/nobleprog-website/_index.php
            [line] => 26
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/__index.php
                )

            [function] => include_once
        )

    [8] => Array
        (
            [file] => /apps/hitra7/index.php
            [line] => 58
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/_index.php
                )

            [function] => include_once
        )

)
NP URI: www.nobleprog.co.cr/en/cc/adsql?participants=1&how=public Undefined property: stdClass::$excluded_sites /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php:108 Array
(
    [0] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 108
            [function] => myErrorHandler
            [args] => Array
                (
                    [0] => 2
                    [1] => Undefined property: stdClass::$excluded_sites
                    [2] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
                    [3] => 108
                )

        )

    [1] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 195
            [function] => hrquery_outline_load_all
            [args] => Array
                (
                    [0] => 3057
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [2] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 43
            [function] => hrquery_outline_load_for_fe
            [args] => Array
                (
                    [0] => 3057
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                    [3] => Array
                        (
                            [0] => category_overview
                            [1] => overview
                        )

                )

        )

    [3] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 54
            [function] => hrquery_get_outline_by_cc_langs
            [args] => Array
                (
                    [0] => 3057
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [4] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 63
            [function] => _hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => 3057
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [5] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 74
            [function] => hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [6] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/outlines.logic.php
            [line] => 209
            [function] => hrquery_get_outlines_by_course_codes
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                )

        )

    [7] => Array
        (
            [file] => /apps/nobleprog-website/modules/course/course.php
            [line] => 25
            [function] => hrquery_outline_get_related
            [args] => Array
                (
                    [0] => hitracr
                    [1] => adsql
                )

        )

    [8] => Array
        (
            [file] => /apps/nobleprog-website/core/routes.php
            [line] => 19
            [function] => course_menu_callback
            [args] => Array
                (
                    [0] => /en/cc/adsql?participants=1&how=public
                )

        )

    [9] => Array
        (
            [file] => /apps/nobleprog-website/__index.php
            [line] => 103
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/core/routes.php
                )

            [function] => require_once
        )

    [10] => Array
        (
            [file] => /apps/nobleprog-website/_index.php
            [line] => 26
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/__index.php
                )

            [function] => include_once
        )

    [11] => Array
        (
            [file] => /apps/hitra7/index.php
            [line] => 58
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/_index.php
                )

            [function] => include_once
        )

)
NP URI: www.nobleprog.co.cr/en/cc/adsql?participants=1&how=public Undefined property: stdClass::$excluded_sites /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php:108 Array
(
    [0] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 108
            [function] => myErrorHandler
            [args] => Array
                (
                    [0] => 2
                    [1] => Undefined property: stdClass::$excluded_sites
                    [2] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
                    [3] => 108
                )

        )

    [1] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 195
            [function] => hrquery_outline_load_all
            [args] => Array
                (
                    [0] => 3119
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [2] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 43
            [function] => hrquery_outline_load_for_fe
            [args] => Array
                (
                    [0] => 3119
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                    [3] => Array
                        (
                            [0] => category_overview
                            [1] => overview
                        )

                )

        )

    [3] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 54
            [function] => hrquery_get_outline_by_cc_langs
            [args] => Array
                (
                    [0] => 3119
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [4] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 63
            [function] => _hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => 3119
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [5] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 74
            [function] => hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [6] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/outlines.logic.php
            [line] => 209
            [function] => hrquery_get_outlines_by_course_codes
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                )

        )

    [7] => Array
        (
            [file] => /apps/nobleprog-website/modules/course/course.php
            [line] => 25
            [function] => hrquery_outline_get_related
            [args] => Array
                (
                    [0] => hitracr
                    [1] => adsql
                )

        )

    [8] => Array
        (
            [file] => /apps/nobleprog-website/core/routes.php
            [line] => 19
            [function] => course_menu_callback
            [args] => Array
                (
                    [0] => /en/cc/adsql?participants=1&how=public
                )

        )

    [9] => Array
        (
            [file] => /apps/nobleprog-website/__index.php
            [line] => 103
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/core/routes.php
                )

            [function] => require_once
        )

    [10] => Array
        (
            [file] => /apps/nobleprog-website/_index.php
            [line] => 26
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/__index.php
                )

            [function] => include_once
        )

    [11] => Array
        (
            [file] => /apps/hitra7/index.php
            [line] => 58
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/_index.php
                )

            [function] => include_once
        )

)
NP URI: www.nobleprog.co.cr/en/cc/adsql?participants=1&how=public Undefined property: stdClass::$excluded_sites /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php:108 Array
(
    [0] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 108
            [function] => myErrorHandler
            [args] => Array
                (
                    [0] => 2
                    [1] => Undefined property: stdClass::$excluded_sites
                    [2] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
                    [3] => 108
                )

        )

    [1] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 195
            [function] => hrquery_outline_load_all
            [args] => Array
                (
                    [0] => 3308
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [2] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 43
            [function] => hrquery_outline_load_for_fe
            [args] => Array
                (
                    [0] => 3308
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                    [3] => Array
                        (
                            [0] => category_overview
                            [1] => overview
                        )

                )

        )

    [3] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 54
            [function] => hrquery_get_outline_by_cc_langs
            [args] => Array
                (
                    [0] => 3308
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [4] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 63
            [function] => _hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => 3308
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [5] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 74
            [function] => hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [6] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/outlines.logic.php
            [line] => 209
            [function] => hrquery_get_outlines_by_course_codes
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                )

        )

    [7] => Array
        (
            [file] => /apps/nobleprog-website/modules/course/course.php
            [line] => 25
            [function] => hrquery_outline_get_related
            [args] => Array
                (
                    [0] => hitracr
                    [1] => adsql
                )

        )

    [8] => Array
        (
            [file] => /apps/nobleprog-website/core/routes.php
            [line] => 19
            [function] => course_menu_callback
            [args] => Array
                (
                    [0] => /en/cc/adsql?participants=1&how=public
                )

        )

    [9] => Array
        (
            [file] => /apps/nobleprog-website/__index.php
            [line] => 103
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/core/routes.php
                )

            [function] => require_once
        )

    [10] => Array
        (
            [file] => /apps/nobleprog-website/_index.php
            [line] => 26
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/__index.php
                )

            [function] => include_once
        )

    [11] => Array
        (
            [file] => /apps/hitra7/index.php
            [line] => 58
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/_index.php
                )

            [function] => include_once
        )

)
NP URI: www.nobleprog.co.cr/en/cc/adsql?participants=1&how=public Undefined property: stdClass::$excluded_sites /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php:108 Array
(
    [0] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 108
            [function] => myErrorHandler
            [args] => Array
                (
                    [0] => 2
                    [1] => Undefined property: stdClass::$excluded_sites
                    [2] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
                    [3] => 108
                )

        )

    [1] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 195
            [function] => hrquery_outline_load_all
            [args] => Array
                (
                    [0] => 3358
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [2] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 43
            [function] => hrquery_outline_load_for_fe
            [args] => Array
                (
                    [0] => 3358
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                    [3] => Array
                        (
                            [0] => category_overview
                            [1] => overview
                        )

                )

        )

    [3] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 54
            [function] => hrquery_get_outline_by_cc_langs
            [args] => Array
                (
                    [0] => 3358
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [4] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 63
            [function] => _hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => 3358
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [5] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 74
            [function] => hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [6] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/outlines.logic.php
            [line] => 209
            [function] => hrquery_get_outlines_by_course_codes
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                )

        )

    [7] => Array
        (
            [file] => /apps/nobleprog-website/modules/course/course.php
            [line] => 25
            [function] => hrquery_outline_get_related
            [args] => Array
                (
                    [0] => hitracr
                    [1] => adsql
                )

        )

    [8] => Array
        (
            [file] => /apps/nobleprog-website/core/routes.php
            [line] => 19
            [function] => course_menu_callback
            [args] => Array
                (
                    [0] => /en/cc/adsql?participants=1&how=public
                )

        )

    [9] => Array
        (
            [file] => /apps/nobleprog-website/__index.php
            [line] => 103
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/core/routes.php
                )

            [function] => require_once
        )

    [10] => Array
        (
            [file] => /apps/nobleprog-website/_index.php
            [line] => 26
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/__index.php
                )

            [function] => include_once
        )

    [11] => Array
        (
            [file] => /apps/hitra7/index.php
            [line] => 58
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/_index.php
                )

            [function] => include_once
        )

)
NP URI: www.nobleprog.co.cr/en/cc/adsql?participants=1&how=public Undefined property: stdClass::$excluded_sites /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php:108 Array
(
    [0] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 108
            [function] => myErrorHandler
            [args] => Array
                (
                    [0] => 2
                    [1] => Undefined property: stdClass::$excluded_sites
                    [2] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
                    [3] => 108
                )

        )

    [1] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 195
            [function] => hrquery_outline_load_all
            [args] => Array
                (
                    [0] => 3410
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [2] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 43
            [function] => hrquery_outline_load_for_fe
            [args] => Array
                (
                    [0] => 3410
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                    [3] => Array
                        (
                            [0] => category_overview
                            [1] => overview
                        )

                )

        )

    [3] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 54
            [function] => hrquery_get_outline_by_cc_langs
            [args] => Array
                (
                    [0] => 3410
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [4] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 63
            [function] => _hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => 3410
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [5] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 74
            [function] => hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [6] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/outlines.logic.php
            [line] => 209
            [function] => hrquery_get_outlines_by_course_codes
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                )

        )

    [7] => Array
        (
            [file] => /apps/nobleprog-website/modules/course/course.php
            [line] => 25
            [function] => hrquery_outline_get_related
            [args] => Array
                (
                    [0] => hitracr
                    [1] => adsql
                )

        )

    [8] => Array
        (
            [file] => /apps/nobleprog-website/core/routes.php
            [line] => 19
            [function] => course_menu_callback
            [args] => Array
                (
                    [0] => /en/cc/adsql?participants=1&how=public
                )

        )

    [9] => Array
        (
            [file] => /apps/nobleprog-website/__index.php
            [line] => 103
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/core/routes.php
                )

            [function] => require_once
        )

    [10] => Array
        (
            [file] => /apps/nobleprog-website/_index.php
            [line] => 26
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/__index.php
                )

            [function] => include_once
        )

    [11] => Array
        (
            [file] => /apps/hitra7/index.php
            [line] => 58
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/_index.php
                )

            [function] => include_once
        )

)
NP URI: www.nobleprog.co.cr/en/cc/adsql?participants=1&how=public Undefined property: stdClass::$excluded_sites /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php:108 Array
(
    [0] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 108
            [function] => myErrorHandler
            [args] => Array
                (
                    [0] => 2
                    [1] => Undefined property: stdClass::$excluded_sites
                    [2] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
                    [3] => 108
                )

        )

    [1] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 195
            [function] => hrquery_outline_load_all
            [args] => Array
                (
                    [0] => 3419
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [2] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 43
            [function] => hrquery_outline_load_for_fe
            [args] => Array
                (
                    [0] => 3419
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                    [3] => Array
                        (
                            [0] => category_overview
                            [1] => overview
                        )

                )

        )

    [3] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 54
            [function] => hrquery_get_outline_by_cc_langs
            [args] => Array
                (
                    [0] => 3419
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [4] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 63
            [function] => _hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => 3419
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [5] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 74
            [function] => hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [6] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/outlines.logic.php
            [line] => 209
            [function] => hrquery_get_outlines_by_course_codes
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                )

        )

    [7] => Array
        (
            [file] => /apps/nobleprog-website/modules/course/course.php
            [line] => 25
            [function] => hrquery_outline_get_related
            [args] => Array
                (
                    [0] => hitracr
                    [1] => adsql
                )

        )

    [8] => Array
        (
            [file] => /apps/nobleprog-website/core/routes.php
            [line] => 19
            [function] => course_menu_callback
            [args] => Array
                (
                    [0] => /en/cc/adsql?participants=1&how=public
                )

        )

    [9] => Array
        (
            [file] => /apps/nobleprog-website/__index.php
            [line] => 103
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/core/routes.php
                )

            [function] => require_once
        )

    [10] => Array
        (
            [file] => /apps/nobleprog-website/_index.php
            [line] => 26
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/__index.php
                )

            [function] => include_once
        )

    [11] => Array
        (
            [file] => /apps/hitra7/index.php
            [line] => 58
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/_index.php
                )

            [function] => include_once
        )

)
NP URI: www.nobleprog.co.cr/en/cc/adsql?participants=1&how=public Undefined property: stdClass::$excluded_sites /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php:108 Array
(
    [0] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 108
            [function] => myErrorHandler
            [args] => Array
                (
                    [0] => 2
                    [1] => Undefined property: stdClass::$excluded_sites
                    [2] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
                    [3] => 108
                )

        )

    [1] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 195
            [function] => hrquery_outline_load_all
            [args] => Array
                (
                    [0] => advsqlpt
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [2] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 43
            [function] => hrquery_outline_load_for_fe
            [args] => Array
                (
                    [0] => advsqlpt
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                    [3] => Array
                        (
                            [0] => category_overview
                            [1] => overview
                        )

                )

        )

    [3] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 54
            [function] => hrquery_get_outline_by_cc_langs
            [args] => Array
                (
                    [0] => advsqlpt
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [4] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 63
            [function] => _hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => advsqlpt
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [5] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 74
            [function] => hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [6] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/outlines.logic.php
            [line] => 209
            [function] => hrquery_get_outlines_by_course_codes
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                )

        )

    [7] => Array
        (
            [file] => /apps/nobleprog-website/modules/course/course.php
            [line] => 25
            [function] => hrquery_outline_get_related
            [args] => Array
                (
                    [0] => hitracr
                    [1] => adsql
                )

        )

    [8] => Array
        (
            [file] => /apps/nobleprog-website/core/routes.php
            [line] => 19
            [function] => course_menu_callback
            [args] => Array
                (
                    [0] => /en/cc/adsql?participants=1&how=public
                )

        )

    [9] => Array
        (
            [file] => /apps/nobleprog-website/__index.php
            [line] => 103
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/core/routes.php
                )

            [function] => require_once
        )

    [10] => Array
        (
            [file] => /apps/nobleprog-website/_index.php
            [line] => 26
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/__index.php
                )

            [function] => include_once
        )

    [11] => Array
        (
            [file] => /apps/hitra7/index.php
            [line] => 58
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/_index.php
                )

            [function] => include_once
        )

)
NP URI: www.nobleprog.co.cr/en/cc/adsql?participants=1&how=public Undefined property: stdClass::$excluded_sites /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php:108 Array
(
    [0] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 108
            [function] => myErrorHandler
            [args] => Array
                (
                    [0] => 2
                    [1] => Undefined property: stdClass::$excluded_sites
                    [2] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
                    [3] => 108
                )

        )

    [1] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 195
            [function] => hrquery_outline_load_all
            [args] => Array
                (
                    [0] => analyticfunctions
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [2] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 43
            [function] => hrquery_outline_load_for_fe
            [args] => Array
                (
                    [0] => analyticfunctions
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                    [3] => Array
                        (
                            [0] => category_overview
                            [1] => overview
                        )

                )

        )

    [3] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 54
            [function] => hrquery_get_outline_by_cc_langs
            [args] => Array
                (
                    [0] => analyticfunctions
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [4] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 63
            [function] => _hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => analyticfunctions
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [5] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 74
            [function] => hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [6] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/outlines.logic.php
            [line] => 209
            [function] => hrquery_get_outlines_by_course_codes
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                )

        )

    [7] => Array
        (
            [file] => /apps/nobleprog-website/modules/course/course.php
            [line] => 25
            [function] => hrquery_outline_get_related
            [args] => Array
                (
                    [0] => hitracr
                    [1] => adsql
                )

        )

    [8] => Array
        (
            [file] => /apps/nobleprog-website/core/routes.php
            [line] => 19
            [function] => course_menu_callback
            [args] => Array
                (
                    [0] => /en/cc/adsql?participants=1&how=public
                )

        )

    [9] => Array
        (
            [file] => /apps/nobleprog-website/__index.php
            [line] => 103
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/core/routes.php
                )

            [function] => require_once
        )

    [10] => Array
        (
            [file] => /apps/nobleprog-website/_index.php
            [line] => 26
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/__index.php
                )

            [function] => include_once
        )

    [11] => Array
        (
            [file] => /apps/hitra7/index.php
            [line] => 58
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/_index.php
                )

            [function] => include_once
        )

)
NP URI: www.nobleprog.co.cr/en/cc/adsql?participants=1&how=public Undefined property: stdClass::$excluded_sites /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php:108 Array
(
    [0] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 108
            [function] => myErrorHandler
            [args] => Array
                (
                    [0] => 2
                    [1] => Undefined property: stdClass::$excluded_sites
                    [2] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
                    [3] => 108
                )

        )

    [1] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 195
            [function] => hrquery_outline_load_all
            [args] => Array
                (
                    [0] => bespokesql2
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [2] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 43
            [function] => hrquery_outline_load_for_fe
            [args] => Array
                (
                    [0] => bespokesql2
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                    [3] => Array
                        (
                            [0] => category_overview
                            [1] => overview
                        )

                )

        )

    [3] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 54
            [function] => hrquery_get_outline_by_cc_langs
            [args] => Array
                (
                    [0] => bespokesql2
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [4] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 63
            [function] => _hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => bespokesql2
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [5] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 74
            [function] => hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [6] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/outlines.logic.php
            [line] => 209
            [function] => hrquery_get_outlines_by_course_codes
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                )

        )

    [7] => Array
        (
            [file] => /apps/nobleprog-website/modules/course/course.php
            [line] => 25
            [function] => hrquery_outline_get_related
            [args] => Array
                (
                    [0] => hitracr
                    [1] => adsql
                )

        )

    [8] => Array
        (
            [file] => /apps/nobleprog-website/core/routes.php
            [line] => 19
            [function] => course_menu_callback
            [args] => Array
                (
                    [0] => /en/cc/adsql?participants=1&how=public
                )

        )

    [9] => Array
        (
            [file] => /apps/nobleprog-website/__index.php
            [line] => 103
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/core/routes.php
                )

            [function] => require_once
        )

    [10] => Array
        (
            [file] => /apps/nobleprog-website/_index.php
            [line] => 26
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/__index.php
                )

            [function] => include_once
        )

    [11] => Array
        (
            [file] => /apps/hitra7/index.php
            [line] => 58
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/_index.php
                )

            [function] => include_once
        )

)
NP URI: www.nobleprog.co.cr/en/cc/adsql?participants=1&how=public Undefined property: stdClass::$excluded_sites /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php:108 Array
(
    [0] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 108
            [function] => myErrorHandler
            [args] => Array
                (
                    [0] => 2
                    [1] => Undefined property: stdClass::$excluded_sites
                    [2] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
                    [3] => 108
                )

        )

    [1] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 195
            [function] => hrquery_outline_load_all
            [args] => Array
                (
                    [0] => datastorageoverview
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [2] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 43
            [function] => hrquery_outline_load_for_fe
            [args] => Array
                (
                    [0] => datastorageoverview
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                    [3] => Array
                        (
                            [0] => category_overview
                            [1] => overview
                        )

                )

        )

    [3] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 54
            [function] => hrquery_get_outline_by_cc_langs
            [args] => Array
                (
                    [0] => datastorageoverview
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [4] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 63
            [function] => _hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => datastorageoverview
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [5] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 74
            [function] => hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [6] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/outlines.logic.php
            [line] => 209
            [function] => hrquery_get_outlines_by_course_codes
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                )

        )

    [7] => Array
        (
            [file] => /apps/nobleprog-website/modules/course/course.php
            [line] => 25
            [function] => hrquery_outline_get_related
            [args] => Array
                (
                    [0] => hitracr
                    [1] => adsql
                )

        )

    [8] => Array
        (
            [file] => /apps/nobleprog-website/core/routes.php
            [line] => 19
            [function] => course_menu_callback
            [args] => Array
                (
                    [0] => /en/cc/adsql?participants=1&how=public
                )

        )

    [9] => Array
        (
            [file] => /apps/nobleprog-website/__index.php
            [line] => 103
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/core/routes.php
                )

            [function] => require_once
        )

    [10] => Array
        (
            [file] => /apps/nobleprog-website/_index.php
            [line] => 26
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/__index.php
                )

            [function] => include_once
        )

    [11] => Array
        (
            [file] => /apps/hitra7/index.php
            [line] => 58
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/_index.php
                )

            [function] => include_once
        )

)
NP URI: www.nobleprog.co.cr/en/cc/adsql?participants=1&how=public Undefined property: stdClass::$excluded_sites /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php:108 Array
(
    [0] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 108
            [function] => myErrorHandler
            [args] => Array
                (
                    [0] => 2
                    [1] => Undefined property: stdClass::$excluded_sites
                    [2] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
                    [3] => 108
                )

        )

    [1] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 195
            [function] => hrquery_outline_load_all
            [args] => Array
                (
                    [0] => ddavsvbsqls
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [2] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 43
            [function] => hrquery_outline_load_for_fe
            [args] => Array
                (
                    [0] => ddavsvbsqls
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                    [3] => Array
                        (
                            [0] => category_overview
                            [1] => overview
                        )

                )

        )

    [3] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 54
            [function] => hrquery_get_outline_by_cc_langs
            [args] => Array
                (
                    [0] => ddavsvbsqls
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [4] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 63
            [function] => _hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => ddavsvbsqls
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [5] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 74
            [function] => hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [6] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/outlines.logic.php
            [line] => 209
            [function] => hrquery_get_outlines_by_course_codes
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                )

        )

    [7] => Array
        (
            [file] => /apps/nobleprog-website/modules/course/course.php
            [line] => 25
            [function] => hrquery_outline_get_related
            [args] => Array
                (
                    [0] => hitracr
                    [1] => adsql
                )

        )

    [8] => Array
        (
            [file] => /apps/nobleprog-website/core/routes.php
            [line] => 19
            [function] => course_menu_callback
            [args] => Array
                (
                    [0] => /en/cc/adsql?participants=1&how=public
                )

        )

    [9] => Array
        (
            [file] => /apps/nobleprog-website/__index.php
            [line] => 103
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/core/routes.php
                )

            [function] => require_once
        )

    [10] => Array
        (
            [file] => /apps/nobleprog-website/_index.php
            [line] => 26
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/__index.php
                )

            [function] => include_once
        )

    [11] => Array
        (
            [file] => /apps/hitra7/index.php
            [line] => 58
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/_index.php
                )

            [function] => include_once
        )

)
NP URI: www.nobleprog.co.cr/en/cc/adsql?participants=1&how=public Undefined property: stdClass::$excluded_sites /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php:108 Array
(
    [0] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 108
            [function] => myErrorHandler
            [args] => Array
                (
                    [0] => 2
                    [1] => Undefined property: stdClass::$excluded_sites
                    [2] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
                    [3] => 108
                )

        )

    [1] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 195
            [function] => hrquery_outline_load_all
            [args] => Array
                (
                    [0] => oplsqlfun
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [2] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 43
            [function] => hrquery_outline_load_for_fe
            [args] => Array
                (
                    [0] => oplsqlfun
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                    [3] => Array
                        (
                            [0] => category_overview
                            [1] => overview
                        )

                )

        )

    [3] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 54
            [function] => hrquery_get_outline_by_cc_langs
            [args] => Array
                (
                    [0] => oplsqlfun
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [4] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 63
            [function] => _hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => oplsqlfun
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [5] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 74
            [function] => hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [6] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/outlines.logic.php
            [line] => 209
            [function] => hrquery_get_outlines_by_course_codes
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                )

        )

    [7] => Array
        (
            [file] => /apps/nobleprog-website/modules/course/course.php
            [line] => 25
            [function] => hrquery_outline_get_related
            [args] => Array
                (
                    [0] => hitracr
                    [1] => adsql
                )

        )

    [8] => Array
        (
            [file] => /apps/nobleprog-website/core/routes.php
            [line] => 19
            [function] => course_menu_callback
            [args] => Array
                (
                    [0] => /en/cc/adsql?participants=1&how=public
                )

        )

    [9] => Array
        (
            [file] => /apps/nobleprog-website/__index.php
            [line] => 103
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/core/routes.php
                )

            [function] => require_once
        )

    [10] => Array
        (
            [file] => /apps/nobleprog-website/_index.php
            [line] => 26
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/__index.php
                )

            [function] => include_once
        )

    [11] => Array
        (
            [file] => /apps/hitra7/index.php
            [line] => 58
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/_index.php
                )

            [function] => include_once
        )

)
NP URI: www.nobleprog.co.cr/en/cc/adsql?participants=1&how=public Undefined property: stdClass::$excluded_sites /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php:108 Array
(
    [0] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 108
            [function] => myErrorHandler
            [args] => Array
                (
                    [0] => 2
                    [1] => Undefined property: stdClass::$excluded_sites
                    [2] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
                    [3] => 108
                )

        )

    [1] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 195
            [function] => hrquery_outline_load_all
            [args] => Array
                (
                    [0] => osqladv
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [2] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 43
            [function] => hrquery_outline_load_for_fe
            [args] => Array
                (
                    [0] => osqladv
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                    [3] => Array
                        (
                            [0] => category_overview
                            [1] => overview
                        )

                )

        )

    [3] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 54
            [function] => hrquery_get_outline_by_cc_langs
            [args] => Array
                (
                    [0] => osqladv
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [4] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 63
            [function] => _hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => osqladv
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [5] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 74
            [function] => hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [6] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/outlines.logic.php
            [line] => 209
            [function] => hrquery_get_outlines_by_course_codes
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                )

        )

    [7] => Array
        (
            [file] => /apps/nobleprog-website/modules/course/course.php
            [line] => 25
            [function] => hrquery_outline_get_related
            [args] => Array
                (
                    [0] => hitracr
                    [1] => adsql
                )

        )

    [8] => Array
        (
            [file] => /apps/nobleprog-website/core/routes.php
            [line] => 19
            [function] => course_menu_callback
            [args] => Array
                (
                    [0] => /en/cc/adsql?participants=1&how=public
                )

        )

    [9] => Array
        (
            [file] => /apps/nobleprog-website/__index.php
            [line] => 103
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/core/routes.php
                )

            [function] => require_once
        )

    [10] => Array
        (
            [file] => /apps/nobleprog-website/_index.php
            [line] => 26
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/__index.php
                )

            [function] => include_once
        )

    [11] => Array
        (
            [file] => /apps/hitra7/index.php
            [line] => 58
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/_index.php
                )

            [function] => include_once
        )

)
NP URI: www.nobleprog.co.cr/en/cc/adsql?participants=1&how=public Undefined property: stdClass::$excluded_sites /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php:108 Array
(
    [0] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 108
            [function] => myErrorHandler
            [args] => Array
                (
                    [0] => 2
                    [1] => Undefined property: stdClass::$excluded_sites
                    [2] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
                    [3] => 108
                )

        )

    [1] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 195
            [function] => hrquery_outline_load_all
            [args] => Array
                (
                    [0] => osqlbgn
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [2] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 43
            [function] => hrquery_outline_load_for_fe
            [args] => Array
                (
                    [0] => osqlbgn
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                    [3] => Array
                        (
                            [0] => category_overview
                            [1] => overview
                        )

                )

        )

    [3] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 54
            [function] => hrquery_get_outline_by_cc_langs
            [args] => Array
                (
                    [0] => osqlbgn
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [4] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 63
            [function] => _hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => osqlbgn
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [5] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 74
            [function] => hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [6] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/outlines.logic.php
            [line] => 209
            [function] => hrquery_get_outlines_by_course_codes
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                )

        )

    [7] => Array
        (
            [file] => /apps/nobleprog-website/modules/course/course.php
            [line] => 25
            [function] => hrquery_outline_get_related
            [args] => Array
                (
                    [0] => hitracr
                    [1] => adsql
                )

        )

    [8] => Array
        (
            [file] => /apps/nobleprog-website/core/routes.php
            [line] => 19
            [function] => course_menu_callback
            [args] => Array
                (
                    [0] => /en/cc/adsql?participants=1&how=public
                )

        )

    [9] => Array
        (
            [file] => /apps/nobleprog-website/__index.php
            [line] => 103
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/core/routes.php
                )

            [function] => require_once
        )

    [10] => Array
        (
            [file] => /apps/nobleprog-website/_index.php
            [line] => 26
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/__index.php
                )

            [function] => include_once
        )

    [11] => Array
        (
            [file] => /apps/hitra7/index.php
            [line] => 58
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/_index.php
                )

            [function] => include_once
        )

)
NP URI: www.nobleprog.co.cr/en/cc/adsql?participants=1&how=public Undefined property: stdClass::$excluded_sites /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php:108 Array
(
    [0] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 108
            [function] => myErrorHandler
            [args] => Array
                (
                    [0] => 2
                    [1] => Undefined property: stdClass::$excluded_sites
                    [2] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
                    [3] => 108
                )

        )

    [1] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/common/outline.logic.php
            [line] => 195
            [function] => hrquery_outline_load_all
            [args] => Array
                (
                    [0] => osqldevdm
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [2] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 43
            [function] => hrquery_outline_load_for_fe
            [args] => Array
                (
                    [0] => osqldevdm
                    [1] => hitracr
                    [2] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                    [3] => Array
                        (
                            [0] => category_overview
                            [1] => overview
                        )

                )

        )

    [3] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 54
            [function] => hrquery_get_outline_by_cc_langs
            [args] => Array
                (
                    [0] => osqldevdm
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [4] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 63
            [function] => _hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => osqldevdm
                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [5] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/denorm.logic.php
            [line] => 74
            [function] => hrquery_get_outline_by_course_code
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                    [1] => Array
                        (
                            [0] => en
                            [1] => es
                        )

                )

        )

    [6] => Array
        (
            [file] => /apps/hitra7/drupal7/sites/all/modules/_custom/common/hrquery/frontend/outlines.logic.php
            [line] => 209
            [function] => hrquery_get_outlines_by_course_codes
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => 3057
                            [1] => 3119
                            [2] => 3308
                            [3] => 3358
                            [4] => 3410
                            [5] => 3419
                            [6] => advsqlpt
                            [7] => analyticfunctions
                            [8] => bespokesql2
                            [9] => datastorageoverview
                            [10] => ddavsvbsqls
                            [11] => oplsqlfun
                            [12] => osqladv
                            [13] => osqlbgn
                            [14] => osqldevdm
                        )

                )

        )

    [7] => Array
        (
            [file] => /apps/nobleprog-website/modules/course/course.php
            [line] => 25
            [function] => hrquery_outline_get_related
            [args] => Array
                (
                    [0] => hitracr
                    [1] => adsql
                )

        )

    [8] => Array
        (
            [file] => /apps/nobleprog-website/core/routes.php
            [line] => 19
            [function] => course_menu_callback
            [args] => Array
                (
                    [0] => /en/cc/adsql?participants=1&how=public
                )

        )

    [9] => Array
        (
            [file] => /apps/nobleprog-website/__index.php
            [line] => 103
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/core/routes.php
                )

            [function] => require_once
        )

    [10] => Array
        (
            [file] => /apps/nobleprog-website/_index.php
            [line] => 26
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/__index.php
                )

            [function] => include_once
        )

    [11] => Array
        (
            [file] => /apps/hitra7/index.php
            [line] => 58
            [args] => Array
                (
                    [0] => /apps/nobleprog-website/_index.php
                )

            [function] => include_once
        )

)
<!DOCTYPE html>
<html lang="en" translate="no">

<head>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="viewport" content="width=device-width,initial-scale=1,maximum-scale=5,user-scalable=yes">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="HandheldFriendly" content="true">
    <link rel="canonical" href="">
            <meta name="description" content="Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes.
">
    
            <meta name="keywords" content="SQL Advanced Training, SQL Advanced Course, SQL Advanced Classes, SQL Advanced Certification">
        <link rel="preconnect" href="https://piwik.nobleprog.com" crossorigin="anonymous">
    <link rel="preload" href="/nplibraries/css/poppins2.woff2" as="font" type="font/woff2" crossorigin="anonymous">
    <link rel="preload" href="/nplibraries/css/bootstrap/bootstrap-cust.min.css" as="style">
    <link rel="preload" href="/nplibraries/css/all.11.min.css?np002" as="style">
    <link rel="preload" href="/nplibraries/js/jquery/jquery-3.7.1.min.js" as="script">
    <link rel="preload" href="/nplibraries/js/bootstrap/bootstrap.bundle-cust.min.js" as="script">
    <link rel="preload" href="/nplibraries/js/custom/main.js" as="script">
    <link rel="preload" href="/sites/all/modules/_custom/common/np_live_chat/np_live_chat.js" as="script">
    <title>SQL Advanced Training Course</title>

    <link href="/nplibraries/css/bootstrap/bootstrap-cust.min.css" rel="stylesheet" type="text/css">
    <link href="/nplibraries/css/all.11.min.css?np002" rel="stylesheet" type="text/css">

    <!-- Define Javascript Libraries -->
    <script src="/nplibraries/js/jquery/jquery-3.7.1.min.js"></script>
    <script src="/nplibraries/js/bootstrap/bootstrap.bundle-cust.min.js"></script>
    <script async src="/nplibraries/js/custom/main.js"></script>

    <!-- MATOMO START - PIWIK -->
    <script async>
        var _paq = _paq || [];
        _paq.push(['enableHeartBeatTimer', 10]);
        _paq.push(['trackPageView', window.document.title, {
            dimension4: 'www.nobleprog.co.cr'
        }]);
        _paq.push(['enableLinkTracking']);
        (function() {
            var u = "//piwik.nobleprog.com/";
            _paq.push(['setTrackerUrl', u + 'piwik.php']);
            _paq.push(['setSiteId', 2]);
            _paq.push(["setDoNotTrack", 1]);
            var d = document,
                g = d.createElement('script'),
                s = d.getElementsByTagName('script')[0];
            g.type = 'text/javascript';
            g.async = true;
            g.defer = true;
            g.src = u + 'piwik.js';
            s.parentNode.insertBefore(g, s);
        })();
    </script>
    <!-- MATOMO END -->
    <link rel="shortcut icon" href="/assets/images/np.ico" type="image/vnd.microsoft.icon">
            <script>
            var Drupal = {"settings":{"livechat":{"language":"","department":13,"lhc_url":"lhc.nobleprog.com","domain":"nobleprog.co.cr"}}};
        </script>
        <script async defer src="/sites/all/modules/_custom/common/np_live_chat/np_live_chat.js"></script>
    
</head>

<body>

    <!-- HEADER -->
    <svg xmlns="http://www.w3.org/2000/svg" height="0" width="0" style="position:absolute">
        <defs>
            <path id="icon-phone" d="M3.654 1.328a.678.678 0 0 0-1.015-.063L1.605 2.3c-.483.484-.661 1.169-.45 1.77a17.568 17.568 0 0 0 4.168 6.608 17.569 17.569 0 0 0 6.608 4.168c.601.211 1.286.033 1.77-.45l1.034-1.034a.678.678 0 0 0-.063-1.015l-2.307-1.794a.678.678 0 0 0-.58-.122l-2.19.547a1.745 1.745 0 0 1-1.657-.459L5.482 8.062a1.745 1.745 0 0 1-.46-1.657l.548-2.19a.678.678 0 0 0-.122-.58L3.654 1.328zM1.884.511a1.745 1.745 0 0 1 2.612.163L6.29 2.98c.329.423.445.974.315 1.494l-.547 2.19a.678.678 0 0 0 .178.643l2.457 2.457a.678.678 0 0 0 .644.178l2.189-.547a1.745 1.745 0 0 1 1.494.315l2.306 1.794c.829.645.905 1.87.163 2.611l-1.034 1.034c-.74.74-1.846 1.065-2.877.702a18.634 18.634 0 0 1-7.01-4.42 18.634 18.634 0 0 1-4.42-7.009c-.362-1.03-.037-2.137.703-2.877L1.885.511z" />
            <path id="icon-envelope" d="M0 4a2 2 0 0 1 2-2h12a2 2 0 0 1 2 2v8a2 2 0 0 1-2 2H2a2 2 0 0 1-2-2V4Zm2-1a1 1 0 0 0-1 1v.217l7 4.2 7-4.2V4a1 1 0 0 0-1-1H2Zm13 2.383-4.708 2.825L15 11.105V5.383Zm-.034 6.876-5.64-3.471L8 9.583l-1.326-.795-5.64 3.47A1 1 0 0 0 2 13h12a1 1 0 0 0 .966-.741ZM1 11.105l4.708-2.897L1 5.383v5.722Z" />
            <path id="icon-map-maker" d="M8 16s6-5.686 6-10A6 6 0 0 0 2 6c0 4.314 6 10 6 10zm0-7a3 3 0 1 1 0-6 3 3 0 0 1 0 6z"></path>
        </defs>
    </svg>

        <style>.sales-area-list-item-btn{color:var(--link-grey)}</style>

    <nav id="contact-nav" class="container-fluid">
                <div class="container">
                            <select class="hidden" id="lang-switch-dropdown" onchange="window.location.href=this.value"  aria-label="Select Site Language"></select>
                <div id="lang-switch-links" class='hidden'>
                                        <a href='/en/cc/adsql?participants=1&how=public' selected="selected">English</a>                                        <a href='/cc/adsql?participants=1&how=public' >Español</a>                                   </div>
                        <a id="selected-phone-anchor" class='d-none' href="tel:" rel="nofollow">
                <svg viewBox="0 0 16 16" height="16">
                    <use xlink:href="#icon-phone"></use>
                </svg>
                <span id="selected-phone-anchor-text"></span>
            </a>
            <a href="mailto: ?>" id="selected-email-anchor" class='d-none'><svg viewBox="0 0 16 16" height="18">
                    <use xlink:href="#icon-envelope"></use>
                </svg>
                <span class="np_mail" id='selected-email-anchor-text'></span>
            </a>
            <style>.mglass{display: inline-block; font-size: 22px; transform: rotate(-45deg); user-select: none;}</style>
            <a class="btn-green btn-contactus" href="/en/contact-us">Contact Us</a>
            <a href="https://search.nobleprog.com/?np_site[0]=www.nobleprog.co.cr&lang=en" target="_blank" aria-label="search">
                <span class="mglass">&#9906;</span>
            </a>
        </div>
    </nav>

    <script>
        function setLinksToDropDown(links_parent_name, dropdown_el_name) {
            const links_parent = document.getElementById(links_parent_name);
            if (!links_parent) return;

            const select_parent = document.getElementById(dropdown_el_name);
            if (!select_parent) return;

            Object.values(links_parent.children).forEach((link) => {
                const opt_el = document.createElement('option');
                opt_el.style['font-weight'] = link.style['font-weight'];
                opt_el.value = link.href;
                opt_el.innerHTML = link.innerHTML;
                select_parent.appendChild(opt_el);
                if (link.attributes.hasOwnProperty('selected')) {
                    if (link.attributes.selected.value == 'selected') {
                        opt_el.setAttribute('selected', '');
                    }
                }
            });

            select_parent.classList.remove('hidden');
            links_parent.classList.add('hidden');
        }
    </script>
    <script>

    function setContactInformationToContactNavElement(contactInfo) {
        let salesAreaAnchor = document.getElementById('selected-sales-area-anchor')
        if (salesAreaAnchor) salesAreaAnchor.querySelector('span').textContent = contactInfo['area'];
        if (contactInfo['phone']) {
            const selectedPhoneAnchor = document.getElementById('selected-phone-anchor');
            selectedPhoneAnchor.href = 'tel:' + contactInfo['phone']
            selectedPhoneAnchor.classList.remove('d-none');
            document.getElementById('selected-phone-anchor-text').textContent = contactInfo['phone']
        }

        if (contactInfo['email']) {
            const selectedEmailAnchor = document.getElementById('selected-email-anchor');
            selectedEmailAnchor.href = 'mailto:' + contactInfo['email']
            selectedEmailAnchor.classList.remove('d-none')
            document.getElementById('selected-email-anchor-text').textContent = contactInfo['email']
        }

    }

    async function getContactInfo() {
        let contactInfo = fetchedContactInfo = null;
        try {
            if (localStorage.getItem('contact-info')) {
                contactInfo = JSON.parse(localStorage.getItem('contact-info'));
                setContactInformationToContactNavElement(contactInfo)
            }
        } catch (error) { }

        if (!contactInfo) {
            fetchedContactInfo = await fetch("/en/get-contact-info");
            fetchedContactInfo = await fetchedContactInfo.json()
        } else {
            fetchedContactInfo = await fetch('/en/get-contact-info?contact-info' + '=' + localStorage.getItem('contact-info'));
            fetchedContactInfo = await fetchedContactInfo.json();
            if (!fetchedContactInfo) {
                fetchedContactInfo = await fetch("/en/get-contact-info");
                fetchedContactInfo = await fetchedContactInfo.json()
            }
        }

        let fetchedContactInfoString = JSON.stringify(fetchedContactInfo);
        if (fetchedContactInfoString != localStorage.getItem('contact-info')) {
            localStorage.setItem('contact-info', fetchedContactInfoString)
            setContactInformationToContactNavElement(fetchedContactInfo)

            if (typeof contactUs_updateContactInfo === 'function') contactUs_updateContactInfo();
        }
    }
    getContactInfo();
</script>

    <div id="firstfocus" class="container topmenu">
        <nav class="navbar navbar-expand-lg">
            <div>
                <a href="/en" title="SQL Advanced Training Course">
                    <svg xmlns="http://www.w3.org/2000/svg" width="206" height="50" viewBox="0 0 206 30">
                        <defs>
                            <g id="flag-at"><path fill="#f00" d="M0 0h30v10h-30z"/><path fill="#fff" d="M0 10h30v10h-30z"/><path fill="#f00" d="M0 20h30v10h-30z"/></g>
                            <g id="flag-ch"><path fill="#db0000" d="M0 0h30v30h-30z"/><path d="M11.8 18.2h-7.5v-6.4h7.5v-7.5h6.4v7.5h7.5v6.4h-7.5v7.5h-6.4v-7.5z" fill="#fff"/></g>
                            <g id="flag-de"><path d="M0 0h30v10h-30z"/><path fill="#db0000" d="M0 10h30v10h-30z"/><path fill="#ffce00" d="M0 20h30v10h-30z"/></g>
                            <g id="flag-ro"><path d="M0 0h10v30h-10v-30z" fill="#002b7f"/><path d="M10 0h10v30h-10v-30z" fill="#fcd116"/><path d="M20 0h10v30h-10v-30z" fill="#ce1126"/></g>
                        </defs>
                        <path id="logotype" fill="#006ebe" d="M19.12 29.88h-4.61l-6.51-19.76-3.38 19.76h-4.62l5.03-29.41h4.63l6.51 19.68 3.38-19.68h4.62l-5.05 29.41zM24.88 21.03c0-3.49.79-6.46 2.37-8.91 1.75-2.69 4.29-4.03 7.6-4.03 2.49 0 4.47.84 5.95 2.53 1.48 1.69 2.22 4.03 2.22 7.04 0 3.53-.92 6.53-2.76 9-1.84 2.47-4.24 3.7-7.21 3.7-2.42 0-4.39-.84-5.9-2.51-1.52-1.66-2.27-3.94-2.27-6.82zm13.46-4.11c0-1.4-.33-2.51-1-3.31-.66-.8-1.5-1.2-2.52-1.2-.86 0-1.66.29-2.41.88-.75.59-1.41 1.61-1.97 3.07-.56 1.46-.85 2.97-.85 4.53 0 1.59.35 2.83 1.04 3.71.69.88 1.54 1.32 2.56 1.32 1.29 0 2.38-.68 3.28-2.04 1.25-1.87 1.87-4.19 1.87-6.96zM44.38 29.88l5.04-29.41h4.74l-1.69 9.83c.92-.84 1.75-1.42 2.48-1.73.73-.31 1.52-.47 2.36-.47 1.83 0 3.3.74 4.42 2.23 1.12 1.48 1.68 3.69 1.68 6.6 0 2.66-.44 5.06-1.31 7.19-.88 2.13-1.97 3.71-3.29 4.73-1.32 1.02-2.66 1.53-4.03 1.53-2.5 0-4.33-1.33-5.51-3.98l-.6 3.49h-4.29zm6.36-8.67c0 1.46.34 2.63 1.01 3.51.67.88 1.45 1.33 2.33 1.33.71 0 1.41-.3 2.1-.9.69-.6 1.31-1.67 1.84-3.22.53-1.54.8-3.17.8-4.87 0-1.57-.32-2.77-.97-3.62s-1.42-1.27-2.31-1.27c-1.36 0-2.5.88-3.42 2.65-.92 1.79-1.38 3.91-1.38 6.39zM65.4 29.88l5.04-29.41h4.73l-5.06 29.41h-4.71zM91.7 21.01h-11.85v.54c0 1.43.33 2.58 1 3.43.67.86 1.47 1.29 2.41 1.29 1.55 0 2.77-.99 3.67-2.97l4.23.86c-.83 2.07-1.93 3.63-3.31 4.65-1.38 1.03-2.92 1.54-4.63 1.54-2.27 0-4.16-.89-5.67-2.66-1.51-1.77-2.26-4.18-2.26-7.21 0-3.28.86-6.16 2.57-8.66 1.71-2.49 4.11-3.74 7.18-3.74 2.07 0 3.75.79 5.05 2.36 1.29 1.57 1.94 3.84 1.94 6.81 0 1.42-.11 2.67-.33 3.76zm-3.99-3.51l.02-.56c0-1.62-.3-2.82-.89-3.59-.59-.78-1.37-1.16-2.32-1.16-.96 0-1.84.45-2.62 1.34-.78.9-1.31 2.22-1.57 3.97h7.38zM98.54 29.88h-4.95l5.03-29.41h9.7c1.84 0 3.26.26 4.25.78.99.52 1.79 1.34 2.39 2.46.6 1.12.9 2.48.9 4.1 0 1.95-.36 3.75-1.08 5.39-.72 1.64-1.62 2.85-2.69 3.64-1.07.79-2.34 1.32-3.81 1.61-.8.15-2.37.22-4.73.22h-3.09l-1.92 11.21zm2.75-16.09h1.43c2.48 0 4.17-.17 5.07-.5.9-.33 1.64-.95 2.22-1.84.58-.89.87-1.92.87-3.1 0-1.27-.42-2.15-1.27-2.63-.49-.28-1.63-.42-3.4-.42h-3.47l-1.45 8.49zM119.19 8.58h4.43l-.71 4.13c1.65-3.08 3.45-4.61 5.4-4.61.68 0 1.42.2 2.21.6l-1.81 4.71c-.43-.19-.89-.28-1.36-.28-.75 0-1.44.25-2.09.74-.99.76-1.75 1.76-2.28 2.99-.53 1.23-1.05 3.34-1.57 6.34l-1.17 6.68h-4.71l3.66-21.3zM129.72 21.03c0-3.49.79-6.46 2.37-8.91 1.75-2.69 4.29-4.03 7.6-4.03 2.49 0 4.47.84 5.95 2.53s2.22 4.03 2.22 7.04c0 3.53-.92 6.53-2.76 9-1.84 2.47-4.24 3.7-7.21 3.7-2.42 0-4.39-.84-5.9-2.51-1.51-1.66-2.27-3.94-2.27-6.82zm13.46-4.11c0-1.4-.33-2.51-1-3.31-.66-.8-1.5-1.2-2.52-1.2-.86 0-1.66.29-2.41.88-.75.59-1.41 1.61-1.97 3.07-.56 1.46-.85 2.97-.85 4.53 0 1.59.35 2.83 1.04 3.71.69.88 1.54 1.32 2.56 1.32 1.29 0 2.38-.68 3.28-2.04 1.25-1.87 1.87-4.19 1.87-6.96zM149.34 31.03l5.01.88c0 .86.21 1.49.63 1.91.42.41 1.06.62 1.92.62.85 0 1.53-.17 2.06-.49.53-.33.94-.83 1.24-1.49.29-.66.59-1.99.88-3.98l.13-1c-1.62 1.66-3.29 2.49-5.03 2.49-1.7 0-3.1-.72-4.21-2.17-1.11-1.44-1.67-3.61-1.67-6.5 0-2.74.4-5.13 1.21-7.17.81-2.04 1.85-3.55 3.14-4.54 1.29-.99 2.59-1.48 3.93-1.48 1.12 0 2.16.36 3.12 1.09.96.73 1.71 1.78 2.27 3.16l.6-3.77h4.43l-2.84 17.76c-.56 3.46-1.07 5.85-1.53 7.16-.63 1.79-1.55 3.08-2.77 3.86-1.22.78-2.9 1.17-5.04 1.17-2.5 0-4.31-.46-5.42-1.38-1.39-1.15-2.09-2.89-2.09-5.24l.03-.89zm5.58-10.32c0 1.62.34 2.91 1.01 3.87.51.74 1.21 1.1 2.08 1.1.71 0 1.42-.3 2.13-.9.71-.6 1.32-1.59 1.83-2.98s.77-2.89.77-4.51c0-1.58-.33-2.83-1-3.74-.67-.92-1.43-1.37-2.29-1.37-.66 0-1.31.28-1.95.85-.64.57-1.23 1.62-1.77 3.16-.54 1.55-.81 3.05-.81 4.52z"></path>
                        <use href="#flag-cr" x="176" y="-10" />
                    </svg>
                </a>
                <div class="mobile-menu">
                    <button class="navbar-toggler collapsed border-0" type="button" data-bs-toggle="collapse" data-bs-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
                        <span class="navbar-toggler-icon"></span>
                        <span class="navbar-toggler-icon"></span>
                        <span class="navbar-toggler-icon"></span>
                    </button>
                </div>
            </div>

            <div class="col-md-auto menu inpt-search d-none">
                <form id='tobBarsearchForm' class="" method="GET" action="https://search.nobleprog.com">
                    <div class="input-group">
                        <input type="hidden" name="language" value="en">
                        <input type="hidden" name="site" value='www.nobleprog.co.cr'>
                        <input type="text" name="q" style="border: 1px solid var(--bg-blue-dark); border-right: none;" autocomplete="search" class="form-control" aria-label="Search in Course Catalogue" placeholder="Type the name of a technology you are interested in e.g. Android, Java, BPMN, Docker etc."  value="" size="10" maxlength="128" required="">
                        <div class="input-group-append">
                            <button class='btn btn-blue input-group-text text-white search-button inpt-leftsquare' style="padding:6px 10px;" value="">
                            <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" viewBox="0 0 16 16">
                                <path id="magnify" d="M11.742 10.344a6.5 6.5 0 1 0-1.397 1.398h-.001c.03.04.062.078.098.115l3.85 3.85a1 1 0 0 0 1.415-1.414l-3.85-3.85a1.007 1.007 0 0 0-.115-.1zM12 6.5a5.5 5.5 0 1 1-11 0 5.5 5.5 0 0 1 11 0z" />
                            </svg>
                            </button>
                        </div>
                    </div>
                </form>
             </div>
            <div class="topmenu-navs collapse navbar-collapse" id="navbarSupportedContent">
                <ul class="nav-tabs navbar-nav" style="align-items: baseline;">
        <li class="col-md-auto menu lowercase"><a href="/en/training "> Course Catalogue</a></li>
    <li class="col-md-auto menu dropdown nav-dropdown">
        <a class="dropdown-toggle main-nav-dropdown-toggle" data-bs-toggle="dropdown" href="#">
            Consultancy            <b class="caret"></b>
        </a>
        <ul class="dropdown-menu main-nav-dropdown" style="z-index:2000;">

                                <li><a href="/en/consultancy">Our Approach</a></li>
                                    <li><a href="/en/case-studies">Case Studies</a></li>
                                    <li><a href="/en/enquiry?type=consultancy">Consultancy Enquiry</a></li>
                                    <li><a href="/en/consultancy-catalogue">Consultancy Catalogue</a></li>
                
        </ul>
    </li>

    <li class="col-md-auto menu dropdown nav-dropdown">
        <a class="dropdown-toggle main-nav-dropdown-toggle" data-bs-toggle="dropdown" href="#">
            Reskilling            <b class="caret"></b>
        </a>
        <ul class="dropdown-menu main-nav-dropdown" style="z-index:2000;">

                                <li><a href="/en/what-is-reskilling">What is Reskilling?</a></li>
                                    <li><a href="/en/our-approach">Our Approach</a></li>
                                    <li><a href="/en/our-experience">Our Experience</a></li>
                                    <li><a href="/en/our-bootcamps">Our Bootcamps</a></li>
                
        </ul>
    </li>

    <li class="col-md-auto menu dropdown nav-dropdown">
        <a class="dropdown-toggle main-nav-dropdown-toggle" data-bs-toggle="dropdown" href="#">
            Services            <b class="caret"></b>
        </a>
        <ul class="dropdown-menu main-nav-dropdown" style="z-index:2000;">

                                <li><a href="/en/digital-transformation">Digital Transformation</a></li>
                                    <li><a href="/en/data-management">Data Management</a></li>
                                    <li><a href="/en/managed-training-services">Managed Training Service</a></li>
                                    <li><a href="/en/instructor-led-online-training-courses">Training Delivery Platform</a></li>
                                    <li><a href="/en/corporate-learning-solutions">Learning Pathways</a></li>
                                    <li class="dropdown dropdown-sub-menu-container dropend">
                        <a class="dropdown-toggle dropdown-toggle-sub-menu" href="#" id="dropdownSubMenu" data-bs-toggle="dropdown">
                            <span class='dropdown-sub-menu-title'>
                                Resources                            </span>
                            <b class="caret"></b>
                        </a>
                        <ul class="dropdown-menu dropdown-sub-menu" aria-labelledby="dropdownSubMenu">
                                                            <li><a href="/en/resources/videos">Videos</a></li>
                                                            <li><a href="/en/resources/articles">Articles</a></li>
                                                            <li><a href="/en/resources/webinars">Webinars</a></li>
                                                    </ul>
                    </li>
            
        </ul>
    </li>

    <li class="col-md-auto menu dropdown nav-dropdown">
        <a class="dropdown-toggle main-nav-dropdown-toggle" data-bs-toggle="dropdown" href="#">
            About Us            <b class="caret"></b>
        </a>
        <ul class="dropdown-menu main-nav-dropdown" style="z-index:2000;">

                                <li><a href="/en/about-us">About Us</a></li>
                                    <li><a href="/en/reason-for-existence">Reason for Existence</a></li>
                                    <li><a href="/en/certifications">Partners & Affiliations</a></li>
                                    <li><a href="/en/training-methods">Training Methods</a></li>
                                    <li><a href="/en/clients-and-references">Clients</a></li>
                                    <li><a href="/en/e-certificate">E-Certificate</a></li>
                                    <li><a href="/en/testimonials">Testimonials</a></li>
                                    <li><a href="/en/careers">Careers</a></li>
                                    <li><a href="/en/terms-and-conditions">T&C</a></li>
                                    <li><a href="/en/faqs">FAQ</a></li>
                
        </ul>
    </li>


</ul>

<style>
    .dropdown-sub-menu-container .dropdown-menu {display: none;}
    .dropdown-sub-menu-container:hover>.dropdown-sub-menu {display: block;}

    .dropdown-sub-menu-container.dropend .dropdown-toggle::after{
        border-top: 0.35em solid transparent;
        border-bottom: 0.35em solid transparent;
        border-left: 0.35em solid;
    }
    
    @media screen and (min-width: 769px) {
        .dropend:hover>.dropdown-sub-menu {
            position: absolute;
            top: 0;
            left: 100%;
        }
        .dropdown-toggle-sub-menu>span {
            display: inline-block;
            width: 90%;
        }
    }
</style>


<script>
    function addEventListenerOnSubMenu() {
        const submenuToggleDropdowns = document.querySelectorAll('.dropdown-toggle-sub-menu');
        submenuToggleDropdowns.forEach((dd) => {
            dd.addEventListener('click', function(e) {
                const menu = this.nextElementSibling;
                menu.style.display = menu.style.display === 'block' ? 'none' : 'block';
                e.stopPropagation();
            })
        })
    }

    function addEventListenerOnDropdownMenu() {
        const mainNavDropdownToggles = document.querySelectorAll('.main-nav-dropdown-toggle');
        mainNavDropdownToggles.forEach((mainNavToggle) => {
            mainNavToggle.addEventListener('click', function(e) {
                const menu = this.nextElementSibling;
                const subMenus = document.querySelectorAll('.dropdown-sub-menu')
                subMenus.forEach(function(subMenu) {
                    const parentDropDownMenu = subMenu.closest('.main-nav-dropdown')
                    if (!mainNavToggle.classList.contains('show') || (parentDropDownMenu && menu != parentDropDownMenu)) subMenu.style.display = 'none';
                });
            })
        })
    }
    
    function addEventListenerOnClickOutsideDropdown() {
        const dropDowns = document.querySelectorAll(".nav-dropdown")
        document.addEventListener('click', function(e) { 
            let clickInsideMenu = false;
            dropDowns.forEach((container) => {
                if (container.contains(e.target)) {
                    clickInsideMenu = true;
                    return;
                }
            });
            if (clickInsideMenu) return;

            const subMenus = document.querySelectorAll('.dropdown-sub-menu');
            subMenus.forEach((subMenu) => {
                subMenu.style.display = 'none';
            });
        });
    }
    function checkIsMobileAndTablet(){
        let check = false;
        (function(a){if(/(android|bb\d+|meego).+mobile|avantgo|bada\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|mobile.+firefox|netfront|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\/|plucker|pocket|psp|series(4|6)0|symbian|treo|up\.(browser|link)|vodafone|wap|windows ce|xda|xiino|android|ipad|playbook|silk/i.test(a)||/1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\-m|r |s )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\-(n|u)|c55\/|capi|ccwa|cdm\-|cell|chtm|cldc|cmd\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\-s|devi|dica|dmob|do(c|p)o|ds(12|\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\-|_)|g1 u|g560|gene|gf\-5|g\-mo|go(\.w|od)|gr(ad|un)|haie|hcit|hd\-(m|p|t)|hei\-|hi(pt|ta)|hp( i|ip)|hs\-c|ht(c(\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\-(20|go|ma)|i230|iac( |\-|\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt( |\/)|klon|kpt |kwc\-|kyo(c|k)|le(no|xi)|lg( g|\/(k|l|u)|50|54|\-[a-w])|libw|lynx|m1\-w|m3ga|m50\/|ma(te|ui|xo)|mc(01|21|ca)|m\-cr|me(rc|ri)|mi(o8|oa|ts)|mmef|mo(01|02|bi|de|do|t(\-| |o|v)|zz)|mt(50|p1|v )|mwbp|mywa|n10[0-2]|n20[2-3]|n30(0|2)|n50(0|2|5)|n7(0(0|1)|10)|ne((c|m)\-|on|tf|wf|wg|wt)|nok(6|i)|nzph|o2im|op(ti|wv)|oran|owg1|p800|pan(a|d|t)|pdxg|pg(13|\-([1-8]|c))|phil|pire|pl(ay|uc)|pn\-2|po(ck|rt|se)|prox|psio|pt\-g|qa\-a|qc(07|12|21|32|60|\-[2-7]|i\-)|qtek|r380|r600|raks|rim9|ro(ve|zo)|s55\/|sa(ge|ma|mm|ms|ny|va)|sc(01|h\-|oo|p\-)|sdk\/|se(c(\-|0|1)|47|mc|nd|ri)|sgh\-|shar|sie(\-|m)|sk\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\-|v\-|v )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\-|tdg\-|tel(i|m)|tim\-|t\-mo|to(pl|sh)|ts(70|m\-|m3|m5)|tx\-9|up(\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\-| )|webc|whit|wi(g |nc|nw)|wmlb|wonu|x700|yas\-|your|zeto|zte\-/i.test(a.substr(0,4))) check = true;})(navigator.userAgent||navigator.vendor||window.opera);
        return check;
    }
    function updateDropdownSubMenuContainerClass() {
        const dropdownSubmenuContainers= document.querySelectorAll('.dropdown-sub-menu-container')
        if (!dropdownSubmenuContainers) return;
        dropdownSubmenuContainers.forEach((container) => {
            container.classList.remove('dropend');
            container.classList.add('dropdown');
        });
    }

    function addEventListenerForDropdownSubmenu() {
        if(!checkIsMobileAndTablet()) return;
        
        addEventListenerOnSubMenu();
        addEventListenerOnDropdownMenu();
        addEventListenerOnClickOutsideDropdown();
        updateDropdownSubMenuContainerClass();
    }
    
    
    addEventListenerForDropdownSubmenu();
</script>            </div>
        </nav>
    </div>

    <!--CONTENT CONTAINER-->
    <main id="content-container">
        <!-- BANNER SECTION -->
<div class="course-banner banner-header blue course">
    <!-- BREADCRUMBS -->
    <div class="container main-breadcrumb">
        <div class="row col-md-12">
                <nav aria-label="breadcrumb">
        <ol class="breadcrumb">
                                <li class="breadcrumb-item">
                        <a href="/en/home">Home</a>
                    </li>
                                    <li class="breadcrumb-item">
                        <a href="/en/database-training">database training</a>
                    </li>
                                    <li class="breadcrumb-item active">
                        <a href="/en/sql-training" class="last-breadcrumb">sql training</a>
                    </li>
                        </ol>
    </nav>
        </div>
    </div>

    <!-- HEADERS-->
    <div class="container course-header">

<script async >
    // last place where is readmore button
    window.onload = function() {
    let rm = document.querySelectorAll('.read-more-text');
    let overview_lenght = $.trim($('.read-more-text').html()).length;
    if (overview_lenght < 400) {
        rm.forEach(el => {
            el.classList.remove('less');
            $('.rmlink').hide();

        })
    }
}

function toggleRM(el) {
    const cl = document.getElementById("overview-text").classList
    //console.log(cl)
    const is_less = cl.contains('less');
    el.innerHTML = !is_less ? "Read more" : "Read less";
    if (is_less) cl.remove('less');
    else cl.add('less');
}

</script>

        <div class="row">
            <div class="col-md-12 category-desc">
                <h1>
                    SQL Advanced Training Course                </h1>
                <!-- AVE RATING FOR THE Course - STARS -->
                                    <a  class="testimonials-link" href="#course-comments-content">
                        <div class="category-stars">
                            <div class="ratings">
                                <div class="discount-empty-stars"></div>
                                <div id="discount-colored-star-main-adsql" class="full-stars"
                                    data-rating="5"></div>
                            </div>
                            <span class="feedback">
                                (3                                Testimonials)
                            </span>
                        </div>
                    </a>
                                                <div class="mt-4" id="aboutUsHeader">
                    <div id="overview-text" class="read-more-text less"> <p>Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes.</p>
                    </div>
                    <button type='button' onclick='toggleRM(this)' class='rmlink'>Read more</button>
                </div>
            </div>
        </div><br><br>
    </div>
</div>

<!-- Enquiry submit alter/ Show this when enquiry submitted successfullt -->

<div class="alert alert-success enquiry-submit-msg" role="alert">
    Thank you for sending your enquiry! One of our team members will contact you shortly.</div>
<!-- Booking submit alter/ Show this when booking submitted successfullt -->

<div class="alert alert-success booking-submit-msg" role="alert">
    Thank you for sending your booking! One of our team members will contact you shortly.</div>
<!-- Course Details -->
<div class="full-course-content">
    <div class="container">
        <div class="row">
            <div class="col-md-12">
                <style>
    .course-sub-details b, strong {
    font-weight: 400;
    font-size: 1.1rem;
    color: #000;
}
</style>
<div class="row course-details">
    <div class="col-sm-6 pt-5">
        <section class="maincategory">
            <h3 class="cdetail-head">
            <i class="fas fa-clipboard"></i>
                Course Outline            </h3>
            <div class="course-sub-details"><h3>Lesson 1: Querying with unions and advanced joins</h3>

<ul>
	<li>Querying multiple tables with unions</li>
	<li>Advanced Joins</li>
	<li>Calculating with COMPUTE</li>
</ul>

<h3>Lesson 2: Querying with subqueries</h3>

<ul>
	<li>Subqueries</li>
</ul>

<h3>Lesson 3: Adding data</h3>

<ul>
	<li>Inserting data</li>
	<li>SELECT INTO</li>
</ul>

<h3>Lesson 4: Updating and removing data</h3>

<ul>
	<li>Updating records</li>
	<li>Deleting records</li>
	<li>Deleting the contents of tables</li>
</ul>

<h3>Lesson 5: Manipulating tables and views</h3>

<ul>
	<li>Creating tables</li>
	<li>Modifying tables</li>
	<li>Deleting tables</li>
	<li>Adding and removing views</li>
</ul>

<h3>Lesson 6: Manipulating indexes</h3>

<ul>
	<li>Adding and removing indexes</li>
</ul>

<h3>Lesson 7: Ensuring data integrity with transactions</h3>

<ul>
	<li>Transactions</li>
</ul>

<h3>Lesson 8: Creating databases</h3>

<ul>
	<li>Creating a database with SQL</li>
	<li>Deleting a database</li>
</ul>
</div>
        </section>
            <div class="maincategory mt-5">
            <h3 class="cdetail-head">
                <i class="fas fa-check-circle"></i>
                Requirements            </h3>
            <div class="course-sub-details">
                <p>SQL: Fundamentals of Querying or equivalent knowledge.</p>
            </div>
        </div>
            </div>
    <div class="col-sm-1"></div>
    <div class="col-sm-5 course-right-col blue">
        <div class="head-course-duration mt-3">
            <i class="fas fa-clock">&nbsp;</i><span>14 Hours</span>
        </div>
        <style>.consultancy-enquiry-btn, .consultancy-enquiry-btn:hover{border-color:#198754; color:#198754; font-size:18px;}</style>
<div class="header-bts mt-3 mb-3 d-flex flex-column gap-3">
    <button type="button" class="btn btn-lg btn-success enquiry-btn col-sm-12" id='default-enquiry-btn-modal' data-bs-toggle="modal" data-bs-target="#myModalGetQuote">COURSE ENQUIRY</button>

        <button type="button" class="btn btn-lg btn-default enquiry-btn consultancy-enquiry-btn col-sm-12" data-bs-toggle="modal" data-bs-target="#myModalGetConsultancyEnquiry">CONSULTANCY ENQUIRY</button>
        <style>
.public-booking-part-1 {
    border: 1px solid #198754;
    padding: 5px;
    margin: 5px 0;
}
.dropdown-location {
    position: relative;
    display: inline-block;
    width: 100%;
}
.dropdown-location .selected-location {
    background-color: #F8F8F8;
    padding: 0.375rem 0.75rem;
    border-radius: 0.375rem;
    cursor: pointer;
}
.selected-location .price,.region_venue_id {display: none;}
.dropdown-location .location-list {
    padding-left: 0px;
    display: none;
    position: absolute;
    top: 100%;
    left: 0;
    max-height: 350px;
    overflow-y: auto;
    background-color: white;
    border: 1px solid #cfcfcf;
    box-shadow: 4px 10px 10px silver;
    z-index: 1;
}
.dropdown-location .location-list li {
    padding: 10px;
    list-style-type: none;
    border-top: 1px solid #cfcfcf;
    cursor: pointer;
    display: flex;
}
.dropdown-location .location-list li .region_venue_id {display: none;}
.dropdown-location .location-list li:first-of-type {border-top: none;}
.dropdown-location .location-list li:last-of-type {border-bottom: 1px solid #cfcfcf;}
.dropdown-location .location-list li .venue-title {flex:1; margin-right:20px;}
.dropdown-location .location-list li .price {float:right;}
.form-check{padding-left: 2.3rem;}
</style>

<div class="public-booking-part-1 my-0">
    <form method="POST" name="public-booking" class="bookForm mt-3">
        <div class="row form-inline ">
            <div class="col-sm-12">
                <p class="dateLabel text-center"><span>Number of participants</span></p>
            </div>
            <div class="col-sm-4">
                <button type="button" class="btn btn-lg no-participants" id="book-btn-minus" aria-label="number of participants remove"><i class="fas fa-minus" aria-hidden="true" >&nbsp;</i></button>
            </div>
            <div class="col-sm-4">
                <input type='text' class="form-control datebox text-center" name="no_of_participants" id="no_of_participants" value="4" min="1" onkeydown="return false" aria-label="How many participant will be on the course?" onfocus="this.blur()"/>
            </div>
            <div class="col-sm-4">
                <button type="button" class="btn btn-lg no-participants" id="book-btn-plus" aria-label="number of participants add" ><i class="fas fa-plus" aria-hidden="true">&nbsp;</i></button>
            </div>
        </div><br>
        <div id='booking-information-row'>
            <div class="form-check" style="margin-top:-1rem;">
                <input id="online-booking" class="form-check-input" type="radio" name="bookingType" value="online" checked />
                <label class="form-check-label" for="online-booking">Online</label>
            </div>
            <div class="form-check mt-3 mb-3">
                <input id="classroom-booking" class="form-check-input" type="radio" name="bookingType" value="classroom" />
                <label class="form-check-label" for="classroom-booking">Classroom</label>
            </div>
            <style>.booking-venues{display:none;}</style>
            <div class="booking-venues">
                <div class="dropdown-location" id="dropdownLocation">
                    <div class="selected-location" onclick="toggleDropdown()">Select Location</div>
                    <ul class="location-list" id="locationList">
                    </ul>
                </div>
                <p class="booking_venue_error" style="color:red;display:none;">Please select a Venue</p>
            </div>
            <div class="row form-inline">
                <input type="hidden" id="book_course_hours" value="14" />
            
            </div><br>
        </div>
        <div class="text-center booking-form-book-btn">
            <input type="button" class="col-md-12 btn btn-lg btn-success w-100 btn-get-booking" value="BOOK" />
            <p>
                <span>
                    Price per participant<br>
                </span>
            </p>
        </div>

        <div class="text-center booking-form-quote-btn" style="display:none">
            <input type="button" data-bs-toggle="modal" data-bs-target="#myModalGetQuote" class="col-md-12 btn btn-lg btn-success btn-get-quote w-100" value="COURSE ENQUIRY" />
        </div>
    </form>
</div>
<div class='book-footer booking-form-book-btn'><p>Open Training Courses require 5+ participants.</p></div>

<script async>
var coursePrices = '{"regions":{"cr_1745":{"tid":"cr_1745","title":"San Jos\u00e9","sales_area":"cr_costa_rica","venues":{"cr_10638141":{"vid":"cr_10638141","title":"San Jose - Plaza Roble Las Terrazas","vfdc":"150.00","prices":{"1":{"remote guaranteed":3937,"classroom guaranteed":4237,"remote guaranteed per delegate":3937,"delegates":1,"adp":937,"classroom guaranteed per delegate":4237},"2":{"remote guaranteed":4874,"classroom guaranteed":5274,"remote guaranteed per delegate":2437,"delegates":2,"adp":937,"classroom guaranteed per delegate":2637},"3":{"remote guaranteed":5811,"classroom guaranteed":6312,"remote guaranteed per delegate":1937,"delegates":3,"adp":937,"classroom guaranteed per delegate":2104},"4":{"remote guaranteed":6748,"classroom guaranteed":7348,"remote guaranteed per delegate":1687,"delegates":4,"adp":937,"classroom guaranteed per delegate":1837},"5":{"remote guaranteed":7685,"classroom guaranteed":8385,"remote guaranteed per delegate":1537,"delegates":5,"adp":937,"classroom guaranteed per delegate":1677},"6":{"remote guaranteed":8622,"classroom guaranteed":9420,"remote guaranteed per delegate":1437,"delegates":6,"adp":937,"classroom guaranteed per delegate":1570},"7":{"remote guaranteed":9562,"classroom guaranteed":10458,"remote guaranteed per delegate":1366,"delegates":7,"adp":937,"classroom guaranteed per delegate":1494},"8":{"remote guaranteed":10496,"classroom guaranteed":11496,"remote guaranteed per delegate":1312,"delegates":8,"adp":937,"classroom guaranteed per delegate":1437},"9":{"remote guaranteed":11430,"classroom guaranteed":12537,"remote guaranteed per delegate":1270,"delegates":9,"adp":937,"classroom guaranteed per delegate":1393},"10":{"remote guaranteed":12370,"classroom guaranteed":13570,"remote guaranteed per delegate":1237,"delegates":10,"adp":937,"classroom guaranteed per delegate":1357}}}}}},"remote":{"1":{"remote guaranteed":3937,"remote guaranteed per delegate":3937,"adp":937},"2":{"remote guaranteed":4874,"remote guaranteed per delegate":2437,"adp":937},"3":{"remote guaranteed":5811,"remote guaranteed per delegate":1937,"adp":937},"4":{"remote guaranteed":6748,"remote guaranteed per delegate":1687,"adp":937},"5":{"remote guaranteed":7685,"remote guaranteed per delegate":1537,"adp":937},"6":{"remote guaranteed":8622,"remote guaranteed per delegate":1437,"adp":937},"7":{"remote guaranteed":9562,"remote guaranteed per delegate":1366,"adp":937},"8":{"remote guaranteed":10496,"remote guaranteed per delegate":1312,"adp":937},"9":{"remote guaranteed":11430,"remote guaranteed per delegate":1270,"adp":937},"10":{"remote guaranteed":12370,"remote guaranteed per delegate":1237,"adp":937}},"currency":"USD"}';
coursePrices = JSON.parse(coursePrices);
var currency = coursePrices['currency'];

$(document).ready(function() {
    var participants = $('#no_of_participants').val();
    var locations = location_options(participants);
    //var min_price_venue = check_min_price_venue(locations);
    refreshLocationOptions(locations);
    setLocationsAndPrice(participants);
})

$('#book-btn-plus').on('click', function(e) {
    var participants = $('#no_of_participants').val();
    participants = parseInt(participants)+1;
    if(participants > 4) {
        $('.booking-form-book-btn').css('display', 'none');
        $('.booking-form-quote-btn').css("display", "block");
        $('#booking-information-row').css('display', 'none');
        $('#default-enquiry-btn-modal').css('display', 'none');
    }else{
        $('.booking-form-book-btn').css('display', 'block');
        $('.booking-form-quote-btn').css("display", "none");
        setLocationsAndPrice(participants)
    }
})

$('#book-btn-minus').on('click', function(e) {
    var participants = $('#no_of_participants').val();
    participants = parseInt(participants) - 1;
    if(participants > 4) {
        $('.booking-form-book-btn').css('display', 'none');
        $('.booking-form-quote-btn').css("display", "block");
    }else{
        $('.booking-form-book-btn').css('display', 'block');
        $('.booking-form-quote-btn').css("display", "none");
        $('#booking-information-row').css('display', 'block');
        $('#default-enquiry-btn-modal').css('display', 'block');
        if(participants > 0) {
            setLocationsAndPrice(participants)
        }
    }
})
function onChangeLocation() {
    var participants = $('#no_of_participants').val();
    setLocationsAndPrice(participants);
}

function refreshLocationOptions(locationOptions) {
    $.each(locationOptions, function(key, venue) {
        $(".location-list").append("<li data-value='" + venue.venue_id + "' onclick='selectLocation(this)'> <span class='region_venue_id'>" + venue.venue_id + "</span>"  + venue.locationTitle + "</li>");
    });
}

function setLocationsAndPrice(participants) {
    var bookingType = $('input[name="bookingType"]:checked').val();
    var bookText = "BOOK" + " - ";
    var price_per_participant = total_price =  '';

    if(bookingType == 'online'){
        price_per_participant = coursePrices.remote[participants]['remote guaranteed per delegate'];
        total_price =  coursePrices.remote[participants]['remote guaranteed'];
    } else {
        if(parseInt(participants) > 10) {
            return ;
        }
        var venueInfo = $('.selected-location .region_venue_id').text();
        if(!venueInfo) {
            return;
        }
        venueInfo = venueInfo.split("-");
        var regionId = venueInfo[0];
        var venueId = venueInfo[1];
        var venues = coursePrices['regions'][regionId]['venues'];

        $.each(venues,function(key, venue) {
            if(venue.vid == venueId) {
                price_per_participant = venue['prices'][participants]['classroom guaranteed per delegate'];
                total_price = venue['prices'][participants]['classroom guaranteed'];
            }
        })

    }

    $('.btn-get-booking').val(bookText + price_per_participant + " " + currency);
    return total_price;
}

function location_options(participants) {
    var locations = [];
    var region = '';
    var venueTitle = '';
    $.each(coursePrices.regions, function(key, value){
        region= value.title;
        sales_area= value.sales_area;
        $.each(value.venues, function(vkey, venue) {
            venueTitle = venue.title;
            var prices = venue['prices'][participants];
            var price = prices['classroom guaranteed per delegate'];
            var classroomGuaranteed = venue['prices'][1]['classroom guaranteed'];
            var locationTitle = "<span class='venue-title'>" + venue.title + "</span>";
            locations.push({price, locationTitle, venue_id: key+"-"+venue.vid, classroomGuaranteed, sales_area});
        })
    })
    return locations;
}
function check_min_price_venue(locationOptions){
    var contactInfo = JSON.parse(localStorage.getItem("contact-info"));
    var current_sales_area = contactInfo && contactInfo['sales_area'];
    if(current_sales_area){
        const filteredData = locationOptions.filter(record => record.sales_area === current_sales_area);
        let minPrice = Infinity;
        let minPriceVenue = null;
    
        $.each(filteredData, function(key, venue) {
            if (venue.price < minPrice) {
                // Update the minimum price and venue details
                minPrice = venue.price;
                minPriceVenue = venue;
            }
        });
        var el = "<li data-value='" + minPriceVenue.venue_id + "' style='list-style:none;'> <span class='region_venue_id'>" + minPriceVenue.venue_id + "</span>"  + minPriceVenue.locationTitle + "</li>";
        var selectedLocation = document.querySelector('.selected-location');
        selectedLocation.innerHTML = el;
    }
}
</script>
<script async>
$(document).ready(function() {
    // show and hide venues for online and classroom
    $('#online-booking, #classroom-booking').change(function() {
        if ($(this).is(':checked')) {
            $('.booking-venues').toggle();
            onChangeLocation();
        }
    });
});

$('.btn-get-booking').on('click', function(e) {
    var course_price = 0;
    var bookingType = $('input[name="bookingType"]:checked').val();
    var participants = $('#no_of_participants').val();
    var venueInfo = $('.selected-location .region_venue_id').text();
    course_price = setLocationsAndPrice(participants);
    if(bookingType == 'classroom' && venueInfo === ''){
        $('.booking_venue_error').show();
        return;
    }
    $('input[name="course_name"]').val('SQL Advanced Training Course');
    $('input[name="location_type"]').val(bookingType);
    $('input[name="duration"]').val('14');
    $('input[name="participants"]').val(participants);
    $('input[name="course_price"]').val(course_price + " " + currency);
    $('input[name="venue_info"]').val(venueInfo);
    $('#myModalBooking').modal('show');
});
</script>
<script>
document.addEventListener('click', function(event) {
    var dropdownLocation = document.getElementById('dropdownLocation');
    var locationList = document.getElementById('locationList');

    if (dropdownLocation.contains(event.target)) {
        // Click inside the dropdown, hide error if shown
        $('.booking_venue_error').hide();
    } else {
        // Click outside the dropdown, close it
        locationList.style.display = 'none';
    }
});

function toggleDropdown() {
    var locationList = document.getElementById('locationList');
    locationList.style.display = locationList.style.display === 'block' ? 'none' : 'block';
}

function selectLocation(element) {
    var selectedLocation = document.querySelector('.selected-location');
    var selectedLocationId = element.getAttribute('data-value');
    selectedLocation.innerHTML = element.innerHTML;
    toggleDropdown();
    onChangeLocation();
}
</script>

<script>
    function updateVenueDropdown() {
        var participants = $('#no_of_participants').val();
        var locations = location_options(participants);
        var min_price_venue = check_min_price_venue(locations);
        refreshLocationOptions(locations, min_price_venue);
        //onChangeLocation();
    }
    function addEventListenerForUpdateVenueDropdown(){
        const target = document.getElementById("selected-email-anchor-text");
        updateVenueDropdown();
        if (target) {
            const observer = new MutationObserver(updateVenueDropdown);
            const config = { childList: true, subtree: true };
            observer.observe(target, config);
        }
    }
    addEventListenerForUpdateVenueDropdown();
</script></div>

<script src="/nplibraries/js/jquery/jquery.validate.min.js"></script>
<!-- Modal -->
<div class="modal fade courseModal" id="myModalBooking" tabindex="-1" role="dialog"
    aria-labelledby="myModalBookingLabel">
    <div class="modal-dialog" role="document">
        <div class="modal-content">

            <div class="modal-header">
                <h3 class="modal-title" id="myModalBookingLabel">SQL Advanced Training Course - Booking</h3>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                <div class="main-booking-part-2">
                    <form id="courseBookingForm" method="post" action="">
    <input id="course_name" type="hidden" class="form-control" name="course_name" value="" readonly />
    <input id="location_type" type="hidden" class="form-control" name="location_type" value="" readonly />
    <input id="duration" type="hidden" class="form-control" name="duration" value="" readonly />
    <input type="hidden" class="form-control" name="participants" readonly />
    <input id="course_price" type="hidden" class="form-control booking-price-display" name="course_price" value="" readonly />

    <div class="form-group">
        <label for="full_name">Full name *</label> <span class='public-booking-full-name-error'></span>
        <input id="full_name" type="text" class="form-control" name="full_name"  />
    </div>
    <div class="form-group">
        <label for="phone">Phone *</label> <span class='public-booking-phone-error'></span>
        <input id="phone" type="text" class="form-control" name="phone"  autocomplete="tel" />
    </div>
    <div class="form-group">
        <label for="email">Email *</label> <span class='public-booking-email-error'></span>
        <input id="email" type="email" class="form-control" name="email"  autocomplete="email"/>
    </div>
    <div class="form-group">
        <label for="job_title">Job Title</label>
        <input id="job_title" type="text" class="form-control" name="job_title" />
    </div>

    <div class="form-group">
        <label for="company_name">Company Name</label>
        <input id="company_name" type="text" class="form-control" name="company_name" />
    </div>
    <div class="form-group">
        <label for="address_1" >Address 1 *</label> <span class='public-booking-address-1-error'></span>
        <input id="address_1" type="text" class="form-control" name="address_1" autocomplete="address-level1"/>
    </div>
    <div class="form-group">
        <label for="address_2">Address 2 </label>
        <input id="address_2" type="text" class="form-control" name="address_2" />
    </div>
    <div class="form-group">
        <label for="city">City *</label> <span class='public-booking-city-error'></span>
        <input id="city" type="text" class="form-control" name="city" />
    </div>
    <div class="form-group">
        <label for="state_province">State / Province</label>
        <input id="state_province" type="text" class="form-control" name="state_province" />
    </div>
    <div class="form-group">
        <label for="country">Country *</label> <span class='public-booking-country-error'></span>
        <input id="country" type="text" class="form-control" name="country" autocomplete="country" />
    </div>
    <div class="form-group">
        <label for="post_code">Postcode *</label> <span class='public-booking-post-code-error'></span>
        <input id="post_code" type="text" class="form-control" name="post_code" />
    </div>
    <div class="form-group">
        <label for="tax_id">Tax ID</label>
        <input id="tax_id" type="text" class="form-control" name="tax_id"/>
    </div>

    <div class="row">
        <div class="col col-sm-6 col-xxl-5 start-date-book">
            <label for="booking_starts" class="dateLabel">Start Date</label>
            <input type='date' class="form-control datebox" min="2024-05-16" name="course_start_date" id="booking_starts" autocomplete="off" />
            <span class='course-start-date-error'></span>
        </div>
        <div class="col col-sm-6 col-xxl-5 end-date-book">
            <label for="booking_ends" class="dateLabel">End Date</label>
            <input type='date' class="form-control datebox" name="course_end_date"  id="booking_ends" autocomplete="off" readonly />
        </div>
        <p style="padding: 5px 10px;margin-bottom:0px;">
                Dates are subject to availability and take place between 09:30 and 16:30.        </p>
    </div>
    
    <p class="modal-header-form mb-0">Payment Method <span style="color:#000"> *</span></p>
    <div class="row form-inline">
        <div class="col-md-6 form-group">
            <input id="payment_method1" class="form-check-input" type="radio" name="payment_method" value="bank_transfer" checked/>&nbsp;&nbsp;
            <label for="payment_method1" class="form-check-label">Bank Transfer (Invoice, PO)</label>
        </div>
        <div class="col-md-6 form-group">
            <input id="payment_method2" class="form-check-input" type="radio" name="payment_method" value="credit_debit_card"/>&nbsp;&nbsp;
            <label for="payment_method2" class="form-check-label">Debit / Credit Card</label>
        </div>
    </div>

    <p class="modal-header-form mb-0">Additional Information</p>

    <div class="form-group">
        <label for="comments_and_remarks" >Comments</label>
        <textarea id="comments_and_remarks" class="form-control" name="comments_and_remarks" style="height:8rem;"></textarea>
    </div>
    <div class="form-inline row mt-2">
        <div class="col-md-1">
            <input type="checkbox" name="allow_publishing_certificate" value="1" checked />
        </div>
        <div class="col-md-11">
            <p>Allow Publishing Certificate </p>
            <p style="opacity: 0.5;font-size: 0.75rem;margin-top:-16px;">If you check this box the participants will receive an option to publish their course certificate on the NobleProg Certified Professional Catalogue.</p>
        </div>
    </div>
    <div class="form-inline row">
        <div class="col-md-1">
            <input type="checkbox" name="terms_and_conditions" value="1"/>
        </div>
        <div class="col-md-11">
            <p><a href="/terms-and-conditions" target="_blank">Terms and Conditions * </a><span class='public-booking-terms-and-conditions-error'></span></p>
            <p style="opacity: 0.5;font-size: 0.75rem;margin-top:-16px;">I am an authorised representative of the above named client and I wish to book the above courses or services in accordance with NobleProg Terms and Conditions and Privacy Policy.</p>
        </div>
    </div>
    <div class="form-inline row">
        <div class="col-md-1">
            <input id="inform_me_about_discounts_and_promotions" type="checkbox" name="inform_me_about_discounts_and_promotions" value="1" checked />
        </div>
        <div class="col-md-11">
            <p for="inform_me_about_discounts_and_promotions">Inform me about discounts and promotions</p>
            <p style="opacity: 0.5;font-size: 0.75rem;margin-top:-16px;">Please read our <a href="/privacy-statement" target="_blank"> Privacy Policy </a> to find out how we use your data</p>
        </div>
    </div>
    
            <!-- Hidden field -->
        <input type="text" name="sendEmailOption" value="2" hidden />
        
    <!-- All hidden fields starts here  -->
    <input type="text" name="course_code" value="adsql" hidden />
    <input type="text" name="spam_not_required" value="Must not be empty" hidden />
    <input type="text" name="spam_required" value="" hidden />
    <input type="text" name="venue_info" value="" hidden />
    <input type="text" name="course_type" value="public" hidden />
    <!-- All hidden fields ends here -->
    <br>
    <div class="text-center">
        <input type="submit" class="col-md-12 btn btn-lg btn btn-success booking-submit-btn" value="Submit" />
    </div>
</form>

<script async>
$("#courseBookingForm").validate({
    rules: {
        course_start_date: "required",
        full_name: "required",
        phone: {
            required: true,
        },
        email: {
            email: true,
            required: true
        },
        address_1: "required",
        city: "required",
        country: "required",
        post_code: "required",
        payment_method: "required",
        terms_and_conditions: "required"
    },
    messages: {
        course_start_date: "Please select starting Date",
        full_name: "Required",
        phone: {
            minlength: "Please enter Valid Phone No.",
            required: "Required"
        },
        email: {
            email: "Enter Valid Email.",
            required: "Required"
        },
        address_1: "Required",
        city: "Required",
        state_province: "Required",
        country: "Required",
        post_code: "Required",
        payment_method: "Required",
        terms_and_conditions: "Required"
    },
    errorPlacement: function(error, element) {
        const errorMessagePlaces = [];
        errorMessagePlaces['course_start_date'] = '.course-start-date-error';
        errorMessagePlaces['full_name'] = '.public-booking-full-name-error';
        errorMessagePlaces['phone'] = '.public-booking-phone-error';
        errorMessagePlaces['email'] = '.public-booking-email-error';
        errorMessagePlaces['address_1'] = '.public-booking-address-1-error';
        errorMessagePlaces['city'] = '.public-booking-city-error';
        errorMessagePlaces['state_province'] = '.public-booking-state-province-error';
        errorMessagePlaces['country'] = '.public-booking-country-error';
        errorMessagePlaces['post_code'] = '.public-booking-post-code-error';
        errorMessagePlaces['payment_method'] = '.public-booking-payment-method-error';
        errorMessagePlaces['terms_and_conditions'] = '.public-booking-terms-and-conditions-error';

        const errorMessagePlace = errorMessagePlaces[element.attr("name")]

        if (errorMessagePlace) {
            if (errorMessagePlace === '.public-booking-terms-and-conditions-error') error[0].style.position = 'static';
            $(errorMessagePlace).empty();
            error.appendTo(errorMessagePlace);
            return;
        }
        error.insertAfter(element);
    },

    submitHandler: function(form, event) {
        $('.booking-submit-btn').attr('disabled' , true);
        //Get UUID
        const id = create_UUID();
        const step = "1";
        //Get token
        const csrf_token = getToken();
        //other
        const others = {
            "lead_type": "booking",
            "username": "",
            "submit": "Complete booking",
            "op": "Complete booking",
            "form_id": "booking_form_v3_custom_form"
        }
        //form.submit()
        //   event.preventDefault(); // avoid to execute the actual submit of the form.
        const form_data = new FormData(event.target);
        const values = Object.fromEntries(form_data.entries());
        const salesArea = JSON.parse(localStorage.getItem("contact-info"))['sales_area'];
        const data = {
            id,
            step,
            ...values,
            ...others,
            csrf_token,
            salesArea
        }

       $.ajax({
            type : 'POST',
            url : window.location.href,
            data: data,
            success: function(response){
                var res = JSON.parse(response);
                if (res.status === 'success') {
                    $('.booking-submit-msg').css('display', 'block');
                    $('#myModalBooking').modal('hide');
                    // window.location.reload();
                }
                if (res.status === 'error') {
                    alert(res.message);
                }
            },
            error: function () {
                console.log('Something went wrong!');
            }
        });
    }
});
</script>                </div>
            </div>

        </div><!-- modal-content -->
    </div><!-- modal-dialog -->
</div>
<script>
   $(document).ready(function(){
    $("#book-btn-plus").click(function() {
        var noVal = $("#no_of_participants").val();
        var newVal = parseInt(noVal) + 1;
        $("#no_of_participants").val(newVal);
    });

    $("#book-btn-minus").click(function() {
        var noVal = $("#no_of_participants").val();
        if(parseInt(noVal) < 2){
            var newVal = 1;
        }else{
            var newVal = parseInt(noVal) - 1;
        }
        $("#no_of_participants").val(newVal);
    });

    $('#booking_starts').change(function() {
        var hrs     = $("#book_course_hours").val();
        var days    = parseInt(hrs) / 7;
        var start   = $("#booking_starts").val();
        var result  = new Date(start);
        var end     = result.setDate(result.getDate() + days - 1);

        //var formatend = new Date(end).toLocaleDateString("en-US");
        $("#booking_ends").val(dateToYMD(end));
        $('.start_date_error').hide();
    });
    function dateToYMD(end_date) {
        var ed = new Date(end_date);
        var d = ed.getDate();
        var m = ed.getMonth() + 1;
        var y = ed.getFullYear();
        return '' + y + '-' + (m<=9 ? '0' + m : m) + '-' + (d <= 9 ? '0' + d : d);
    }

});
</script><!-- Modal -->
<div class="modal fade courseModal" id="myModalGetQuote" tabindex="-1" role="dialog" aria-labelledby="myModalGetQuoteLabel">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <h3 class="modal-title" id="myModalGetQuoteLabel">SQL Advanced Training Course - Enquiry</h3>
                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <div class="modal-body">
                <form id="courseEnquiryForm" method="post" action="">
                    <!-- <p class="modal-header-form">Personal Information</p> -->
                    <div class="row">
                        <div class="col-12">
                            <label for="fullName">Full name *</label> <span class="enquiry-full-name-error"></span>
                            <input id="fullName" type="text" class="form-control" name="fullName" style="float:left;" />
                        </div>
                    </div>
                    <div class="row form-group">
                        <div class="col-12">
                            <label for="phoneNumber">Phone *</label> <span class="enquiry-phone-number-error"></span>
                            <input id="phoneNumber" type="text" class="form-control" name="phoneNumber" style="float:left;"/>
                        </div>
                        <div class="col-3" style="display:none;">
                            <!-- hidden block for removal -->
                            <input id="preferredPhone" type="checkbox" name="preferredPhone" value="true" />
                            <label for="preferredPhone">Preferred</label>
                        </div>
                    </div>
                    <div class="row form-group">
                        <div class="col-12">
                            <label for="emailAddress">Email *</label> <span class="enquiry-email-address-error"></span>
                            <input id="emailAddress" type="text" class="form-control" name="emailAddress" style="float:left;" />
                        </div>
                        <div class="col-12" style="display:none;">
                            <!-- hidden block for removal -->
                            <input id="preferredEmail" type="checkbox" name="preferredEmail" value="true" />
                            <label for="preferredEmail">Preferred</label>
                        </div>
                    </div>

                    <div class="form-group">
                        <label for="companyName">Company Name</label>
                        <input id="companyName" type="text" class="form-control" name="companyName" />
                    </div>

                    <div class="row form-group">
                        <div class="col-12">
                            <label for="address">Company Address</label>
                            <input id="address" type="text" class="form-control" name="address" autocomplete="address-level1"/>
                        </div>
                        <div class="col-3" style="display:none;">
                            <!-- hidden block for removal -->
                            <input id="preferredAddress" type="checkbox" name="preferredAddress" value="true" />
                            <label for="preferredAddress">Preferred</label>
                        </div>
                    </div>
                    <div class="row form-group">
                        <div class="col-12">
                            <label for="participants">Number of participants</label>
                            <input id="participants" type="text" value="1" class="form-control" name="participants" />
                        </div>
                        <div class="col-6" style="display:none;">
                            <!-- hidden block for removal -->
                            <label for="suitableDate">Date</label>
                            <input id="suitableDate" type="date" class="form-control" name="suitableDate" />
                        </div>
                    </div>
                    <!-- -----------------Course info starts here------------------------------------------------- -->
                    <!-- <p class="modal-header-form">Course Information</p> -->

                    <div class="row form-group">
                        <p>How do you want to take the course?</p>
                        <div class="col-4" style="padding-right:0;text-align:center;">
                            <input type="radio" name="locationType" value="onsite" id="onsite" />&nbsp;
                            <label for="onsite">Client Premises</label>
                        </div>
                        <div class="col-3" style="padding:0;text-align:center;">
                            <input type="radio" name="locationType" value="online" id="online" checked />&nbsp;
                            <label for='online'>Online</label>
                        </div>
                        <div class="col-5" style="padding:0;text-align:center;">
                            <input type="radio" name="locationType" value="classroom" id="classroom" />&nbsp;
                            <label for='classroom'>Classroom</label>
                        </div>
                    </div>
                    <div class="form-group" style="display:none;">
                        <!-- hidden block for removal -->
                        <label for="courseName">Course Name</label>
                        <input id="courseName" type="text" class="form-control" name="courseName" value="SQL Advanced" readonly />
                    </div>
                    <div class="col-md-6 form-group" style="display:none;">
                        <!-- hidden block for removal -->
                        <label for="courseDuration">Duration, hours</label>
                        <input id="courseDuration" type="text" class="form-control" name="courseDuration" value="14 Hours" readonly />
                    </div>

                    <div class="row">
                    <script async>$('input[type="radio"]').click(function(){
                        if($(this).attr("value")=="onsite"){
                            $(".venueadress").hide('slow');
                        }
                        if($(this).attr("value")=="online"){
                            $(".venueadress").hide('slow');
                        }
                        if($(this).attr("value")=="classroom"){
                            $(".venueadress").hide('slow');
                        }
                        });
                    </script>
                        <div class="col-md-6 form-group" style="display:none;">
                            <!-- hidden block for removal -->
                            <label for="siutableTime">Suitable Time</label>
                            <input id="siutableTime" type="time" class="form-control" name="siutableTime"  />
                        </div>
                    </div>
                    <div class="form-group" style="display:none;" >
                        <!-- hidden block for removal -->
                        <label for="preferredLanguage">Preferred language</label>
                        <input id="preferredLanguage" type="text" class="form-control" name="preferredLanguage"  />
                    </div>
                    <div class="form-group venueadress" style="display:none;" >
                        <!-- hidden block for removal -->
                        <label for="suggestedVenue" >Suggested Venue Address</label>
                        <input id="suggestedVenue" type="text" class="form-control" name="suggestedVenue"  />
                    </div>
                    <!-- Course info ends here -->

                    <!-- <p class="modal-header-form">Additional Information</p> -->
                    <div class="form-group">
                        <label for="comments" >Comments</label>
                        <textarea id="comments" class="form-control" name="comments" style="height:3.88rem;"></textarea>
                    </div>
                    <div class="form-check mt-3">
                        <input class="form-check-input" type="checkbox" name="newsletter" id="newsletter" value="true" checked />
                        <label for="newsletter" class="form-check-label mb-0">Inform me about discounts and promotions</label>
                        <p style='color:gray;font-size: 0.75rem;'>
                            <span>Please read our <a href="/privacy-statement" target="_blank"> Privacy Policy </a> to find out how we use your data</span>

                        </p>
                    </div>
                                            <!-- Hidden field -->
                        <input type="text" name="sendEmailOption" value="2" hidden />
                                        <!-- All hidden fields starts here  -->
                    <input type="text" name="courseCode" value="adsql" hidden />
                    <!-- <input type="text" name="salesArea" value="<?//=$sales_area;?>" hidden /> -->
                    <input type="text" name="submitterDetails" value="3.139.62.103 | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" hidden />
                    <input type="text" name="spam_not_required" value="Must not be empty" hidden />
                    <input type="text" name="spam_required" value="" hidden />
                    <!-- <input id="courseType" type="text" name="courseType" value="" hidden /> -->
                    <!-- All hidden fields ends here -->
                    <br>
                    <div class="text-center">
                        <input type="submit" class="col-md-12 btn btn-success btn-lg book-now-btn enquiry-submit-btn" value="Submit" />
                    </div>
                </form>
            </div>
        </div><!-- modal-content -->
    </div><!-- modal-dialog -->
</div>

<script async>
$("#courseEnquiryForm").validate({
    rules: {
        fullName: "required",
        phoneNumber: {
            required: true,
        },
        emailAddress: {
            email: true,
            required: true
        },
    },
    messages: {
        fullName: "Required",
        phoneNumber: {
            minlength: "Please enter Valid Phone No.",
            required: "Required"
        },
        emailAddress: {
            email: "Enter Valid Email.",
            required: "Required"
        },
    },
    errorPlacement: function(error, element) {
        const errorMessagePlaces = [];
        errorMessagePlaces['fullName'] = '.enquiry-full-name-error';
        errorMessagePlaces['phoneNumber'] = '.enquiry-phone-number-error';
        errorMessagePlaces['emailAddress'] = '.enquiry-email-address-error';
        const errorMessagePlace = errorMessagePlaces[element.attr("name")]
        if (errorMessagePlace) {
            $(errorMessagePlace).empty();
            error.appendTo(errorMessagePlace);
            return;
        }
        error.insertAfter(element);

    },

    submitHandler: function(form, event) {
        $('.enquiry-submit-btn').attr('disabled' , true);
        //Get UUID
        const id = create_UUID();
        const step = "1";
        //Get token
        const token = getToken();
        //other
        const others = {
            "classroomLiveTrainer": "false",
            "classroomRemoteTrainer": "false",
            "remoteTraining": "true",
            "hardwareNobleProg": "false",
            "hardwareClient": "false",
            "venueNobleProg": "false",
            "venueClient": "false",
            "subject": "",
            "location": "",
            "type": "course",
            "consultancySubject": "",
            "numberConsultants": "",
            "consultancyDuration": "",
            "workWith": "",
            "consultancyGoal": "",
            "urgencyNow": "false",
            "urgencyAsap": "false",
            "urgencyNotRush": "false",
            "venueId": "",
            "maxPrice": "",
            "referer": "",
            "username": "",
            "lead_type": "enquiry",
        }
        //form.submit()
        //   event.preventDefault(); // avoid to execute the actual submit of the form.
        const form_data = new FormData(event.target);
        const values = Object.fromEntries(form_data.entries());
        const v = JSON.stringify(values);
        const salesArea = JSON.parse(localStorage.getItem("contact-info"))['sales_area']

        const data = {
            id,
            step,
            ...values,
            ...others,
            token,
            salesArea,
        }
        $.ajax({
            type : 'POST',
            url : window.location.href,
            data: data,
            success: function(response){
                var res = JSON.parse(response);
                if (res.status === 'success') {
                    $('.enquiry-submit-msg').css('display', 'block');
                    // $("#courseEnquiryForm")[0].reset();
                    $('#myModalGetQuote').modal('hide');
                    // window.location.reload();
                }
                if (res.status === 'error') {
                    alert(res.message);
                }
            },
            error: function () {
                console.log('Something went wrong!');
            }
        });
    }
});
</script><!-- Modal -->
<div class="modal fade courseModal" id="myModalGetConsultancyEnquiry" tabindex="-1" role="dialog"
    aria-labelledby="myModalGetConsultancyEnquiryLabel">
    <div class="modal-dialog" role="document">
        <div class="modal-content">

            <div class="modal-header">
                <h3 class="modal-title" id="myModalGetConsultancyEnquiryLabel">
                    SQL Advanced - Consultancy Enquiry                </h3>
                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <div class="modal-body">
                <div class="container">
    <form id="consultancyEnquiryForm" method="post" action="">
        <!-- <p class="modal-header-form">Personal Information</p> -->
        <div class="row">
            <div class="col-12">
                <label for="fullName">Full name *</label> <span class="consultancy-enquiry-full-name-error"></span>
                <input id="fullName" type="text" class="form-control" name="fullName" style="float:left;" />
            </div>
        </div>
        <div class="row form-group">
            <div class="col-12">
                <label for="phoneNumber">Phone *</label> <span class="consultancy-enquiry-phone-number-error"></span>
                <input id="phoneNumber" type="text" class="form-control" name="phoneNumber" style="float:left;"/>
            </div>
        </div>
        <div class="row form-group">
            <div class="col-12">
                <label for="emailAddress">Email *</label> <span class="consultancy-enquiry-email-address-error"></span>
                <input id="emailAddress" type="text" class="form-control" name="emailAddress" style="float:left;" />
            </div>
        </div>
        <div class="row form-group">
            <div class="col-12">
                <label for="companyName">Company Name</label>
                <input id="companyName" type="text" class="form-control" name="companyName" />
            </div>
        </div>
        <div class="row form-group">
            <div class="col-12">
                <label for="consultancySubject">Consultancy Subject *</label> <span class="consultancy-enquiry-consultancy-subject-error"></span>
                <input id="consultancySubject" type="text" class="form-control" name="consultancySubject" value="SQL Advanced" />
            </div>
        </div>
        <div class="row form-group">
            <div class="col-12">
                <label for="consultancyGoal">Consultancy Goal</label>
                <input id="consultancyGoal" type="text" class="form-control" name="consultancyGoal" />
            </div>
        </div>
        <div class="row form-group">
            <div class="col-12">
                <label for="consultancyDuration">Consultancy Duration</label>
                <input id="consultancyDuration" type="text" class="form-control" name="consultancyDuration" placeholder="e.g. 1 day, two weeks, 3 months, etc..." />
            </div>
        </div>
        <div class="row form-group">
            <div class="col-12">
                <label for="numberConsultants">Number of Consultants</label>
                <input id="numberConsultants" type="text" class="form-control" name="numberConsultants" placeholder="e.g. 'two to four', '1-8', etc..." />
            </div>
        </div>
        <div class="row form-group">
            <div class="col-12">
                <label for="suitableDate">Suitable Date</label>
                <input id="suitableDate" type="text" class="form-control" name="suitableDate" placeholder="e.g.: next 2 months, 1Q20, December." />
            </div>
        </div>

        <div class="row form-group">
            <div class="col-12">
                <label for="workWith">Who will the consultant work with?</label>
                <input id="workWith" type="text" class="form-control" name="workWith" placeholder="e.g. Stakeholders, IT Team etc...">
            </div>
        </div>
        <div class="row form-group">
            <div class="col-12">
                <label for="consultancy_urgency">Consultancy Urgency *</label>
                <select class="form-select" aria-label="Consultancy Urgency" name="consultancy_urgency" id="consultancy_urgency">
                    <option value="urgencyNotRush" selected="">We are not in an immediate rush but require a consultant</option>
                    <option value="urgencyAsap">We need a consultant as soon as possible</option>
                    <option value="urgencyNow">We are at crisis point and are in urgent need of a consultant now</option>
                </select>
            </div>
        </div>
        <div class="form-group" style="display:none;">
            <!-- hidden block for removal -->
            <label for="courseName">Course Name</label>
            <input id="courseName" type="text" class="form-control" name="courseName" value="SQL Advanced" readonly />
        </div>

        <div class="col-md-6 form-group" style="display:none;">
            <!-- hidden block for removal -->
            <label for="courseDuration">Duration, hours</label>
            <input id="courseDuration" type="text" class="form-control" name="courseDuration" value="14 Hours" readonly />
        </div>
        <!-- Course info ends here -->
        <!-- <p class="modal-header-form">Additional Information</p> -->
        <div class="form-group">
            <div class="col-12">
                <label for="comments" >Comments</label>
                <textarea id="comments" class="form-control" name="comments" style="height:3.88rem;"></textarea>
            </div>
        </div>
        <div class="form-check mt-3">
            <input class="form-check-input" type="checkbox" name="newsletter" id="newsletter" value="true" checked />
            <label for="newsletter" class="form-check-label">Inform me about discounts and promotions            <p style='font-size:0.8rem; opacity:0.8;'>
                <span>Please read our <a style="opacity:1;" href="/privacy-statement" target="_blank"> Privacy Policy </a> to find out how we use your data</span>
            </p>
        </div>
                    <!-- Hidden field -->
            <input type="text" name="sendEmailOption" value="2" hidden />
                <!-- All hidden fields starts here  -->
        <input type="text" name="courseCode" value="adsql" hidden />
        <!-- <input type="text" name="salesArea" value="<?//=$sales_area;?>" hidden /> -->
        <input type="text" name="submitterDetails" value="3.139.62.103 | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" hidden />
        <input type="text" name="spam_not_required" value="Must not be empty" hidden />
        <input type="text" name="spam_required" value="" hidden />
        <!-- <input id="courseType" type="text" name="courseType" value="" hidden /> -->
        <!-- All hidden fields ends here -->
        <br>
        <div class="text-center">
            <input type="submit" class="col-md-12 btn btn-success btn-lg book-now-btn consultancy-enquiry-submit-btn" value="Submit" />
        </div>
    </form>
</div>

<script async>
$("#consultancyEnquiryForm").validate({
    rules: {
        fullName: "required",
        phoneNumber: {
            required: true,
        },
        emailAddress: {
            email: true,
            required: true
        },
        consultancySubject: "required",
    },
    messages: {
        fullName: "Required",
        phoneNumber: {
            minlength: "Please enter Valid Phone No.",
            required: "Required"
        },
        emailAddress: {
            email: "Enter Valid Email.",
            required: "Required"
        },
        consultancySubject: "Required",
    },
    errorPlacement: function(error, element) {
        const errorMessagePlaces = [];
        errorMessagePlaces['fullName'] = '.consultancy-enquiry-full-name-error';
        errorMessagePlaces['phoneNumber'] = '.consultancy-enquiry-phone-number-error';
        errorMessagePlaces['emailAddress'] = '.consultancy-enquiry-email-address-error';
        errorMessagePlaces['consultancySubject'] = '.consultancy-enquiry-consultancy-subject-error';

        const errorMessagePlace = errorMessagePlaces[element.attr("name")]
        if (errorMessagePlace) {
            $(errorMessagePlace).empty();
            error.appendTo(errorMessagePlace);
            return;
        }
        error.insertAfter(element);
    },

    submitHandler: function(form, event) {
        $('.consultancy-enquiry-submit-btn').attr('disabled' , true);
        //Get UUID
        const id = create_UUID();
        const step = "1";
        //Get token
        const token = getToken();
        //other
        const others = {
            "classroomLiveTrainer": "false",
            "classroomRemoteTrainer": "false",
            "remoteTraining": "true",
            "hardwareNobleProg": "false",
            "hardwareClient": "false",
            "venueNobleProg": "false",
            "venueClient": "false",
            "subject": "",
            "location": "",
            "type": "consultancy",
            "locationType": "",
            "venueId": "",
            "maxPrice": "",
            "referer": "",
            "username": "",
            'lead_type': 'enquiry',
        }
        //form.submit()
        //   event.preventDefault(); // avoid to execute the actual submit of the form.
        const form_data = new FormData(event.target);
        const values = Object.fromEntries(form_data.entries());
        const v = JSON.stringify(values);
        const salesArea = JSON.parse(localStorage.getItem("contact-info"))['sales_area'];
        const data = {
            id,
            step,
            ...values,
            ...others,
            token,
            salesArea,
        }

        $.ajax({
            type : 'POST',
            url : window.location.href,
            data: data,
            success: function(response){
                var res = JSON.parse(response);
                    if (res.status === 'success') {
                       $('.enquiry-submit-msg').css('display', 'block');
                      $("#consultancyEnquiryForm")[0].reset();
                       $('#myModalGetConsultancyEnquiry').modal('hide');
                       // window.location.reload();
                    }
                    if (res.status === 'error') {
                        alert(res.message);
                    }
            },
            error: function () {
                console.log('Something went wrong!');
            }
        });
    }
});
</script>                     </div>

        </div><!-- modal-content -->
    </div><!-- modal-dialog -->
</div>    </div>
</div>
<script type="application/ld+json">{
    "@context": "http://schema.org",
    "@type": "Course",
    "courseCode": "adsql",
    "name": "SQL Advanced",
    "description": "<p>Students will learn advanced queries and how to add, u...",
    "provider": {
        "@type": "Organization",
        "name": "NobleProg"
    },
    "offers": {
        "@type": "Offer",
        "category": "Paid"
    },
    "hasCourseInstance": {
        "@type": "CourseInstance",
        "courseMode": "Onsite",
        "courseWorkload": "PT14H"
    }
}</script>            </div>
        </div>
    </div>
        <div class="container mt-3 mb-3">
        <div class="row">
            <div class="col-sm-12">
                <h3 class="mt-1 mb-3" id="course-comments-content">
                    <i class="fas fa-comments"></i>
                    Testimonials                    (3)
                </h3>
            </div>
        </div>
        <div class="row">
            <link href="/nplibraries/plugins/owl-carousel/dist/assets/owl.carousel.min.css" as="style" fetchpriority='low' rel="preload" onload="this.onload=null;this.rel='stylesheet'" type="text/css">
    <link href="/nplibraries/plugins/owl-carousel/dist/assets/owl.theme.default.min.css" as="style" fetchpriority='low' rel="preload" onload="this.onload=null;this.rel='stylesheet'" type="text/css">
    <noscript>
        <link href="/nplibraries/plugins/owl-carousel/dist/assets/owl.carousel.min.css" rel='stylesheet' type="text/css">
        <link href="/nplibraries/plugins/owl-carousel/dist/assets/owl.theme.default.min.css" rel='stylesheet' type="text/css">
   </noscript>
   <script defer src="/nplibraries/plugins/owl-carousel/dist/owl.carousel.min.js"></script>
<script>
$(document).ready(function() {
    //course discount carousel in the home
    $('.testimonials-carousel').owlCarousel({
        loop: false,
        margin: 10,
        dots: false,
        nav: true,
        autoplay: true,
        smartSpeed: 3000,
        autoplayTimeout: 7000,
        responsive: {
            0: {
                items: 1
            },
            700: {
                items: 2
            },
            1000: {
                items: 4
            },
            1400: {
                items: 5
            },
        }
    })
});
</script>

<section class="testimonials-content">
    <div class="testimonials-carousel owl-carousel owl-theme owl-loaded owl-drag">
	                <div>
            <div class="testimonial-card">
                    <p class="elipsis e4 mb-0">
                        Podczas szkolenia zostały bardzo szczegółowe - jak na dwa dni szkolenia - omówione wszystkie moduły, a na tym mi najbardziej zależało.                    </p>
                    <div class="course-outline-stars">
                        <div class="ratings">
                            <div class="discount-empty-stars"></div>
                            <div id="testimonial-colored-star-0" class="full-stars"
                                data-rating="5"></div>
                        </div>
                    </div>
                    <h5 class="delegate-company elipsis e3">Bernadetta  - Urząd Komisji Nadzoru Finansowego</h5>
                     
                      <h6 class="testimonials-title">Course - SQL Advanced</h6>
                                                    </div>
                    </div>
                <div>
            <div class="testimonial-card">
                    <p class="elipsis e4 mb-0">
                        - I really liked that the entire training was tailored to the level of all users and to different environments. It was cool to see how queries differ in different environments. - A huge advantage here is that the presenter&#39;s goal was to share his knowledge with us, and not to show the participants how smart he is:) - I also consider learning from my own and other people&#39;s mistakes to be very valuable because it significantly broadens your horizons.                    </p>
                    <div class="course-outline-stars">
                        <div class="ratings">
                            <div class="discount-empty-stars"></div>
                            <div id="testimonial-colored-star-1" class="full-stars"
                                data-rating="5"></div>
                        </div>
                    </div>
                    <h5 class="delegate-company elipsis e3">Kasia </h5>
                     
                      <h6 class="testimonials-title">Course - SQL Advanced</h6>
                                                                <p><small class="testimonials-mt">Machine Translated</small></p>
                                </div>
                    </div>
                <div>
            <div class="testimonial-card">
                    <p class="elipsis e4 mb-0">
                        The scope of topics discussed, practical tasks, the instructor&#39;s approach, and the involvement of participants                    </p>
                    <div class="course-outline-stars">
                        <div class="ratings">
                            <div class="discount-empty-stars"></div>
                            <div id="testimonial-colored-star-2" class="full-stars"
                                data-rating="5"></div>
                        </div>
                    </div>
                    <h5 class="delegate-company elipsis e3">Agnieszka Flis </h5>
                     
                      <h6 class="testimonials-title">Course - SQL Advanced</h6>
                                                                <p><small class="testimonials-mt">Machine Translated</small></p>
                                </div>
                    </div>
            </div>
</section>
        </div>
    </div>
    </div>

<!-- Related Courses -->
<div class="full-category-tab-content">
    <div class="category-tab-content tab-content" id="category-tabs-content">
        <div class="container">
    <div class="row">
        <h3 class="mb-3 mb-sm-4">Related Courses</h3>
                                    <div class="col-sm-12 col-lg-4 mb-4" onclick="location.href='/en/cc/3057';" style="cursor: pointer;">
                    <a class='hover-text-no-underline' href="/en/cc/3057" >
                        <div class="outline-course-box">
                            <h2 class="elipsis"><div class='text-black hover-text-underline'>Oracle SQL Language</div></h2>
                            <div class="course-outline-adds">
                                <span class="course-outline-hours">
                                    <i class="fas fa-clock"></i>
                                    14 Hours                                </span>
                            </div>
                            <div class="cat-course-desc related">
                                <div role="definition" class="elipsis e4" style="margin:1rem 0.15rem; min-height:5.4rem">
                                    <h3>The course answers questions</h3>

<p>How to build a query?</p>

<p>What possibilities have SQL?</p>

<p>What is a relational database?</p>

<p>What is the structure and SQL commands</p>
                                </div>
                                <div class='hover-text-underline' style='color:var(--bs-link-color);'> Read more...</div>
                            </div>
                        </div>
                    </a>
                </div>
                        <div class="col-sm-12 col-lg-4 mb-4" onclick="location.href='/en/cc/3119';" style="cursor: pointer;">
                    <a class='hover-text-no-underline' href="/en/cc/3119" >
                        <div class="outline-course-box">
                            <h2 class="elipsis"><div class='text-black hover-text-underline'>Business Intelligence in MS SQL Server 2008</div></h2>
                            <div class="course-outline-adds">
                                <span class="course-outline-hours">
                                    <i class="fas fa-clock"></i>
                                    14 Hours                                </span>
                            </div>
                            <div class="cat-course-desc related">
                                <div role="definition" class="elipsis e4" style="margin:1rem 0.15rem; min-height:5.4rem">
                                    <p>Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008.</p>

<p>Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008.</p>

<p>Gain knowledge of how to build a simple ETL process based on the SSIS and then design and implement a data cube using SSAS.</p>

<p>The participant will be able to manage OLAP database: create and delete database OLAP Processing a partition changes on-line.</p>

<p>The participant will acquire knowledge of scripting XML / A and MDX.</p>
                                </div>
                                <div class='hover-text-underline' style='color:var(--bs-link-color);'> Read more...</div>
                            </div>
                        </div>
                    </a>
                </div>
                        <div class="col-sm-12 col-lg-4 mb-4" onclick="location.href='/en/cc/3308';" style="cursor: pointer;">
                    <a class='hover-text-no-underline' href="/en/cc/3308" >
                        <div class="outline-course-box">
                            <h2 class="elipsis"><div class='text-black hover-text-underline'>Oracle 11g - SQL language for administrators - workshops</div></h2>
                            <div class="course-outline-adds">
                                <span class="course-outline-hours">
                                    <i class="fas fa-clock"></i>
                                    21 Hours                                </span>
                            </div>
                            <div class="cat-course-desc related">
                                <div role="definition" class="elipsis e4" style="margin:1rem 0.15rem; min-height:5.4rem">
                                    <h3>For who</h3>

<p>The workshop is intended for beginners, starting to work with the Oracle database, future administrators and users of systems based on this database need able to use the SQL language for the extraction and modification of the information contained in the systems.</p>

<h3>Exams and Certificates</h3>

<p>The training plan coincides with the material required to pass the exam: 1Z0-051 Oracle Database 11g: SQL Fundamentals I, the first step to getting most certifications Oracle&#39;s Database</p>

<h3>Purpose of training</h3>

<p>The workshop aims to introduce participants to work with the Oracle database, making them familiar with the SQL language to the extent required for the efficient operation of the system and to take in the future obligations of database applications and Oracle databases.</p>

<h3>The content of the training</h3>

<ul>
	<li>The organization of the working environment</li>
	<li>Introduction to relational databases</li>
	<li>Extraction of the data using the SELECT statement</li>
	<li>Modifying data using INSERT, UPDATE, DELETE</li>
	<li>Overview of schema objects</li>
</ul>

<h3>Remarks</h3>

<p>The workshops are based on 11g XE software</p>
                                </div>
                                <div class='hover-text-underline' style='color:var(--bs-link-color);'> Read more...</div>
                            </div>
                        </div>
                    </a>
                </div>
                        <div class="col-sm-12 col-lg-4 mb-4" onclick="location.href='/en/cc/3358';" style="cursor: pointer;">
                    <a class='hover-text-no-underline' href="/en/cc/3358" >
                        <div class="outline-course-box">
                            <h2 class="elipsis"><div class='text-black hover-text-underline'>Oracle 11g - SQL language for developers - Workshop</div></h2>
                            <div class="course-outline-adds">
                                <span class="course-outline-hours">
                                    <i class="fas fa-clock"></i>
                                    35 Hours                                </span>
                            </div>
                            <div class="cat-course-desc related">
                                <div role="definition" class="elipsis e4" style="margin:1rem 0.15rem; min-height:5.4rem">
                                    <h3>For who</h3>

<p>Workshops are dedicated as a first step for developers and designers of applications based on Oracle databases. Participants do not need to have any prior knowledge of the Oracle database, or other relational database systems, even though such knowledge may be useful.</p>

<h3>Exams and Certificates</h3>

<p>The plan covers the training material required to pass the exam 1Z0-047 Oracle Database SQL Expert and obtain the title of Oracle Database SQL Certified Expert</p>

<h3>Purpose of training</h3>

<p>The workshop aims to familiarize participants with the Oracle database techniques to build database structures and data manipulation. Particular emphasis is placed on the participant to see across the board, which offers opportunities to design and build applications Relational Database Management System, Oracle Database, and to be able to independently work with her.</p>

<h3>The content of the training</h3>

<ul>
	<li>Introduction to database technology and the organization of the work environment</li>
	<li>Acquisition and modification of data</li>
	<li>Construction of the repository application</li>
	<li>Safety and concurrency runtime</li>
</ul>

<h3>Notes</h3>

<p>The workshops are based on the software version 11g XE</p>
                                </div>
                                <div class='hover-text-underline' style='color:var(--bs-link-color);'> Read more...</div>
                            </div>
                        </div>
                    </a>
                </div>
                        <div class="col-sm-12 col-lg-4 mb-4" onclick="location.href='/en/cc/3410';" style="cursor: pointer;">
                    <a class='hover-text-no-underline' href="/en/cc/3410" >
                        <div class="outline-course-box">
                            <h2 class="elipsis"><div class='text-black hover-text-underline'>Oracle 11g - Programming with PL / SQL I - Workshops</div></h2>
                            <div class="course-outline-adds">
                                <span class="course-outline-hours">
                                    <i class="fas fa-clock"></i>
                                    28 Hours                                </span>
                            </div>
                            <div class="cat-course-desc related">
                                <div role="definition" class="elipsis e4" style="margin:1rem 0.15rem; min-height:5.4rem">
                                    <h3>For who</h3>

<p>Workshops are dedicated to developers, end users and administrators, who until now have had no contact with the language PL / SQL, and the need to exploit its huge potential in working with a database, automate processes, and in building applications</p>

<h3>Exams and Certificates</h3>

<p>The plan covers the training material required to pass the exam 1Z0-144 Oracle Database 11g Program with PL / SQL and obtain the title of Oracle PL / SQL Developer Certified Associate</p>

<h3>Purpose of training</h3>

<p>The workshop aims to familiarize participants with the programming language PL / SQL, its capabilities and limitations. This workshop will include a full understanding of the mechanisms involved in the programming language PL / SQL needed to implement the logic of the free applications, automation of data processing and database management.</p>

<h3>The content of the training</h3>

<ul>
	<li>Introduction to PL / SQL architecture solutions based on this language, the organization of the working environment</li>
	<li>Create scripts and stored program units that operate on data</li>
</ul>

<h3>Notes</h3>

<p>The workshops are based on the software version 11g XE</p>
                                </div>
                                <div class='hover-text-underline' style='color:var(--bs-link-color);'> Read more...</div>
                            </div>
                        </div>
                    </a>
                </div>
                        <div class="col-sm-12 col-lg-4 mb-4" onclick="location.href='/en/cc/3419';" style="cursor: pointer;">
                    <a class='hover-text-no-underline' href="/en/cc/3419" >
                        <div class="outline-course-box">
                            <h2 class="elipsis"><div class='text-black hover-text-underline'>Oracle 11g - Programming with PL / SQL II</div></h2>
                            <div class="course-outline-adds">
                                <span class="course-outline-hours">
                                    <i class="fas fa-clock"></i>
                                    21 Hours                                </span>
                            </div>
                            <div class="cat-course-desc related">
                                <div role="definition" class="elipsis e4" style="margin:1rem 0.15rem; min-height:5.4rem">
                                    <h3>For who</h3>

<p>This training is in addition to, and continuation of the &#39;Oracle 11g - Programming in PL / SQL and - workshops &quot;, but can also be designed for practitioners, developers, PL / SQL who already have experience with the language, and who want to systematize their knowledge and learn advanced mechanisms and solutions developed in this language.</p>

<h3>The content of the training</h3>

<ul>
	<li>Objects, streams and complex data structures</li>
	<li>Advanced solutions based on PL / SQL</li>
</ul>

<h3>Exams and Certificates</h3>

<p>The plan covers the training material required to pass the exam 1Z0-146 Oracle Advanced PL / SQL and obtain the title of Oracle Advanced PL / SQL Developer Certified Professional</p>

<h3>Purpose of training</h3>

<p>The training is designed to familiarize participants with the advanced aspects of programming in an Oracle database. The emphasis is on flexibility and performance solutions based on PL / SQL.</p>

<h3>Notes</h3>

<p>The workshops are based on the software version 11g XE</p>
                                </div>
                                <div class='hover-text-underline' style='color:var(--bs-link-color);'> Read more...</div>
                            </div>
                        </div>
                    </a>
                </div>
                        <div class="col-sm-12 col-lg-4 mb-4" onclick="location.href='/en/cc/advsqlpt';" style="cursor: pointer;">
                    <a class='hover-text-no-underline' href="/en/cc/advsqlpt" >
                        <div class="outline-course-box">
                            <h2 class="elipsis"><div class='text-black hover-text-underline'>Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server</div></h2>
                            <div class="course-outline-adds">
                                <span class="course-outline-hours">
                                    <i class="fas fa-clock"></i>
                                    14 Hours                                </span>
                            </div>
                            <div class="cat-course-desc related">
                                <div role="definition" class="elipsis e4" style="margin:1rem 0.15rem; min-height:5.4rem">
                                    <p>The aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL. For more in depth coverage of the topics this course can be run as a three day course.</p>
                                </div>
                                <div class='hover-text-underline' style='color:var(--bs-link-color);'> Read more...</div>
                            </div>
                        </div>
                    </a>
                </div>
                        <div class="col-sm-12 col-lg-4 mb-4" onclick="location.href='/en/cc/analyticfunctions';" style="cursor: pointer;">
                    <a class='hover-text-no-underline' href="/en/cc/analyticfunctions" >
                        <div class="outline-course-box">
                            <h2 class="elipsis"><div class='text-black hover-text-underline'>Analytic Functions Fundamentals</div></h2>
                            <div class="course-outline-adds">
                                <span class="course-outline-hours">
                                    <i class="fas fa-clock"></i>
                                    21 Hours                                </span>
                            </div>
                            <div class="cat-course-desc related">
                                <div role="definition" class="elipsis e4" style="margin:1rem 0.15rem; min-height:5.4rem">
                                    <p>This instructor-led, live training in Costa Rica (online or onsite) is aimed at intermediate-level database administrators, SQL developers, and data analysts who wish to enhance their SQL skills by mastering the use of Analytic Functions.</p>

<p>By the end of this training, participants will be able to:</p>

<ul>
	<li>Understand the concept and importance of Analytic Functions.</li>
	<li>Apply various Analytic Functions to solve complex analytical problems.</li>
	<li>Combine Analytic Functions with other SQL features for comprehensive data analysis.</li>
	<li>Optimize queries for better performance using Analytic Functions.</li>
</ul>
                                </div>
                                <div class='hover-text-underline' style='color:var(--bs-link-color);'> Read more...</div>
                            </div>
                        </div>
                    </a>
                </div>
                        <div class="col-sm-12 col-lg-4 mb-4" onclick="location.href='/en/cc/bespokesql2';" style="cursor: pointer;">
                    <a class='hover-text-no-underline' href="/en/cc/bespokesql2" >
                        <div class="outline-course-box">
                            <h2 class="elipsis"><div class='text-black hover-text-underline'>SQL DATABASE MANAGEMENT AND DESIGN - Bespoke</div></h2>
                            <div class="course-outline-adds">
                                <span class="course-outline-hours">
                                    <i class="fas fa-clock"></i>
                                    14 Hours                                </span>
                            </div>
                            <div class="cat-course-desc related">
                                <div role="definition" class="elipsis e4" style="margin:1rem 0.15rem; min-height:5.4rem">
                                    <p><strong>Format of the Course</strong></p>

<ul>
	<li>Interactive lecture and discussion.</li>
	<li>Lots of exercises and practice.</li>
	<li>Hands-on implementation in a live-lab environment.</li>
</ul>
                                </div>
                                <div class='hover-text-underline' style='color:var(--bs-link-color);'> Read more...</div>
                            </div>
                        </div>
                    </a>
                </div>
                        <div class="col-sm-12 col-lg-4 mb-4" onclick="location.href='/en/cc/datastorageoverview';" style="cursor: pointer;">
                    <a class='hover-text-no-underline' href="/en/cc/datastorageoverview" >
                        <div class="outline-course-box">
                            <h2 class="elipsis"><div class='text-black hover-text-underline'>Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems</div></h2>
                            <div class="course-outline-adds">
                                <span class="course-outline-hours">
                                    <i class="fas fa-clock"></i>
                                    7 Hours                                </span>
                            </div>
                            <div class="cat-course-desc related">
                                <div role="definition" class="elipsis e4" style="margin:1rem 0.15rem; min-height:5.4rem">
                                    <p>This course helps customer to chose the write data storage depend on their needs. It covers almost all possible modern approaches.</p>
                                </div>
                                <div class='hover-text-underline' style='color:var(--bs-link-color);'> Read more...</div>
                            </div>
                        </div>
                    </a>
                </div>
                        <div class="col-sm-12 col-lg-4 mb-4" onclick="location.href='/en/cc/ddavsvbsqls';" style="cursor: pointer;">
                    <a class='hover-text-no-underline' href="/en/cc/ddavsvbsqls" >
                        <div class="outline-course-box">
                            <h2 class="elipsis"><div class='text-black hover-text-underline'>Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012</div></h2>
                            <div class="course-outline-adds">
                                <span class="course-outline-hours">
                                    <i class="fas fa-clock"></i>
                                    21 Hours                                </span>
                            </div>
                            <div class="cat-course-desc related">
                                <div role="definition" class="elipsis e4" style="margin:1rem 0.15rem; min-height:5.4rem">
                                    <p>This course is divided into 3 main sections and is made up of a mixture of presentations and practical exercises.</p>

<ol>
	<li>VB.NET Language in Visual Studio 2012</li>
	<li>VB.NET Object Orientation</li>
	<li>VB.NET and Sql Server 2012</li>
</ol>
                                </div>
                                <div class='hover-text-underline' style='color:var(--bs-link-color);'> Read more...</div>
                            </div>
                        </div>
                    </a>
                </div>
                        <div class="col-sm-12 col-lg-4 mb-4" onclick="location.href='/en/cc/oplsqlfun';" style="cursor: pointer;">
                    <a class='hover-text-no-underline' href="/en/cc/oplsqlfun" >
                        <div class="outline-course-box">
                            <h2 class="elipsis"><div class='text-black hover-text-underline'>ORACLE PL/SQL Fundamentals</div></h2>
                            <div class="course-outline-adds">
                                <span class="course-outline-hours">
                                    <i class="fas fa-clock"></i>
                                    21 Hours                                </span>
                            </div>
                            <div class="cat-course-desc related">
                                <div role="definition" class="elipsis e4" style="margin:1rem 0.15rem; min-height:5.4rem">
                                    <p>This 3 day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/SQL commands.</p>

<p>The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.</p>

<p>Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.</p>
                                </div>
                                <div class='hover-text-underline' style='color:var(--bs-link-color);'> Read more...</div>
                            </div>
                        </div>
                    </a>
                </div>
                        <div class="col-sm-12 col-lg-4 mb-4" onclick="location.href='/en/cc/osqladv';" style="cursor: pointer;">
                    <a class='hover-text-no-underline' href="/en/cc/osqladv" >
                        <div class="outline-course-box">
                            <h2 class="elipsis"><div class='text-black hover-text-underline'>Oracle SQL Advanced</div></h2>
                            <div class="course-outline-adds">
                                <span class="course-outline-hours">
                                    <i class="fas fa-clock"></i>
                                    14 Hours                                </span>
                            </div>
                            <div class="cat-course-desc related">
                                <div role="definition" class="elipsis e4" style="margin:1rem 0.15rem; min-height:5.4rem">
                                    <h3>Listeners</h3>

<p>This course is designed for people who want to use the advanced features of SQL in Oracle</p>

<h3>The course answers the questions</h3>

<ul>
	<li>How to build advanced queries?</li>
	<li>How to create advanced reports?</li>
</ul>
                                </div>
                                <div class='hover-text-underline' style='color:var(--bs-link-color);'> Read more...</div>
                            </div>
                        </div>
                    </a>
                </div>
                        <div class="col-sm-12 col-lg-4 mb-4" onclick="location.href='/en/cc/osqlbgn';" style="cursor: pointer;">
                    <a class='hover-text-no-underline' href="/en/cc/osqlbgn" >
                        <div class="outline-course-box">
                            <h2 class="elipsis"><div class='text-black hover-text-underline'>Oracle SQL for beginners</div></h2>
                            <div class="course-outline-adds">
                                <span class="course-outline-hours">
                                    <i class="fas fa-clock"></i>
                                    21 Hours                                </span>
                            </div>
                            <div class="cat-course-desc related">
                                <div role="definition" class="elipsis e4" style="margin:1rem 0.15rem; min-height:5.4rem">
                                    <h3>Listeners</h3>

<p>This training is addressed for people starting to work with the SQL language in Oracle database</p>

<h3>The course answer for questions:</h3>

<ul>
	<li>How to build a query?</li>
	<li>What possibilities have SQL?</li>
	<li>What is a relational database?</li>
	<li>What is the structure and SQL commands</li>
</ul>
                                </div>
                                <div class='hover-text-underline' style='color:var(--bs-link-color);'> Read more...</div>
                            </div>
                        </div>
                    </a>
                </div>
                        <div class="col-sm-12 col-lg-4 mb-4" onclick="location.href='/en/cc/osqldevdm';" style="cursor: pointer;">
                    <a class='hover-text-no-underline' href="/en/cc/osqldevdm" >
                        <div class="outline-course-box">
                            <h2 class="elipsis"><div class='text-black hover-text-underline'>Oracle SQL for development and database management</div></h2>
                            <div class="course-outline-adds">
                                <span class="course-outline-hours">
                                    <i class="fas fa-clock"></i>
                                    35 Hours                                </span>
                            </div>
                            <div class="cat-course-desc related">
                                <div role="definition" class="elipsis e4" style="margin:1rem 0.15rem; min-height:5.4rem">
                                    <p>This 5-day course demonstrates how to use Oracle SQL for database development and database management.</p>
                                </div>
                                <div class='hover-text-underline' style='color:var(--bs-link-color);'> Read more...</div>
                            </div>
                        </div>
                    </a>
                </div>
            </div>
</div>    </div>
</div>

    <div class='container mt-4'>
        <div class="row">
            <div class="col-sm-12">
                <h3 class="mt-1" id="course-comments-content">
                    Related Categories                </h3>
            </div>
        </div>
        <div class="row">
            <div class="row">
                
                    <div class="col-xxl-2 col-md-3 col-6 category-linkbox">
                        <a class="card card-body upcoming-card" href="/en/sql-training">
                            <img loading="lazy" src="/sites/hitrahr/files/category_images/height35_scale/sql_training.png?t=d5eca0f1" alt="Image for SQL category" title="SQL" style="height:80px" />                            <h6 class="mt-2">SQL</h6>
                        </a>
                    </div>

                            </div>
        </div>
    </div>


<!-- Public Course Discounts -->
<!-- <div class="container"> -->
    <!-- </div><br> -->
<!-- NP_PAGE_TYPE: page-cc -->    </main>

    <!-- isl for category -->
            <div id="isl-domain-switch" class="isl container nav-hide">
    <div class='d-flex align-items-center mb-2 mt-4 justify-content-between'>
        <h2 class="block-title my-0">This site in other countries/regions</h2>
        <div class='d-flex justify-content-center align-items-center'>
            <button type="button" class="btn-close p-0" onclick="isl_switch('isl-domain-switch')"></button>
        </div>
    </div>
        <div>
        <input type="radio" name="sections" style="display:none" id="Europe" >
        <article>
            <div class="row">
                <div class="col-sm-12">
                    <h3 class="mt-4 mb-2">Europe</h3>
                </div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.at'>Österreich (Austria)</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.ch'>Schweiz (Switzerland)</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.de'>Deutschland (Germany)</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.cz'>Czech Republic</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.dk'>Denmark</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.ee'>Estonia</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.fi'>Finland</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.gr'>Greece</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.hu'>Magyarország (Hungary)</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.ie'>Ireland</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.lu'>Luxembourg</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.lv'>Latvia</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.es'>España (Spain)</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.it'>Italia (Italy)</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.lt'>Lithuania</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.nl'>Nederland (Netherlands)</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.co.no'>Norway</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.pt'>Portugal</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.ro'>România (Romania)</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.se'>Sverige (Sweden)</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.tr'>Turkey</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.mt'>Malta</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.be'>Belgique (Belgium)</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.fr'>France</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.pl'>Polska (Poland)</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.co.uk'>United Kingdom</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.bg'>Bulgaria</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.md'>Moldova</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.sk'>Slovakia</a></div>
                            </div>
        </article>
    </div>
        <div>
        <input type="radio" name="sections" style="display:none" id="Asia" >
        <article>
            <div class="row">
                <div class="col-sm-12">
                    <h3 class="mt-4 mb-2">Asia Pacific</h3>
                </div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.cn'>中国 (China)</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a class="isl-indent" href='https://www.nobleprog.hk'>香港 (Hong Kong)</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a class="isl-indent" href='https://www.nobleprog.mo'>澳門 (Macao)</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a class="isl-indent" href='https://www.nobleprog.tw'>台灣 (Taiwan)</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.co.jp'>日本 (Japan)</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.au'>Australia</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.my'>Malaysia</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.co.nz'>New Zealand</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.ph'>Philippines</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.sg'>Singapore</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.co.th'>Thailand</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.vn'>Vietnam</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.in'>India</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.co.kr'>South Korea</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.pk'>Pakistan</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.lk'>Sri Lanka</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.id'>Indonesia</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog-kz.com'>Kazakhstan</a></div>
                            </div>
        </article>
    </div>
        <div>
        <input type="radio" name="sections" style="display:none" id="North"  checked>
        <article>
            <div class="row">
                <div class="col-sm-12">
                    <h3 class="mt-4 mb-2">North America</h3>
                </div>
                                <div class="col-sm-3 mt-1 mb-1"><a id="current-site" disabled href='/'>Costa Rica</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.ca'>Canada</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com'>USA</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.gt'>Guatemala</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.mx'>México (Mexico)</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.pa'>Panama</a></div>
                            </div>
        </article>
    </div>
        <div>
        <input type="radio" name="sections" style="display:none" id="South" >
        <article>
            <div class="row">
                <div class="col-sm-12">
                    <h3 class="mt-4 mb-2">South America</h3>
                </div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.br'>Brasil (Brazil)</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.ar'>Argentina</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.cl'>Chile</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.ec'>Ecuador</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.co'>Colombia</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.pe'>Peru</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.uy'>Uruguay</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.ve'>Venezuela</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.bo'>Bolivia</a></div>
                            </div>
        </article>
    </div>
        <div>
        <input type="radio" name="sections" style="display:none" id="Africa" >
        <article>
            <div class="row">
                <div class="col-sm-12">
                    <h3 class="mt-4 mb-2">Africa / Middle East</h3>
                </div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.ae'>United Arab Emirates</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.qa'>Qatar</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.eg'>Egypt</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog-ksa.com'>Saudi Arabia</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.co.za'>South Africa</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.co.il'>Israel</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.co.ma'>Morocco</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.tn'>Tunisia</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog-kw.com'>Kuwait</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog-om.com'>Oman</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.co.ke'>Kenya</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.com.ng'>Nigeria</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.nobleprog.co.bw'>Botswana</a></div>
                            </div>
        </article>
    </div>
        <div>
        <input type="radio" name="sections" style="display:none" id="Other" >
        <article>
            <div class="row">
                <div class="col-sm-12">
                    <h3 class="mt-4 mb-2">Other sites</h3>
                </div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://hr.nobleprog.com'>Human Resources</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://training-course-material.com/training/Main_Page'>Training Materials</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://training-franchise.com'>NobleProg Franchise</a></div>
                                <div class="col-sm-3 mt-1 mb-1"><a href='https://www.dadesktop.com/'>DaDesktop - Cloud Desktop</a></div>
                            </div>
        </article>
    </div>
    </div>    
    <!-- FOOTER -->
    <footer class="footer">
    <!-- Footer Nav -->
    <div class="container footer-navs">
        <div class="row">
            <div class="col-md-3">
    <p>Training Courses</p>
    <ul class="list-group">
                    <li class="list-group-item"><a href="/en/training">Catalogue</a></li>
                    <li class="list-group-item"><a href="/en/course-discounts">Promotions</a></li>
                    <li class="list-group-item"><a href="/en/training-methods">Training Methods</a></li>
                    <li class="list-group-item"><a href="/en/resources/articles">Articles</a></li>
                    <li class="list-group-item"><a href="/en/resources/webinars">Webinar</a></li>
            </ul>
</div><div class="col-md-3">
    <p>Consultancy</p>
    <ul class="list-group">
                    <li class="list-group-item"><a href="/en/consultancy">Our Approach</a></li>
                    <li class="list-group-item"><a href="/en/case-studies">Case Studies</a></li>
                    <li class="list-group-item"><a href="/en/enquiry?type=consultancy">Consultancy Enquiry</a></li>
                    <li class="list-group-item"><a href="/en/consultancy-catalogue">Consultancy Catalogue</a></li>
            </ul>
</div><div class="col-md-3">
    <p>Services</p>
    <ul class="list-group">
                    <li class="list-group-item"><a href="/en/digital-transformation">Digital Transformation</a></li>
                    <li class="list-group-item"><a href="/en/data-management">Data Management</a></li>
                    <li class="list-group-item"><a href="/en/managed-training-services">Managed Training Service</a></li>
                    <li class="list-group-item"><a href="/en/instructor-led-online-training-courses">Training Delivery Platform</a></li>
                    <li class="list-group-item"><a href="/en/corporate-learning-solutions">Learning Pathways</a></li>
            </ul>
</div><div class="col-md-3">
    <p>About Us</p>
    <ul class="list-group">
                    <li class="list-group-item"><a href="/en/about-us">About Us</a></li>
                    <li class="list-group-item"><a href="/en/contact-us">Contact Us</a></li>
                    <li class="list-group-item"><a href="/en/certifications">Partners</a></li>
                    <li class="list-group-item"><a href="/en/clients-and-references">Clients</a></li>
                    <li class="list-group-item"><a href="/en/testimonials">Testimonials</a></li>
                    <li class="list-group-item"><a href="/en/careers">Careers</a></li>
                    <li class="list-group-item"><a href="/en/faqs">FAQ</a></li>
                    <li class="list-group-item"><a href="/en/terms-and-conditions">T&C</a></li>
            </ul>
</div>        </div>
        <hr>
    </div>

    <!-- Footer Icons -->
    <div class="container ">
                <div class="row">
    <div class="col-md-3 pt-2 footer-icon" style='box-sizing:border-box'>
        <div>
            <p class='footer-trade' style='font-size:0.9rem' id='footer-sales-area-email'></p>
            <p class='footer-trade' style='font-size:0.9rem' id='footer-sales-area-phone'></p>
            <a class='d-inline-block px-0 py-0' style='font-size:0.9rem; color:#212529' href="#firstfocus" onclick="isl_switch('isl-domain-switch')">
                <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16">
                    <path id="globe2" d="M0 8a8 8 0 1 1 16 0A8 8 0 0 1 0 8zm7.5-6.923c-.67.204-1.335.82-1.887 1.855-.143.268-.276.56-.395.872.705.157 1.472.257 2.282.287V1.077zM4.249 3.539c.142-.384.304-.744.481-1.078a6.7 6.7 0 0 1 .597-.933A7.01 7.01 0 0 0 3.051 3.05c.362.184.763.349 1.198.49zM3.509 7.5c.036-1.07.188-2.087.436-3.008a9.124 9.124 0 0 1-1.565-.667A6.964 6.964 0 0 0 1.018 7.5h2.49zm1.4-2.741a12.344 12.344 0 0 0-.4 2.741H7.5V5.091c-.91-.03-1.783-.145-2.591-.332zM8.5 5.09V7.5h2.99a12.342 12.342 0 0 0-.399-2.741c-.808.187-1.681.301-2.591.332zM4.51 8.5c.035.987.176 1.914.399 2.741A13.612 13.612 0 0 1 7.5 10.91V8.5H4.51zm3.99 0v2.409c.91.03 1.783.145 2.591.332.223-.827.364-1.754.4-2.741H8.5zm-3.282 3.696c.12.312.252.604.395.872.552 1.035 1.218 1.65 1.887 1.855V11.91c-.81.03-1.577.13-2.282.287zm.11 2.276a6.696 6.696 0 0 1-.598-.933 8.853 8.853 0 0 1-.481-1.079 8.38 8.38 0 0 0-1.198.49 7.01 7.01 0 0 0 2.276 1.522zm-1.383-2.964A13.36 13.36 0 0 1 3.508 8.5h-2.49a6.963 6.963 0 0 0 1.362 3.675c.47-.258.995-.482 1.565-.667zm6.728 2.964a7.009 7.009 0 0 0 2.275-1.521 8.376 8.376 0 0 0-1.197-.49 8.853 8.853 0 0 1-.481 1.078 6.688 6.688 0 0 1-.597.933zM8.5 11.909v3.014c.67-.204 1.335-.82 1.887-1.855.143-.268.276-.56.395-.872A12.63 12.63 0 0 0 8.5 11.91zm3.555-.401c.57.185 1.095.409 1.565.667A6.963 6.963 0 0 0 14.982 8.5h-2.49a13.36 13.36 0 0 1-.437 3.008zM14.982 7.5a6.963 6.963 0 0 0-1.362-3.675c-.47.258-.995.482-1.565.667.248.92.4 1.938.437 3.008h2.49zM11.27 2.461c.177.334.339.694.482 1.078a8.368 8.368 0 0 0 1.196-.49 7.01 7.01 0 0 0-2.275-1.52c.218.283.418.597.597.932zm-.488 1.343a7.765 7.765 0 0 0-.395-.872C9.835 1.897 9.17 1.282 8.5 1.077V4.09c.81-.03 1.577-.13 2.282-.287z" />
                </svg>
                &nbsp;
                <span class='footer-trade d-inline' style='font-size:inherit'>Costa Rica</span>
            </a>
        </div>
    </div>
    <div class="col-md-6 pt-2">
        <p class="footer-trade" style='font-size:0.9rem'>NobleProg® Limited 2004 - <span id="current_year"></span> All Rights Reserved</p>
        <p class="footer-trade" style='font-size:0.9rem'>NobleProg® is a registered trade mark of NobleProg Limited and/or its affiliates.</p>
        <script async>
            d = new Date();
            year = d.getFullYear();
            document.getElementById("current_year").innerHTML = year;
        </script>
    </div>
    <div class="col-md-3 pt-2">
        <ul class="list-inline">
            
                <li class="list-inline-item">
                    <a href="https://www.linkedin.com/company/nobleprog-canada" target="_blank" aria-label="go to NobleProg LinkedIn">
                        <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" fill="black" viewBox="0 0 16 16"><path d="M0 1.146C0 .513.526 0 1.175 0h13.65C15.474 0 16 .513 16 1.146v13.708c0 .633-.526 1.146-1.175 1.146H1.175C.526 16 0 15.487 0 14.854V1.146zm4.943 12.248V6.169H2.542v7.225h2.401zm-1.2-8.212c.837 0 1.358-.554 1.358-1.248-.015-.709-.52-1.248-1.342-1.248-.822 0-1.359.54-1.359 1.248 0 .694.521 1.248 1.327 1.248h.016zm4.908 8.212V9.359c0-.216.016-.432.08-.586.173-.431.568-.878 1.232-.878.869 0 1.216.662 1.216 1.634v3.865h2.401V9.25c0-2.22-1.184-3.252-2.764-3.252-1.274 0-1.845.7-2.165 1.193v.025h-.016a5.54 5.54 0 0 1 .016-.025V6.169h-2.4c.03.678 0 7.225 0 7.225h2.4z"/></svg>                    </a>
                </li>

            
                <li class="list-inline-item">
                    <a href="https://twitter.com/NobleProgCA" target="_blank" aria-label="go to NobleProg Twitter">
                        <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" fill="black" viewBox="0 0 16 16"><path d="M5.026 15c6.038 0 9.341-5.003 9.341-9.334 0-.14 0-.282-.006-.422A6.685 6.685 0 0 0 16 3.542a6.658 6.658 0 0 1-1.889.518 3.301 3.301 0 0 0 1.447-1.817 6.533 6.533 0 0 1-2.087.793A3.286 3.286 0 0 0 7.875 6.03a9.325 9.325 0 0 1-6.767-3.429 3.289 3.289 0 0 0 1.018 4.382A3.323 3.323 0 0 1 .64 6.575v.045a3.288 3.288 0 0 0 2.632 3.218 3.203 3.203 0 0 1-.865.115 3.23 3.23 0 0 1-.614-.057 3.283 3.283 0 0 0 3.067 2.277A6.588 6.588 0 0 1 .78 13.58a6.32 6.32 0 0 1-.78-.045A9.344 9.344 0 0 0 5.026 15z"/></svg>                    </a>
                </li>

            
                <li class="list-inline-item">
                    <a href="https://www.facebook.com/NobleProgCA" target="_blank" aria-label="go to NobleProg Facebook">
                        <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" fill="black" viewBox="0 0 16 16"><path d="M16 8.049c0-4.446-3.582-8.05-8-8.05C3.58 0-.002 3.603-.002 8.05c0 4.017 2.926 7.347 6.75 7.951v-5.625h-2.03V8.05H6.75V6.275c0-2.017 1.195-3.131 3.022-3.131.876 0 1.791.157 1.791.157v1.98h-1.009c-.993 0-1.303.621-1.303 1.258v1.51h2.218l-.354 2.326H9.25V16c3.824-.604 6.75-3.934 6.75-7.951z"/></svg>                    </a>
                </li>

            
                <li class="list-inline-item">
                    <a href="https://www.instagram.com/nobleprogcanada/" target="_blank" aria-label="go to NobleProg Instagram">
                        <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" fill="black" viewBox="0 0 16 16"><path d="M8 0C5.829 0 5.556.01 4.703.048 3.85.088 3.269.222 2.76.42a3.917 3.917 0 0 0-1.417.923A3.927 3.927 0 0 0 .42 2.76C.222 3.268.087 3.85.048 4.7.01 5.555 0 5.827 0 8.001c0 2.172.01 2.444.048 3.297.04.852.174 1.433.372 1.942.205.526.478.972.923 1.417.444.445.89.719 1.416.923.51.198 1.09.333 1.942.372C5.555 15.99 5.827 16 8 16s2.444-.01 3.298-.048c.851-.04 1.434-.174 1.943-.372a3.916 3.916 0 0 0 1.416-.923c.445-.445.718-.891.923-1.417.197-.509.332-1.09.372-1.942C15.99 10.445 16 10.173 16 8s-.01-2.445-.048-3.299c-.04-.851-.175-1.433-.372-1.941a3.926 3.926 0 0 0-.923-1.417A3.911 3.911 0 0 0 13.24.42c-.51-.198-1.092-.333-1.943-.372C10.443.01 10.172 0 7.998 0h.003zm-.717 1.442h.718c2.136 0 2.389.007 3.232.046.78.035 1.204.166 1.486.275.373.145.64.319.92.599.28.28.453.546.598.92.11.281.24.705.275 1.485.039.843.047 1.096.047 3.231s-.008 2.389-.047 3.232c-.035.78-.166 1.203-.275 1.485a2.47 2.47 0 0 1-.599.919c-.28.28-.546.453-.92.598-.28.11-.704.24-1.485.276-.843.038-1.096.047-3.232.047s-2.39-.009-3.233-.047c-.78-.036-1.203-.166-1.485-.276a2.478 2.478 0 0 1-.92-.598 2.48 2.48 0 0 1-.6-.92c-.109-.281-.24-.705-.275-1.485-.038-.843-.046-1.096-.046-3.233 0-2.136.008-2.388.046-3.231.036-.78.166-1.204.276-1.486.145-.373.319-.64.599-.92.28-.28.546-.453.92-.598.282-.11.705-.24 1.485-.276.738-.034 1.024-.044 2.515-.045v.002zm4.988 1.328a.96.96 0 1 0 0 1.92.96.96 0 0 0 0-1.92zm-4.27 1.122a4.109 4.109 0 1 0 0 8.217 4.109 4.109 0 0 0 0-8.217zm0 1.441a2.667 2.667 0 1 1 0 5.334 2.667 2.667 0 0 1 0-5.334z"/></svg>                    </a>
                </li>

            
                <li class="list-inline-item">
                    <a href="https://www.youtube.com/@nobleprogcanada1684" target="_blank" aria-label="go to NobleProg YouTube">
                        <svg xmlns="http://www.w3.org/2000/svg" width="28" height="28" fill="black" viewBox="0 0 16 16"><path d="M8.051 1.999h.089c.822.003 4.987.033 6.11.335a2.01 2.01 0 0 1 1.415 1.42c.101.38.172.883.22 1.402l.01.104.022.26.008.104c.065.914.073 1.77.074 1.957v.075c-.001.194-.01 1.108-.082 2.06l-.008.105-.009.104c-.05.572-.124 1.14-.235 1.558a2.007 2.007 0 0 1-1.415 1.42c-1.16.312-5.569.334-6.18.335h-.142c-.309 0-1.587-.006-2.927-.052l-.17-.006-.087-.004-.171-.007-.171-.007c-1.11-.049-2.167-.128-2.654-.26a2.007 2.007 0 0 1-1.415-1.419c-.111-.417-.185-.986-.235-1.558L.09 9.82l-.008-.104A31.4 31.4 0 0 1 0 7.68v-.123c.002-.215.01-.958.064-1.778l.007-.103.003-.052.008-.104.022-.26.01-.104c.048-.519.119-1.023.22-1.402a2.007 2.007 0 0 1 1.415-1.42c.487-.13 1.544-.21 2.654-.26l.17-.007.172-.006.086-.003.171-.007A99.788 99.788 0 0 1 7.858 2h.193zM6.4 5.209v4.818l4.157-2.408L6.4 5.209z"/></svg>                    </a>
                </li>

                    </ul>
    </div>
</div>
<div class='row mt-4'>
    <p class="footer-trade" style='font-size:0.9rem'>
        This site is operated by the NobleProg franchisor. If you interested in opening a franchise in your country, please visit <a href="https://training-franchise.com" style="color:#003765;" >https://training-franchise.com</a> for more information.    </p>
    <p class='d-flex justify-content-center' style='font-size:14px;'>
        <a href="/en/privacy-statement">
            Privacy & Cookies        </a>
    </p>
    <div id="sso-link" class="sso-link text-center"></div>
	<script>
		var a = document.createElement("a");
		var linkText = document.createTextNode("Staff login");
		a.appendChild(linkText);
		a.href = "/en/moLogin";
		a.style = "color:#6e6e6e;font-size:10px";
		a.rel = "nofollow";
		a.accessKey = "s";
		document.getElementById("sso-link").appendChild(a);
	</script> 
</div>


<script>
    function updateFooterContactInfo() {
        let contactInfo = localStorage.getItem('contact-info');
        contactInfo = JSON.parse(contactInfo);

        if (contactInfo == null) {
            return;
        }

        if (contactInfo['email']) document.getElementById('footer-sales-area-email').textContent = contactInfo['email'];
        if (contactInfo['phone']) document.getElementById('footer-sales-area-phone').textContent = contactInfo['phone'];


    }

    function addEventListenerForUpdateFooterContactInformation(){
        const target = document.getElementById("selected-email-anchor-text");
        updateFooterContactInfo();
        if (target) {
            const observer = new MutationObserver(updateFooterContactInfo);
            const config = { childList: true, subtree: true };
            observer.observe(target, config);
        }
    }

    addEventListenerForUpdateFooterContactInformation();
</script>    </div>
</footer>    <script>
            setLinksToDropDown('lang-switch-links', 'lang-switch-dropdown');
            setLinksToDropDown('cat-region-links', 'cat-region-dropdown');
            setLinksToDropDown('cat-region-2-links', 'cat-region-2-dropdown');
    </script>

</body>
</html> <!-- NP_PAGE_TYPE: page-cc -->