LU06.A01 - SQL-DDL: DB Management

• Work type: Individual
• Timeframe: 15 Minutes
• Means of aid:
  • oOnly teaching materials, no websearch, no use of ai.
  • MySQL.com | CREATE and USE DATABASE
  • W3Schools | CREATE DATABASE
  • W3Schools | DROP DATABASE
• Expected result: Sementically and syntactically correct SQL statements according to the requirements of the case studies.

To deepen our new SQL knowledge, we need to practise. Our overall assingment at the beginning is to create, use and drop databases. In other words, in this task we will set up the „storerooms“ for our „data storage“.

Let's get started

• 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).
• b: Display all instances which are currently running on our database.
• 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.
• e: Activate the instance „myDB_good“ by using the USE command.
• f: Display the system date by using the command „SELECT sysdate();“

Lösung

Volkan Demir