Get 25% off DataCamp using my link: datacamp.pxf.io/xkW3B1
@cautran7536Ай бұрын
The link seems to have access problem . Please help to check
@agathakangАй бұрын
@@cautran7536 hmm it works for me but I will check!
@adestemitope9730Ай бұрын
Thank you I got a scholarship to learn Data science from Datacamp . Wow , I am going to maximize it to the fullest
@TDMac11Күн бұрын
such a nice lady, I mean i can organically feel the positivity. Thank you.
@apamwambaАй бұрын
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
@dcj247Ай бұрын
Thank you for this video Agatha! Your videos are very beginner friendly and informative without talking over our heads.
@mustakmnm7Ай бұрын
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.
@moonshine6712 сағат бұрын
I don't know she has this AURA on her so much positivity energy
@srs8734Ай бұрын
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
@agathakangАй бұрын
You're welcome! Glad this helps!
@hoangtrung9236Ай бұрын
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 !
@gospelmoto2833Ай бұрын
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.
@dimakatsoramosidi7408Ай бұрын
I really appreciate your content, i have a Bachelor in Economics and recently done short course in business analytics
@trujilloroldancarlosarturo4281Ай бұрын
me too, even as economists, they are asking to have advanced knowledge in SQL,R or Python and financial SAP
@GeoV23Ай бұрын
6:08 thank you 🙏🙏 so convenient
@nishantkarakoti40466 күн бұрын
Thank u so much for this amazing video love it😊
@francesdobbins2964Ай бұрын
This video was very informative, Agatha.
@tammymui858729 күн бұрын
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.
@muneebboloАй бұрын
Thanks a lot Agatha for sharing these helpful tips and studies.
@khakha169325 күн бұрын
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! 😊
@joecater89426 күн бұрын
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.
@sallycheng614912 күн бұрын
Thank you for this video.
@joe-fc6beАй бұрын
Thank you Agatha
@bonfaceangatia9203Ай бұрын
Very helpful information Agatha
@sayesko97Ай бұрын
Thanks a lot for this awesome video Agatha! Can you tell me best websites to search for data jobs for remote workers?
@metallic907Ай бұрын
What certification would look best on a Resume for SQL?
@anjucaesar93Ай бұрын
I'd like to know that too
@kingtauАй бұрын
None
@emulevu25 күн бұрын
Thank you.
@SujeetVlogs16Ай бұрын
Agatha, do you require a video editor to edit your shorts content? It helps boost your channel.
@saudmir24Ай бұрын
Hi, should I go for these certificates to learn about data analytics or learn separately like excel, sql, python and so on .
@4Rs94Ай бұрын
Thanks for this video ! There seem to be a problem with the link for Data Camp provided.
@vishalsehgal6454Ай бұрын
i always struggle in solving intermediate and advance problems can you suggest something?
@_raickАй бұрын
Obrigado pelo conteúdo ! Estou me desevolvendo muito.
@agathakangАй бұрын
You're welcome!!
@utsabsarkar4462Ай бұрын
hey Agatha thankyou for this video, could you please suggest me some SQL portfolio project which is more relevant to getting the job...
@amoasiwa.n6598Ай бұрын
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
@kingtauАй бұрын
Try W3schools and
@rubeneduard7271Ай бұрын
Do you have a code for monthly subscription? Thanks
@JulFrankeАй бұрын
what minimum PC specs you recommend?
@leaks19652 күн бұрын
Okay, seen nothing but a simple select statement on the screen... Videos is clearly up for the DataCamp advertisement. Channel blocked for clickbait.
@SekPlusАй бұрын
great tips!
@agathakangАй бұрын
Thank you!!
@Jeff_buezeАй бұрын
Did you also learn statistics fundamentals?
@jaafarsadik258826 күн бұрын
I Think SQL isn't Programing Language Right?!
@user-vy6fn1xn5m19 күн бұрын
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.
@jaafarsadik258818 күн бұрын
@@user-vy6fn1xn5m i know but in video she said it's programing language. But SQL isn't you u can't use it to programing
@pumelelabanca144218 күн бұрын
It does have loops and functions.
@Brahmarishi2488Ай бұрын
Can you start SQL course
@expertgaming5146Ай бұрын
does college degree matter to get into tech as a fresher ?? especially in asian countries?, please answer this question
@opalthebestАй бұрын
I know a friend that is going back get her degree in cs and she was offered an internship role
@StrongMonica-v2b7 күн бұрын
Williams Timothy Moore Jeffrey Miller Timothy
@drorbenamiАй бұрын
SELECT Nice restaurant FROM Your city WHERE < 15 km from your house