This one is not required today or tonight. It is due by tomorrow night or you could say it's due in 36 hours or so.
For some reason I can't open this one. I could open last weeks with Workbench, but not this week's. I just downloaded SQL Workbench last week so I am not too familiar with it yet. When I open MySQL Work bench there are three main options: 1. SQL Development 2. Data Modeling 3. Server Administration. I am using option 1. SQL Development. Under that (on the left at the bottom) I am trying to open and run the file by clicking "edit sql script" but it won't let me open it. It prompts me for a password XXX I never set up a pw.
Any suggestions? Am I totally overlooking something very simple? Thanks in advance.
Okay, I will try this. Thanks. Where to find the sql window? Which nav button is it under or where exactly do you find it? Sorry, not at all familiar with this workbench yet lol.
Great, thanks! Very helpful.
I have new question. This question builds on the one from last week and uses that assignment. I have a not at the bottom following the question - it makes the answer much easier. Here is the question:
In this assignment, you will practice writing SQL statements.
Create scripts of SQL statements for the following situations:
In a Microsoft Word document, create a report that outlines the steps you took to create these scripts. Include the scripts in the report along with a description of the results that you achieved. With your results, include screen shots showing your results.
NOTE: The instructor changed the requirements to make it easier:
"Manually create the following scripts:
INSERT SQL Scripts
In a file create the INSERT Scripts that you would use to load the data that I provided in the Week 4 Problems and Solutions Discussion Area
SQL QUERY Script
Show in a file the script that you would use to query the database for the for one of the sales people that are assigned to multiple clients
Show in a file the script that you would use to produce a full client list by sales person
SQL QUERY Scripts
Show in a file the scripts that you would use to add a contact summary to one of your clients, then modify it, and then delete it"
So I have pasted the original assignment above, followed by the revised requirements. If you accept this one I will need it done in the next 12 hours or so.