Education & Knowledge
If there is one thing worth committing to, it's your education. Whether it's doing well in school, reading a new book, or learning how a language, taking the time to sharpen your noodle is the wisest investment you can make.
32K
Members
104K
Successful Reports
Support me!
By nature all people are alike, but by education become different
- Author Unknown
Who's stickKing?
Community Journal: Education & Knowledge
-
Giovanni91 Dec 5, 2019, 9:39 PM"Allright, ga nog ies denkem over makkelijk controlesysteem"View my Commitment -
Giovanni91 Dec 5, 2019, 9:37 PM"Goeie vraag, ik heb gisteren avond e-mail met het verslag doorgestuurd, maar da kunt gij niet weten of checken natuurlijk... "View my Commitment
-
-
viatsevskyi Dec 5, 2019, 7:34 PM"36/90 https://leetcode.com/problems/traffic-light-controlled-intersection"View my Commitment -
-
maleyna13 Dec 5, 2019, 4:59 PM"We just started school again after a whole week off for fall break. There was a big storm that made the school cancel classes for Monday and Tuesday, so this is only the second day back. I haven’t gotten many assignments because we just got back to school. I’m still working my hardest to keep all my grades up, staying on task, and getting everything done on time. "View my Commitment -
maleyna13 Dec 5, 2019, 4:58 PM"This week we had fall break. I didn't have any homework to do, but my math teacher did give out an extra credit pack to the whole class that will help improve grades. I like that he gave us and extra credit pack because it will help me improve my grade and i also like them because they are fun to do, so I was working on that during the whole week. In English class we were assigned to read a chapter during the week we had off.I also finishes two college applications while being on break. So there,s not much I can do for school during break."View my Commitment -
-
-
-
-
-
-
viatsevskyi Dec 5, 2019, 5:36 AM"34/90 https://leetcode.com/problems/check-if-it-is-a-straight-line"View my Commitment -
joshmrallen Dec 5, 2019, 4:11 AM"Baby Leah fell asleep very early today! Yesterday, we studied CREATE DATABASE and then CREATE TABLE. And then I learned that in pgadmin, in order to create a table in your desired database, you have to right click that specific database when opening the query tool (because you can only be connected to one database at a time, I think). That rose the question, how do you create a table in a specific database in psql in terminal? But I think it's very straightforward: I remember amigoscode on youtube showing how you just connect to that specific database and then you can start typing commands, essentially -- but I'll review once I get a chance. Maybe I'll use some creative means to download his video so i can save it to my phone for my commute. Today's first lecture: Insert Data Connect to the movies database we created yesterday Open query tool SELECT * FROM movies; Look at the column names and datatypes Notice that we still have no data here just fyi, because this is one way to add date to a table: copy COPY movies FROM '/home/josh/Desktop/filename.csv' DELIMITER ',' CSV HEADER Remember the comma part of the DELIMITER statement - this tells postgres that the csv file is differentiating between row cells by using a comma (,) CSV HEADER tells postgres that the first row are headers, so please don't copy it as data Use the INSERT INTO statement to create entries on the table INSERT INTO movies VALUES () parenthesis: the value for each column, left to right, separated by a comma INSERT multiple entries at the same time: just put a comma and type new parentheses: INSERT INTO movies VALUES (data,data,data), (data,data,data) what happens when you forget to add data for a column? depends on your constraints will enter the data, without heed to where you meant to put it, so be careful If you mean to leave a cell blank, if it's varchar, use ' ' to indicate that the cell should be blank if you don't do this, the wrong data will be put into the wrong cells. UPDATE an entry or even delete it use the statement: UPDATE UPDATE movies SET country = 'USA' WHERE movie_name = 'The Godfather' AND movie_year = 1972 command to use is SET, then column name WHERE tells where/which cells to update in this case, we're specifying entries for the PRIMARY KEYS (remember, we specified the columns movie_name and movie_year as the primary keys for this table) Instructor says that manually importing data isn't as efficient as importing from a csv, since if you make a mistake, you can just re-open the source csv. Ok, let me try a little bit. Yay, that was fun. I'm going to get to bed now. She gave me an early night and I should get some sleep."View my Commitment -
-
viatsevskyi Dec 5, 2019, 3:27 AM"33/90 https://leetcode.com/problems/array-transformation/"View my Commitment -
viatsevskyi Dec 5, 2019, 3:19 AM"32/90 https://leetcode.com/problems/find-winner-on-a-tic-tac-toe-game"View my Commitment -
Adnama547 Dec 5, 2019, 3:12 AM"Today I updated and expanded my outline and created a new, better task list. Still working on two tasks per day, I think. Some are more labor intensive than others"View my Commitment
-
viatsevskyi Dec 5, 2019, 3:03 AM"31/90 https://leetcode.com/problems/number-of-days-in-a-month"View my Commitment -
viatsevskyi Dec 5, 2019, 2:22 AM"30/90 https://leetcode.com/problems/index-pairs-of-a-string/"View my Commitment -
viatsevskyi Dec 4, 2019, 11:21 PM"29/90 https://leetcode.com/problems/check-if-a-number-is-majority-element-in-a-sorted-array"View my Commitment -
viatsevskyi Dec 4, 2019, 10:37 PM"28/90 https://leetcode.com/problems/largest-unique-number"View my Commitment -
viatsevskyi Dec 4, 2019, 10:26 PM"27/90 https://leetcode.com/problems/find-positive-integer-solution-for-a-given-equation"View my Commitment -
raunaqc99 Dec 4, 2019, 9:17 PM"Averaged another day of 3 hours of studying of Marine auxillary machineswhich went well but i know tried to avoid everything new. So tommorow to mke up for tgat is going to be doing the things that i did not want to do first and then some. Will try a new time spacing method with more sleep in between to try to average more work in a day. "View my Commitment -
Daz_Vs_Life Dec 4, 2019, 8:40 PM"Successful week. I think next week I’m going to try and record every thing from my Whoop strap. Doors healed now so I can start running again"View my Commitment -
bivanov Dec 4, 2019, 7:13 PM"D3 is a night for football and a drink, limited time on laptop today."View my Commitment -
bivanov Dec 4, 2019, 7:13 PM"D2 - Tuesday was great. Had a study buddy as well. "View my Commitment
-
esandler Dec 4, 2019, 3:26 PM"Daily plan and gratitude Doesn’t have to be followed perfectly "View my Commitment -
DillionKrisik12 Dec 4, 2019, 3:19 PM"My commuting has been going well. It’s been a weird week to follow my commitment though. I’ve had the last couple days of fall break and the last few days of school have been snow days."View my Commitment -
-
PerpetualNovice Dec 4, 2019, 1:07 PM"In new Orleans for work. Not going to miss a beat. "View my Commitment -
-
-
Atratune Dec 4, 2019, 9:55 AM"so many deadlines this month to pay dept . it is frustrating and impossible target , I don't know what to do and I have no one to share this burden with. everything around me seems ok no one feels the pressure.no body knows the urgency . can't tell anyone , they would freak out . I have 5 final notices . will I get out of this? ,, "View my Commitment -
Atratune Dec 4, 2019, 9:37 AM"My goal is to provide income from what I am passionate about and along the way it is more like a self improvement journey . mind body and soul in better shape . I am liking this and feeling much better.. on the negative side work and the takeaway shop is financially struggling. financial stress and pressure is trying to take over. I wonder how things would have turned out if...... "View my Commitment -
-
-
Jonvigna Dec 4, 2019, 7:24 AM"PIP is still on me. I must analyse and plan accordingly."View my Commitment -
ChristyMD Dec 4, 2019, 5:20 AM"I am starting this important progress record on my honor and pledge to take it seriously!"View my Commitment -
joshmrallen Dec 4, 2019, 4:53 AM"Yesterday, I created a query file full of all the joins I've learned. Today, I'll begin Section 8: Creating Tables in SQL So this section is going to prepare me for the real world: it'll be teaching me how to basically "create a database" and manage it. Type the SQL command for creating a database: CREATE DATABASE my_database; refresh after you enter this statement. very easy! pgadmin can do this for you by right clicking on any existing database, clicking Create, then clicking New Database. Fill in the appropriate fields. notice the tabs for General, Definition, Security, Parameters, and SQL. If you click on SQL, you'll be shown the SQL that will be used to create this database from the information you've provided! Next Lecture: Create Table This apparently requires much more thought and planning than creating a database does. Type the command to create a table CREATE TABLE Example the instructor uses is movies: CREATE TABLE movies(); this creates an empty table -- only able to be done with postgreSQL/pgadmin -- command line and other platforms don't let you do this. CREATE TABLE movies ( movie_name ); name by itself is an SQL function, so make sure you make it longer using _ or other letters like above. Add the datatype for each column: CREATE TABLE movies ( movie_name VARCHAR(200), movie_year INTEGER, --can't put constraints on INTEGER country VARCHAR(100), genre VARCHAR NOT NULL, PRIMARY KEY (movie_name, movie_year) --specify which columns will be a primary key, can be two! ); Graphically, in pgadmin: right click and click Create, then Create table. You can do everything you can do writing SQL. Ok, try it myself real quick. Cool cool, created a database. I created a table, but it's not showing up anywhere. Maybe because it's empty? Haha, it was created as a table in the Console Games database. I wonder how I specify the database that I want it to be a part of. No answer to this. Maybe the database has to be selected. Someone else asked this before. So I have to open the query tool from the right-click menu of that specific Database. is there an SQL way to specify? not sure? probably in psql, yes. I should review that psql tutorial on youtube from amigoscode. Ok, I'm going to sleep now! Good night!"View my Commitment
-
-
-
viatsevskyi Dec 4, 2019, 1:08 AM"26/90 https://leetcode.com/problems/sum-of-digits-in-the-minimum-number"View my Commitment -
viatsevskyi Dec 4, 2019, 1:03 AM"25/90 https://leetcode.com/problems/count-substrings-with-only-one-distinct-letter"View my Commitment
-
viatsevskyi Dec 3, 2019, 11:53 PM"24/90 https://leetcode.com/problems/armstrong-number/"View my Commitment -
Toiya Dec 3, 2019, 11:42 PM"3 dec - jobbade 2h och var upptagen stor del av dagen, så hann bara med 1h50min. Bättre imorrn"View my Commitment -
viatsevskyi Dec 3, 2019, 11:41 PM"23/90 https://leetcode.com/problems/cells-with-odd-values-in-a-matrix"View my Commitment
-
viatsevskyi Dec 3, 2019, 11:01 PM"22/90 https://leetcode.com/problems/minimum-time-visiting-all-points"View my Commitment -
Stephaniethp Dec 3, 2019, 10:56 PM"- gave a personalized gift - decorated final room :) - got Christmas tree and decor ! - actualized work - dental health - value / passion / meaning work"View my Commitment -
-
viatsevskyi Dec 3, 2019, 10:30 PM"21/90 https://leetcode.com/problems/single-row-keyboard/"View my Commitment
-
-
raunaqc99 Dec 3, 2019, 10:01 PM"Got the extra info from the ppt and thats it in the morning, then i went and lost a game of tt which sucked, really sucked then i smoked ip chilled and from 9 to around 1230 where i probably worked for approx 2 and half hours to complete Revision, diagrams and engine failures "View my Commitment -
-
viatsevskyi Dec 3, 2019, 6:06 PM"20/90 https://leetcode.com/problems/valid-word-square"View my Commitment -
-
-
-
-
aryalgaurav135 Dec 3, 2019, 1:25 PM"I have not done anything remotely with coding. I am just wandering around. Sorry to lie to myself, but truth kind of sucks. My life is a mess without any input into coding and machine logic."View my Commitment -
aryalgaurav135 Dec 3, 2019, 1:23 PM"I have not studied Data Structure two hours a day. I am not doing what I am supposed to do. I really feel bad about this."View my Commitment
-
-
-
Adnama547 Dec 3, 2019, 9:07 AM"I finally dragged my computer open and made a brand new outline. This paper needs a major overhaul so instead of the more specific writing tasks, I'm going to make a new list tomorrow based on my outline. "View my Commitment
-
nayeemjamil Dec 3, 2019, 7:54 AM"I have found social media and drinking this week has affected my confidence. I need to have a day without it to see if it helps"View my Commitment -
viatsevskyi Dec 3, 2019, 7:40 AM"19/90 https://leetcode.com/problems/confusing-number"View my Commitment
-
viatsevskyi Dec 3, 2019, 7:20 AM"18/90 https://leetcode.com/problems/remove-vowels-from-a-string/"View my Commitment -
viatsevskyi Dec 3, 2019, 7:19 AM"17/90 https://leetcode.com/problems/intersection-of-three-sorted-arrays/"View my Commitment
-
viatsevskyi Dec 3, 2019, 6:07 AM"16/90 https://leetcode.com/problems/valid-word-abbreviation/"View my Commitment -
joshmrallen Dec 3, 2019, 5:53 AM"23:46! She felt a little awake tonight. But she did sleep for an hour from 19:30 to 20:40 or so so that may have had an effect. yesterday, we learned how you can use join after join -- which is referred to as a complex join. Where the ON statement ends, another join statment can begin. Also learned about specifying which columns (instead of all columns, all the time), we can clean up the data and display only the columns we want to display without having to see the columns that helped us accomplish the join, but create a lot of duplication, etc. Today's first lecture is Cross Join: this one's a "bonus" tutorial. the instructor says it's a secret that you would eventually find out in the progression of your career and that it's "advanced." it took him a year of professional usage of sql until he finally needed to use it and found it. it's an implementation of a cartesian product in sql. a cartesian product is an operation that returns a set: there's no criteria for the match, it's all possible matches. We won't use the ON statement that the other joins utilize. CROSS JOIN pets and owners tables Choose a smaller table Each entry in pets will be matched to all 89 owners Basically A x B What's the point of CROSS JOIN? Sometimes you might need to see all the possible combinations of the rows of 2 tables. E.g., bathroom floor tiles: different combinations of colors and materials guessing game: a group of people, you want to see the consequences of each possible combinations of guesses/answers that each person makes Warning CROSS JOINS are advanced not because they're difficult to comprehend, but actually because they can take up a lot of resources The instructor's experience was that he did an analysis of several socio-economic factors in a geographical area and he needed to see the combination of all factors for that region, resulting in over 900 million rows! That would definitely take the computer a long time to completely process. SELECT * FROM pets CROSS JOIN owners Oh, the next lectures are all MS SQL. I'll skip it for now and come back to them later for review with MS SQL. Next lecture is section 8, but I promised I'd make a query file with all the statements covered in this section. let's do a cross join first and then make that. Here we go: wow, 8900 rows. Good thing we chose small tables. I feel like you have to know what you want to see and choose the right table to be on the left (the FROM statement). Haha, excellent, that was a nice review practice. And now I have a reference query file of my own I can refer to. Going to bed now!"View my Commitment
-
-
bivanov Dec 2, 2019, 10:55 PM"1st day of my 2 week challenge has been successful. Stayed late at work and ticked off tasks in both personal and professional aspects. D1 DONE "View my Commitment
-
raunaqc99 Dec 2, 2019, 9:18 PM"Getting back on track and completed basic note making yesterday, will revise today and go through ppts for diagrams and extra info. Before 5 After 5 we will figure it out "View my Commitment -
-
jensg97 Dec 2, 2019, 6:42 PM"Day 1- the snowball effect only Works if the snowball begins to roll."View my Commitment -
viatsevskyi Dec 2, 2019, 5:31 PM"15/90 https://leetcode.com/problems/missing-number-in-arithmetic-progression"View my Commitment -
-
-
marknagelberg Dec 2, 2019, 2:52 PM"Mostly met time targets - exceeded some and behind on a couple. Giving myself a break this week though because Jane is in town"View my Commitment
-
ntlambitvietnam Dec 2, 2019, 2:25 PM"Thể loại Thực hành Chủ đề Tâm lý học - Tư duy thành công Cấu trúc: Câu chuyện đằng sau câu chuyện Buổi họp lớp Chuyện ngụ ngôn: Ai đã dời chỗ phomat của tôi Buổi thảo luận Mỗi người chúng ta đều có định nghĩa riêng của mình về pho mát là gì, và ta theo đuổi nó vì tin rằng nó sẽ làm cho ta hạnh phúc Nếu đạt được, ta thường trở nên gắn liền với nó. Còn nếu ta mất nó, hoặc nó bị mang đi mất, nó sẽ trở thành sự đau khổ HÃY ĐI THEO PHO MÁT VÀ TẬN HƯỞNG NÓ (NÓ ở đây vừa là mục đích ta tìm kiếm vừa là con đường ta đi đến đó) Ăn pho mát khiến ta sung sướng Món pho mát của ta càng quan trọng với ta bao nhiêu thì ta càng muốn giữ chặt nó bấy nhiêu Nếu ta không thay đổi, ta có thể không tồn tại nổi Ta sẽ làm gì nếu ta không sợ hãi Hãy ngửi pho mát thường xuyên để biết lúc nào nó bị cũ Di chuyển theo một hướng mới giúp ta tìm thấy pho mát mới Khi ta vượt qua nỗi sợ hãi của bản thân, ta cảm thấy tự do Việc hình dung ra bản thân đang thưởng thức miếng pho mát mới, thậm chí trước khi tôi tìm thấy nó, dẫn tôi đến chỗ nó Càng chóng bỏ qua miếng pho mát cũ chừng nào, ta càng sớm tìm thấy miếng pho mát mới chừng đó Đi tìm trong mê cung thì chắc ăn hơn là ở lại một trạm không có pho mát Những niềm tin cũ không dẫn người ta đến chỗ pho mát mới Khi người ta thấy mình có thể tìm ra và thưởng thức pho mát mới, người ta sẽ thay đổi cách cư xử Sớm nhận ra những thay đổi nhỏ giúp người ta thích nghi với những thay đổi lớn sắp xảy đến Đi theo pho mát và tận hưởng nó "View my Commitment -
-
ccor2312 Dec 2, 2019, 12:39 PM"Two days accomplished. Three was the ideal goal for this first week. Thanksgiving travel was a bigger obstacle than imagined. Need to adjust my approach for Christmas time."View my Commitment -
yo-yo Dec 2, 2019, 11:40 AM"Very little progress on the essay, and it's gonna get delayed by a week. Been working mostly on the thesis to get it finished properly, with its DL next Wednesday. Could've probably pushed out some kind of an essay if I committed the weekend 100%, but I want to do this topic right."View my Commitment
-
-
viatsevskyi Dec 2, 2019, 7:46 AM"14/90 https://leetcode.com/problems/two-sum-iii-data-structure-design/"View my Commitment -
raunaqc99 Dec 2, 2019, 7:38 AM"Today will start with mice and focus entirely on engine construction and maintenance "View my Commitment -
viatsevskyi Dec 2, 2019, 7:02 AM"13/90 https://leetcode.com/problems/design-compressed-string-iterator"View my Commitment -
viatsevskyi Dec 2, 2019, 6:35 AM"12/90 https://leetcode.com/problems/day-of-the-year/"View my Commitment -
Toiya Dec 2, 2019, 6:21 AM"Medel nu är 1.95 hrs/day - nästa vecka är målet att det i snitt ska bli minst 4"View my Commitment -
viatsevskyi Dec 2, 2019, 6:19 AM"11/90 https://leetcode.com/problems/fixed-point"View my Commitment -
joshmrallen Dec 2, 2019, 4:58 AM"Ready to go! Yesterday, we learned how to join on multiple fields by using the AND statement after the ON statement. Pretty straight forward. Next lecture: Complex Joins By complex join, the instructor means that we'll have two joins in a row in one statement. And I take complex to mean that any statement that has 2 or more joins will be complex join. I realize too late that I should have saved the same query file that i did all these small examples/exercises -- that way I could look at it later as reference -- but really, that in itself would be a great review exercise. Maybe after this section of lectures is complete? That would help cement everything together well. Making note: at the end of this lecture section, make one query file with all of the queries discussed in this section. So, in this lecture, to create a complex join, we're going to find out which pets had procedures then find the descriptions of those procedures and their actual costs. SELECT * FROM pets AS A INNER JOIN procedurehistory AS B ON A.petid = B.petid; Now we have only the pets that had procedures We'll treat this whole statement as if it were an entire table name -- let's call it x for now. To get the descriptions and costs, remember we can't just use the one field, subcode, because it's not unique -- we have to LEFT JOIN on proceduretype as well as proceduresubcode. SELECT * FROM x AS C --he doesn't make an alias for this LEFT JOIN proceduredetails AS D ON C.proceduretype = D.proceduretype AND C.proceduresubcode = D.proceduresubcode; he doesn't make an alias for x so, because the table already has an alias -- B (for procedurehistory, which is the table we're seeing fields for, not pets): SELECT * FROM x LEFT JOIN proceduredetails AS C ON B.proceduretype = B.proceduretype AND C.proceduresubcode = C.proceduresubcode; So now add in the first join, replacing everything form SELECT to x and getting rid of the semicolon (because this is one complete statement: SELECT * FROM pets AS A INNER JOIN procedurehistory AS B ON A.petid = B.petid LEFT JOIN proceduredetails AS C ON B.proceduretype = C.proceduretype AND B.proceduresubcode = C.proceduresubcode; I've been pausing the video and checking my results with the lecture. Awesome! Next lecture: cleaning up your joins This video for a useful technique that will help you "clean up" your joins. The challenge, he says, is to leave only the information that we need from our resulting joined table. SELECT * FROM pets AS A INNER JOIN procedurehistory AS B ON A.petid = B.petid; go through the output and decide which columns you need. you don't need pairs of columns (the foreign keys used to join the columns) -- e.g., petid is duplicated since it shows in both tables. Get rid of one. use SELECT with specific column names, instead of * type in the name of the columns, starting from left to right in the output and separating them by commas (,) Remember to specify the alias for each column: SELECT A.petid, A.name, etc. Comment out (using dashes: --) individual columns that you decide you don't actually need. This way you can quickly adjust which columns you see as you need them. Ok, let's practice a little. Well that's not so bad, all you have to do is join right after one another. I could even filter with ORDER BY right after the last join. Here, I did it by ownerid so we could easily see the procedures for the same pet. Now let's clean it up a bit by showing only the columns we want (and not seeing the same information twice) will it still go through all the joins if I don't specify the joined keys in the join statements? Wow, yes. This is awesome. Now to comment out a bit, if I just need to focus on say, the price the owner had to pay. Haha, this is brilliant! Ok, I'll do more tomorrow. Goodnight!"View my Commitment
-
KLORD1 Dec 2, 2019, 3:09 AM"Slighty rough and overwhelming, seeing all the dates inch closer and closer is bring upon a lot of stress "View my Commitment -
-
bivanov Dec 2, 2019, 12:30 AM"Just created my commitment. Hoping for a good start after work tomorrow but the real test will be D2 and D3."View my Commitment
-
Ygg Dec 1, 2019, 11:13 PM"Not satisfied of today yet happy of the overall week. I should really emphasize two things : -Block. things. even. more. -Time your time on mail applications -Do drafts, as often as possible. Alpha versions. Don't wait. -Note things down to remember them. Because you won't. -Try a "don't shoot the dog" when you derail The minipedia-anki thing starts giving surprising effects : reduced revision time + a weird "opening folder" feeling whenever I link a notion with another. Really pleasant sensation."View my Commitment -
viatsevskyi Dec 1, 2019, 10:48 PM"10/90 https://leetcode.com/problems/read-n-characters-given-read4"View my Commitment -
-
viatsevskyi Dec 1, 2019, 9:13 PM"9/90 https://leetcode.com/problems/palindrome-permutation"View my Commitment -
viatsevskyi Dec 1, 2019, 8:26 PM"8/90 https://leetcode.com/problems/strobogrammatic-number/"View my Commitment
Get Started!
Read more
Set aside more time for reading.
Take a class
Learn a new skill, deepen your knowledge or explore an interest of yours.
Learn a Language
Choose a language and commit to learning it
Custom goal
Create your own goal.
