Thoughts and advice for a live SQL coding round

Data Science With Marco · Intermediate ·📊 Data Analytics & Business Intelligence ·3y ago

Key Takeaways

The video provides advice and thoughts on how to approach a live SQL coding round, covering topics such as SQL coding best practices, time management, and problem-solving strategies.

Full Transcript

have you done a live SQL coding round I have never done this before and I want to get your thoughts on how did you find it yes I've done it and it's horrible but that being said let me give you some advices so you can Ace your SQL live coding round so first of all get a lot of practice so go on hiker Rank and Lead code don't be afraid to pay for the premium version you know at least for a month get get a lot of practice and second when you are doing the interview explain out loud what you are doing even better plan ahead okay so once you're given the problem make a plan of what are the steps that should be done in order to achieve your your objective to solve the problem and then start writing your SQL code it will be much easier for you keeps everything organized and you're gonna do less mistakes so yeah good luck on an interview
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Playlist

Uploads from Data Science with Marco · Data Science with Marco · 32 of 38

1 Linear Regression in Python | Data Science with Marco
Linear Regression in Python | Data Science with Marco
Data Science with Marco
2 Classification in Python | logistic regression, LDA, QDA | Data Science With Marco
Classification in Python | logistic regression, LDA, QDA | Data Science With Marco
Data Science with Marco
3 Resampling and Regularization | Data Science with Marco
Resampling and Regularization | Data Science with Marco
Data Science with Marco
4 Decision Trees | Data Science with Marco
Decision Trees | Data Science with Marco
Data Science with Marco
5 Suppor Vector Machine (SVM) in Python | Data Science with Marco
Suppor Vector Machine (SVM) in Python | Data Science with Marco
Data Science with Marco
6 Unsupervised Learning | PCA and Clustering | Data Science with Marco
Unsupervised Learning | PCA and Clustering | Data Science with Marco
Data Science with Marco
7 Data Science Portfolio Project: Regression #1 | Data Science with Marco
Data Science Portfolio Project: Regression #1 | Data Science with Marco
Data Science with Marco
8 Data Science Portfolio Project: Regression #2 | Data Science with Marco
Data Science Portfolio Project: Regression #2 | Data Science with Marco
Data Science with Marco
9 What Are Time Series - Applied Time Series Analysis in Python and TensorFlow
What Are Time Series - Applied Time Series Analysis in Python and TensorFlow
Data Science with Marco
10 Basic Statistics - Applied Time Series Analysis in Python and TensorFlow
Basic Statistics - Applied Time Series Analysis in Python and TensorFlow
Data Science with Marco
11 Autocorrelation and White Noise - Applied Time Series Analysis in Python and TensorFlow
Autocorrelation and White Noise - Applied Time Series Analysis in Python and TensorFlow
Data Science with Marco
12 Stationarity and Differencing - Applied Time Series Analysis in Python and TensorFlow
Stationarity and Differencing - Applied Time Series Analysis in Python and TensorFlow
Data Science with Marco
13 Random Walk Model - Applied Time Series Analysis in Python and TensorFlow
Random Walk Model - Applied Time Series Analysis in Python and TensorFlow
Data Science with Marco
14 Moving Average Process - Applied Time Series Analysis in Python and TensorFlow
Moving Average Process - Applied Time Series Analysis in Python and TensorFlow
Data Science with Marco
15 Autoregressive Process - Applied Time Series Analysis in Python and TensorFlow
Autoregressive Process - Applied Time Series Analysis in Python and TensorFlow
Data Science with Marco
16 ARMA Model - Time Series Analysis in Python and TensorFlow
ARMA Model - Time Series Analysis in Python and TensorFlow
Data Science with Marco
17 What is data science?
What is data science?
Data Science with Marco
18 Answering DATA SCIENCE questions #1 - Why learn SQL when Python and R exist?
Answering DATA SCIENCE questions #1 - Why learn SQL when Python and R exist?
Data Science with Marco
19 R vs Python in the Industry - Data Science Q&A #datascience #datasciencecareer #careeradvice
R vs Python in the Industry - Data Science Q&A #datascience #datasciencecareer #careeradvice
Data Science with Marco
20 Data science or data engineering - which is best for you? #datascience #datasciencecareer
Data science or data engineering - which is best for you? #datascience #datasciencecareer
Data Science with Marco
21 Where to find data for data science projetcs? #datascience #datasciencecareer
Where to find data for data science projetcs? #datascience #datasciencecareer
Data Science with Marco
22 Data science certificates on resume? #datascience #datasciencecareer #careeradvice
Data science certificates on resume? #datascience #datasciencecareer #careeradvice
Data Science with Marco
23 Should you aim for data science or data engineering? | Data Science Q&A #1
Should you aim for data science or data engineering? | Data Science Q&A #1
Data Science with Marco
24 Don't waste time on this | #datascience #datasciencecareer
Don't waste time on this | #datascience #datasciencecareer
Data Science with Marco
25 Low-code AI tools - are they good? | #datascience #datasciencecareer #careeradvice
Low-code AI tools - are they good? | #datascience #datasciencecareer #careeradvice
Data Science With Marco
26 How to grow as a data scientist after 2+ years of experience? #datascience #datasciencecareer
How to grow as a data scientist after 2+ years of experience? #datascience #datasciencecareer
Data Science with Marco
27 Transition into DATA SCIENCE without a masters or bootcamp #careertransition
Transition into DATA SCIENCE without a masters or bootcamp #careertransition
Data Science With Marco
28 How to improve your data science profile?
How to improve your data science profile?
Data Science With Marco
29 How to learn Python for data science?
How to learn Python for data science?
Data Science With Marco
30 Does Scrum/Agile work for data science?
Does Scrum/Agile work for data science?
Data Science With Marco
31 What are the major roles in analytics and how to choose?
What are the major roles in analytics and how to choose?
Data Science with Marco
Thoughts and advice for a live SQL coding round
Thoughts and advice for a live SQL coding round
Data Science With Marco
33 Data science interview question: difference between type 1 and type 2 error
Data science interview question: difference between type 1 and type 2 error
Data Science With Marco
34 Feature selection in machine learning | Full course
Feature selection in machine learning | Full course
Data Science With Marco
35 Anomaly detection in time series with Python | Data Science with Marco
Anomaly detection in time series with Python | Data Science with Marco
Data Science With Marco
36 Podcast - TimeGPT, predicting the future, and more
Podcast - TimeGPT, predicting the future, and more
Data Science With Marco
37 Big announcement - Revealing my new book
Big announcement - Revealing my new book
Data Science With Marco
38 Get Started in Time Series Forecasting in Python | Full Course
Get Started in Time Series Forecasting in Python | Full Course
Data Science With Marco

