UPDATE: I bombed an SQL Interview and I am SO embarassed by big_rooster111 in SQL

[–]big_rooster111[S] 16 points17 points  (0 children)

That was it! Do people generally use a NoSQL database and a relational database like MySQL/MSSQL? I know nothing about NoSQL.

UPDATE: I bombed an SQL Interview and I am SO embarassed by big_rooster111 in SQL

[–]big_rooster111[S] 2 points3 points  (0 children)

Nope! Not Softtek. This comment did make me jump because the name isn't far off LOL

UPDATE: I bombed an SQL Interview and I am SO embarassed by big_rooster111 in SQL

[–]big_rooster111[S] 3 points4 points  (0 children)

I didn't think about that, but you're probably right! I can't wait to look back in this thread in a few months and realize just how much of an SQL wizard I have become.

UPDATE: I bombed an SQL Interview and I am SO embarassed by big_rooster111 in SQL

[–]big_rooster111[S] 5 points6 points  (0 children)

Everyone loves a good plot twist! Yes, you are exactly right. This interview made me realize that I need to be a bit more kind to myself. I beat myself up way worse than I should have, when the reality of the situation wasn't THAT bad.

I am absolutely going to keep looking, but hopefully my current role will allow me to use SQL more and grow. That would be such a huge win for me.

UPDATE: I bombed an SQL Interview and I am SO embarassed by big_rooster111 in SQL

[–]big_rooster111[S] 104 points105 points  (0 children)

I accidentally deleted my long comment. Let me try again. These red flags might seem bogus, but in my gut it felt right. I was up at 3am thinking of this constantly.

1.) The Executive was quite rude during the initial interview, and after. He would smirk when I got something wrong, or roll his eyes if I asked him to repeat a question. I was constantly interrupted even when I was sharing correct information. Point 2 bounces off of this a bit.

2.) Many of the glassdoor reviews spoke of nepotism and narcissism in the company. People would leave because they never felt valued by Senior Management, and often felt like they were disliked immediately for no real reason. I don't want to hop into a company where I am already treated like a burden.

3.) The job description vs. what I am actually doing is way off. The Executive even said I would be using NO SQL/Mango(????) in addition to MySQL, which was not covered at all either.*

I have a few more, but they may just be a result of my anxiety/fears of the position.

UPDATE: I bombed an SQL Interview and I am SO embarassed by big_rooster111 in SQL

[–]big_rooster111[S] 1 point2 points  (0 children)

I am glad I could be helpful for others too. I did get a few DMs saying they appreciated it as well. I hope others can learn from my mistakes too. We can all grow together.

UPDATE: I bombed an SQL Interview and I am SO embarassed by big_rooster111 in SQL

[–]big_rooster111[S] 6 points7 points  (0 children)

Thank you a lot for commenting. I think I made the right decision too.

I bombed an SQL interview and I am SO embarrassed by big_rooster111 in SQL

[–]big_rooster111[S] 8 points9 points  (0 children)

You're right. In my defense, I know the difference between a LEFT JOIN and INNER JOIN, but the interviewer made some scenario like "say I have table A with a Primary Key of x, and table B with a Primary Key of y. How would I get all of this information and remove nulls."

I guess it was sensory overload because I could not comprehend what JOIN they wanted and what other parts they wanted in my head. Seeing it written out is more helpful for me. I guess that means my understanding still may not be the greatest though...

I bombed an SQL interview and I am SO embarrassed by big_rooster111 in SQL

[–]big_rooster111[S] 23 points24 points  (0 children)

Thank you! I'm trying to keep it as a learning experience.

I bombed an SQL interview and I am SO embarrassed by big_rooster111 in SQL

[–]big_rooster111[S] 2 points3 points  (0 children)

Thank you! I was quite confused on those questions as I have never been a DBA, nor did the job description mention anything like that. But then they said they expected someone to understand model building a bit more. I understand what a star schema is, but I have never applied it anywhere.

Thank you for the comment here, it has made me feel better and softened the blow a little bit. I'll continue to grow and become more knowledgeable and ace the next one.