CS373 Fall 2019 Week 10: Jing Fang

Jing Fang
Jing Fang
Nov 4 · 2 min read

What did you do this past week?

This past week I finished the problem set for the Algorithms and did some practice problems in the textbook for the upcoming exam. For the rest of the time, we continued the group project and worked on collecting more data from sources with a RESTful API.

What’s in your way?

Our group continued to work on the SWE project by following all the requirements. We updated the format of the returned JSON responses. I also spent time to finish the practice exam and review all problem sets for the Algorithms exam on Monday.

What will you do next week?

Next week seems to be a little busy because there are two exams and several deadlines for class projects and problem sets. I plan to study for two exams on Monday and Wednesday, and finish the programming assignment and the weekly problem for computer security by Thursday as well. For the rest of the time, I will continue the project with my group. Hopefully, we will finish up adding filtering, searching, and sorting to the model pages by Wednesday.

What was your experience of SQL?

I was unable to attend classes on Monday and Wednesday, so I spent some time to review notes and in-class practice questions. I learned to write an SQL query to tell the database that I want to read some of its data. For example, I can use a SELECT statement to get data from a database and use a JOIN statement to combine rows from two or more tables. I also understood the difference between SELECT and SELECT DISTINCT, and the difference between JOIN and INNER JOIN after doing the in-class practice questions on HackerRank. To avoid having errors in a query, I think it is necessary to fully understand the structures of different tables in a database, and it may be also helpful to use a subquery.

What’s your pick-of-the-week or tip-of-the-week?

My pick-of-the-week will be this website. Since I was unable to attend classes on Monday and Wednesday, I found it useful to learn more about SQL after I reviewed all the notes and in-class coding questions.

    Jing Fang

    Written by

    Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
    Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
    Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade