modul:m290:learningunits:lu07:aufgaben:03

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Nächste Überarbeitung		 Vorhergehende Überarbeitung
modul:m290:learningunits:lu07:aufgaben:03 [2024/10/01 09:53] – angelegt vdemirmodul:m290:learningunits:lu07:aufgaben:03 [2024/10/17 12:45] (aktuell) – vdemir
Zeile 1: Zeile 1:
-====== LU07.A03 - INSERT INTO ======+====== LU08.A03 - UPATE ======
  
 ===== Requirements  ===== ===== Requirements  =====
Zeile 6: Zeile 6:
   * Means of aid:    * Means of aid: 
       * Only teaching materials, no websearch, no use of ai.       * Only teaching materials, no websearch, no use of ai.
-  * Expected Result: eployee's data are updated according to the requirements below+  * Expected Result: employee's data are updated according to the requirements below
  
 ===== Assignments ===== ===== Assignments =====
 In assignment A2 you imported 30 lines of date to the table 'employees'. In this assignment your task is to perform some DML update commands. In assignment A2 you imported 30 lines of date to the table 'employees'. In this assignment your task is to perform some DML update commands.
  
-==== A: Update with OR ====+==== A: Basic Update ==== 
 +The employee ‘Laura Clark’ got divorced and therefore took her maiden name. Update her data record in the table. 
 + 
 +==== B: Update with OR ====
 As a company policy the attribute 'sex' is not required anymore and is to be emptied. Formulate the corresponding SQL statement that deletes all content from that column. As a company policy the attribute 'sex' is not required anymore and is to be emptied. Formulate the corresponding SQL statement that deletes all content from that column.
  
-  UPDATE employees +==== C: Update with AND ==== 
-  SET sex = '' +The performance of our company's IT department was outstanding last year, resulting in a pay rise to 70'000 for all IT employees earning less than 70,000. Create a DML update command that covers the requirements.
-  WHERE sex = 'M' OR sex = 'F'; +
-   +
-After performing the update statement, the select on the table 'employee' shows that the column 'sex' is now empty. +
- +
-{{:modul:m290:learningunits:lu07:aufgaben:lu07.s03a.png?800|}} +
- +
- +
-==== B: One single INSERT statement ==== +
-After inserting 10 lines of data with 10 separate SQL commands, the next step is to do the import with one single SQL commands, which is basicly more compact and more efficient, that the first approach. Insert the following 20 lines of data into the table "employees".+
  
-   
 ===== Solution ===== ===== Solution =====
-[[modul:m290:learningunits:lu07:loesungen:l02|Lösung]]+[[modul:m290:learningunits:lu07:loesungen:l03|Lösung]]
  
 ===== Vocabulary ===== ===== Vocabulary =====
  • modul/m290/learningunits/lu07/aufgaben/03.1727769215.txt.gz
  • Zuletzt geändert: 2024/10/01 09:53
  • von vdemir