{"id":535,"date":"2024-09-03T12:04:44","date_gmt":"2024-09-03T10:04:44","guid":{"rendered":"https:\/\/modedcon.com\/?page_id=535"},"modified":"2025-08-18T20:08:12","modified_gmt":"2025-08-18T18:08:12","slug":"programmiersprache-sql","status":"publish","type":"page","link":"https:\/\/modedcon.com\/de\/kurse\/programmiersprache-sql\/","title":{"rendered":"Programmiersprache SQL"},"content":{"rendered":"\n<div class=\"wp-block-columns alignwide is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:60%\">\n<p>Der Kurs ist auf 3 Tage ausgelegt. Es wird davon ausgegangen, dass die Teilnehmer sowohl Basic-SQL, als auch eine Programmiersprache beherrschen. Es wird ebenfalls davon ausgegangen, dass sich die Teilnehmer zumindest einigerma\u00dfen mit den ACS-Tools f\u00fcr die Datenbank auskennen.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" style=\"margin-top:48px;margin-bottom:24px\">Inhalte<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>SQL PL &#8211; Programming Language<\/strong>\n<ul class=\"wp-block-list\">\n<li>Syntax und Struktur\n<ul class=\"wp-block-list\">\n<li>Definition von Konstanten und Variablen<\/li>\n\n\n\n<li>Set-Statement: Wert Zuweisung<\/li>\n\n\n\n<li>IF-\/CASE- Statements: Bedingungen<\/li>\n\n\n\n<li>LOOP-, WHILE-, REPEAT-Statements: Schleifen<\/li>\n\n\n\n<li>Cursor Handling<\/li>\n\n\n\n<li>Statisches und dynamisches SQL <\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Error Handling\n<ul class=\"wp-block-list\">\n<li>Definition von Continue, Undo, Exit Handlern<\/li>\n\n\n\n<li>SIGNAL-\/RESIGNAL-Statements<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>ACS Integrated Debugger<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Stored Procedures<\/strong>\n<ul class=\"wp-block-list\">\n<li>Externe und SQL Stored Procedures<\/li>\n\n\n\n<li>Parameter-Styles zur Registrierung von externen Procedures, Functions und Table Functions<\/li>\n\n\n\n<li>Erstellen und Verarbeiten von Result-Sets<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>User Defined Functions<\/strong>\n<ul class=\"wp-block-list\">\n<li>Externe und SQL Skalare User Defined Functions<\/li>\n\n\n\n<li>Externe und SQL Table Functions<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Trigger<\/strong>\n<ul class=\"wp-block-list\">\n<li>Externe und SQL-Trigger<\/li>\n\n\n\n<li>Trigger Event und Trigger Zeit<\/li>\n\n\n\n<li>Bedingte Trigger und Trigger auf Feldebene<\/li>\n\n\n\n<li>Instead Of Trigger<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:5%\"><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:35%\">\n<div class=\"wp-block-group has-custom-bg-background-color has-background is-vertical is-layout-flex wp-container-core-group-is-layout-079504a7 wp-block-group-is-layout-flex\" style=\"padding-top:var(--wp--preset--spacing--10);padding-right:var(--wp--preset--spacing--10);padding-bottom:var(--wp--preset--spacing--10);padding-left:var(--wp--preset--spacing--10)\">\n<p class=\"hideonmobile\"><a href=\"https:\/\/modedcon.com\/kurse\" data-type=\"page\" data-id=\"74\">zur\u00fcck zur \u00dcbersicht<\/a><\/p>\n\n\n\n<div class=\"wp-block-group is-vertical is-layout-flex wp-container-core-group-is-layout-fe9cc265 wp-block-group-is-layout-flex\">\n<h2 class=\"wp-block-heading has-large-font-size\">Dieser Kurs<\/h2>\n\n\n\n<p>Teilnehmer: 8<br>Dauer: 3 Tage<\/p>\n\n\n\n<p class=\"has-custom-logo-red-color has-text-color has-link-color wp-elements-0769cf7e1cc07049e052ffe016fe898e\">Die Buchung ist nur f\u00fcr Unternehmer, Gewerbetreibende, Freiberufler und \u00f6ffentliche Institutionen m\u00f6glich; nicht f\u00fcr Verbraucher i.S.d. \u00a7 13 BGB.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-custom-logo-blue-background-color has-background wp-element-button\" href=\"https:\/\/modedcon.com\/kontakt\/\">Unverbindliche Anfrage stellen<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-group is-vertical is-layout-flex wp-container-core-group-is-layout-5f9f5280 wp-block-group-is-layout-flex\">\n<h2 class=\"wp-block-heading has-large-font-size\">Alle Kurse<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--20);margin-bottom:0.5rem;font-size:clamp(0.929rem, 0.929rem + ((1vw - 0.2rem) * 0.785), 1.4rem);\">RPG<\/h3>\n\n\n\n<ul class=\"wp-block-list is-style-default\">\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/rpg-intro\/\" data-type=\"page\" data-id=\"515\">RPG \u2013 Intro<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/rpg-jump-start\/\" data-type=\"page\" data-id=\"521\">RPG \u2013 Jump-Start<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/ile-konzepte\/\" data-type=\"page\" data-id=\"525\">ILE Konzepte<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/embedded-sql\/\" data-type=\"page\" data-id=\"527\">Embedded SQL<\/a><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--20);margin-bottom:0.5rem;font-size:clamp(0.929rem, 0.929rem + ((1vw - 0.2rem) * 0.785), 1.4rem);\">SQL<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/sql-abfragen-fuer-beginner\/\" data-type=\"page\" data-id=\"529\">SQL Abfragen f\u00fcr Beginner<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/sql-abfragen-fuer-profis\/\" data-type=\"page\" data-id=\"531\">SQL Abfragen f\u00fcr Profis<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/erstellen-und-verarbeiten-von-json-und-xml-daten-mit-sql\/\" data-type=\"page\" data-id=\"533\">Erstellen und Verarbeiten von JSON- und XML-Daten mit SQL<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/programmiersprache-sql\/\" data-type=\"page\" data-id=\"535\">Programmiersprache SQL<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/sql-performance-analyse\/\" data-type=\"page\" data-id=\"538\">SQL-Performance Analyse<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/data-centric-verlagerung-von-programmlogik-in-die-datenbank\/\" data-type=\"page\" data-id=\"540\">Data Centric Verlagerung von Programmlogik in die Datenbank<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/anwendungsmodernisierung-datenbank\/\" data-type=\"page\" data-id=\"542\">Anwendungsmodernisierung Datenbank<\/a><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--20);margin-bottom:0.5rem;font-size:clamp(0.929rem, 0.929rem + ((1vw - 0.2rem) * 0.785), 1.4rem);\">Spezielle Kurse und Vortr\u00e4ge<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/temporale-tabellen\/\" data-type=\"page\" data-id=\"544\">Temporale Tabellen<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/row-and-column-access-control-rcac\/\" data-type=\"page\" data-id=\"546\">ROW and Column Access Control (RCAC)<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/partitioned-tables\/\" data-type=\"page\" data-id=\"548\">Partitioned Tables<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/self-sql-error-logging-facility\/\" data-type=\"page\" data-id=\"550\">SELF \u2013 SQL Error Logging Facility<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/sql-und-ifs\/\" data-type=\"page\" data-id=\"552\">SQL und IFS<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Der Kurs ist auf 3 Tage ausgelegt. Es wird davon ausgegangen, dass die Teilnehmer sowohl Basic-SQL, als auch eine Programmiersprache beherrschen. Es wird ebenfalls davon ausgegangen, dass sich die Teilnehmer zumindest einigerma\u00dfen mit den ACS-Tools f\u00fcr die Datenbank auskennen. Inhalte zur\u00fcck zur \u00dcbersicht Dieser Kurs Teilnehmer: 8Dauer: 3 Tage Die Buchung ist nur f\u00fcr Unternehmer, [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":834,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-535","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/modedcon.com\/de\/wp-json\/wp\/v2\/pages\/535","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/modedcon.com\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/modedcon.com\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/modedcon.com\/de\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/modedcon.com\/de\/wp-json\/wp\/v2\/comments?post=535"}],"version-history":[{"count":17,"href":"https:\/\/modedcon.com\/de\/wp-json\/wp\/v2\/pages\/535\/revisions"}],"predecessor-version":[{"id":987,"href":"https:\/\/modedcon.com\/de\/wp-json\/wp\/v2\/pages\/535\/revisions\/987"}],"up":[{"embeddable":true,"href":"https:\/\/modedcon.com\/de\/wp-json\/wp\/v2\/pages\/834"}],"wp:attachment":[{"href":"https:\/\/modedcon.com\/de\/wp-json\/wp\/v2\/media?parent=535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}