Create a mysql database- Database Management System
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.
