Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu07:aufgaben:02 [2024/10/01 08:44] – vdemir
+++ modul:m290:learningunits:lu07:aufgaben:02 [2024/10/17 12:45] (aktuell) – vdemir
@@ Zeile 1: / Zeile 1: @@
-====== LU07.A02 - INSERT INTO ======
+====== LU08.A02 - INSERT INTO ======
 ===== Requirements  =====
@@ Zeile 8: / Zeile 8: @@
   * Expected Result:
     * At least 30 rows of employees data, inserted into the **table employees**.
-    * At least 10 rows are inserted with 10 separate inserts statements.
+    * 10 of the 30 rows are inserted with 10 separate insert statements.
-    * At least 20 rows of data inserted with one single SQL statement.
+    * 20 of the 30 rows are inserted with one single SQL statement.
 ===== Assignments =====
@@ Zeile 28: / Zeile 28: @@
 ==== B: One single INSERT statement ====
-To exercise the DML commands, we need a suitable table including a reasonable amout of data. The following SQL statement will create a table **employee** regarding all necessary attributes of an "average employee".
+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"
 , 'Ryan', 'Turner', '1991-05-21', 'M', 'He/Him', '2017-07-19', 70000.00, 'Marketing'