CiAgICA8IS0tIExpbmtlZEluIC0tPgogICAgPHNjcmlwdCB0eXBlPSJ0ZXh0L2phdmFzY3JpcHQiPgogICAgICAgIF9saW5rZWRpbl9wYXJ0bmVyX2lkID0gIjEyMzUwNzMiOwogICAgICAgIHdpbmRvdy5fbGlua2VkaW5fZGF0YV9wYXJ0bmVyX2lkcyA9IHdpbmRvdy5fbGlua2VkaW5fZGF0YV9wYXJ0bmVyX2lkcyB8fCBbXTsKICAgICAgICB3aW5kb3cuX2xpbmtlZGluX2RhdGFfcGFydG5lcl9pZHMucHVzaChfbGlua2VkaW5fcGFydG5lcl9pZCk7CiAgICA8L3NjcmlwdD48c2NyaXB0IHR5cGU9InRleHQvamF2YXNjcmlwdCI+CiAgICAgICAgKGZ1bmN0aW9uKCl7dmFyIHMgPSBkb2N1bWVudC5nZXRFbGVtZW50c0J5VGFnTmFtZSgic2NyaXB0IilbMF07CiAgICAgICAgICAgIHZhciBiID0gZG9jdW1lbnQuY3JlYXRlRWxlbWVudCgic2NyaXB0Iik7CiAgICAgICAgICAgIGIudHlwZSA9ICJ0ZXh0L2phdmFzY3JpcHQiO2IuYXN5bmMgPSB0cnVlOwogICAgICAgICAgICBiLnNyYyA9ICJodHRwczovL3NuYXAubGljZG4uY29tL2xpLmxtcy1hbmFseXRpY3MvaW5zaWdodC5taW4uanMiOwogICAgICAgICAgICBzLnBhcmVudE5vZGUuaW5zZXJ0QmVmb3JlKGIsIHMpO30pKCk7CiAgICA8L3NjcmlwdD4KICAgIDxub3NjcmlwdD4KICAgICAgICA8aW1nIGhlaWdodD0iMSIgd2lkdGg9IjEiIHN0eWxlPSJkaXNwbGF5Om5vbmU7IiBhbHQ9IiIgc3JjPSJodHRwczovL3B4LmFkcy5saW5rZWRpbi5jb20vY29sbGVjdC8/cGlkPTEyMzUwNzMmZm10PWdpZiIgLz4KICAgIDwvbm9zY3JpcHQ+CiAgICA8IS0tIEVuZCBMaW5rZWRJbiAtLT4KICAgIA==
Generic filters
Exact matches only
Search in title
Search in excerpt
Search in content
Lade Events

Meet the Experts – Programmierung (17.07.2023)

17. Juli 2023, 14:0016:00 Uhr, Bissantz Campus (virtuell)
480EUR

Ein Expertengespräch mit Schwerpunkten nach Ihrer Wahl, zum Beispiel aus dem folgenden Themenkatalog:

SQL I – Einführung in relationale Datenbanken und die Abfragesprache SQL
Einsteiger-/Auffrischungskurs zu relationalen Datenbanken, Modellierung und der Abfragesprache SQL.

  • Grundlagen der relationalen Modellierung
  • Normalisierung, Schlüssel und Indizes, Verknüpfungstypen
  • Strukturierte Einführung in SQL und die wesentlichen Sprachelemente

SQL II – Fortgeschrittene Techniken
Grundkenntnisse z.B. aus der Schulung SQL I und/oder Praxiserfahrungen mit SQL sind Voraussetzung.

  • Techniken: Common Table Expressions, CROSS APPLY und CROSS JOIN
  • Window-Funktionen (OVER)
  • Prozeduren und Funktionen
  • Tipps zur Performanceoptimierung

