Machine Learning News Hubb
Advertisement Banner
  • Home
  • Machine Learning
  • Artificial Intelligence
  • Big Data
  • Deep Learning
  • Edge AI
  • Neural Network
  • Contact Us
  • Home
  • Machine Learning
  • Artificial Intelligence
  • Big Data
  • Deep Learning
  • Edge AI
  • Neural Network
  • Contact Us
Machine Learning News Hubb
No Result
View All Result
Home Artificial Intelligence

SQL Interview Study Plan for Data Scientists | by Yasmine Hejazi | Sep, 2022

admin by admin
September 8, 2022
in Artificial Intelligence


A SQL Study Plan with LeetCode questions

Photo by Christina @ wocintechchat.com on Unsplash

A numerous amount of data science positions require proficiency in SQL. As a result, a SQL technical interview is commonly included in the data science interview process.

LeetCode is a great source for practicing interviews, ranging from data structures & algorithms to SQL. LeetCode categorizes their questions into difficulty levels of easy, medium, and hard. LeetCode also has their own SQL study plans; however, the SQL topics are not sorted out well (or correctly in some cases) and therefore I find LeetCode more helpful as a testing tool than a studying tool.

This study guide categorizes SQL questions into different SQL topics so that the user can improve competency by area via focus and repetitions. You will find selected links to LeetCode questions that are a good representation of interview questions for each topic.

Study Plan Timeline

A good pace for this study guide is to attempt 2–4 SQL questions a day. This allows you to choose a SQL topic you will focus on for the study duration and solidify your understanding of that area. If you feel that you are already strong in the basic areas, you can skip them and focus on the more intermediate and advanced topics.

Photo by Estée Janssens on Unsplash

Day 9— Day 10: These days cover window functions. I’ve found that a good study source is sqltutorial.org SQL Window Functions page. Read through the short article, then go over each window function on the bottom of the page (value window functions and ranking window functions). There aren’t many non-premium LeetCode questions on window functions, so getting further practice in the area, especially ranking functions, is recommended.

Day 1: Select and Filter

The SQL SELECT function selects columns from one or more tables. The SQL WHERE clause lets you filter rows based on one or more conditions.

Day 2: Joins and Union

There are 4 main types of joins: INNER JOIN (or JOIN), LEFT JOIN / RIGHT JOIN, FULL OUTER JOIN, and CROSS JOIN.

The SQL UNION function combines result sets of two or more select statements into a single result. The SQL UNION ALL function retains the duplicate rows.

Day 3: Group By

The SQL GROUP BY clause groups rows based on values of one or more columns, returning one row for each group. You can perform aggregate functions such as SUM and COUNT to each group.

Day 4: Group By

The SQL HAVING clause specifies a condition for groups defined in GROUP BY. This is typically used to filter rows resulted from group by and aggregation.

Day 5: Case When

The SQL CASE function evaluates one of more conditions and returns results defined by that condition. This is just like an if statement.

Day 6: Subquery

A SQL subquery is a query nested inside of another query. You can use the results of one query to support another.

Day 7: Update and Remove From Table

The SQL UPDATE function changes existing data in a table. The SQL DELETE function removes one or more rows from a table.

Day 8: String Processing

There are many string processing functions such as UPPER, LOWER, CONCAT, GROUP_CONCAT, TRIM, and utilization of regular expressions. Become familiar with some common SQL string functions here.

Day 9: Value Window Functions

The FIRST_VALUE() and LAST_VALUE() window functions return the first value and last value in an ordered set of values respectively. The LAG() window function provides access to data of the previous row or rows. The LEAD() window function provides access to data of the following row or rows.

Day 10: Ranking Window Functions

Notable ranking window functions are ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE(). You can familiarize yourself with value and ranking window functions here.

To test SQL proficiency, SQL technical interviews are frequently included in the data science interview process. LeetCode serves as a great resource for practicing interviews, however, the randomization of questions generates a testing tool rather than a study tool. To align study focus to one SQL topic at a time, this study guide categorizes LeetCode SQL questions into core topics that come up in SQL interviews.



Source link

Previous Post

Deep Learning In Minutes !!!. Although far from being able to match… | by Nerd Dev | Sep, 2022

Next Post

The Best Way to do Named Entity Recognition (NER) | by Yujian Tang | Sep, 2022

Next Post

The Best Way to do Named Entity Recognition (NER) | by Yujian Tang | Sep, 2022

9 Visualizations to Show Proportions or Percentages instead of a Pie chart | by Boriharn K | Sep, 2022

Huawei 2022 DIGIX: Global AI Challenge Başlıyor | by Elanuryurur | Huawei Developers - Türkiye | Sep, 2022

Related Post

Artificial Intelligence

Dates and Subqueries in SQL. Working with dates in SQL | by Michael Grogan | Jan, 2023

by admin
January 27, 2023
Machine Learning

ChatGPT Is Here To Stay For A Long Time | by Jack Martin | Jan, 2023

by admin
January 27, 2023
Machine Learning

5 steps to organize digital files effectively

by admin
January 27, 2023
Artificial Intelligence

Explain text classification model predictions using Amazon SageMaker Clarify

by admin
January 27, 2023
Artificial Intelligence

Human Resource Management Challenges and The Role of Artificial Intelligence in 2023 | by Ghulam Mustafa Shoaib | Jan, 2023

by admin
January 27, 2023
Deep Learning

Training Neural Nets: a Hacker’s Perspective

by admin
January 27, 2023

© 2023 Machine Learning News Hubb All rights reserved.

Use of these names, logos, and brands does not imply endorsement unless specified. By using this site, you agree to the Privacy Policy and Terms & Conditions.

Navigate Site

  • Home
  • Machine Learning
  • Artificial Intelligence
  • Big Data
  • Deep Learning
  • Edge AI
  • Neural Network
  • Contact Us

Newsletter Sign Up.

No Result
View All Result
  • Home
  • Machine Learning
  • Artificial Intelligence
  • Big Data
  • Deep Learning
  • Edge AI
  • Neural Network
  • Contact Us

© 2023 JNews - Premium WordPress news & magazine theme by Jegtheme.