For Loops Practice + A Linear Algebra Worksheet I Had To Do This Afternoon.

day 21/30 of productivity

had my calc exam today (horrible awful but it's fine) and I finished the database group assignment- also awful and horrible but ultimately fine. The submission date got moved to tomorrow instead of today and like I've been saying in every post I am soooooo tired. on the right is a cappuccino I bought impulsively yesterday cos I knew id be staying up all night. It didn't do anything for me cos coffee never does but I like to pretend.

so the 60 days of productivity challenge did not work out and that's fine we can always start over. but I've realized the way I've been studying is fragmented and all over the place so I've decided that I must do the following things:

1. Learn java

2. Then finish the kotlin course

3. Then make an app

4. then study more c++

5. then do a project in c++

and this seems very ambitious but I'm not planning to be an expert in these languages anytime soon, just know enough to make stuff and grow my knowledge through practice. ideally I'd like to do all of these things by mid to late October. And I'll do projects throughout the year so I don't forget and can improve :)

I'm starting java today, I'll post a lot here to keep myself accountable and I hope I can do it. I'm excited to learn new languages and build things!

Day 8/60 of productivity

Learning kotlin now and im not fond of the tutorials to be honest, I prefer the teachers from the past videos and I'm now using other resources on top of the course. im not being as productive as id like the past few days i hope this week is better.

day 7 of 30 days of code

(didn't do anything yesterday cos I was really sick of studying)

today I did the last of the functions exercises. i used my white board and talked aloud about each function as I wrote it and it helped a lot.

how do people do hobbies or learn other things on top of university?? I'm trying and it genuinely does not seem possible [we're going to ignore the daily 5hrs of screentime]

7 Reasons you might be procrastinating and how to solve them:

I'm going to start another challenge tomorrow this week next week because the 30dop really helped last semester. this time it'll be 60 days of productivity.

goals for this challenge:

- study and complete at least two classes I'll take next year

- revise c++ and study oop in c++

- learn java

- do at least 5 projects in java and c++ each

I hope you're all having a good summer :)

30 days of productivity: day 2-day 4/30

I've been studying a bit but haven't been posting so here's what I've done in the last week:

advanced database ch1

started discrete maths and combinatorics ch1

finished required online courses

backlog for software engineering project

started learning html

day 10/30 of productivity

this was from yesterday where i spent the whole day (and night) cramming for my computer architecture and assembly language exam. it went well!

SQL Interactive Websites

Hi! I wanted to share some websites that have helped me with bettering my SQL skills and are interactive, as in you can learn as you practice SQL on the website through an educational or fun way! 

SQL Bolt

This website is one of the best for beginners to SQL as it helps with explaining the different SQL statements as well as giving brief interactive exercises for each explanation/topic. Additionally, it offers help on more intermediate topics as well such as subqueries. However, this site doesn’t have many resources on more advanced SQL topics, so it may not be best if you’re more intermediate in SQL, but could be good for a basics refresher.

SQL Zoo

This website is another one which is good for beginners to SQL as similarly to SQL Bolt, it primarily explains different SQL statements and queries. There are brief interactive exercises as well as quizzes on various SQL topics. Additionally, there are assessments for more advanced users of SQL to test their knowledge which consist of 15 questions for different databases, including dressmaker, musicians, help desk, and so forth.

Select Star SQL

This website is an interactive SQL exercise where you learn as you go while interacting with a database of death row patients. The difficulty of queries slowly increases as you go through the exercise. I find this website helpful as it threw me into SQL and I prefer the learning while doing method, especially with real-world data. This could potentially be triggering if you don’t want to read the details of people being on death row.

SQL Murder Mystery

This website is an interactive SQL exercise where you try to figure out who committed a murder using SQL. This website is good for both beginners and more intermediate SQL learners. It offers a walkthrough for people who are completely new to SQL. Alternatively, the website gives schema details to those experienced with SQL and want to figure it out on their own.

SQL Police Department

This website is similar to SQL Murder Mystery where you try to figure out police cases through learning SQL. It has prompts where you then use SQL to try to figure out the information the police need. The site also has a guide on SQL and gives basic summaries on different queries. I found this site fun to use and it has a cool interface. However, one con of this site is you can only do a certain amount of SQL queries before it asks you to pay for the longer version of the site.

Practice SQL

This website has been my personal favorite as the interface is clean and easy to understand. The website gives you prompts to use SQL to select from two different databases, the first of which is based on doctors and patients in different provinces while the the second is based on products and their orders as well as employees who work at the company. For both of these databases, there’s a series of prompts/questions from easy to intermediate to advanced SQL. Additionally, there’s learning resources which helps explain different queries and functions of SQL as well, if you’re confused or need help!

I hope you guys find these websites helpful!!