Day 23/30 Of Productivity

Day 7/60 of productivity

- 2hrs of Udacity course (I'm now 70% through android dev fundamentals :))

- worked out

- hair-care

I wanted to study more in the evening but the wifi was being spotty so I'm just going to sleep. I'd really love to wake up early tomorrow and get stuff done but we'll see.

day 7/30 of productivity

1hr of calculus II on the couch. I have a cold and it's been pretty hot during the day so that's all I could do today 🤷🏾‍♀️

day 1/30 of productivity

3 hours of assembly language. first two hours of studying were really hard (I was NOT motivated) but I pushed through and the last hour in the evening was easier :) assembly's fucking awful tho

notes from when I was studying for finals plus code from a group assignment where we made a bank management system with c++. it was fine and we got a good grade in it but we had to abandon our original plan because we didn't have enough time and ended up making a simpler version. I'm going to try to make it on my own this week.

also i keep forgetting about this blog, will try to post more in second sem. hope you're all well :)

day 25/30 of productivity

I didn't do nearly enough today but I'm tired and my eyes hurt so I'm going to bed

day 13/30 of productivity

still tired. Im going to have another exam after this week and then in a month it'll be finals and in between all that I have assignments to submit and worksheets to complete 😞 but summer break's coming and I'll rest soon.

Day 5/60 days of productivity

Today:

- got halfway through lesson 3 of android dev fundamentals

@getbreaded there is a discord (made by @vexacarnivorous 🙏🏾) and it's great!

Link to join if you're interested

I love you codeblr! I love you blogs who compile a shit load of resources and post them! I love you reblog threads of people helping one person with a code issue! I love you codeblr discord! I love you codeblr!

day 26/30 of productivity

stressed out about not studying enough which leads to me not being able to study which leads to more stress. fun

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!!