๐จ DataLemur is LIVE! ๐จ
Solve 50+ SQL Interview questions from companies like Facebook, Amazon, and Google for FREE!
Even if you arenโt on the job hunt, DataLemur is still a great place to practice your
#SQL
skills on tricky problems:
Google recently released an "Interview Warmup" tool, to help candidates who are applying to Data Analytics jobs at Google better prep for their technical interview.
Here's 15 Data Analytics Questions Google expects you to know:
(how many can you answer??)
My 22-year old coaching client landed a new-grad Machine Learning job at a NYC startup that pays $175k per year ๐
($120k base, $40k stock, $15k annual bonus)
Here's the 17 interview questions they were asked:
(how many of these could you answer?)
A past coaching client of mine interviewed for an entry-level Data Science job in Los Angeles that paid $110k per year.
Here's the 19 interview questions they were asked:
(how many of these could you answer?)
PUBLIC SERVICE ANNOUNCEMENT:
If you are trying to become a Data Analyst or Data Scientist and have not learned SQL, stop doing whatever you are doing and go learn SQL.
I simply cannot stress this enough.
SQL interviews don't just test your ability to write SQL - you might even be asked to do DB schema design too!
This is especially true if interviewing for Data Engineering, Business Intelligence, or Analytics Engineering jobs.
Some example questions (and how to prep) ๐งต๐
Giving away the 33 SQL Interview Questions from my book Ace the Data Science Interview!
It features real SQL questions asked by FB, Google, & Amazon (with full solutions!)
To get access:
Like this Tweet + RT + Comment โSQLโ
And I'll send it!
(Must be following so I can DM)
Giving away the 33 SQL Interview Questions from my book Ace the Data Science Interview!
It features real SQL questions asked by FB, Google, & Amazon (with full solutions!)
To get access:
Like this Tweet + Comment โSQLโ
(Last time my auto-DM bot messed up, so re-posting this)
Google recently released an "Interview Warmup" tool, to help candidates who are applying to Data Analytics jobs at Google better prep for their technical interview.
Here's 15 Data Analytics Questions Google expects you to know:
(how many can you answer??)
SQL interviews don't just test your ability to write SQL - you might even be asked to do DB schema design too!
This is especially true if interviewing for Data Engineering, Business Intelligence, or Analytics Engineering jobs.
Some example questions (and how to prep) ๐งต๐
FREE SQL Tutorial with 31 lessons covering every SQL command you for Data Analytics & Data Science.
Unlike YouTube tutorials this includes 20+ interactive SQL exercises which you solve directly in the browser!
#sql
#postgresql
#dataanalytics
My 22-year old coaching client landed a new-grad Machine Learning job at a NYC startup that pays $175k per year ๐
($120k base, $40k stock, $15k annual bonus)
Here's the 17 interview questions they were asked:
(how many of these could you answer?)
The best Data Scientists aren't good because they know Python, TensorFlow, and Spark.
They're good because they can solve tough problems using good coding practices and the right data tools for the job.
Don't be tied to a particular language or framework.
Linear Algebra is FOUNDATIONAL to Data Science & Machine Learning.
Hereโs 3 FREE Linear Algebra resources I highly recommend to build a strong foundation ๐งต๐
My 22-year old coaching client landed a new-grad Machine Learning job at a NYC startup that pays $175k per year ๐
($120k base, $40k stock, $15k annual bonus)
Here's the 17 interview questions they were asked:
(how many of these could you answer?)
Google recently released an "Interview Warmup" tool, to help candidates who are applying to Data Analytics jobs at Google better prep for their technical interview.
Here's 15 Data Analytics Questions Google expects you to know:
(how many can you answer??)
Google recently released an "Interview Warmup" tool, to help candidates who are applying to Data Analytics jobs at Google better prep for their technical interview.
Here's 15 Data Analytics Questions Google expects you to know:
(how many can you answer??)
My 22-year old coaching client landed a new-grad Machine Learning job at a NYC startup that pays $175k per year ๐
($120k base, $40k stock, $15k annual bonus)
Here's the 17 interview questions they were asked:
(how many of these could you answer?)
๐ฆ๐ค๐ ๐ง๐๐๐ผ๐ฟ๐ถ๐ฎ๐น ๐ณ๐ผ๐ฟ ๐๐ฎ๐๐ฎ ๐๐ป๐ฎ๐น๐๐๐ถ๐ฐ๐ / ๐๐ฎ๐๐ฎ ๐ฆ๐ฐ๐ถ๐ฒ๐ป๐ฐ๐ฒ:
31 interactive SQL lessons lessons for FREE.
20+ practice exercises which you solve directly in the browser - no installation needed.
๐
My 22-year old coaching client landed a new-grad Machine Learning job at a NYC startup that pays $175k per year ๐
($120k base, $40k stock, $15k annual bonus)
Here's the 17 interview questions they were asked:
(how many of these could you answer?)
The best Data Scientists aren't great because they mastered SQL, Pandas, or TensorFlow.
They're great because they do these 3 things:
1. Solve tough problems with data
2. Solve tough problems with data
3. Solve tough problems with data
Let's not lose sight of the big picture!
Being a Data Scientist can be a gateway to a career in:
- Data Engineering
- Technical Consulting
- Software Engineering
- Database Administration
- Data Product Management
- Cloud Solutions Architecture
- Machine Learning Engineering
Your dream job is one book away.
Software Engineers -> Cracking the Coding Interview
Sr. SWE -> System Design Interview Insider's Guide
Data Scientists -> Ace the Data Science Interview
Designers -> Solving Product Design Exercises
PMs -> Cracking the PM Interview
My 22-year old coaching client landed a new-grad Machine Learning job at a NYC startup that pays $175k per year ๐
($120k base, $40k stock, $15k annual bonus)
Here's the 17 interview questions they were asked:
(how many of these could you answer?)
I've read hundreds of Data Science books, and even wrote one too.
Sadly, most Data Science books aren't worth your time.
That's why I curated a list of the 5 Best Data Science Books every Data Scientist should read ๐งต๐
It's one thing to make an LLM demo, but a totally different challenge to put that LLM into production!
This fantastic 24-page guide by
@chipro
is a must read when it comes to tackling the challenges involved with productionizing LLMs!
Link:
Trying to break into Data Analytics, Digital Marketing, or Software Engineering?
Did you know that Facebook, Google, & IBM each have multiple FREE training programs and courses?
Here's the details (you should bookmark this ๐งต)
๐
I just have to say this: We conducted interviews for 5 data analysts today, Friday, July 28, 2023, and surprisingly, none of the candidates could state clearly the differences between "statistic" and "statistics."
Advanced SQL Interviews LOVE to test you on Window Functions.
Here's 4 real SQL interview questions from Uber, Google, Spotify & Wayfair to practice SQL window functions like:
โข LEAD()
โข LAG()
โข RANK()
โข DENSE_RANK()
โข ROW_NUMBER()
โข NTH_VALUE()
๐งต๐
A past coaching client of mine interviewed for an entry-level Data Science job in Los Angeles that paid $110k per year.
Here's the 19 interview questions they were asked:
(how many of these could you answer?)
A past coaching client of mine interviewed for an entry-level Data Science job in Los Angeles that paid $110k per year.
Here's the 19 interview questions they were asked:
(how many of these could you answer?)
Linear Algebra is FOUNDATIONAL to Data Science & Machine Learning.
Hereโs 3 FREE Linear Algebra resources I highly recommend to build a strong foundation ๐งต๐
Here's an Amazon Data Analyst SQL assessment featuring 4 increasingly more complex questions about Amazon orders... can you solve them?
Input data & Amazon SQL interview questions below ๐๐
Advanced SQL Interviews LOVE to test you on Window Functions.
Here's 4 real SQL interview questions from Uber, Google, Spotify & Wayfair to practice SQL window functions like:
โข LEAD()
โข LAG()
โข RANK()
โข DENSE_RANK()
โข ROW_NUMBER()
โข NTH_VALUE()
๐งต๐
It's one thing to make an LLM demo, but a totally different challenge to put that LLM into production!
This fantastic 24-page guide by
@chipro
is a must read when it comes to tackling the challenges involved with productionizing LLMs!
Link:
Data Science Interviews cover a HUGE range of topics:
๐น Data Structures & Algorithms
๐น Product/Business Sense
๐น Machine Learning
๐น Statistics
๐น Python
๐น SQL
Seems like a lot?
IT F**KING IS !!
Here's why Data Science interviews seem to cover everything under the sun ๐งต๐
Hit 100,000 followers on LinkedIn!
If you are a Data Scientist, Data Analyst, or into Machine Learning, let's connect on LinkedIn!
I wanna see the Twitter Data community connected so we can grow our careers together!
Drop your LinkedIn URL ๐๐
Can you solve this real Microsoft SQL interview question:
โWhich Azure customer buys at least 1 Azure product from each product category?โ
You're given a customer_contracts table & a table of Azure products.
A past coaching client of mine interviewed for an entry-level Data Science job in Los Angeles that paid $110k per year.
Here's the 19 interview questions they were asked:
(how many of these could you answer?)
Have an upcoming SQL interview, and freaking out about it?
Here's how to cram, depending on if you've only got a few hours or a few days to prep for the SQL interview:
4 real SQL Window Function Interview Questions:
Uber Interview x ROW_NUMBER():
Google Interview x ROW_NUMBER():
Spotify Interview x DENSE_RANK():
Wayfair Interview x LAG():
โcouldn't find an internship so I built an AI Robot Handโ
Creating portfolio projects is an amazing way to stand out on the job hunt but I've never seen someone do a project as well as Alan Lu & his robot hand!
Want your portfolio project to stand out too?
Here's 3 tips ๐งต
A past coaching client of mine interviewed for an entry-level Data Science job in Los Angeles that paid $110k per year.
Here's the 19 interview questions they were asked:
(how many of these could you answer?)
Here's an Amazon Data Analyst SQL assessment featuring 4 increasingly more complex questions about Amazon orders... can you solve them?
Input data & Amazon SQL interview questions below ๐๐
Being a Data Scientist can be a gateway to a career in:
- Data Engineering
- Technical Consulting
- Software Engineering
- Database Administration
- Data Product Management
- Cloud Solutions Architecture
- Machine Learning Engineering
Data Science Interviews cover a HUGE range of topics:
๐น Data Structures & Algorithms
๐น Product/Business Sense
๐น Machine Learning
๐น Statistics
๐น Python
๐น SQL
Seems like a lot?
IT F**KING IS !!
Here's why Data Science interviews seem to cover everything under the sun ๐งต๐
Everyone says "portfolio projects get you hired".
But what does that actually look like?
Check out this Data Analyst Success Story & their Customer Analytics Project:
My 22-year old coaching client landed a new-grad Machine Learning job at a NYC startup that pays $175k per year ๐
($120k base, $40k stock, $15k annual bonus)
Here's the 17 interview questions they were asked:
(how many of these could you answer?)
Popular SQL Interview Question:
What's the difference between RANK() and DENSE_RANK()?
SQL interviews for Data Analyst/Data Science jobs LOVE to test you on window functions & one of the most tested window functions is RANK() vs. DENSE_RANK().
My answer ๐
I've read hundreds of Data Science books, and even wrote one too.
Sadly, most Data Science books aren't worth your time.
That's why I curated a list of the 5 Best Data Science Books every Data Scientist should read ๐งต๐