Murach's MySQL, 4th Edition by
Joel Murach
Complete Chapter Solutions Manual
are included (Ch 1 to 20)
** Immediate Download
** Swift Response
** All Chapters included
** SQL Format Solutions
download-link available
,Table of Contents are given below
Chapter 1 An introduction to relational databases
Chapter 2 How to use MySQL Workbench and other development tools
Chapter 3 How to retrieve data from a single table
Chapter 4 How to retrieve data from two or more tables
Chapter 5 How to insert, update, and delete data
Chapter 6 How to code summary queries
Chapter 7 How to code subqueries
Chapter 8 How to work with data types
Chapter 9 How to use functions
Chapter 10 How to design a database
Chapter 11 How to create databases, tables, and indexes
Chapter 12 How to create views
Chapter 13 Language skills for writing stored programs
Chapter 14 How to use transactions and locking
Chapter 15 How to create stored procedures and functions
Chapter 16 How to create triggers and events
Chapter 17 An introduction to database administration
Chapter 18 How to secure a database
Chapter 19 How to backup and restore a database
Chapter 20 How to host a database with AWS
,1 My Guitar Shop Exercises for Murach’s MySQL (4th Edition)
Chapter 2
How to use MySQL Workbench
and other development tools
Before you start the exercises…
Before you start these exercises, you need to install the MySQL server and MySQL
Workbench. The procedures for doing this are provided in appendix A (Windows) and B
(macOS).
In addition, you’ll need to get the mgs_ex_starts directory from your instructor. This
directory contains some script files that you need to do the exercises.
Exercises
In these exercises, you’ll use MySQL Workbench to create the My Guitar Shop database,
to review the tables in this database, and to enter SQL statements and run them against
this database.
Make sure the MySQL server is running
1. Start MySQL Workbench and open a connection for the root user.
2. Check whether the MySQL server is running. If it isn’t, start it.
Use MySQL Workbench to create the My Guitar Shop database
3. Open the script file named create_my_guitar_shop.sql that’s in the mgs_ex_starts
directory by clicking the Open SQL Script File button in the SQL Editor toolbar.
Then, use the resulting dialog box to locate and open the file.
4. Execute the entire script by clicking the Execute SQL Script button in the SQL editor
toolbar or by pressing Ctrl+Shift+Enter. When you do, the Output window displays
messages that indicate whether the script executed successfully.
Use MySQL Workbench to review the My Guitar Shop database
5. In the Schemas category of the Navigator window, expand the node for the database
named my_guitar_shop so you can see all of the database objects it contains. If it
isn’t displayed in the Schemas tab of the Navigator window, you may need to click
on the Refresh button to display it.
6. View the data for the Categories and Products tables.
7. Navigate through the database objects and view the column definitions for at least the
Categories and Products tables.
, 2 My Guitar Shop Exercises for Murach’s MySQL (4th Edition)
Use MySQL Workbench to enter and run SQL statements
8. Double-click on the my_guitar_shop database to set it as the default database. When
you do that, MySQL Workbench should display the database in bold.
9. Open a SQL editor tab. Then, enter and run this SQL statement:
SELECT product_name FROM products
10. Delete the e at the end of product_name and run the statement again. Note the error
number and the description of the error.
11. Open another SQL editor tab. Then, enter and run this statement:
SELECT COUNT(*) AS number_of_products
FROM products
Use MySQL Workbench to open and run scripts
12. Open the script named product_details.sql that’s in the mgs_ex_starts directory. Note
that this script contains just one SQL statement. Then, run the statement.
13. Open the script named product_summary.sql that’s in the mgs_ex_starts directory.
Note that this opens another SQL editor tab.
14. Open the script named product_statements.sql that’s in the mgs_ex_starts directory.
Notice that this script contains two SQL statements that end with semicolons.
15. Press the Ctrl+Shift+Enter keys or click the Execute SQL Script button to run both of
the statements in this script. Note that this displays the results in two Result tabs.
Make sure to view the results of both SELECT statements.
16. Move the cursor into the first statement and press Ctrl+Enter to run just that
statement.
17. Move the cursor into the second statement and press Ctrl+Enter to run just that
statement.
18. Exit from MySQL Workbench.
Joel Murach
Complete Chapter Solutions Manual
are included (Ch 1 to 20)
** Immediate Download
** Swift Response
** All Chapters included
** SQL Format Solutions
download-link available
,Table of Contents are given below
Chapter 1 An introduction to relational databases
Chapter 2 How to use MySQL Workbench and other development tools
Chapter 3 How to retrieve data from a single table
Chapter 4 How to retrieve data from two or more tables
Chapter 5 How to insert, update, and delete data
Chapter 6 How to code summary queries
Chapter 7 How to code subqueries
Chapter 8 How to work with data types
Chapter 9 How to use functions
Chapter 10 How to design a database
Chapter 11 How to create databases, tables, and indexes
Chapter 12 How to create views
Chapter 13 Language skills for writing stored programs
Chapter 14 How to use transactions and locking
Chapter 15 How to create stored procedures and functions
Chapter 16 How to create triggers and events
Chapter 17 An introduction to database administration
Chapter 18 How to secure a database
Chapter 19 How to backup and restore a database
Chapter 20 How to host a database with AWS
,1 My Guitar Shop Exercises for Murach’s MySQL (4th Edition)
Chapter 2
How to use MySQL Workbench
and other development tools
Before you start the exercises…
Before you start these exercises, you need to install the MySQL server and MySQL
Workbench. The procedures for doing this are provided in appendix A (Windows) and B
(macOS).
In addition, you’ll need to get the mgs_ex_starts directory from your instructor. This
directory contains some script files that you need to do the exercises.
Exercises
In these exercises, you’ll use MySQL Workbench to create the My Guitar Shop database,
to review the tables in this database, and to enter SQL statements and run them against
this database.
Make sure the MySQL server is running
1. Start MySQL Workbench and open a connection for the root user.
2. Check whether the MySQL server is running. If it isn’t, start it.
Use MySQL Workbench to create the My Guitar Shop database
3. Open the script file named create_my_guitar_shop.sql that’s in the mgs_ex_starts
directory by clicking the Open SQL Script File button in the SQL Editor toolbar.
Then, use the resulting dialog box to locate and open the file.
4. Execute the entire script by clicking the Execute SQL Script button in the SQL editor
toolbar or by pressing Ctrl+Shift+Enter. When you do, the Output window displays
messages that indicate whether the script executed successfully.
Use MySQL Workbench to review the My Guitar Shop database
5. In the Schemas category of the Navigator window, expand the node for the database
named my_guitar_shop so you can see all of the database objects it contains. If it
isn’t displayed in the Schemas tab of the Navigator window, you may need to click
on the Refresh button to display it.
6. View the data for the Categories and Products tables.
7. Navigate through the database objects and view the column definitions for at least the
Categories and Products tables.
, 2 My Guitar Shop Exercises for Murach’s MySQL (4th Edition)
Use MySQL Workbench to enter and run SQL statements
8. Double-click on the my_guitar_shop database to set it as the default database. When
you do that, MySQL Workbench should display the database in bold.
9. Open a SQL editor tab. Then, enter and run this SQL statement:
SELECT product_name FROM products
10. Delete the e at the end of product_name and run the statement again. Note the error
number and the description of the error.
11. Open another SQL editor tab. Then, enter and run this statement:
SELECT COUNT(*) AS number_of_products
FROM products
Use MySQL Workbench to open and run scripts
12. Open the script named product_details.sql that’s in the mgs_ex_starts directory. Note
that this script contains just one SQL statement. Then, run the statement.
13. Open the script named product_summary.sql that’s in the mgs_ex_starts directory.
Note that this opens another SQL editor tab.
14. Open the script named product_statements.sql that’s in the mgs_ex_starts directory.
Notice that this script contains two SQL statements that end with semicolons.
15. Press the Ctrl+Shift+Enter keys or click the Execute SQL Script button to run both of
the statements in this script. Note that this displays the results in two Result tabs.
Make sure to view the results of both SELECT statements.
16. Move the cursor into the first statement and press Ctrl+Enter to run just that
statement.
17. Move the cursor into the second statement and press Ctrl+Enter to run just that
statement.
18. Exit from MySQL Workbench.
