LU06.A01 - SQL-DDL: DB Management

• Work type: Individual
• Timeframe: 15 Minutes
• Means of aid:
  • Only 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

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).

Display all instances which are currently running on our database.

Create the database instances

• myDB_PERFECT
• myDB_OK
• myDB_OBSOLETE

and display your result.

Drop the instance „myDB_obsolete“, as it obviously obsolete (no longer needed). Display the result.

Activate the instance „myDB_good“ by using the USE command.

Display the system date by using the command „SELECT sysdate();“

Lösung

Volkan Demir