SQL Discussion Response 2

 

Please see below the discussion in response to the original question asked and respond as a peer using 150 or more words.

Original Question:  Explain SQL and its functions. What do you enjoy the most about learning SQL? What you find the most difficult? 

Peer Response:

 

SQL is a query language and one of the most popular database languages, mostly due to it not being too difficult to learn. Each SQL database systems have data definition language and data manipulation language. The data definition language is for database creation, change and maintenance. The data manipulation language (DML) is used for computing data within a database. The DML can also support functions like COUNT, which counts the number of rows meeting the selection criteria. CURRENT_DATE will return the current system date. AVG computed the total value of the column given. Some very basic and standard commands include, SELECT, INSERT, FROM, CREATE and DROP. 

I enjoyed how simple it was to understand the language. I have taken courses with other languages and this has been the least confusing. Being able to continue to build on what you already have is the best part. The most difficult was understanding the normalization forms. This was a big hurdle for me but once I got more of an understanding it became simpler to understand how I needed to do the diagrams. Also some of the syntaxes. in the trucks assignment it took me hours, and I mean hours, to fully understand where I was going wrong with some of them. But now I’ve become more aware of what to use and where to use it. 

(200 word minimum, 150-words summary, for each question)

1Q.

Using the Web, search for at least three (3) tools to automate risk assessment.

Collect information on automated risk assessment tools. 

●      How much do the tools cost?

●      What features do the tools provide?

●      What are the advantages and disadvantages of each tool?

2Q.

Professional written communication is a key skill required in the workplace. Provide an example of either documentation or written communication that you have done this week in your workplace. What was the result of the communication? In what ways could you potentially improve?

Problem 7- Proj Risk

Question 1.

Build a full risk management plan, including a complete risk matrix for a project for a wedding including the wedding itself, the reception and the dinner.  You own the wedding planning company doing this event. 

Question 2.

Create a three page paper with three references other than your text. Explain how the concepts of risk control and quality are related within the project management discipline.  How do the two knowledge areas impact one another?  Explain the work in these two areas from a strategic perspective. 

Question 3.

How does monitor and control play an intricate part in risk management?  How would this involve project communication?  Create a sample communication plan for a project which also includes a RACI as part of the plan.  Include at least 10 different individuals and organizations which must be included in the project communications.

Text-

Title: Managing Project Risks; 464 Pages ISBN: 978-1-119-48975-7 Authors: Peter J. Edwards, Paulo Vaz Serra, Michael Edwards Publisher: Wiley-Blackwell Publication Date: 2019 

Create User Access Policies

You are a security professional for a large, private health care organization. Users have access to file and application servers, as well as data storage facilities that contain customer health information and personally identifiable information (PII). Your organization needs to create user access policies and provide them to its employees.

Sean, your manager, asks you to write a report detailing relevant user access policies. He needs you to research a generic template and use that as a starting point from which to move forward.

For this assignment:

  1. Research existing policy templates and examples from organizations of a similar type.
  2. Write a report detailing at least three relevant user access policies based on your research.
    • Create a table for the policies.
    • Include a short summary explaining why you chose the policies.
    • Include an introduction and conclusion.
    • Provide citations for your sources.

I have a research paper due and I need a writer

Hello, I have a research paper in Managment of Cybersecurity due in April.  The checkpoint, which my outline will be due is 4/4/23.  I want to turn in the research paper on 4/15/23. Please see the upload for details.  I would like it 8 pages.

Social Engineering

Social engineering is the art of manipulating people so they give up confidential information. The types of information these criminals are seeking can vary, but when individuals are targeted the criminals are usually trying to trick you into giving them your passwords or bank information, or access your computer to secretly install malicious software – that will give them access to your passwords and bank information as well as giving them control over your computer.

Explain a scenario where you or someone you know may have unknowingly given too much personal information to a stranger. How could this situation be avoided? Need this in APA format in a word document with no less than 350 words with “Two references & Citations”

Reference Article Link: 

https://www.webroot.com/us/en/resources/tips-articles/what-is-social-engineering

Exp22_Excel_Ch04_ML1 – EBL Sporting Goods 1.1

Exp22_Excel_Ch04_ML1 – EBL Sporting Goods 1.1

Exp22_Excel_Ch04_ML1 – EBL Sporting Goods 1.1

Excel Chapter 4 Mid-Level 1 – EBL Sporting Goods 

  

Project Description:

You are the inventory manager for EBL Sporting Goods. EBL is a national sporting goods store with several warehouses. You are currently performing an analysis to determine inventory levels, as well as the total value of inventory on hand. Your last steps will be to check the report for duplicate entries and format for printing.

     

Start Excel. Download and open   the file named EXP22_Excel_Ch04_ML1_Inventory.xlsx.   Grader has automatically added your last name to the beginning of the   filename.

 

Freeze the panes at cell B2 so   that the column labels do not scroll offscreen.

 

Convert the data to a table and   name the table Inventory2024.

 

Apply Light Green, Table Style   Light 18 to the table.

 

Sort the table by Warehouse (A   to Z), then by Unit Price (smallest to largest), and then by Department.   Create a custom sort order for Department so that it displays in this   sequence: Training, Athletic Apparel, Footwear, Fitness, Outdoor Gear, and Toys.

 

Remove duplicate records from   the table. Excel should find and remove one duplicate record.

 

Create an unqualified structured   reference in column G to determine the value of the inventory on hand. To   calculate the inventory on hand, multiply the Unit Price and the Amount on   Hand.

 

Apply a Total Row to the   Inventory2024 table; set the Amount on Hand to Average. Format the results to   display with two decimal points.

 

Create a new conditional   formatting rule in column D that displays any Inventory Value for the Toys   department with a value of $10,000 or more as Red, Accent 2 fill color (the   6th color located on the top row of the Format Cells window) with White,   Background 1 font color. There will be two qualifying entries.

 

Ensure the warehouse information   is not broken up between pages when printed. Add a page break to make sure   that each warehouse prints on its own consecutive page.

 

Set the worksheet to Landscape   orientation and repeat row 1 labels on all pages and page order prints Down,   then over.

 

Display the Inventory sheet in   Page Break Preview.

 

Save and close EXP22_Excel_CH04_ML1_Inventory.xlsx.   Exit Excel.