Lab 3 – SQL EXERCISES

 

Lab Upload Three 

Joseph Dolan 

B00130057 

 

Lab 3 – SQL EXERCISES  

For lab 3 we learned how to complete a set of exercises to develop our understanding of SQL. 

 

• Create a database 
• Create tables using SQL statements 
• Insert data into the table using SQL 
• Perform Simple SQL queries 
• Update tables 
•  Drop the table 

 

 

 

Note- Part way through this lab I Ran into some problems but used other materials to finish blog. 

 

Set up 

To start i simply launched Laragan. It's important to make sure that your Apache server starts correctly and you're using the correct version of MYSQL. And then boot up PHP my admin by logging in. 

 

Setting up a database 

Click on the SQL table again and create database, uses to create a database and name it. use the named database to execute SQL commands simply click on it in the list of databases and then on the tab 

 

 

File location 

 

 

 

 

Making Tabels 

This time we're going to be creating the tables for the code so we're going to have to go onto the SQL tab. Check the syntax and paste this block of code inside. 

 

Finish of creating your table and then check in the structure tab to see if it's laid out correctly. We then want to insert multiple students into the table using T Dublin email accounts and Gmail accounts this is so for the lab exercise later we can query for them later. To do that you select all all students where email is like ‘%gmail.com’; 

 

Relationships 

Create a new table within the same folder have it looking lineup as seen on screen.