This video provides valuable advice and thoughts on how to approach a live SQL coding round, helping data scientists and analysts improve their SQL coding skills and prepare for technical interviews.

Key Takeaways
  1. Review SQL syntax and basics
  2. Practice solving complex SQL problems
  3. Focus on time management and coding efficiency
  4. Use online resources and tutorials to improve skills
  5. Prepare for common SQL interview questions
💡 Effective time management and coding efficiency are crucial in a live SQL coding round, and practicing with real-world problems and scenarios can help improve skills and build confidence.

Related AI Lessons

Why Statistics is Important in Data Science
Statistics is the foundation of data science, enabling professionals to extract insights and make informed decisions from data, and its importance cannot be overstated
Medium · Data Science
Does This Have AI in It Yet?
You can build AI-friendly systems using existing data discipline skills, no new skills required
Medium · Data Science
Web Scraping with Python in 2026: Best Libraries and Anti-Bot Strategies
Learn to scrape websites with Python in 2026 using the best libraries and anti-bot strategies to avoid being blocked
Dev.to · Etrit Neziri
How Wisconsin Used Foxes And Deer To Revamp Science Education
Wisconsin's innovative use of trail camera photos and public input revolutionizes science education and wildlife management
Forbes Innovation
Up next
Spreadsheet Guy Meets the CFO: "Define How Much"
Digital Transformation with Eric Kimberling
Watch →