Career
The routine of the work week and the pressure of our job responsibilities can often get the best of us. However, whether it's putting more effort into your job, or finding one that makes you truly happy, its time to commit to your career.
34K
Members
134K
Successful Reports
Support me!
It is never too late to be what you might have been.
- George Eliot
Who's stickKing?
Community Journal: Career
-
-
viatsevskyi Dec 5, 2019, 7:34 PM"36/90 https://leetcode.com/problems/traffic-light-controlled-intersection"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 -
-
LinneaH Dec 4, 2019, 7:56 PM"Oh man I have been at interviews twice this week, another tomorrow, and three hours of information today, and am really tired. It´s not that many hours but it is mentally draining. Also not sleeping that well. I am not doing things according to the list - I have not had the time and energy, but I have been applying and interviewing so good enough :-)."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
-
dlocker8 Dec 4, 2019, 3:26 PM"On track! thanks to a late call yesterday evening. "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
-
-
-
-
-
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 -
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 -
-
greg_gillis Dec 3, 2019, 9:35 PM"Thanks for the positive vibes David, much appreciated! At the moment I'm focusing on getting my basic drawing skills back, so it's a lot of exercises. And the writing part is the second draft of a detective novel I wrote last year. "View my Commitment -
viatsevskyi Dec 3, 2019, 6:06 PM"20/90 https://leetcode.com/problems/valid-word-square"View my Commitment -
-
-
-
-
ladeevix Dec 3, 2019, 2:50 PM"Want to start medium posts weekly to build an audience."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 -
bivin Dec 3, 2019, 6:25 AM"I commit to not work after 5:30. Finish everything by end of day, one thing at a time"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
-
-
Saporaku Dec 2, 2019, 11:14 PM"Put off the work too long and couldn't finish part 1. Intend to finish part 1 and 2 by next week. May need some leniency for submitting part 2. "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
-
barksdjy Dec 2, 2019, 8:57 PM"This being a major holiday week, it was challenging but I did the best I could under the circumstances."View my Commitment -
-
neiltigh Dec 2, 2019, 7:40 PM"Managed to keep a good focus for half the week, but had a few wobbles later with being only just on time for a meeting etc. No forfeit, no celebration - keep on keeping on! 👆🆙️"View my Commitment -
viatsevskyi Dec 2, 2019, 5:31 PM"15/90 https://leetcode.com/problems/missing-number-in-arithmetic-progression"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
-
Hopelyn Dec 2, 2019, 10:01 AM"Yeah I am so happy i completed the challenge for the week"View my Commitment -
Hopelyn Dec 2, 2019, 9:58 AM"It has been awesome. I stuck through it both last week and this week"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 -
viatsevskyi Dec 2, 2019, 7:02 AM"13/90 https://leetcode.com/problems/design-compressed-string-iterator"View my Commitment -
farrooda Dec 2, 2019, 6:53 AM"I am still learning and moving forward and progressing towards my goal. Despite having one bad day, I'm still moving forward so this is certainly a success. "View my Commitment -
viatsevskyi Dec 2, 2019, 6:35 AM"12/90 https://leetcode.com/problems/day-of-the-year/"View my Commitment -
viatsevskyi Dec 2, 2019, 6:19 AM"11/90 https://leetcode.com/problems/fixed-point"View my Commitment -
-
Jlynn94 Dec 2, 2019, 5:53 AM"Modified: -Insta 15min/day -Vision 5hr/wk -FORI 5hr/wk -Strangle the Turkey 2x/wk -Personal blog 2x/mo -Meditate 4x/wk -Morning routine 3x/wk -Someone else's vision 1hr/wk -Random convo 5x/wk -TL 1x/mo "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
-
-
-
-
darrank Dec 2, 2019, 1:19 AM"Note: 10 minute grace period at bedtime to not get fined"View my Commitment -
darrank Dec 2, 2019, 1:19 AM"Note: 10 mins grace period at bedtime to not get fined."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
-
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
-
viatsevskyi Dec 1, 2019, 8:11 PM"7/90 https://leetcode.com/problems/add-bold-tag-in-string"View my Commitment -
viatsevskyi Dec 1, 2019, 7:56 PM"6/90 https://leetcode.com/problems/bold-words-in-string/"View my Commitment -
viatsevskyi Dec 1, 2019, 7:55 PM"5/90 https://leetcode.com/problems/two-sum-less-than-k/"View my Commitment -
-
-
-
-
-
roamediate Dec 1, 2019, 1:02 PM"Oh the first week though, I’ll be taking things slow. I’m only winking"View my Commitment -
-
roamediate Dec 1, 2019, 12:54 PM"Personal social risks would be talking to strangers not related to money or career"View my Commitment
-
roamediate Dec 1, 2019, 12:54 PM"Professionally it would be cold sales or talking to a knowledgeable person in my field"View my Commitment -
Get Started!
Start my own business
Can't find the dream job? Create your own business and make your dream come true.
Go job hunting every day
Set a schedule to look for a job.
Custom goal
Create your own goal.
