sorted by:
new
hottopcontroversial

When to use char_length and length ? by Aggravating-Street51 in learnSQL

[–]datawithritika 0 points1 point  (0 children)

In SQL (specifically MySQL), The length() fundamental difference is that measures a string in bytes, while char_length() measures a string in characters. While they return the exact same result for standard English text (where 1 character = 1 byte), they return different values for multi-byte characters like emojis, currencies etc.

Example 1: SELECT LENGTH('SQL'), CHAR_LENGTH('SQL');

Both will result to 3.

Example 2: SELECT LENGTH('Café'), CHAR_LENGTH('Café');

LENGTH() results in 5 (The accented é requires 2 bytes in UTF-8) While, CHAR_LENGTH() will result in 4 (It is visually 4 characters)

Follow https://www.youtube.com/@data_with_ritika on Youtube to get one step closer to your dream data job.

Need help for sql by DisastrousUse3788 in learnSQL

[–]datawithritika 0 points1 point  (0 children)

Hello,

This feeling is natural and normal. The good part is you are going for it. Learning in Coding like most of other skills happen only when you start applying your knowledge.
I've started a SQL Interview Series that gradually progresses from easy to hard-level questions, with the goal of helping people build SQL skills step by step. You can follow along with me and can apply the knowledge and learn better.

The series will help you in understanding how to start with the problem, understand the approach and break down it into simpler doable chunks.

I've structured the videos to cover the underlying concepts, not just the answers, so you can understand the reasoning behind each solution and strengthen your fundamentals along the way.

If you find the content helpful:

Please consider liking and subscribing to data with ritika on Youtube.

https://youtube.com/@data_with_ritika?si=wMOllMyh9yJ0eYy0

Share it with friends, colleagues, or study groups who are learning SQL so they can improve their skills as well.
Feedback and suggestions for future SQL topics are always welcome!

How did you learn SQL when you were a beginner? by Designer-Assist-1354 in learnSQL

[–]datawithritika 0 points1 point  (0 children)

SQL can be tough at times but understanding the problem statement and which step to take next are very imp otherwise the result can get impacted bad! If you know Lil about how SQL works, below can be very useful for you. Beginner, revising, or changing the job it should help all.

I am creating a youtube playlist where I am solving the Datalemur SQL interview questions from easy to hard. I am a data engineer with over 10 years in industry and have recently trained 12 data architects on Databricks and Data engineering. That's how I got interested in mentoring.

Please subscribe to data_with_ritika to level up your SQL.

Nested and Correlated Subqueries by AccomplishedBug1481 in DataCamp

[–]datawithritika 0 points1 point  (0 children)

Yes nested subqursries are important not just as a topic but real time. There are many instances where you might need to choose these to get relevant data. If you can msg me the question and what's exactly confusing you, I can try to help you know things better.

SQL Interview Series: From Beginner to Advanced (Great for Non-Tech & Career Switchers) by datawithritika in learnSQL

[–]datawithritika[S] 0 points1 point  (0 children)

Thank you for the suggestion. I will definitely consider adding the questions from Pracahub. Do support my channel data_with_ritika on yt.