Assignment #8 due November 2nd, 2023

 Assignment #8 due November 2nd, 2023

BigQuery

Select a Public Dataset from the available BiQuery Datasets

Pick one of the Sample Queries available

Run the query

Export the output to a file

Email the file along with reason you picked the Dataset and explain
the data you are sending.

https://uconnstamfordslp.blogspot.com/p/bigquery-datasets.html

Don't pick my example

Assignment # 7 due 10/26/23

Assignment # 7 due 10/26/23

 https://uconnstamfordslp.blogspot.com/p/assignment-exercise-python-datastore.html 

Recreate the app engine project above and send me a working link from app engine screen.

Create a datastore entity called Custinfo 

Load programs per link Add your name to the html that the program displays 

Note: Need to have Google Translate API turned on in order to read data 

Email me me the app engine link

Assignment #6 Due 10/19/23

 

Assignment #6

Assignment #6 Due 10/19/23

Create a web site on your cloud storage bucket that will allow customers to add, change, delete and list their customer information via a custmain.html menu.

Using google cloud python functions, html forms and mysql database tables from the SQL customer table. 

https://uconnstamfordslp.blogspot.com/p/mysql-exercise.html 

https://uconnstamfordslp.blogspot.com/p/cloud-function-project-python.html

Note: use my instance of customer, No need to change any of the function code.

Send me link to the main html page e.g. https://storage.googleapis.com/jiacovacci/custmain.html

Assignment #5 due 10/12/23

 Assignment #5 due 10/12/23

Note: I need to assign your gmail to the project so please everyone email me your gmail address.

Create a database on the project 'uconn customers' using your first initial and last name.

Insert the values for your information and your state.

use the select command to list this formation on screen. Need to join the customer table and the state table in the select.

select customer.FirstName, customer.LastName, states.StateName from customer, states where customer.StateCode = states.StateCode;

Copy and paste the output in an email

https://uconnstamfordslp.blogspot.com/p/mysql-exercise.html

MySQL Exercise Creating and managing MySQL databases Go to SQL Note: For this exercise everyone will access the same project An email will go out to gmail ... uconnstamfordslp.blogspot.com

Midterm exam next Wednesday, Oct. 4th at 7:30pm and Monday Oct. 9th at 7:30pm.

 Midterm exam next Wednesday, Oct. 4^th  at 7:30pm and Monday Oct. 9^th at 7:30pm.

Short answers 

1. What is the Cloud?

2. Describe what a data center is?

3.What is a virtual machine?

4.What is Google Cloud Storage?

5. Explain the difference between zones and regions? 

6. What are the choices when selecting cloud storage classes?

7. Explain the concept of the Google app engine?

Assignment #4 due 10/5/23

 Assignment #4 due Thursday 10/5/23

Build a Python Invoicer program that lists 4 items that you want to
sell and produce a total.

Also, add a line for sales tax when you total the bill from CT (note sales tax is 6.35%)

Note you can not duplicate my items.

https://uconnstamfordslp.blogspot.com/p/python-invoicer.html

#!/usr/bin/python3
# DATA TYPE Examples
########## DICTIONARY #################
cust_name = input("Customer name: ")
cust_address = input(" Address: ")
cust_city = input(" City: ")
cust_state = input(" State: ")
cust_zip = input(" Zip: ")
print(cust_name)
print(cust_address)
items = {"plates" : 3, "cups" : 1, "glasses" : 2}
for x in items:
    print(x, items[x])
no_plates = input("Number of Plates: ")
no_cups = input("Number of Cups: ")
no_glasses = input("Number of Glasses: ")
total_plates = int(no_plates) * int(items["plates"])
total_cups = int(no_cups) * int(items["cups"])
total_glasses = int(no_glasses) * int(items["glasses"])
total_charge = int(total_plates) + int(total_cups) + int(total_glasses)
print(cust_name)
print(cust_address)
print(cust_city)
print(cust_zip)
print(total_charge)
myplates = "You Bought {} number of plates at {} = {} dollars."
print(myplates.format(no_plates, items["plates"], total_plates))
mycups = " {} number of cups at {} = {} dollars."
print(mycups.format(no_cups, items["cups"], total_cups))
myglasses = " {} number of glasses at {} = {} dollars."
print(myglasses.format(no_glasses, items["glasses"], total_glasses))
mytotal = " Total Amount Due = {} dollars."
print(mytotal.format(total_charge))

john_iacovacci1@cloudshell:~/pyprojects/assign4 (uconn-engr)$ python3
invoicer.py
Customer name: John
Address: 55 daffodil Rd
City: Stamford
State: CT
Zip: 06903
John
55 daffodil Rd
plates 3
cups 1
glasses 2
Number of Plates: 5
Number of Cups: 5
Number of Glasses: 5
John
55 daffodil Rd
Stamford
06903
30
You Bought 5 number of plates at 3 = 15 dollars.
5 number of cups at 1 = 5 dollars.
5 number of glasses at 2 = 10 dollars.
Total Amount Due = 30 dollars.
john_iacovacci1@cloudshell:~/pyprojects/assign4 (uconn-engr)$

email me the code and the output from the code

Midterm Exam

 Midterm exam for Wednesday's class it will be on Oct 4th and for Monday's class it will be October 9th.