Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu05:aufgaben:01 [2024/09/25 11:31] – vdemir
+++ modul:m290:learningunits:lu05:aufgaben:01 [2024/10/24 08:21] (aktuell) – [Task E] vdemir
@@ Zeile 1: / Zeile 1: @@
-====== LU06.A01 - SQL-DDL: DB Management ======
+====== LU07.A01 - SQL-DDL: DB Management ======
 ===== Requirements  =====
@@ Zeile 5: / Zeile 5: @@
   * Timeframe: 15 Minutes
   * Means of aid:
-      * oOnly teaching materials, no websearch, no use of ai.
+      * Only teaching materials, no websearch, no use of ai.
       * [[https://dev.mysql.com/doc/refman/8.4/en/database-use.html | MySQL.com | CREATE and USE DATABASE]]
       * [[https://www.w3schools.com/sql/sql_create_db.asp | W3Schools | CREATE DATABASE]]
@@ Zeile 17: / Zeile 17: @@
 ===== Assignments =====
-  * a: Make sure, that your MySQL database system is running and connect with you webstorm editor to your database with your DBA credentials (user: root, password: yourPW).
+==== Task A ====
-  * b: Display all instances which are currently running on our database.
+Make sure, that your MySQL database system is running and connect with you webstorm editor to your database with your DBA credentials (user: root, password: yourPW).
-  * c: Create the instances “myDB_good”, “myDB_OK”, “myDB_obsolete” and display your result.
-  * d: Drop the instance "myDB_obsolete", as it obviously obsolete (no longer needed). Display the result.
+==== Task B ====
-  * e: Activate the instance "myDB_good" by using the USE command.
+Display all instances which are currently running on our database.
-  * f: Display the system date by using the command "SELECT sysdate();"
+==== Task C ====
+Create the database instances
+  * myDB_PERFECT
+  * myDB_OK
+  * myDB_OBSOLETE
+and display your result.
+==== Task D ====
+Drop the instance "myDB_obsolete", as it obviously obsolete (no longer needed). Display the result.
+==== Task E ====
+Activate the instance "myDB_PERFECT" by using the USE command.
+==== Task F ====
+Display the system date by using the command "SELECT sysdate();"
 ===== Solution =====
-[[modul:m290:learningunits:lu06:loesungen:l01|Lösung]]
+[[modul:m290:learningunits:lu05:loesungen:l01|Lösung]]
 ===== Vocabulary =====
 ^ English ^ German ^
-| ... | ... |
+| obsolete | überflüssig |
-| ... | ... |
+| credential | Berechtigungsnachweis |
 ----
 [[https://creativecommons.org/licenses/by-nc-sa/4.0/|{{https://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png}}]] Volkan Demir