Skip to content

Homework#1

Open
franklinen wants to merge 9 commits intomainfrom
homework
Open

Homework#1
franklinen wants to merge 9 commits intomainfrom
homework

Conversation

@franklinen
Copy link
Copy Markdown
Owner

What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)

added homework1 draw.io file

What did you learn from the changes you have made?

how to create table relationship diagrams

Was there another approach you were thinking about making? If so, what approach(es) were you thinking of?

no other approaches

Were there any challenges? If so, what issue(s) did you face? How did you overcome it?

no challenges

How were these changes tested?

downloading the file and checking content

A reference to a related issue in your repository (if applicable)

none

Checklist

  • I can confirm that my changes are working as intended

@SidraBushra
Copy link
Copy Markdown

Hello Frankline, I am unable to see your model picture, can you please take screenshot of the model you created on draw.io, and save it as PNG or JPEG then submit it so I can see it. Thanks

@franklinen
Copy link
Copy Markdown
Owner Author

homework_1

@franklinen
Copy link
Copy Markdown
Owner Author

franklinen commented Sep 15, 2024

homework is added as png file in comment

Copy link
Copy Markdown
Owner Author

@franklinen franklinen left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)
completed homework2

What did you learn from the changes you have made?
how to query SQL tables

Was there another approach you were thinking about making? If so, what approach(es) were you thinking of?
no other approaches

Were there any challenges? If so, what issue(s) did you face? How did you overcome it?
no challenges

How were these changes tested?
run the query against the table to show output

A reference to a related issue in your repository (if applicable)
none

Checklist
[ ] I can confirm that my changes are working as intended

@SidraBushra
Copy link
Copy Markdown

Thanks HW1 marked.

@franklinen
Copy link
Copy Markdown
Owner Author

Homework 3 completed

What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)
completed homework3

What did you learn from the changes you have made?
how to create temporary tables
how to query table date columns

Was there another approach you were thinking about making? If so, what approach(es) were you thinking of?
no other approaches

Were there any challenges? If so, what issue(s) did you face? How did you overcome it?
no challenges

How were these changes tested?
run the query against the table to show output

A reference to a related issue in your repository (if applicable)
none

Checklist
[ ] I can confirm that my changes are working as intended

@franklinen
Copy link
Copy Markdown
Owner Author

What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)
completed homework4

What did you learn from the changes you have made?
how to query SQL tables and produce common table expressions

Was there another approach you were thinking about making? If so, what approach(es) were you thinking of?
no other approaches

Were there any challenges? If so, what issue(s) did you face? How did you overcome it?
no challenges

How were these changes tested?
run the query against the table to show output

A reference to a related issue in your repository (if applicable)
none

Checklist
[ ] I can confirm that my changes are working as intended

@franklinen
Copy link
Copy Markdown
Owner Author

Homework 5 and 6 completed
What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)
completed homework 5 and 6

What did you learn from the changes you have made?
Advanced SQL queries
Data ethics and principles

Was there another approach you were thinking about making? If so, what approach(es) were you thinking of?
no other approaches

Were there any challenges? If so, what issue(s) did you face? How did you overcome it?
no challenges

How were these changes tested?
run the query against the table to show the output

A reference to a related issue in your repository (if applicable)
none

Checklist
[ ] I can confirm that my changes are working as intended

@SidraBushra
Copy link
Copy Markdown

HW 2, 3, 4, 5, 6 marked.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants