IT 1025 – IT Concepts for Programmers

Our academic experts are ready and waiting to assist with any writing project you may have. From simple essay plans, through to full dissertations, you can guarantee we have a service perfectly matched to your needs.

GET A 40% DISCOUNT ON YOU FIRST ORDER

ORDER NOW DISCOUNT CODE >>>> WELCOME40

IT 1025 – IT Concepts for Programmers
Lab 6 – Information & Data Analytics
Continuing in Lab 6 you have the requirement to upload your file to a cloud storage environment, share the
file and, include your shared link with your lab submission (files will still be uploaded as in the past.)
Here is the link to the lab requirements:
https://sites.google.com/site/ccit1025/labrequirementswithsharedlink
Start by reviewing the Foundation Skills for Lesson 6: https://sites.google.com/site/ccit1025/home/lesson-6
If you are completely new to database and SQL review the resource to prepare for the lab.
Tasks for Lab 6 (see rubric for points/task):
1. Read Chapter 4 – Data and Databases:
a. Consider a trip to your local grocery store. Give an example: data, information and knowledge
that you would come across in this experience and explain how the items fit each definition.
b. When considering a relational database explain how products and orders might be related
following? Be sure to outline the tables for each and what would be a common field.
c. Explain why it is important to determine the correct data type for each field of data (you might
want to think back to the data issues you explored in lab 2.)
d. What is SQL and how is it important on today’s Internet?
2. Big Data: review the article “Big Data – How big data is driving technological innovation” and respond
to the following: How is big data disruptive and at the same time important for business success? Feel
free to use additional resources if necessary.
3. To experience database processing first hand, you will be reviewing the tutorial from w3schools.com to
become familiar with and practice SQL.
a. Follow the link for w3Schools on the course site.
b. As you begin the tutorial you will see a “Try it yourself” button. Click this button (this opens in a
new window so the SQL tutorial window is still available) and view the code: SELECT * FROM
Customers;
c. Click the “Run SQL” button and view the results.
d. If you do not see a list of tables on the right click “Restore Database”
e. Pick a table on the right and view the code generated in the window. Notice when you do this it
automatically reruns the code and new output is displayed.
f. The tables you see here are from the “Northwind” database created by Microsoft as a
representative normalized database meant for practicing database concepts.
g. Continue through the tutorial (click “Start learning SQL now!” below the “Try it Yourself”
window or “SQL Intro” to the left) up to and including “SQL Order By” (note that when you click
IT 1025 – IT Concepts for Programmers
the “Try it yourself” option this opens in a new window, you may want to close this window as
you continue) and complete/answer the following:
i. Explain the code: SELECT * FROM Customers (using the terminology you have learned
in the tutorial.)
ii. Write a query (SQL statements are called “queries”) to select ProductName, Unit and
Price (note that SQL is case sensitive) from the Products table and sort by Price (submit
both your query code and a screenshot (just one screen) of your output.)
iii. Edit your last query to select only those products with a price lower than $20 (submit
both your query code and a screenshot of your output.)
iv. Write a query to select SupplierName, City and Country from the Suppliers table where
the Country is Germany sorted by Country (submit both your query code and a
screenshot (just one screen) of your output.)
4. Under “Expert Organizations” visit the ISO site and respond to the following:
a. Who develops ISO standards?
b. Give some examples of the standards developed by ISO.
c. Use the search box and find a standard that pertains to SQL. Explain the nature and scope of
the standard.
5. In addition to data representation issues, SQL Injections are an issue in database design and potential
threat to information security. Review the “SQL: Injections” link the “CISCO” link to more details on SQL
Injections and respond to the following:
a. Select a type of SQL injection and explain the impact of the attack. Do additional research to
find an example of the attack.
b. Explain network defenses that can be implemented to protect against SQL injection attacks.
Be sure to follow the submission guidelines for your lab (include title page, executive summary and conclusion.)
Your Name
IT025: Lab #
Date
Semester, Year
Executive Summary
***You will delete this explanation and provide your own summary of the assignment – this is just a
little more detail on what is meant by an “executive summary”***
Please read the entire lab and provide an overview of what you will be doing. For example: I will be
presenting information on the process for binary conversion and answering questions about this history
of computing. I will also include diagrams and code for required programming components etc. (this is
only an example.)
Obviously this information would relate to the assignment / lab that you are currently completing. It
should be a discussion as if you were explaining to someone what you had to do for class this week.
Summaries are very important in IT and are also called “scope”. Scope details what will be included in a
proposal and sometimes more importantly, what will not be included (so that someone is not expecting
more than what you intend to do.) Please let me know if you have any questions or concerns.
After the executive summary the headings will vary depending on the project but, I have included a few
possibilities that you can edit as necessary.
All lab assignments will end with a conclusion. This should be your professional review of the topics
such as: where there were issues, what you found interesting or, what additional steps you may have
taken. Your tone in this review should be directed as if you were speaking to an employer or customer
about the tasks (view your completed assignment as a tool for your “toolkit”.)
The ultimate goal in the format of these projects is to start a portfolio foundation that you can use in
future classes or for prospective employers. Good luck and, always let me know if you have a question.
Early Computer Inventions
What is an Information System?
Careers in IT
Ethics and Intellectual Property
Conclusion

Our academic experts are ready and waiting to assist with any writing project you may have. From simple essay plans, through to full dissertations, you can guarantee we have a service perfectly matched to your needs.

GET A 40% DISCOUNT ON YOU FIRST ORDER

ORDER NOW DISCOUNT CODE >>>> WELCOME40

 

 

Posted in Uncategorized

