ITS410 Database Management Study guides, Class notes & Summaries
Looking for the best study guides, study notes and summaries about ITS410 Database Management? On this page you'll find 2 study documents about ITS410 Database Management.
All 2 results
Sort by
-
ITS410: DATABASE MANAGEMENT COURSE
- Package deal • 4 items • 2022
-
- $15.49
- + learn more
Working with MySQL Table Joins
Changing a MySQL Table Structure
Performing an Advanced MySQL Query
Configuring a MySQL Database
-
Changing a MySQL Table Structure
- Other • 5 pages • 2022
- Available in package deal
-
- $8.29
- + learn more
Option #2: Changing a MySQL Table Structure 
Using the "classicmodels" database you installed in Module 1 and your MySQL Workbench, add a JSON field named "customers_contacts" to the "customers" table with the following keys: 
 
customerNumber, 
contactLastName, and 
contactFirstName. 
Write a SQL statement to insert at least three values for the "customers_contacts" field. Use data from the customers table. If you need a hint on how to write the SQL insert statement for a JSON data type...
Get paid weekly? You can!
That summary you just bought made someone very happy. Also get paid weekly? Sell your study resources on Stuvia! Discover all about earning on Stuvia