LU06.S01 - SQL-DDL: DB Management
Solutions
Task 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).
Windows
CTRL + Shift + ESC –> Dienste –> Filtering the resultset to MySQL
MacOS …
Task B
Display all instances which are currently running on our database.
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_good“ by using the USE command.
Task F
Display the system date by using the command „SELECT sysdate();“
Congratulations!! You have just received a first respond from your database „mydb_perfect“.
Vocabulary
| English | German |
|---|---|
| obsolete | überflüssig |
| credential | Berechtigungsnachweis |
Volkan Demir