Disclaimer: This piece is written anonymously. The names of a few particular companies are mentioned, but as common examples only.
This is a short write-up on things that I wish I'd known and considered before joining a private company (aka startup, aka unicorn in some cases). I'm not trying to make the case that you should never join a private company, but the power imbalance between founder and employee is extreme, and that potential candidates would
| /* | |
| https://www.codewars.com/kata/593ef0e98b90525e090000b9 | |
| SQL Basics - Monsters using CASE | |
| */ | |
| SELECT top.* | |
| ,bot.* | |
| ,CASE | |
| WHEN top.heads > top.arms THEN 'BEAST' | |
| WHEN bot.tails > bot.legs THEN 'BEAST' | |
| ELSE 'WEIRDO' |
| #! /usr/bin/env python | |
| # -*- coding: utf-8 -*- | |
| """This module's docstring summary line. | |
| This is a multi-line docstring. Paragraphs are separated with blank lines. | |
| Lines conform to 79-column limit. | |
| Module and packages names should be short, lower_case_with_underscores. | |
| Notice that this in not PEP8-cheatsheet.py |
| --https://dax.do/HjDPEEQlk8ADkj | |
| --13.10 - Sales by year | |
| EVALUATE | |
| SUMMARIZECOLUMNS ( | |
| 'Date'[Calendar Year], | |
| "Sales", [Sales Amount], | |
| "Pct", | |
| DIVIDE ( | |
| [Sales Amount], | |
| CALCULATE ( [Sales Amount], ALL ( 'Date'[Calendar Year] ) ) |
Many people, especially tech people - have a difficult time asking for raises. It is just not part of the typical personality trait of a very smart but often introverted person. Many of us are taught to be humble, even meek, from a very young age. Of course, too much of a good thing can be a bad thing. I'm mid-career and have alot of serious bills. I've been with my company for a long time, but struggled with whether or not to leave, ask for a raise, etc. I went four years without a cost of living increase, before I got up the nerve to ask. Am I already making too much? Will I be fired for asking? Salaries are the most tightly kept secrets. I know about guys cheating on their wives and with who. I don't know what ANYONE in my company makes.
>I desperately wanted to know what people made, so I could know where I stood - if I should leave and when applying to other jobs, feel good about asking and what I expected to get paid. In fact I was almost obse
| CREATE TABLE `department` ( | |
| `id` INT UNSIGNED NOT NULL PRIMARY KEY, | |
| `name` VARCHAR(30) | |
| ); | |
| CREATE TABLE `employee` ( | |
| `id` INT UNSIGNED NOT NULL PRIMARY KEY, | |
| `name` VARCHAR(30), | |
| `salary` INT UNSIGNED, | |
| `boss_id` INT UNSIGNED DEFAULT NULL, |
140 Comments
New Year Gift to every fellow time-constrained engineer out there looking for a job, here's a list of the best LeetCode questions that teach you core concepts and techniques for each category/type of problems! Many other LeetCode questions are a mash of the techniques from these individual questions. I used this list in my last job hunt to only do the important questions.
Good luck and Happy New Year!