Day 86 of 100 Days of Code & Scrum: SELECT Within SELECT, Aggregate Functions In SQL, and Other Stuff

This content originally appeared on DEV Community and was authored by Rammina

Greetings, everyone!

Today, I worked on a lot of different things. I made some progress with learning SQL and Next.js as well as coding the Terms of Use page for my business site. Not too bad I'd say.

Note: The character in the thumbnail is Lena from 86.

Anyway, let's move on to my daily report!

Yesterday

I set my goals for this week, which are:

finish the Terms of Use and Privacy Policy pages, and then deploy them.
learning more SQL, Next.js, and Scrum.

Today

Next.js

learned how to render markdown as JSX.
continued going through Next.js & React by Maximilian Schwarzmüller.

SQL

practice doing nested SELECTs.
learn more about how correlated subqueries work.
learned how to use aggregate functions, SUM and COUNT.
continued to go through SQLZoo's SQL Tutorial.

Scrum

read this article, titled Myth 3: In Scrum, releases are done only at the end of the Sprint by Barry Overeem.
it is okay to release updates to production even before the Sprint Review.
it is recommended to keep expanding the Definition of Done (DoD).

Thank you for reading! Have a good day!

Resources/Recommended Readings

DISCLAIMER

This is not a guide, it is just me sharing my experiences and learnings. This post only expresses my thoughts and opinions (based on my limited knowledge) and is in no way a substitute for actual references. If I ever make a mistake or if you disagree, I would appreciate corrections in the comments!

Other Media

Feel free to reach out to me in other media!

This content originally appeared on DEV Community and was authored by Rammina

Print Share Comment Cite Upload Translate Updates

APA

Rammina | Sciencx (2022-01-27T06:07:46+00:00) Day 86 of 100 Days of Code & Scrum: SELECT Within SELECT, Aggregate Functions In SQL, and Other Stuff. Retrieved from https://www.scien.cx/2022/01/27/day-86-of-100-days-of-code-scrum-select-within-select-aggregate-functions-in-sql-and-other-stuff/

MLA

" » Day 86 of 100 Days of Code & Scrum: SELECT Within SELECT, Aggregate Functions In SQL, and Other Stuff." Rammina | Sciencx - Thursday January 27, 2022, https://www.scien.cx/2022/01/27/day-86-of-100-days-of-code-scrum-select-within-select-aggregate-functions-in-sql-and-other-stuff/

HARVARD

Rammina | Sciencx Thursday January 27, 2022 » Day 86 of 100 Days of Code & Scrum: SELECT Within SELECT, Aggregate Functions In SQL, and Other Stuff., viewed ,<https://www.scien.cx/2022/01/27/day-86-of-100-days-of-code-scrum-select-within-select-aggregate-functions-in-sql-and-other-stuff/>

VANCOUVER

Rammina | Sciencx - » Day 86 of 100 Days of Code & Scrum: SELECT Within SELECT, Aggregate Functions In SQL, and Other Stuff. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2022/01/27/day-86-of-100-days-of-code-scrum-select-within-select-aggregate-functions-in-sql-and-other-stuff/

CHICAGO

" » Day 86 of 100 Days of Code & Scrum: SELECT Within SELECT, Aggregate Functions In SQL, and Other Stuff." Rammina | Sciencx - Accessed . https://www.scien.cx/2022/01/27/day-86-of-100-days-of-code-scrum-select-within-select-aggregate-functions-in-sql-and-other-stuff/

IEEE

" » Day 86 of 100 Days of Code & Scrum: SELECT Within SELECT, Aggregate Functions In SQL, and Other Stuff." Rammina | Sciencx [Online]. Available: https://www.scien.cx/2022/01/27/day-86-of-100-days-of-code-scrum-select-within-select-aggregate-functions-in-sql-and-other-stuff/. [Accessed: ]

rf:citation

» Day 86 of 100 Days of Code & Scrum: SELECT Within SELECT, Aggregate Functions In SQL, and Other Stuff | Rammina | Sciencx | https://www.scien.cx/2022/01/27/day-86-of-100-days-of-code-scrum-select-within-select-aggregate-functions-in-sql-and-other-stuff/ |

Please log in to upload a file.

There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.