IT 1025 – IT Concepts for Programmers

Our academic experts are ready and waiting to assist with any writing project you may have. From simple essay plans, through to full dissertations, you can guarantee we have a service perfectly matched to your needs.

GET A 40% DISCOUNT ON YOU FIRST ORDER

ORDER NOW DISCOUNT CODE >>>> WELCOME40

IT 1025 – IT Concepts for Programmers
Lab 6 – Information & Data Analytics
Continuing in Lab 6 you have the requirement to upload your file to a cloud storage environment, share the
file and, include your shared link with your lab submission (files will still be uploaded as in the past.)
Here is the link to the lab requirements:
https://sites.google.com/site/ccit1025/labrequirementswithsharedlink
Start by reviewing the Foundation Skills for Lesson 6: https://sites.google.com/site/ccit1025/home/lesson-6
If you are completely new to database and SQL review the resource to prepare for the lab.
Tasks for Lab 6 (see rubric for points/task):
1. Read Chapter 4 – Data and Databases:
a. Consider a trip to your local grocery store. Give an example: data, information and knowledge
that you would come across in this experience and explain how the items fit each definition.
b. When considering a relational database explain how products and orders might be related
following? Be sure to outline the tables for each and what would be a common field.
c. Explain why it is important to determine the correct data type for each field of data (you might
want to think back to the data issues you explored in lab 2.)
d. What is SQL and how is it important on today’s Internet?
2. Big Data: review the article “Big Data – How big data is driving technological innovation” and respond
to the following: How is big data disruptive and at the same time important for business success? Feel
free to use additional resources if necessary.
3. To experience database processing first hand, you will be reviewing the tutorial from w3schools.com to
become familiar with and practice SQL.
a. Follow the link for w3Schools on the course site.
b. As you begin the tutorial you will see a “Try it yourself” button. Click this button (this opens in a
new window so the SQL tutorial window is still available) and view the code: SELECT * FROM
Customers;
c. Click the “Run SQL” button and view the results.
d. If you do not see a list of tables on the right click “Restore Database”
e. Pick a table on the right and view the code generated in the window. Notice when you do this it
automatically reruns the code and new output is displayed.
f. The tables you see here are from the “Northwind” database created by Microsoft as a
representative normalized database meant for practicing database concepts.
g. Continue through the tutorial (click “Start learning SQL now!” below the “Try it Yourself”
window or “SQL Intro” to the left) up to and including “SQL Order By” (note that when you click
IT 1025 – IT Concepts for Programmers
the “Try it yourself” option this opens in a new window, you may want to close this window as
you continue) and complete/answer the following:
i. Explain the code: SELECT * FROM Customers (using the terminology you have learned
in the tutorial.)
ii. Write a query (SQL statements are called “queries”) to select ProductName, Unit and
Price (note that SQL is case sensitive) from the Products table and sort by Price (submit
both your query code and a screenshot (just one screen) of your output.)
iii. Edit your last query to select only those products with a price lower than $20 (submit
both your query code and a screenshot of your output.)
iv. Write a query to select SupplierName, City and Country from the Suppliers table where
the Country is Germany sorted by Country (submit both your query code and a
screenshot (just one screen) of your output.)
4. Under “Expert Organizations” visit the ISO site and respond to the following:
a. Who develops ISO standards?
b. Give some examples of the standards developed by ISO.
c. Use the search box and find a standard that pertains to SQL. Explain the nature and scope of
the standard.
5. In addition to data representation issues, SQL Injections are an issue in database design and potential
threat to information security. Review the “SQL: Injections” link the “CISCO” link to more details on SQL
Injections and respond to the following:
a. Select a type of SQL injection and explain the impact of the attack. Do additional research to
find an example of the attack.
b. Explain network defenses that can be implemented to protect against SQL injection attacks.
Be sure to follow the submission guidelines for your lab (include title page, executive summary and conclusion.)
Your Name
IT025: Lab #
Date
Semester, Year
Executive Summary
***You will delete this explanation and provide your own summary of the assignment – this is just a
little more detail on what is meant by an “executive summary”***
Please read the entire lab and provide an overview of what you will be doing. For example: I will be
presenting information on the process for binary conversion and answering questions about this history
of computing. I will also include diagrams and code for required programming components etc. (this is
only an example.)
Obviously this information would relate to the assignment / lab that you are currently completing. It
should be a discussion as if you were explaining to someone what you had to do for class this week.
Summaries are very important in IT and are also called “scope”. Scope details what will be included in a
proposal and sometimes more importantly, what will not be included (so that someone is not expecting
more than what you intend to do.) Please let me know if you have any questions or concerns.
After the executive summary the headings will vary depending on the project but, I have included a few
possibilities that you can edit as necessary.
All lab assignments will end with a conclusion. This should be your professional review of the topics
such as: where there were issues, what you found interesting or, what additional steps you may have
taken. Your tone in this review should be directed as if you were speaking to an employer or customer
about the tasks (view your completed assignment as a tool for your “toolkit”.)
The ultimate goal in the format of these projects is to start a portfolio foundation that you can use in
future classes or for prospective employers. Good luck and, always let me know if you have a question.
Early Computer Inventions
What is an Information System?
Careers in IT
Ethics and Intellectual Property
Conclusion

Our academic experts are ready and waiting to assist with any writing project you may have. From simple essay plans, through to full dissertations, you can guarantee we have a service perfectly matched to your needs.

GET A 40% DISCOUNT ON YOU FIRST ORDER

ORDER NOW DISCOUNT CODE >>>> WELCOME40

 

 

Posted in Uncategorized