STEP 1: Logging in to Omnymbus

• Look at your email account to obtain the MySQL/Omnymbus account and password that your Professor has emailed to you.

• To help you log into MySQL Omnymbus environment, download the tutorial Login MySQL Omnymbus Environment in the Doc-Sharing folder titled "Omnymbus Tutorial Files".

STEP 2: Create a Database and modify your script to reference your Database

Create a MySQL database:

• Download the tutorial Creating a Database in MySQL Omnymbus Environment from the folder in Doc-Sharing titled Omnymbus Tutorial Files. Follow the steps to create a database in MySQL, especially paying attention to the database naming conventions specified in the tutorial.

• Download the WeekOneiLabScript.sqlfile from Doc Sharing in the folder titled iLab Documents

STEP 3: Running script file in MySQL, create SQL SELECT Queries

Run scripts files in MySQL:

• Download the tutorial Running SQL Scripts in MySQL Omnymbus environment from the folder in Doc-Sharing titled Omnymbus Tutorial Files. Follow those steps to help execute the WeekOneiLabScript.sql file needed to create the needed tables and to insert data into them.

Create SQL SELECT Queries:

• Using the data in the Student table in the database, create a SQL script file named LastName_Lab1_Query.sql, containing queries to execute each of the tasks below.

• To reference, learn and apply MySQL's own dialect of the SQL language to this iLab, browse through the file M10C_KROE8352_13_SE_WC10C.pdf in the Doc-Sharing folder titled My SQL Documents.

Attachment:- database.rar