DAD 220 SNHU Create a MySQL D

Overview

Codio is an online integrated development environment (IDE) where you will perform the labs for this course. It will provide you with a place to practice many of the skills and abilities that are necessary in data science and analytics. In this assignment, you will practice using structured query language, or SQL, in Codio.

Prompt

Note: You should already have completed the tutorial on getting started with Codio before you begin this lab.

Go to your Codio lab environment and start a new terminal session to complete this assignment. Then, follow the steps below to get practice with MySQL. SQL is very sensitive to input. It’s important to note that spelling, capitalization, letters, numbers, and punctuation marks must be entered into Codio the exact way that they appear in your instructions. To prove that the commands you have written worked, capture them with a screenshot and place them in a document for submission. Your work should be organized like this example: Module One Lab Screenshot Example PDF.

Review the Additional Support section of this module for information that will assist you as you work through this lab.

To complete this lab, follow the steps outlined below:

  1. Create a new database and update the name to your last name, then connect to it. Type the following commands after the prompt mysql>
    1. Create database (last name here);
      1. For example, if your database is going to be named Jetson, then substitute Jetson for “last name here.”
      2. Press Enter.
    2. show databases;
      1. Press Enter.
      2. You should see a listing of all of the databases (or schemas) in MySQL, including the one you just created.
    3. use (last name here);
      1. Press Enter.
      2. Substitute the name of your database (for example, Jetson) for “last name here.” This SQL statement connects your MySQL session to the database you have just created.
      3. Capture a screenshot or clipping of the results of this action, and place it in a Word document for submission.
  2. Create a table called tb2 and list out the tables in your database with one field by typing the following commands after the prompt mysql>
    1. create table tb2 (user_id VARCHAR( 50 ));
      1. Press Enter.
    2. show tables;
      1. Press Enter.
    3. describe tb2;
      1. Press Enter.
      2. Capture a screenshot or clipping of the results of this action, and place it in a Word document for submission.
  3. Now, add a second field by entering the following commands after mysql>
    1. alter table tb2 add newfield VARCHAR(25);
      1. Press Enter.
    2. describe tb2;
      1. Press Enter.
      2. Capture a screenshot or clipping of the results of this action, and place it in a Word document for submission.
  4. Organize the resultant outputs of the commands you have written for submission, grading, and feedback. These should follow the guidelines presented in the example mentioned above.

Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount

Posted in Uncategorized