CYB 230 Module Two Lab Worksheet (3)

docx

School

Seminole State College of Florida *

*We aren’t endorsed by this school

Course

2354C

Subject

Mechanical Engineering

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by SuperHumanKangarooPerson628

DAD 220 Module One Lab Guidelines and Rubric Overview Codio is an online integrated development environment (IDE) where you’ll perform the labs for this course. In this assignment, you'll practice using structured query language, or SQL, in Codio. Directions 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 needs very specific input language. 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 show that the commands you've written worked, capture them with a screenshot and place them in a document for submission. Your work should be organized like the Module One Lab Screenshot Example . Look at the Additional Support section in the Resources area of this module for information that will assist you as you work through this lab. To complete this lab, follow the steps shown below: 1. Begin working with Command line in MySQL by typing the following command: a. mysql i. Press Enter.

2. Create a new database and update the name to your last name, then connect to it. Type the following commands after the prompt mysql>: a. create database last_name_here; i. For example, if your database is going to be named Jetson, then substitute Jetson for "last_name_here." ii. Press Enter . b. show databases; i. Press Enter . ii. You should see a listing of all of the databases (or schemas) in MySQL, including the one you just created. c. use last_name_here; i. Press Enter . ii. Substitute the name of your database (for example, Jetson) for "last_name_here". This SQL statement connects your MySQL session to the database you've just created. iii. Capture a screenshot or clipping of the results of this action, and place it in a Word document for submission. 3. 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>:

a. create table tb2 (user_id VARCHAR( 50 )); i. Press Enter . b. show tables; i. Press Enter . c. describe tb2; i. Press Enter . ii. Capture a screenshot or clipping of the results of this action, and place it in a Word document for submission. 4. Add a second field into the table and describe it. Do this by entering the following commands after mysql>: a. alter table tb2 add newfield VARCHAR(25); i. Press Enter . b. describe tb2; i. Press Enter . ii. Capture a screenshot or clipping of the results of this action, and place it in a Word document for submission.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

5. Organize your work by following the guidelines presented in the example mentioned above. a. Follow standard guidelines for submitting the work to show that commands you've written for this lab worked. What to Submit Submit all screenshots, clippings, or text in a Word document with 12-point Times New Roman font, double spacing, and one-inch margins. Each screenshot and its explanation should be sized to approximately one quarter of the page, with a description written below the screenshot. CYB 230 Module Two Lab Worksheet Complete this worksheet by replacing the bracketed phrases in the Response column with the relevant information. Lab: Ubuntu Desktop Linux Installation Prompt Response In the lab section “Install Ubuntu Using a Custom Hard Disk Layout,” Step 25 , use your name for the user information and provide a screenshot of the output before clicking Continue . [Insert screenshot.] In the lab section “Installing Patches With the Ubuntu Software Updater,” Step 8 , provide a screenshot of the output before clicking Authenticate . [Insert screenshot.] What is the importance of keeping an operating system patched and up- to-date? [Insert short response.] Lab: Disk Maintenance and Data Recovery

Prompt Response In the lab section “Backing Up and Restoring Data,” provide a screenshot of the output of Step 51 . [Insert screenshot.] In the industry, desktops are typically cloned and images are used on multiple PCs. Explain how using the restore point utility can help with the rebuilding and testing of PCs. [Insert short response.] Lab: Patching, Securing Systems, and Configuring Anti-Virus Prompt Response In the lab section “Closing Unnecessary Ports,” Step 30 , insert your name at the command line below the output and include it in your screenshot. [Insert screenshot.] In the lab section “Exploitation and Patching,” Step 18 , insert your name at the command line below the output and include it in your screenshot. [Insert screenshot.] Explain why it is important to close ports that are not being used within a computer system. [Insert short response.]