{"id":581,"date":"2021-10-22T17:42:50","date_gmt":"2021-10-22T15:42:50","guid":{"rendered":"https:\/\/www.akademia-umiejetnosci.ue.katowice.pl\/?page_id=581"},"modified":"2021-11-08T10:35:50","modified_gmt":"2021-11-08T09:35:50","slug":"raportowanie-w-systemie-impuls-evo","status":"publish","type":"page","link":"https:\/\/www.akademia-umiejetnosci.ue.katowice.pl\/index.php\/raportowanie-w-systemie-impuls-evo\/","title":{"rendered":"Samodzielne tworzenie raport\u00f3w na potrzeby firmy"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"581\" class=\"elementor elementor-581\" data-elementor-settings=\"[]\">\n\t\t\t\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ffcb0e6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ffcb0e6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bf59b03\" data-id=\"bf59b03\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-99005bb elementor-tabs-view-horizontal elementor-widget elementor-widget-tabs\" data-id=\"99005bb\" data-element_type=\"widget\" data-widget_type=\"tabs.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-tabs\">\n\t\t\t<div class=\"elementor-tabs-wrapper\" role=\"tablist\" >\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-1601\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"elementor-tab-content-1601\" aria-expanded=\"false\">Opis szkolenia<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-1602\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-1602\" aria-expanded=\"false\">Program szkolenia<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t<div class=\"elementor-tabs-content-wrapper\" role=\"tablist\" aria-orientation=\"vertical\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"elementor-tab-content-1601\" aria-expanded=\"false\">Opis szkolenia<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-1601\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-1601\" tabindex=\"0\" hidden=\"false\"><p><strong>Termin:<\/strong> 7-8.12.2021<br><strong>Miejsce:<\/strong>&nbsp;<a href=\"https:\/\/www.google.pl\/maps\/place\/Centrum+Nowoczesnych+Technologii+Informatycznych\/@50.2606246,19.043421,17z\/data=!3m1!4b1!4m5!3m4!1s0x4716cfcea6cfa6f1:0x333417018f914e11!8m2!3d50.2606246!4d19.0456097\" target=\"_blank\" rel=\"noreferrer noopener\">Uniwersytet Ekonomiczny w Katowicach, CNTI Sala: 2\/19<\/a><\/p>\n<p><strong>Czas trwania:<\/strong>&nbsp;2 dni<br><strong>Maksymalna liczba os\u00f3b w grupie:<\/strong>&nbsp;10 os\u00f3b<br><strong>Trener:<\/strong> 1 dzie\u0144 &#8211; Jacek Mielcarski, 2 dzie\u0144 &#8211; Tomasz Krzyszkowski<\/p><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-1602\" aria-expanded=\"false\">Program szkolenia<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-1602\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"2\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-1602\" tabindex=\"0\" hidden=\"hidden\"><h3>1 dzie\u0144<\/h3><ul><li><strong>Wst\u0119p do SQL &#8211; budowanie zapyta\u0144 do tabeli<\/strong><\/li><\/ul><ol><li style=\"list-style-type: none;\"><ol><li>(polecenie select, klauzula where, warunki, operatory, wbudowane funkcje, parametry)<\/li><li>zapytania do kilku tabel<\/li><li>sprawdzenie sk\u0105d pobiera dane formatka<\/li><li>r\u00f3\u017cnica pomi\u0119dzy tabel\u0105 i perspektyw\u0105<\/li><\/ol><\/li><\/ol><ul><li><strong>Zaawansowany kreator raport\u00f3w &#8211; wprowadzenie<\/strong><\/li><\/ul><ol><li style=\"list-style-type: none;\"><ol><li>budowa nowego raportu gridowego (zapytanie do tabeli)<\/li><li>definiowanie w\u0142asnych parametr\u00f3w (typy parametr\u00f3w)<\/li><\/ol><\/li><\/ol><h3>\u00a0<\/h3><h3>2 dzie\u0144<\/h3><ul><li><strong>Raport gridowy<\/strong><\/li><li><strong>Raport z odno\u015bnikiem do formatki<\/strong><\/li><li><strong>Raport z odno\u015bnikiem do raportu podrz\u0119dnego<\/strong><\/li><li><strong>Raport typu Pivot grid<\/strong><\/li><li><strong>Raport uruchamiany na formatce pod przyciskiem \u201eDrukuj\u201d i powi\u0105zany z zaznaczonym rekordem<\/strong><\/li><li><strong>Raport typu wykres s\u0142upkowy \/ wykres ko\u0142owy<\/strong><\/li><\/ul><\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8468469 elementor-widget elementor-widget-heading\" data-id=\"8468469\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Cena: 1400 z\u0142 (brutto)<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-026c7d1 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"026c7d1\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ae1cbc5 elementor-widget elementor-widget-button\" data-id=\"ae1cbc5\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a href=\"https:\/\/www.akademia-umiejetnosci.ue.katowice.pl\/index.php\/rejestracja-na-szkolenie\/\" class=\"elementor-button-link elementor-button elementor-size-sm\" role=\"button\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Zarejestruj si\u0119<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-54535d5 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"54535d5\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4b14267 elementor-widget elementor-widget-heading\" data-id=\"4b14267\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Miejsce szkolenia<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3dbde91 elementor-widget elementor-widget-google_maps\" data-id=\"3dbde91\" data-element_type=\"widget\" data-widget_type=\"google_maps.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-custom-embed\">\n\t\t\t<iframe frameborder=\"0\" scrolling=\"no\" marginheight=\"0\" marginwidth=\"0\"\n\t\t\t\t\tsrc=\"https:\/\/maps.google.com\/maps?q=Centrum%20Nowoczesnych%20Technologii%20Informatycznych%2C%20Katowice&#038;t=m&#038;z=10&#038;output=embed&#038;iwloc=near\"\n\t\t\t\t\ttitle=\"Centrum Nowoczesnych Technologii Informatycznych, Katowice\"\n\t\t\t\t\taria-label=\"Centrum Nowoczesnych Technologii Informatycznych, Katowice\"\n\t\t\t><\/iframe>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Opis szkolenia Program szkolenia Opis szkolenia Termin: 7-8.12.2021 Miejsce:&nbsp;Uniwersytet Ekonomiczny w Katowicach, CNTI Sala: 2\/19 Czas trwania:&nbsp;2 dni Maksymalna liczba os\u00f3b w grupie:&nbsp;10 os\u00f3b Trener: 1 dzie\u0144 \u2013 Jacek Mielcarski, 2 dzie\u0144 \u2013 Tomasz Krzyszkowski Program szkolenia 1 dzie\u0144 Wst\u0119p do SQL&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-581","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.akademia-umiejetnosci.ue.katowice.pl\/index.php\/wp-json\/wp\/v2\/pages\/581","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.akademia-umiejetnosci.ue.katowice.pl\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.akademia-umiejetnosci.ue.katowice.pl\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.akademia-umiejetnosci.ue.katowice.pl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.akademia-umiejetnosci.ue.katowice.pl\/index.php\/wp-json\/wp\/v2\/comments?post=581"}],"version-history":[{"count":34,"href":"https:\/\/www.akademia-umiejetnosci.ue.katowice.pl\/index.php\/wp-json\/wp\/v2\/pages\/581\/revisions"}],"predecessor-version":[{"id":647,"href":"https:\/\/www.akademia-umiejetnosci.ue.katowice.pl\/index.php\/wp-json\/wp\/v2\/pages\/581\/revisions\/647"}],"wp:attachment":[{"href":"https:\/\/www.akademia-umiejetnosci.ue.katowice.pl\/index.php\/wp-json\/wp\/v2\/media?parent=581"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}