{"id":177417,"date":"2023-06-01T09:53:34","date_gmt":"2023-06-01T08:53:34","guid":{"rendered":"https:\/\/datascientest.com\/de\/?p=177417"},"modified":"2023-10-30T10:00:31","modified_gmt":"2023-10-30T09:00:31","slug":"sql-update-daten-mit-diesem-befehl-aktualisieren","status":"publish","type":"post","link":"https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren","title":{"rendered":"SQL UPDATE : Daten mit diesem Befehl aktualisieren"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"177417\" class=\"elementor elementor-177417\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f770065 e-flex e-con-boxed e-con\" data-id=\"f770065\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c2adf0f elementor-widget elementor-widget-heading\" data-id=\"c2adf0f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Da sich Datenbanken st\u00e4ndig weiterentwickeln, ist es wichtig, dass du die UPDATE SQL-Abfrage kennst. Mit dieser Abfrage kannst du eine oder mehrere Zeilen in deiner Tabelle \u00e4ndern. Wie benutzt man sie also? Wir erkl\u00e4ren dir alles in diesem Artikel.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e3a6fb6 e-flex e-con-boxed e-con\" data-id=\"e3a6fb6\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9f9644b elementor-widget elementor-widget-heading\" data-id=\"9f9644b\" 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\">Was ist SQL UPDATE ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9f04a0d elementor-widget elementor-widget-text-editor\" data-id=\"9f04a0d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>Der Befehl<strong> SQL UPDATE<\/strong> wird verwendet, um Daten innerhalb einer Tabelle zu aktualisieren. Dies ist unerl\u00e4sslich, wenn du eine Datenbank mit aktuellen und zuverl\u00e4ssigen Informationen behalten willst.<\/p><p>Da die Datenqualit\u00e4t eine der gr\u00f6\u00dften Herausforderungen f\u00fcr Datenexperten ist, ist UPDATE eine der h\u00e4ufigsten SQL-Anfragen.<\/p><p>\u00a0<\/p><p>\ud83d\udca1Auch interessant:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\"><colgroup><col width=\"268\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;MySQL Relationale Datenbanksoftware&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/de\/mysql-eine-relationale-datenverwaltungssoftware\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/de\/mysql-eine-relationale-datenverwaltungssoftware\" target=\"_blank\" rel=\"noopener\">MySQL Relationale Datenbanksoftware<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Tutorial&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/de\/sql-tutorial\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/de\/sql-tutorial\" target=\"_blank\" rel=\"noopener\">SQL Tutorial<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Apache Cassandra noSQL BDD&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/de\/apache-cassandra-die-beliebteste-nosql-bdd\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/de\/apache-cassandra-die-beliebteste-nosql-bdd\" target=\"_blank\" rel=\"noopener\">Apache Cassandra noSQL BDD<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Joins&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/de\/alles-uber-sql-joins-verstehen\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/de\/alles-uber-sql-joins-verstehen\" target=\"_blank\" rel=\"noopener\">SQL Joins<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Count Tutorial&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/de\/sql-count-unser-tutorial\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/de\/sql-count-unser-tutorial\" target=\"_blank\" rel=\"noopener\">SQL Count Tutorial<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Datei \u00f6ffnen&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/de\/sql-datei-oeffnen-unser-tutorial\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/de\/sql-datei-oeffnen-unser-tutorial\" target=\"_blank\" rel=\"noopener\">SQL Datei \u00f6ffnen<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL vs. NOSQL&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/de\/sql-vs-nosql-unterschiede-anwendungen-vor-und-nachteile\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/de\/sql-vs-nosql-unterschiede-anwendungen-vor-und-nachteile\" target=\"_blank\" rel=\"noopener\">SQL vs. NOSQL<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;noSQL nicht relationale Datenbanken&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/de\/no-sql-nicht-relationale-datenbanken\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/de\/no-sql-nicht-relationale-datenbanken\" target=\"_blank\" rel=\"noopener\">noSQL nicht relationale Datenbanken<\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-03bd177 e-flex e-con-boxed e-con\" data-id=\"03bd177\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4997b6e elementor-widget elementor-widget-heading\" data-id=\"4997b6e\" 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\">Wie benutzt man den Befehl SQL UPDATE ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d98f9b4 elementor-widget elementor-widget-text-editor\" data-id=\"d98f9b4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Die Syntax der SQL UPDATE Abfrage lautet wie folgt:<\/p><ul><li>UPDATE Tabellenname<\/li><li>SET spaltenname = &#8217;neuer Wert&#8216;.<\/li><li>WHERE Bedingung<\/li><\/ul><p>Um sie besser zu verstehen, sollten wir noch einmal auf die wichtigsten Attribute eingehen, n\u00e4mlich :<\/p><ul><li>Die SET-Klausel: Damit wird festgelegt, durch was du die vorhandenen Daten ersetzen willst. Hier m\u00fcssen nur die Spalten genannt werden, die ge\u00e4ndert werden sollen. Alle anderen behalten ihre aktuellen Werte bei.<\/li><li>Die WHERE-Klausel: Damit wird festgelegt, wo die \u00c4nderungen vorgenommen werden sollen.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0d3a4cf elementor-widget elementor-widget-text-editor\" data-id=\"0d3a4cf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Neben dieser vereinfachten Syntax ist es auch m\u00f6glich, die <strong>UPDATE-Funktion mit anderen SQL-Abfragen wie SELECT, INSERT INTO, GETDATE, INNER, JOIN<\/strong> usw. zu verwenden. Dies erm\u00f6glicht es dir, deine <a href=\"https:\/\/datascientest.com\/de\/relationale-datenbanken\">Datenbank<\/a> zu erweitern und komplexere Manipulationen durchzuf\u00fchren.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-98fc521 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"98fc521\" 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 class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/de\/unsere-aus-und-weiterbildungen\">\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\">SQL lernen<\/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\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e3a82e8 e-flex e-con-boxed e-con\" data-id=\"e3a82e8\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a789605 elementor-widget elementor-widget-heading\" data-id=\"a789605\" 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\">5 Beispiele f\u00fcr die Verwendung der UPDATE-Abfrage<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aa83c02 elementor-widget elementor-widget-heading\" data-id=\"aa83c02\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Eine Zeile bearbeiten<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-112424e elementor-widget elementor-widget-text-editor\" data-id=\"112424e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In diesem Beispiel verwenden wir die untenstehende Client-Tabelle.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-93a0a29 elementor-widget elementor-widget-html\" data-id=\"93a0a29\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\n<colgroup>\n<col style=\"width: 25px\">\n<col style=\"width: 75px\">\n<col style=\"width: 75px\">\n<col style=\"width: 125px\">\n<col style=\"width: 200px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-a0vq\">ID<\/th>\n    <th class=\"tg-a0vq\">Vorname<\/th>\n    <th class=\"tg-a0vq\">Nachname<\/th>\n    <th class=\"tg-a0vq\">Stadt<\/th>\n    <th class=\"tg-a0vq\">E-Mail<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-a0vq\">1<\/td>\n    <td class=\"tg-c3ow\">Justin<\/td>\n    <td class=\"tg-c3ow\">Martin<\/td>\n    <td class=\"tg-c3ow\">Paris<\/td>\n    <td class=\"tg-c3ow\">justinemartin@gmail.com<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">2<\/td>\n    <td class=\"tg-c3ow\">Thomas<\/td>\n    <td class=\"tg-c3ow\">Durant<\/td>\n    <td class=\"tg-c3ow\">Bordeaux<\/td>\n    <td class=\"tg-c3ow\">tomtom@sfr.fr<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">3<\/td>\n    <td class=\"tg-c3ow\">Marie<\/td>\n    <td class=\"tg-c3ow\">Leroy<\/td>\n    <td class=\"tg-c3ow\">Angers<\/td>\n    <td class=\"tg-c3ow\">marieleroy@laposte.net<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">4<\/td>\n    <td class=\"tg-c3ow\">Vanessa<\/td>\n    <td class=\"tg-c3ow\">Savary<\/td>\n    <td class=\"tg-c3ow\">Marseille<\/td>\n    <td class=\"tg-c3ow\">vanessa13@gmail.com<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0937e77 elementor-widget elementor-widget-text-editor\" data-id=\"0937e77\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Hier m\u00f6chtest du die E-Mail-Adresse von Justine Martin aktualisieren. Hier ist ihre neue Adresse: justinemartin@sfr.fr. F\u00fclle dazu einfach die folgende Abfrage aus:<\/p><p>UPDATE Kunde<\/p><p>SET Email = &#8218;justinemartin@sfr.fr&#8216;.<\/p><p>WHERE id = 1<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2a58014 elementor-widget elementor-widget-text-editor\" data-id=\"2a58014\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Und hier ist das Ergebnis:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e4ee70b elementor-widget elementor-widget-html\" data-id=\"e4ee70b\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 75px\">\r\n<col style=\"width: 75px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 200px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-a0vq\">ID<\/th>\r\n    <th class=\"tg-a0vq\">Vorname<\/th>\r\n    <th class=\"tg-a0vq\">Nachname<\/th>\r\n    <th class=\"tg-a0vq\">Stadt<\/th>\r\n    <th class=\"tg-a0vq\">E-mail<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">1<\/td>\r\n    <td class=\"tg-c3ow\">Justin<\/td>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n    <td class=\"tg-c3ow\">Paris<\/td>\r\n    <td class=\"tg-c3ow\">justinemartin@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">2<\/td>\r\n    <td class=\"tg-c3ow\">Thomas<\/td>\r\n    <td class=\"tg-c3ow\">Durant<\/td>\r\n    <td class=\"tg-c3ow\">Bordeaux<\/td>\r\n    <td class=\"tg-c3ow\">tomtom@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">3<\/td>\r\n    <td class=\"tg-c3ow\">Marie<\/td>\r\n    <td class=\"tg-c3ow\">Leroy<\/td>\r\n    <td class=\"tg-c3ow\">Angers<\/td>\r\n    <td class=\"tg-c3ow\">marieleroy@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">4<\/td>\r\n    <td class=\"tg-c3ow\">Vanessa<\/td>\r\n    <td class=\"tg-c3ow\">Savary<\/td>\r\n    <td class=\"tg-c3ow\">Marseille<\/td>\r\n    <td class=\"tg-c3ow\">vanessa13@gmail.com<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-10c3335 elementor-widget elementor-widget-heading\" data-id=\"10c3335\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Mehrere Daten bearbeiten<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d3ab67a elementor-widget elementor-widget-text-editor\" data-id=\"d3ab67a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Wenn du mehrere Informationen innerhalb einer Zeile \u00e4ndern m\u00f6chtest, trenne die neuen Werte einfach durch ein Komma.<\/p><p>In unserem Beispiel m\u00f6chtest du nicht nur die E-Mail-Adresse von Justine Martin \u00e4ndern, sondern auch ihren Wohnort. Sie wohnt jetzt in Nantes.<\/p><p>Die Abfrage sieht folgenderma\u00dfen aus:<\/p><p>UPDATE Kunde<\/p><p>SET<\/p><p>Stadt = &#8218;Nantes&#8216;,<\/p><p>Email = &#8218;justinemartin@sfr.fr&#8216;.<\/p><p>WHERE id = 1<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2de92d2 elementor-widget elementor-widget-text-editor\" data-id=\"2de92d2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Und hier die neue Tabelle:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2cc6feb elementor-widget elementor-widget-html\" data-id=\"2cc6feb\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 75px\">\r\n<col style=\"width: 75px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 200px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-a0vq\">ID<\/th>\r\n    <th class=\"tg-a0vq\">Vorname<\/th>\r\n    <th class=\"tg-a0vq\">Nachname<\/th>\r\n    <th class=\"tg-a0vq\">Stadt<\/th>\r\n    <th class=\"tg-a0vq\">E-mail<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">1<\/td>\r\n    <td class=\"tg-c3ow\">Justin<\/td>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n    <td class=\"tg-c3ow\">Nantes<\/td>\r\n    <td class=\"tg-c3ow\">justinemartin@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">2<\/td>\r\n    <td class=\"tg-c3ow\">Thomas<\/td>\r\n    <td class=\"tg-c3ow\">Durant<\/td>\r\n    <td class=\"tg-c3ow\">Bordeaux<\/td>\r\n    <td class=\"tg-c3ow\">tomtom@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">3<\/td>\r\n    <td class=\"tg-c3ow\">Marie<\/td>\r\n    <td class=\"tg-c3ow\">Leroy<\/td>\r\n    <td class=\"tg-c3ow\">Angers<\/td>\r\n    <td class=\"tg-c3ow\">marieleroy@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">4<\/td>\r\n    <td class=\"tg-c3ow\">Vanessa<\/td>\r\n    <td class=\"tg-c3ow\">Savary<\/td>\r\n    <td class=\"tg-c3ow\">Marseille<\/td>\r\n    <td class=\"tg-c3ow\">vanessa13@gmail.com<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-957e189 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"957e189\" 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 class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/de\/unsere-aus-und-weiterbildungen\">\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\">SQL Weiterbildung<\/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-08ef773 elementor-widget elementor-widget-heading\" data-id=\"08ef773\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Alle Zeilen bearbeiten<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-25884cd elementor-widget elementor-widget-text-editor\" data-id=\"25884cd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Wenn du alle Zeilen der Tabelle \u00e4ndern willst, kannst du die<strong> WHERE-Abfrage<\/strong> einfach weglassen. Wenn z. B. alle Kunden nach Lyon umziehen, ist dies die Abfrage, die du speichern musst:<\/p><p>UPDATE Kunde<\/p><p>SET<\/p><p>Stadt = &#8218;Lyon&#8216;<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d502156 elementor-widget elementor-widget-text-editor\" data-id=\"d502156\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Und hier die neue Tabelle:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-daab380 elementor-widget elementor-widget-html\" data-id=\"daab380\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 75px\">\r\n<col style=\"width: 75px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 200px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-a0vq\">ID<\/th>\r\n    <th class=\"tg-a0vq\">Vorname<\/th>\r\n    <th class=\"tg-a0vq\">Name<\/th>\r\n    <th class=\"tg-a0vq\">Stadt<\/th>\r\n    <th class=\"tg-a0vq\">E-mail<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">1<\/td>\r\n    <td class=\"tg-c3ow\">Justin<\/td>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n    <td class=\"tg-c3ow\">Lyon<\/td>\r\n    <td class=\"tg-c3ow\">justinemartin@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">2<\/td>\r\n    <td class=\"tg-c3ow\">Thomas<\/td>\r\n    <td class=\"tg-c3ow\">Durant<\/td>\r\n    <td class=\"tg-c3ow\">Lyon<\/td>\r\n    <td class=\"tg-c3ow\">tomtom@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">3<\/td>\r\n    <td class=\"tg-c3ow\">Marie<\/td>\r\n    <td class=\"tg-c3ow\">Leroy<\/td>\r\n    <td class=\"tg-c3ow\">Lyon<\/td>\r\n    <td class=\"tg-c3ow\">marieleroy@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">4<\/td>\r\n    <td class=\"tg-c3ow\">Vanessa<\/td>\r\n    <td class=\"tg-c3ow\">Savary<\/td>\r\n    <td class=\"tg-c3ow\">Lyon<\/td>\r\n    <td class=\"tg-c3ow\">vanessa13@gmail.com<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7138608 elementor-widget elementor-widget-heading\" data-id=\"7138608\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Daten aus Daten in einer anderen Tabelle bearbeiten<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-93c2cae elementor-widget elementor-widget-text-editor\" data-id=\"93c2cae\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>F\u00fcr dieses Beispiel verwenden wir zwei Tabellen.<\/p><p>Die erste Tabelle<strong> &#8222;Produkte&#8220;<\/strong> listet die von einem Unternehmen verkauften Produkte und den Verk\u00e4ufer auf, der den Verkauf durchgef\u00fchrt hat:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6e5ba50 elementor-widget elementor-widget-html\" data-id=\"6e5ba50\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\n<colgroup>\n<col style=\"width: 100px\">\n<col style=\"width: 100px\">\n<col style=\"width: 150px\">\n<col style=\"width: 150px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-a0vq\">Produkt<\/th>\n    <th class=\"tg-a0vq\">Prix<\/th>\n    <th class=\"tg-a0vq\">Kommerzielle ID<\/th>\n    <th class=\"tg-a0vq\">Nom du commercial<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-c3ow\">Batterie<\/td>\n    <td class=\"tg-c3ow\">100<\/td>\n    <td class=\"tg-c3ow\">5<\/td>\n    <td class=\"tg-c3ow\">NULL<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">Telefon<\/td>\n    <td class=\"tg-c3ow\">300<\/td>\n    <td class=\"tg-c3ow\">1<\/td>\n    <td class=\"tg-c3ow\">NULL<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">Ordinateur<\/td>\n    <td class=\"tg-c3ow\">800<\/td>\n    <td class=\"tg-c3ow\">3<\/td>\n    <td class=\"tg-c3ow\">NULL<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-807962d elementor-widget elementor-widget-text-editor\" data-id=\"807962d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Das zweite &#8222;Mitarbeiter&#8220; listet die Besch\u00e4ftigten eines Unternehmens auf.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e75773 elementor-widget elementor-widget-html\" data-id=\"8e75773\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 325px\">\n<colgroup>\n<col style=\"width: 25px\">\n<col style=\"width: 150px\">\n<col style=\"width: 150px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-a0vq\">ID<\/th>\n    <th class=\"tg-a0vq\">Prix<\/th>\n    <th class=\"tg-a0vq\">Kommerzielle ID<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-c3ow\">1<\/td>\n    <td class=\"tg-c3ow\">Justin<\/td>\n    <td class=\"tg-c3ow\">Martin<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">2<\/td>\n    <td class=\"tg-c3ow\">Thomas<\/td>\n    <td class=\"tg-c3ow\">Durant<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">3<\/td>\n    <td class=\"tg-c3ow\">Marie<\/td>\n    <td class=\"tg-c3ow\">Leroy<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-baqh\">4<\/td>\n    <td class=\"tg-baqh\">Vanessa<\/td>\n    <td class=\"tg-baqh\">Savary<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-baqh\">5<\/td>\n    <td class=\"tg-baqh\">Jean<\/td>\n    <td class=\"tg-baqh\">Dupont<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8380a8b elementor-widget elementor-widget-text-editor\" data-id=\"8380a8b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Ziel ist es, den Namen des Vertriebsmitarbeiters, der den Verkauf get\u00e4tigt hat, anhand seiner ID zu identifizieren. Dieser Name wird dann in die Produkttabelle aufgenommen.<\/p><p>Um dies zu erreichen, musst du folgende Abfrage speichern:<\/p><p>UPDATE Produkt<\/p><p>SET Name des Vertriebsmitarbeiters = (SELECT &#8222;name&#8220; from &#8222;Employee&#8220; WHERE sales ID = ID)<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4f7d12b elementor-widget elementor-widget-text-editor\" data-id=\"4f7d12b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Und hier ist das Ergebnis:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-af1d4dc elementor-widget elementor-widget-html\" data-id=\"af1d4dc\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-03gf{background-color:#6665cd;color:#efefef;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 575px\">\n<colgroup>\n<col style=\"width: 25px\">\n<col style=\"width: 125px\">\n<col style=\"width: 125px\">\n<col style=\"width: 150px\">\n<col style=\"width: 150px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-a0vq\">ID<\/th>\n    <th class=\"tg-a0vq\">Produkt<\/th>\n    <th class=\"tg-a0vq\">Preis<\/th>\n    <th class=\"tg-03gf\">Kommerzielle ID<\/th>\n    <th class=\"tg-03gf\">Name des Verk\u00e4ufers<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-a0vq\">1<\/td>\n    <td class=\"tg-c3ow\">Batterie<\/td>\n    <td class=\"tg-c3ow\">100<\/td>\n    <td class=\"tg-baqh\">5<\/td>\n    <td class=\"tg-baqh\">Dupont<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">2<\/td>\n    <td class=\"tg-c3ow\">Telefon<\/td>\n    <td class=\"tg-c3ow\">300<\/td>\n    <td class=\"tg-baqh\">1<\/td>\n    <td class=\"tg-baqh\">Martin<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">3<\/td>\n    <td class=\"tg-c3ow\">Computer<\/td>\n    <td class=\"tg-c3ow\">800<\/td>\n    <td class=\"tg-baqh\">3<\/td>\n    <td class=\"tg-baqh\">Leroy<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7f59f78 elementor-widget elementor-widget-heading\" data-id=\"7f59f78\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Aktualisieren der Uhrzeit mit SQL UPDATE<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f06f125 elementor-widget elementor-widget-text-editor\" data-id=\"f06f125\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Es ist auch m\u00f6glich, die<strong> SQL-Abfrage UPDATE<\/strong> mit dem Befehl GETDATE zu verwenden, um die Uhrzeit und das Datum zu aktualisieren.<\/p><p>Zum Beispiel m\u00f6chtest du mit dieser Tabelle &#8222;Produkt&#8220; das Kaufdatum der unten aufgef\u00fchrten Produkte mit dem heutigen Datum (25.04.2023) aktualisieren.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b171862 elementor-widget elementor-widget-html\" data-id=\"b171862\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-03gf{background-color:#6665cd;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 425px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 150px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-a0vq\">ID<\/th>\r\n    <th class=\"tg-a0vq\">Produkt<\/th>\r\n    <th class=\"tg-a0vq\">Preis<\/th>\r\n    <th class=\"tg-03gf\">Kaufdatum<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">1<\/td>\r\n    <td class=\"tg-c3ow\">Batterie<\/td>\r\n    <td class=\"tg-c3ow\">100<\/td>\r\n    <td class=\"tg-baqh\">01\/03\/2023<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">2<\/td>\r\n    <td class=\"tg-c3ow\">Telefon<\/td>\r\n    <td class=\"tg-c3ow\">300<\/td>\r\n    <td class=\"tg-baqh\">06\/03\/2022<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">3<\/td>\r\n    <td class=\"tg-c3ow\">Computer<\/td>\r\n    <td class=\"tg-c3ow\">800<\/td>\r\n    <td class=\"tg-baqh\">15\/04\/2023<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d862a8d elementor-widget elementor-widget-text-editor\" data-id=\"d862a8d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Dazu muss die folgende Abfrage ausgef\u00fcllt werden:<\/p><p>UPDATE Produkt<\/p><p>SET Kaufdatum = GETDATE()<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d26bdbc elementor-widget elementor-widget-text-editor\" data-id=\"d26bdbc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>So sieht die Tabelle jetzt aus:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-853f33d elementor-widget elementor-widget-html\" data-id=\"853f33d\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-03gf{background-color:#6665cd;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 425px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 150px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-a0vq\">ID<\/th>\r\n    <th class=\"tg-a0vq\">Produkt<\/th>\r\n    <th class=\"tg-a0vq\">Preis<\/th>\r\n    <th class=\"tg-03gf\">Kaufdatum<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">1<\/td>\r\n    <td class=\"tg-c3ow\">Batterie<\/td>\r\n    <td class=\"tg-c3ow\">100<\/td>\r\n    <td class=\"tg-baqh\">25\/04\/2023<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">2<\/td>\r\n    <td class=\"tg-c3ow\">Telefon<\/td>\r\n    <td class=\"tg-c3ow\">300<\/td>\r\n    <td class=\"tg-baqh\">25\/04\/2023<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">3<\/td>\r\n    <td class=\"tg-c3ow\">Computer<\/td>\r\n    <td class=\"tg-c3ow\">800<\/td>\r\n    <td class=\"tg-baqh\">25\/04\/2023<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d38cedd elementor-widget elementor-widget-text-editor\" data-id=\"d38cedd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Wie du gesehen hast, gibt es viele M\u00f6glichkeiten, die <strong>SQL-Abfrage UPDATE<\/strong> zu verwenden. Das Schreiben eines Blogartikels scheint nicht auszureichen, um die Vielzahl der m\u00f6glichen Anwendungen zu durchleuchten. Wenn du mehr dar\u00fcber erfahren m\u00f6chtest, kannst du gerne an einem unserer Kurse bei DataScientest teilnehmen.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-2959acb e-flex e-con-boxed e-con\" data-id=\"2959acb\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0a59a98 elementor-widget elementor-widget-heading\" data-id=\"0a59a98\" 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\">Erweitere deine Kenntnisse der SQL-Sprache<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0d036a1 elementor-widget elementor-widget-text-editor\" data-id=\"0d036a1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Die SQL-Sprache ist zwar die unverzichtbare Grundlage f\u00fcr den Umgang mit relationalen Datenbanken, ihre Beherrschung erfordert jedoch eine Ausbildung mit mehreren Stunden Praxis. Aus diesem Grund bieten wir dir bei DataScientest verschiedene Schulungen an. Jede dieser Schulungen ist entweder fach- oder werkzeugorientiert, so dass du deine SQL-Kenntnisse entsprechend deinen spezifischen Bed\u00fcrfnissen weiterentwickeln kannst.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3fd6858 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"3fd6858\" 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 class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/de\/unsere-aus-und-weiterbildungen\">\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\">Entdecke die DataScientest Schulungen<\/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-5867310 elementor-widget elementor-widget-html\" data-id=\"5867310\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">.\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{{\n    \"@type\": \"Frage\",\n    \"name\": \"Was ist UPDATE SQL?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Der SQL-Befehl UPDATE wird verwendet, um Daten in einer Tabelle zu aktualisieren. Dies ist notwendig, wenn du eine Datenbank mit aktuellen und zuverl\u00e4ssigen Informationen haben m\u00f6chtest. Da die Datenqualit\u00e4t eine der gr\u00f6\u00dften Herausforderungen f\u00fcr Datenexperten ist, ist UPDATE eine der h\u00e4ufigsten SQL-Anfragen.\"\n    }\n  },{\n    \"@type\": \"Frage\",\n    \"name\": \"Wie verwende ich den SQL-Befehl UPDATE?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Um sie besser zu verstehen, sollten wir auf ihre wichtigsten Attribute eingehen, n\u00e4mlich: : Die SET-Klausel: Hiermit kannst du festlegen, durch was du die vorhandenen Daten ersetzen willst. Hier m\u00fcssen nur die Spalten angegeben werden, die ge\u00e4ndert werden sollen. Alle anderen behalten ihre aktuellen Werte bei. Die WHERE-Klausel: Damit legst du fest, wo sich die \u00c4nderungen beziehen.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Da sich Datenbanken st\u00e4ndig weiterentwickeln, ist es wichtig, dass du die UPDATE SQL-Abfrage kennst. Mit dieser Abfrage kannst du eine oder mehrere Zeilen in deiner Tabelle \u00e4ndern. Wie benutzt man sie also? Wir erkl\u00e4ren dir alles in diesem Artikel. Was ist SQL UPDATE ? Der Befehl SQL UPDATE wird verwendet, um Daten innerhalb einer Tabelle [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":177418,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2454],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL UPDATE : Daten mit diesem Befehl aktualisieren<\/title>\n<meta name=\"description\" content=\"Mit dem Befehl SQL UPDATE kannst du Daten in SQL aktualisieren. Du solltest allerdings unbedingt beachten, dass ...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL UPDATE : Daten mit diesem Befehl aktualisieren\" \/>\n<meta property=\"og:description\" content=\"Da sich Datenbanken st\u00e4ndig weiterentwickeln, ist es wichtig, dass du die UPDATE SQL-Abfrage kennst. Mit dieser Abfrage kannst du eine oder mehrere Zeilen\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren\" \/>\n<meta property=\"og:site_name\" content=\"Weiterbildung Data Science | DataScientest.com\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-01T08:53:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-30T09:00:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2023\/05\/update-sql-datascientest.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"5\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"SQL UPDATE : Daten mit diesem Befehl aktualisieren\",\"datePublished\":\"2023-06-01T08:53:34+00:00\",\"dateModified\":\"2023-10-30T09:00:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren\"},\"wordCount\":874,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/de\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren\",\"url\":\"https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren\",\"name\":\"SQL UPDATE : Daten mit diesem Befehl aktualisieren\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/de\/#website\"},\"datePublished\":\"2023-06-01T08:53:34+00:00\",\"dateModified\":\"2023-10-30T09:00:31+00:00\",\"description\":\"Mit dem Befehl SQL UPDATE kannst du Daten in SQL aktualisieren. Du solltest allerdings unbedingt beachten, dass ...\",\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/de\/#website\",\"url\":\"https:\/\/datascientest.com\/de\/\",\"name\":\"Weiterbildung Data Science | DataScientest.com\",\"description\":\"F\u00fchrender Anbieter von Schulungen im Bereich Data Science\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/de\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/de\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/company\/datascientest-germany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/de\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL UPDATE : Daten mit diesem Befehl aktualisieren","description":"Mit dem Befehl SQL UPDATE kannst du Daten in SQL aktualisieren. Du solltest allerdings unbedingt beachten, dass ...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren","og_locale":"de_DE","og_type":"article","og_title":"SQL UPDATE : Daten mit diesem Befehl aktualisieren","og_description":"Da sich Datenbanken st\u00e4ndig weiterentwickeln, ist es wichtig, dass du die UPDATE SQL-Abfrage kennst. Mit dieser Abfrage kannst du eine oder mehrere Zeilen","og_url":"https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren","og_site_name":"Weiterbildung Data Science | DataScientest.com","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-06-01T08:53:34+00:00","article_modified_time":"2023-10-30T09:00:31+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2023\/05\/update-sql-datascientest.webp","type":"image\/webp"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Verfasst von":"Melanie","Gesch\u00e4tzte Lesezeit":"5\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren#article","isPartOf":{"@id":"https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/de\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"SQL UPDATE : Daten mit diesem Befehl aktualisieren","datePublished":"2023-06-01T08:53:34+00:00","dateModified":"2023-10-30T09:00:31+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren"},"wordCount":874,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/de\/#organization"},"articleSection":["Data Science"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren","url":"https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren","name":"SQL UPDATE : Daten mit diesem Befehl aktualisieren","isPartOf":{"@id":"https:\/\/datascientest.com\/de\/#website"},"datePublished":"2023-06-01T08:53:34+00:00","dateModified":"2023-10-30T09:00:31+00:00","description":"Mit dem Befehl SQL UPDATE kannst du Daten in SQL aktualisieren. Du solltest allerdings unbedingt beachten, dass ...","inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/de\/#website","url":"https:\/\/datascientest.com\/de\/","name":"Weiterbildung Data Science | DataScientest.com","description":"F\u00fchrender Anbieter von Schulungen im Bereich Data Science","publisher":{"@id":"https:\/\/datascientest.com\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/de\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/de\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/datascientest.com\/de\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/de\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/company\/datascientest-germany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/de\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/datascientest.com\/de\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/de\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/posts\/177417"}],"collection":[{"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/comments?post=177417"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/posts\/177417\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/media\/177418"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/media?parent=177417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/categories?post=177417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/tags?post=177417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}