Lab One - SQL Start up part 1

Lab One 

Step 1 

Straight off the bat we downloaded a program called Laragon and also a program called PHP my admin. once both programs were installed you want to extract the PHP my admin file into the directory,  

Largon>ect apps 

This now allows you to use pH my admin true Laragan local hosting 






Step 2 

Open PHP, my admin, by using the widget at the bottom of the windows taskbar. The reason why we're doing this is that we're going to create some selections within a table on the database. So create I new table. and fill out the criteria that you wish to catalogue. I've chosen a game store and several games at the game store will have in stock or on display. 




It's very important that you make sure you have a key and unique attributes within your list. 

 

Step 3 

Next up was making a query, a query is a way for us to discover particular items on the table by excluding properties of the items that we're not looking for. 

For example in the image below as you can see you can set it to select from games weather prices under 20. 



once you clear the underline you can see that it's showing Rayman 2-3 and x But it's excluding the original Rayman game which is priced at 20. at its core, this is how the query tool works and helps you search through large volumes of items efficiently. 

In the table below you're able to see that there is delete buttons for each row, you can use it query tool defined items that you are looking to remove and remove that single item from a massive list. 

And if you're looking to remove an entire list it can be done so in the browse tab. 




Comments

Post a Comment

Popular posts from this blog

Adobe Max 2021 from a UX and UI perspective

Image
  Adobe Max 2021 from a UX and UI perspective   Joseph Dolan   B00130057     Intro   This blog post is going to consist of my experience and my opinion on the Adobe Max 2021 Create together stream. Straight off the bat I'd like to say overall, I'm relatively excited and disappointed on this conference. they show off a lot of new and interesting collaborative tools and AI tools that will speed up peoples work process in a very interesting and intuitive way. but Adobe has still failed to realize that the biggest problem with their software's its self. Adobe software's notorious for crashing and running badly. Apartment example that I use is Adobe premiere pro and after effects these two programs constantly crash when working between one another I work on a high-end device and run into frequent problems.  so,  it is a little disappointing that they have not addressed their optimization as it's what I believe to be there  Achilles's  heel. ...
Read more

Lab 3 – SQL EXERCISES

Image
  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 exec...
Read more

Lab Two - SQL Start up part 2

Image
    Create and Relate Tables     Step 1   This lab we're learning how to create and relate tables so to start off straight off the bat I need to create a single table, editorial video the lecturer uses movie directors and movies as his criteria for this list or management system. I have opted to put my personal touch on it and have game makers  and  games from my list almost approved that I've done the work myself.   So  I created my first list with titles of basic information at the game designer would have as seen in the image below. all the while keeping very sure that I have a prime  key.( primary key)       Step 2   next was the list that would be displaying information for the games themselves, including their creator this is  the  shared ID that these two lists  have.( what will be linking them together)   Once again ensure that game ID in this list is set to your prime key and you migh...
Read more