SQL

In this past couple OAs (IBM, Citizens Bank just to name a few), I have been taking L’s on the database questions. As a CS major in my university, SQL is not part of our curriculum. So I decided to make this post to go over some basic concepts in SQL. SQL is a query language and data is usually stored in tables After some research, I have decided to use MySQL since it is the most popular database....

October 21, 2022 · 4 min · 685 words · Jackie Gan

Object Oriented Programming with Java

Back in my sophomore year I got rejected by 3 internships (or more) because my OOP skills weren’t good enough. I want to make this post to remind myself I know the concepts. Java Basic Concepts What is a class? A class is a blueprint of anything, I mean literally anything. You can also have nested class too (this is too advanced for now). For example, a car has an engine, mpg, top speed, gear type, gear amount, and etc but the class will hold all of theses....

October 1, 2022 · 6 min · 1269 words · Jackie Gan

Python and Pipenv

Python is a great language for everyone. Easy to understand, and a lot of libraries to mess around with. However, managing packages in python can be a pain. Also, installing it the right way. I had to personally witness this myself……. Installing Python (on macOS) I’m a big fan of brew, brew is a Package Manager for macOS (something like apt-get in linux). More info please check out this. Open terminal and run this command to install homebrew /bin/bash -c "$(curl -fsSL https://raw....

September 19, 2022 · 2 min · 311 words · Jackie Gan

Vim

Learning vim(neovim) from the goat himself, ThePrimeagen. Vim As Your Editor (1/6): The Basic Vim Movements j moving down k moving up h moving left l moving right w moving forward of a word b moving backward of a word “try not to rely on your arrow keys” yy yank the line(copy it), store in the register p paste the line dd delete the line u undo the line when you want to delete a function, dd + dd + dd isn’t practical shift + v visual line mode(highlights the line), in this mode you can use jk or other commands from above....

September 11, 2022 · 2 min · 308 words · Jackie Gan

Travel pt1

In the last few years, I haven’t been traveling internationally or domestically due to the unspoken deadly disease 😷. In this travel pt1, I want to share some of my favorite places that I have traveled before the pandemic and places I have traveled this summer. Atlanta, GA (ATL) I have to admit I had a great time at Atlanta with friends. There is a lot to the city, a lot of places to visit such as Atlanta Botanical Garden, World of Coca-Cola, Georgia Aquarium and so on....

August 22, 2022 · 3 min · 481 words · Jackie Gan