MDX – Einführung in die Datenbanksprache Multidimensional Expressions
Eine Kompakte Einführung in die Abfragesprache MDX anhand von griffigen Praxisbeispielen mit DeltaMaster.

  • MDX-Grundlagen für BI-Anwender
  • Einführung in die MDX-Syntax (Terminologie, Aufbau)
  • Erkennen und Nutzen der wichtigsten MDX-Objekte (Tupel, Set, Member)
  • Verstehen, wie DeltaMaster MDX anwendet
  • Navigieren in Hierarchie-Bäumen per MDX
  • Arbeiten mit MDX-Operatoren und -Funktionen, z.B. Ancestor, Descendants, Crossjoin uvm.
  • Errechnen von Kennzahlen per MDX (Aggregate, Rangfolgen etc.)
  • Nutzung der gelernten Grundlagen in DeltaMaster (Achsendefinition, Analysewerte, Benannte Mengen etc.)
  • Zahlreiche Übungen zur Festigung des Gelernten

Dauer
Frei vereinbar, typischerweise: 2 Stunden.

Kosten
480,- EUR je zweistündiges Expertengespräch, zzgl. MwSt.


Terminanfrage

ICAgICAgICA8aW5wdXQgdHlwZT0iaGlkZGVuIiBuYW1lPSJmcm9tIgogICAgICAgICAgICAgICB2YWx1ZT0iaHR0cHM6Ly93d3cuYmlzc2FudHouZGUvdmVyYW5zdGFsdHVuZy9tZWV0LXRoZS1leHBlcnRzLXByb2dyYW1taWVydW5nLTIwMjMtMDctMTcvIj4KICAgICAgICA8aW5wdXQgdHlwZT0iaGlkZGVuIiBuYW1lPSJyZWNhcHRjaGFfcmVzcG9uc2UiIGlkPSJyZWNhcHRjaGFSZXNwb25zZSI+CgoJCTxzY3JpcHQgc3JjPSIvL3d3dy5nb29nbGUuY29tL3JlY2FwdGNoYS9hcGkuanM/cmVuZGVyPTZMY3hlOE1VQUFBQUFGY0RhMHo3d2hDWnJLMVBZcEI5Uzdaai1LUmEmb25sb2FkPXJlY2FwdGNoYU9ubG9hZCI+PC9zY3JpcHQ+CgkJPHNjcmlwdD4KICAgICAgICAgICAgdmFyIGJpc3NSZWNhcHRjaGEgPSB7CiAgICAgICAgICAgICAgICBmb3JtU2VsZWN0b3I6IG51bGwsCiAgICAgICAgICAgICAgICBzdWJtaXRCdXR0b246IG51bGwsCgogICAgICAgICAgICAgICAgZ2V0UGFnZVRva2VuKHN1Ym1pdCkgewoKICAgICAgICAgICAgICAgICAgICAvLyBTdG9yZSBhIHJlZmVyZW5jZSB0byB0aGUgY3VycmVudCBzY29wZQogICAgICAgICAgICAgICAgICAgIHZhciB0aGF0ID0gdGhpczsKCiAgICAgICAgICAgICAgICAgICAgLy8gQ2hlY2sgaWYgdGhlIGZvcm0gc2hvdWxkIGJlIHN1Ym1pdHRlZCBhcyB3ZWxsCiAgICAgICAgICAgICAgICAgICAgaWYgKHR5cGVvZiBzdWJtaXQgPT09ICdib29sZWFuJyAmJiBzdWJtaXQgPT09IHRydWUpIHsKCiAgICAgICAgICAgICAgICAgICAgICAgIC8vIFN0b3JlIHRoZSBzdWJtaXQgYnV0dG9uCiAgICAgICAgICAgICAgICAgICAgICAgIHRoaXMuc3VibWl0QnV0dG9uID0gZG9jdW1lbnQucXVlcnlTZWxlY3RvcignI3NjLTkxNjcyIGZvcm0gW3R5cGU9InN1Ym1pdCJdJyk7CgogICAgICAgICAgICAgICAgICAgICAgICAvLyBEaXNhYmxlIHRoZSBidXR0b24KICAgICAgICAgICAgICAgICAgICAgICAgdGhpcy5zdWJtaXRCdXR0b24uY2xhc3NOYW1lICs9ICcgYnV0dG9uLS1kaXNhYmxlZCc7CiAgICAgICAgICAgICAgICAgICAgfQoKICAgICAgICAgICAgICAgICAgICAvLyBFeGVjdHVlIHRoZSByZWNhcHRjaGEgY2FsbAogICAgICAgICAgICAgICAgICAgIGdyZWNhcHRjaGEuZXhlY3V0ZSgnNkxjeGU4TVVBQUFBQUZjRGEwejd3aENacksxUFlwQjlTN1pqLUtSYScsIHthY3Rpb246ICdNZWV0X3RoZV9FeHBlcnRzX19Qcm9ncmFtbWllcnVuZ18nfSkudGhlbihmdW5jdGlvbih0b2tlbikgewoKICAgICAgICAgICAgICAgICAgICAgICAgLy8gU2V0IHRoZSByZWNhcHRjaGEgdG9rZW4KICAgICAgICAgICAgICAgICAgICAgICAgZG9jdW1lbnQuZ2V0RWxlbWVudEJ5SWQoJ3JlY2FwdGNoYVJlc3BvbnNlJykudmFsdWUgPSB0b2tlbjsKCiAgICAgICAgICAgICAgICAgICAgICAgIC8vIENoZWNrIGlmIHRoZSBmb3JtIHNob3VsZCBiZSBzdWJtaXR0ZWQgYXMgd2VsbAogICAgICAgICAgICAgICAgICAgICAgICBpZiAodHlwZW9mIHN1Ym1pdCA9PT0gJ2Jvb2xlYW4nICYmIHN1Ym1pdCA9PT0gdHJ1ZSkgewoKICAgICAgICAgICAgICAgICAgICAgICAgICAgIC8vIFJlLWVuYWJsZSB0aGUgYnV0dG9uCiAgICAgICAgICAgICAgICAgICAgICAgICAgICB0aGF0LnN1Ym1pdEJ1dHRvbi5jbGFzc05hbWUucmVwbGFjZSgnYnV0dG9uLS1kaXNhYmxlZCcsICcnKTsKCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAvLyBTdWJtaXQgdGhlIGZvcm0KICAgICAgICAgICAgICAgICAgICAgICAgICAgIHRoYXQuZm9ybVNlbGVjdG9yLnN1Ym1pdCgpOwogICAgICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICB9LAoKICAgICAgICAgICAgICAgIGdldFBhZ2VUb2tlblByb21pc2VkKCkgewoKICAgICAgICAgICAgICAgICAgICAvLyBFeGVjdHVlIHRoZSByZWNhcHRjaGEgY2FsbAogICAgICAgICAgICAgICAgICAgIHJldHVybiBncmVjYXB0Y2hhLmV4ZWN1dGUoJzZMY3hlOE1VQUFBQUFGY0RhMHo3d2hDWnJLMVBZcEI5Uzdaai1LUmEnLCB7YWN0aW9uOiAnTWVldF90aGVfRXhwZXJ0c19fUHJvZ3JhbW1pZXJ1bmdfJ30pOwogICAgICAgICAgICAgICAgfSwKCiAgICAgICAgICAgICAgICBiaW5kaW5nKCkgewoKICAgICAgICAgICAgICAgICAgICAvLyBTdG9yZSBhIHJlZmVyZW5jZSB0byB0aGUgY3VycmVudCBzY29wZQogICAgICAgICAgICAgICAgICAgIHZhciB0aGF0ID0gdGhpczsKCiAgICAgICAgICAgICAgICAgICAgLy8gQWRkIHRoZSBmb3JtIGxpc3RlbmVyCiAgICAgICAgICAgICAgICAgICAgdGhpcy5mb3JtU2VsZWN0b3IuYWRkRXZlbnRMaXN0ZW5lcignc3VibWl0JywgZnVuY3Rpb24oZXZlbnQpIHsKCiAgICAgICAgICAgICAgICAgICAgICAgIC8vIFByZXZlbnQgdGhlIHN1Ym1pdCBwcm9jZXNzCiAgICAgICAgICAgICAgICAgICAgICAgIGV2ZW50LnByZXZlbnREZWZhdWx0KCk7CgogICAgICAgICAgICAgICAgICAgICAgICAvLyBHZXQgdGhlIHBhZ2Uga2V5IGFuZCBzdG9yZSBpdAogICAgICAgICAgICAgICAgICAgICAgICB0aGF0LmdldFBhZ2VUb2tlbih0cnVlKTsKICAgICAgICAgICAgICAgICAgICB9LCBmYWxzZSk7CiAgICAgICAgICAgICAgICB9LAoKICAgICAgICAgICAgICAgIGluaXQoKSB7CiAgICAgICAgICAgICAgICAgICAgLy8gU3RvcmUgZm9ybSBzZWxlY3RvcnMKICAgICAgICAgICAgICAgICAgICB0aGlzLmZvcm1TZWxlY3RvciA9IGRvY3VtZW50LnF1ZXJ5U2VsZWN0b3IoJyNzYy05MTY3MiBmb3JtJyk7CgogICAgICAgICAgICAgICAgICAgIC8vIE1ha2Ugc3VyZSB0aGUgZm9ybSBzZWxlY3RvciBleGlzdHMKICAgICAgICAgICAgICAgICAgICBpZiAodGhpcy5mb3JtU2VsZWN0b3IgIT09IG51bGwpIHsKCiAgICAgICAgICAgICAgICAgICAgICAgIC8vIEJpbmQgdGhlIHN1Ym1pdCBldmVudAogICAgICAgICAgICAgICAgICAgICAgICB0aGlzLmJpbmRpbmcoKTsKICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICB9LAoKICAgICAgICAgICAgICAgIHJlY2FwdGNoYUhhbmRsZXIoKSB7CiAgICAgICAgICAgICAgICAgICAgLy8gSWYgcmVjYXB0Y2hhIGlzIGRlZmluZWQKICAgICAgICAgICAgICAgICAgICBpZiAodHlwZW9mIGdyZWNhcHRjaGEgIT09ICd1bmRlZmluZWQnKSB7CiAgICAgICAgICAgICAgICAgICAgICAgIGdyZWNhcHRjaGEucmVhZHkoZnVuY3Rpb24oKSB7CgogICAgICAgICAgICAgICAgICAgICAgICAgICAgLy8gSW5pdGlhbGl6ZSByZWNhcHRjaGEKICAgICAgICAgICAgICAgICAgICAgICAgICAgIGJpc3NSZWNhcHRjaGEuaW5pdCgpOwoKICAgICAgICAgICAgICAgICAgICAgICAgICAgIC8vIEluaXRpYWxseSB0cnkgdG8gZ2V0IHRoZSBwYWdlIGtleQogICAgICAgICAgICAgICAgICAgICAgICAgICAgYmlzc1JlY2FwdGNoYS5nZXRQYWdlVG9rZW4oKTsKICAgICAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgfSwKICAgICAgICAgICAgfTsKCiAgICAgICAgICAgIGZ1bmN0aW9uIHJlY2FwdGNoYU9ubG9hZCgpIHsKICAgICAgICAgICAgICAgIGJpc3NSZWNhcHRjaGEucmVjYXB0Y2hhSGFuZGxlcigpOwogICAgICAgICAgICB9CiAgICAgICAgPC9zY3JpcHQ+CgkJ





* Pflichtangaben

Dieses Formular ist durch reCAPTCHA und die Datenschutzrichtlinie von Google geschützt. Es gelten die Nutzungsbedingungen.








PGJyIC8+CjxidXR0b24gY2xhc3M9ImJ1dHRvbiBidXR0b24tLWZpbGxlZCBidXR0b24tLWNvbG9yLXByaW1hcnkiIHR5cGU9InN1Ym1pdCI+QW5mcmFnZW48L2J1dHRvbj48YnIgLz4K

Ähnliche Veranstaltungen