Chat with us, powered by LiveChat Database Management SQL Tutorial | Gen Paper
+1(978)310-4246 credencewriters@gmail.com
  

I will Upload Word Document that has the instructions on it and you going to follow them.
you will need to go to

 dbf.do.mdzi.me/pma 

username: aa238205
Password:  pA6c7p5Dj6 

SQL Tutorial

So that you can experience writing and running SQL yourself, we are forgoing exercises from the book where you cannot test your statements and replacing it with this guide. This guide has embedded questions that you will need to enter the values for or paste screen shots where needed. It is worth 200 points (the value of exercises and case examples combined).

NOTE: Do NOT copy/paste code examples from this guide. Word embeds “smart quotes” into the document which are not compatible with phpMyAdmin. Please type the queries as you see them.

NOTE: MySQL can be case-sensitive. Please double-check the case on your statements when you enter them. My convention is that all table names and field names within our sample database will be lowercase, but that may not hold true for all databases. In addition, my convention for SQL keywords is to capitalize them within the statement.

Part 0 – Getting Started

Your Name: Click or tap here to enter text.

Part I – Logging In

1. Refer to the email sent to you at your SUNYSCCC.edu email address from me with the subject MySQL Credentials

2. Go to https://dbf.do.mdzi.me/pma

3. In the login box, enter your Username in the Username field and your Password in the Password field, then click Go

4. You will now be on the phpMyAdmin index page. The phpMyAdmin index page contains general server statistics information on the right and a tree of databases that you can access on the left. The databases include:

a. employees – a database with an example human resources system with a large number of seeded values *read-only*

b. information_schema – a system database containing a view into MySQL configuration *read-only*

c. menagerie – a small veterinary information database *read-only*

d. sakila – an example movie information database *read-only*

e. world – information about world cities *read-only*

f. hafh – book example database *read-only*

g. zagi – book example database *read-only*

h. zstu_s_*username* – a database for you to test in that you have read/write access on

5. Click on the [+] symbol next to sakila and then click on the [+] symbol next to Tables

6. Here, you see a list of database tables

7. Please use the Print Screen button on your computer and Paste a screenshot of your phpMyAdmin screen in the box below:

8. Note the tables in this database – they include actor, address, category, city, and more. phpMyAdmin allows you to view the table configuration settings and data without t

error: Content is protected !!