SELECT FROM WHERE GROUP BY HAVING ORDER BY DISTINCT TOP/LIMIT/OFFSET FETCH (Depending on database being used) , FUNCTIONS ,CTEs , WINDOW FUNCTIONS., SET OPERATIONS , JOINS , SUB QUERYS and FINALLY SQL OPTIMIZATION
Hi everyone! It is helpful information for me! This is a great idea for using SQL in budget analysis for a beginner like me. Agatha, thank you so much!
Just what I needed to hear for my new adventure of learning SQL. Great job presenting it so clear like this. Subscribed and liked you, of course! looking to learn more from you. thanks!
Thanks a lot Agatha for sharing this, I'm currently learning SQL and these tips helped me so much especially the beginner, intermediate and the advanced section.
Great video. Thanks for the inspiration. I've learned SQL before but did not really delve into actual practice. But with your video, you've just encouraged me to pursue it. I guess, it's meant to stumble on your video today to urge me further as I've been contemplating to learn it further.
I've just found your channel recently. I found your advice extremely helpful for a fresh graduate like me. I major in statistics and think that I can go further as a data analyst. Keep it up, your content is great !
Great video! Quick question, would a Business Analyst need beginner or an intermediate level of SQL? Data Analyst and Business Analyst often times overlap but I feel like it depends on the job description too.
I’m soo happy I get to see your channel, this is helpful for someone like me who would like to transition to data analyst role. I just quit my job, and taking my time to concentrate on upskilling. I’ve been watching a lot of videos but it is somehow overwhelming, but your videos gave a me a guide to follow as my learning roadmap, and hopefully I can learn this easily same as you do. Btw do you have a video that will give us a sample view of what exactly are the usual analysis being done by someone in data analyst role position? Do you happen to have examples related to KPI analysis and reports? Thank you so much! I will surely check your other videos! 😊
It’s actually useful, more useful than a lot of SQL videos out there bec she breaks down the skills and she also mentions what skill level is sufficient for a lot of roles. I have seen so many aspiring data analysts that just go straight to learning SQL and try to learn them all at once but as entry level, u actually only need beginner level to create your projects that will be included in your portfolio then to be job-ready, you need to have at least intermediate SQL. I am a supply chain data analyst and I only use intermediate level SQL bec our data engineers and other data people are usually the ones that require the advanced level. If you don’t know this, then you can easily get lost with all these SQL courses and practice tests online then u end up not using these advanced SQL skills in the job anyway. You’ll end up basically just wasting your time learning all these advanced SQL like performance tuning when u don’t even use them in your job bec it’s not your job to do it anyway but someone else’s.
Hey, I heard you can get SQL certification from Microsoft and the rest from Coursera. Getting certified is good but corporates focus more on the subject knowledge than the actual certification.
Structured Query Language (SQL) (pronounced S-Q-L; historically "sequel")[4][5] is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables.
I find its best to just keep going and the brain learns the connections of code.. learn to use documentation and these days AI.. and can do anything on the job.. the really good familiarity will build later.. but the important thing is being able to get the job done by any means at disposal.
I know you mean well ,but for the most part it's quite difficult to pay or invest in the courses , especially these paid ones . I'm african , which doesnt matter but as a young working adult or even a uni student it'll be very hard to gather the money for the payment of the data course. If there was a way to pay in installments it'll help significantly Imaging earning less than $150 and having to pay for a course when you also have a whole month ahead with no other source of income
Get 25% off DataCamp using my link: datacamp.pxf.io/xkW3B1
The link seems to have access problem . Please help to check
@@cautran7536 hmm it works for me but I will check!
Thank you
I got a scholarship to learn Data science from Datacamp . Wow , I am going to maximize it to the fullest
Thank you madam 🌹
hi link didnt work for me either
SELECT FROM WHERE GROUP BY HAVING ORDER BY DISTINCT TOP/LIMIT/OFFSET FETCH (Depending on database being used) , FUNCTIONS ,CTEs , WINDOW FUNCTIONS., SET OPERATIONS , JOINS , SUB QUERYS and FINALLY SQL OPTIMIZATION
Hi everyone!
It is helpful information for me! This is a great idea for using SQL in budget analysis for a beginner like me.
Agatha, thank you so much!
Thank you for this video Agatha! Your videos are very beginner friendly and informative without talking over our heads.
Thanks, from Indonesian.
Omg i am literally stressed over watching many videos and struggling to solve leetcode and hackerank but u came like an light thank you so much
You're welcome! Glad this helps!
Just what I needed to hear for my new adventure of learning SQL. Great job presenting it so clear like this. Subscribed and liked you, of course! looking to learn more from you. thanks!
such a nice lady, I mean i can organically feel the positivity. Thank you.
Thanks a lot Agatha for sharing this, I'm currently learning SQL and these tips helped me so much especially the beginner, intermediate and the advanced section.
concise, informative, and you covered everything. thanks girlie
Great video, thanks for the valuable tips. Hugs from Brazil.
Great video. Thanks for the inspiration. I've learned SQL before but did not really delve into actual practice. But with your video, you've just encouraged me to pursue it. I guess, it's meant to stumble on your video today to urge me further as I've been contemplating to learn it further.
I've just found your channel recently. I found your advice extremely helpful for a fresh graduate like me. I major in statistics and think that I can go further as a data analyst. Keep it up, your content is great !
6:08 thank you 🙏🙏 so convenient
Great video! Quick question, would a Business Analyst need beginner or an intermediate level of SQL? Data Analyst and Business Analyst often times overlap but I feel like it depends on the job description too.
Depends on what you need to use it for.
I really appreciate your content, i have a Bachelor in Economics and recently done short course in business analytics
me too, even as economists, they are asking to have advanced knowledge in SQL,R or Python and financial SAP
Thank you!
I’m soo happy I get to see your channel, this is helpful for someone like me who would like to transition to data analyst role. I just quit my job, and taking my time to concentrate on upskilling. I’ve been watching a lot of videos but it is somehow overwhelming, but your videos gave a me a guide to follow as my learning roadmap, and hopefully I can learn this easily same as you do. Btw do you have a video that will give us a sample view of what exactly are the usual analysis being done by someone in data analyst role position? Do you happen to have examples related to KPI analysis and reports? Thank you so much! I will surely check your other videos! 😊
Thank u so much for this amazing video love it😊
What certification would look best on a Resume for SQL?
I'd like to know that too
None
Personal projects > certifications
This video was very informative, Agatha.
Great video!
Still confused how to practice.. on what..
Thank you for this video.
Thanks for this video ! There seem to be a problem with the link for Data Camp provided.
Thank you.
Thank you Agatha
Thanks a lot for this awesome video Agatha!
Can you tell me best websites to search for data jobs for remote workers?
Thanks a lot Agatha for sharing these helpful tips and studies.
SELECT
Nice restaurant
FROM
Your city
WHERE
< 15 km from your house
I thought I was a clever programmer until I saw a 100+ line sql query
Does a person who knows sql have to be good with computers? And does everyone who know sql considered tech savy?
hey Agatha thankyou for this video, could you please suggest me some SQL portfolio project which is more relevant to getting the job...
learn sql fast = pay datacamp course
Agatha, do you require a video editor to edit your shorts content? It helps boost your channel.
What level in SQL does a Business Analyst need ?
great advice, applicable to any kind of learning we need to engage,
Amen!
what minimum PC specs you recommend?
i always struggle in solving intermediate and advance problems can you suggest something?
Very helpful information Agatha
Okay, seen nothing but a simple select statement on the screen... Videos is clearly up for the DataCamp advertisement. Channel blocked for clickbait.
6:08 is a breakdown of the skill levels. You're welcome...
It’s actually useful, more useful than a lot of SQL videos out there bec she breaks down the skills and she also mentions what skill level is sufficient for a lot of roles.
I have seen so many aspiring data analysts that just go straight to learning SQL and try to learn them all at once but as entry level, u actually only need beginner level to create your projects that will be included in your portfolio then to be job-ready, you need to have at least intermediate SQL.
I am a supply chain data analyst and I only use intermediate level SQL bec our data engineers and other data people are usually the ones that require the advanced level.
If you don’t know this, then you can easily get lost with all these SQL courses and practice tests online then u end up not using these advanced SQL skills in the job anyway. You’ll end up basically just wasting your time learning all these advanced SQL like performance tuning when u don’t even use them in your job bec it’s not your job to do it anyway but someone else’s.
They're all "influencers". No one does shit without a referral link 😂
great tips!
Thank you!!
Do you have a code for monthly subscription? Thanks
6:05 rest is crap
Did you also learn statistics fundamentals?
Hi, should I go for these certificates to learn about data analytics or learn separately like excel, sql, python and so on .
Hey, I heard you can get SQL certification from Microsoft and the rest from Coursera. Getting certified is good but corporates focus more on the subject knowledge than the actual certification.
Can you start SQL course
Obrigado pelo conteúdo ! Estou me desevolvendo muito.
You're welcome!!
I Think SQL isn't Programing Language Right?!
Structured Query Language (SQL) (pronounced S-Q-L; historically "sequel")[4][5] is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables.
@@MichaelKaplan-c2o i know but in video she said it's programing language. But SQL isn't you u can't use it to programing
It does have loops and functions.
does college degree matter to get into tech as a fresher ?? especially in asian countries?, please answer this question
I know a friend that is going back get her degree in cs and she was offered an internship role
I find its best to just keep going and the brain learns the connections of code.. learn to use documentation and these days AI.. and can do anything on the job.. the really good familiarity will build later.. but the important thing is being able to get the job done by any means at disposal.
I don't know she has this AURA on her so much positivity energy
I know you mean well ,but for the most part it's quite difficult to pay or invest in the courses , especially these paid ones . I'm african , which doesnt matter but as a young working adult or even a uni student it'll be very hard to gather the money for the payment of the data course. If there was a way to pay in installments it'll help significantly
Imaging earning less than $150 and having to pay for a course when you also have a whole month ahead with no other source of income
Try W3schools and
Summary: this video is about sponsoring the bullshit website guys, nothing more
i like it cause she's asian so she must know
This is paid service don’t make fool
Thank you