This has got to be the best advice ever. I just recently started SQL and noticed everything focused on syntax and I was so lost with it. I shifted to building and using Mysql and actual scenarios from starting to build tables to in depth data pulling etc instead of focusing on what EVERYTHING meant. I am being self taught and this helped me a huge amount. Thank you!
If you don't mind, Can you please share your approach to learning SQL or any source of learning? I'm just new to this language and doing everything on my own.
Task-oriented learning helps people learn faster and retain the knowledge while developing specific skills. This video is the most important that aspiring data professionals shoukd watch and the advice to heed.
I think this applies to everything programming maybe even everything technical. It's definitely not a trivial process but it's the best way to learn I know this far.
This is super true. I lived in Japan for 3 years and there was never a reason to learn many words that aren't used in conversation, like tree or van. I learned what was useful.
In my opinion, if I knew SQL's basic syntax and how they work, then I apply what I learned within a specific context, I can remember them longer. But anyway, I think your advice also is really useful, use SQL with a context better than only know the syntax. Thank you ^^
I’m beginner at coding and have been learning SQL for a week now and this is just what I was looking for. Unlike with other programming languages I studied so far, I’ve been having trouble applying the knowledge. The courses I found don’t teach at all how to do so. Glad to have found this video.
I like the idea of not learning SQL by rote memory, but by understanding they way the data could talk among itself, and how to make that happen. Without knowing the end result, all the syntax is meaningless. By the way- tickled at how you add an R to the end of the word "data" because of your accent. Charming. Thanks for the video.
I’m just gonna say it because everyone is already thinking it… that door handle is too high. But in all seriousness, this is fantastic advice for anyone beginning to code regardless of reason. When you have bad breath, you don’t need to understand the chemicals in toothpaste, how a toothbrush works, or why you need to brush for roughly two minutes. You just need to begin by brushing your teeth.
Great approach, 100% agree, I do remember when I was working as a management controller, with Excel functions for example, you could know by heart all the sophisticated functions in there, but if you don't have a good grasp of your data, what needs to be done, map the path and visualize the results, you won't make it far with those functions.
Max.I really loved the point you stressed on Data Handling. But I request you to give depth on topics like. 1) What to learn in SQL apart from Crud operations & Data types.What to do with demons like " Store procedures". 2) Which is the best platform to bring all data from various platform to one place .Is it Excel power pivot Data model or any other thing. 3) What topics to learn in Python?
Hi Divya, As a data analyst, you need to know this SQL: 1. Joining data sources together 2. Summarising data into summary numbers (i.e. from a list of customers to a number of customers, or a list of ages to an average age) and summarising by variables (i.e. to get a sense of what is driving differences in your summary numbersr). 3. Do 1 and 2 together, solving a range of problems, over and over again. You can look up the rest of the syntax you need along the way. Good luck
Thank you so much for this piece of advice because I was so hyper focused on the Syntax and remembering them all. I have downloaded your free course to follow with a real life example. Thank you so much
Thanks for this perspective, I'm on my 2nd day learning SQL, yesterday I felt like I was doing great with some basic syntax, today I feel extremely overwhelmed trying retain it all. Watching your video was just a reminder not to beat myself up too much, studying because I have an opportunity for a data integration analyst position pending acquiring the certifications required. I will look for your Udemy courses as well, thanks for the content
It's a really good advice, couldn't agree more with everything said in the video. Could you possibly give any directions to how and where one could be learning SQL/data-handling based on the real tasks? Especially more intermediate and advanced stuff since the basics are quite easy to learn and comprehend even if not put into a very specific context. Thanks!
Hi Ruslan thanks for the feedback. Unfortunately I haven't yet 'surveyed' the entire market (it's difficult as there are lots of courses and most cost money). I'd suggest to only consider courses that promise substantial problem solving. Here is one by a data science who has worked at a very reputable Australian company. Perhaps you couuld reach out to him with your concerns and hear what he has to say about his course www.datawithdanny.com/courses/serious-sql
I have started a course on Udemy about SQL & Power BI as I want a career shift to Business Intelligence. It started with SQL from beginner to intermediate level and I am facing the same problem - I am learning the syntax/language, but I do not know how to apply it on datasets to gain benefit from it so that I can make visualizations. I keep on learning new syntax but it doesn't seem very beneficial. I also forget syntax again n again.
This is precisely the problem I have had with learning SQL, what are we using it for and what problems are we solving. How do you suggest going about learning it?
Data Launch pad is showing up "Coming Soon" as I scrolled down was excited to see 3 imp courses, Analyse, handle and visualize .. very appealing and I see reviews but I get message "Coming Soon"
Hello, this is amazing advice! I've been learning SQL for the past couple of months now and have had this predicament. I have good understanding of the syntax but haven't yet applied it towards data handling. Have you got any resources you could recommend to shift my approach?
I have a free course on Udemy that covers the very basics and puts them in the context of a retail bank. www.udemy.com/course/sql-for-real-world-data-analysis/ Note free courses on udemy only allow 2h so this course only scratches the surface. For more advanced sql try to find a similar style course that promises "real business context"
Knowing the context of the SQL concept is important: * Change from learning SQL syntax to "Data Handling". (How data work - what to do in each situation). * SQL skill: Transfer to other tools and languages.
I’m not a DA yet, but it helped me learning the syntax first because it exposed me to what I can do with each command/combinations. Because now when I’m looking to implement some sort of query in a project I know how I can formulate it and then tighten up my syntax with each subsequent query. Similarly if you need to do something you’ll realize “ohhh that’s what that was for”, but it might just be me🤷♂️🤷♂️. I think really what I’m getting at is you don’t know what you don’t know lol
Max thanks for the videos. Quick question. When do you think your Udemy course titled ‘SQL for Data Analysis’ will be complete? I’ve finished the first part. Appreciate it.
How are people creating context / gathering feedback in this initial phase? How will companies give their data to do this real practice (especially for new folks)?
Are there many data analyst type roles in Qld? Specifically the GC/BNE regions? I'm starting to think about potentially making a lateral from accounting into an analyst type role sometime in the near future, but I don't know where to start! What's really holding me back though, is how stable accounting is as a career. I personally love the puzzle solving technical type of work there is in accounting, but it's not the most fulfilling type of work as it's a very backwards looking type of role, whereas I like to think I'm more future oriented. I don't know, maybe I just want someone to talk me into making the jump lol!
Checking your videos, great content! I've been trying to learn sql for the past month and I can totally relate to what you say. I will ceirtanly check your Udemy course, but would like to ask for some other examples or resources that you know of, that could help clarify this point to a begginer as myself. I also would like to ask for your opinion on how viable do you think it is for someone over 40 to get an entry level data analyst position. Thank you! 👍🏼
Hi Domenico, Age is unlikely to be a barrier per se. The question is 1) whether you meet the requirements for an entry level role in terms of your skills, and 2) whether you are the best person applying for the job. So how do you know if you have or can develop the skills? 1) Does your job history relate in any way to data, analysis, logical thinking? 2) Are you stronger than the average person in mathemathical thinking? 3) Try learning SQL and practice solving SQL problems (A good resource for practicing SQL problems by difficulty is sqlpad.io/) Then if you think you can do it, then invest the time to apply!
You told us the problem, they gave us a way through.. but how can we learn data handling.. can you recommend any channel.. I would have told you to upload video since you have been inactive since past 8 months so please tell me what are the free resources for learning it.
I just tried to buy your product in your website and it was unavailable. This is what i don’t like about smart people. Have the product operational first then create a distribution strategy. Doing vise versa is not as effective. 😔
So what should I do? Because I was thinking to look up some SQL RUclips videos .but how do you direct me to learn in context? Any SQL courses you can recommend?
Currently doing a project on T-SQL, I have a question if you do not mind. How are these Information schema tables designed so I can do joins, internet is full of helpful scripts like joining sys. objects to views and joining on on object ID but where I can learn how these tables are designed and so i can actually use joins to ensure I do not get data type errors on joining or no data
Sir i know sql for data analysis .. I know bits of python programming thats it .. I dont know python lib gor data science as an entry what should i do to get job.. Because i dont want to learn anything further before getting a job as an analyst .. Where to pick projects..?
I downloaded your Udemy course, and I’m trying to install it, but I keep getting the error message “no compatible servers were found. You’ll need to cancel this wizard and install one.” I don’t know how to do that or even what that means. Please help! 🙏🏻
This has got to be the best advice ever. I just recently started SQL and noticed everything focused on syntax and I was so lost with it. I shifted to building and using Mysql and actual scenarios from starting to build tables to in depth data pulling etc instead of focusing on what EVERYTHING meant. I am being self taught and this helped me a huge amount. Thank you!
If you don't mind, Can you please share your approach to learning SQL or any source of learning? I'm just new to this language and doing everything on my own.
building tables just isn't used in the real world, like ever
Task-oriented learning helps people learn faster and retain the knowledge while developing specific skills. This video is the most important that aspiring data professionals shoukd watch and the advice to heed.
Thanks Gregory.
Thanks Gregory. Did you have a good learning experience or find it difficult for lack of context?
I think this applies to everything programming maybe even everything technical. It's definitely not a trivial process but it's the best way to learn I know this far.
This is super true. I lived in Japan for 3 years and there was never a reason to learn many words that aren't used in conversation, like tree or van. I learned what was useful.
Damn, thank you for ur thoughts.
In my opinion, if I knew SQL's basic syntax and how they work, then I apply what I learned within a specific context, I can remember them longer. But anyway, I think your advice also is really useful, use SQL with a context better than only know the syntax. Thank you ^^
I’m beginner at coding and have been learning SQL for a week now and this is just what I was looking for. Unlike with other programming languages I studied so far, I’ve been having trouble applying the knowledge. The courses I found don’t teach at all how to do so. Glad to have found this video.
wow, exactly the advice i needed. been overwhelmed lately my syntax
I like the idea of not learning SQL by rote memory, but by understanding they way the data could talk among itself, and how to make that happen. Without knowing the end result, all the syntax is meaningless. By the way- tickled at how you add an R to the end of the word "data" because of your accent. Charming. Thanks for the video.
Thank you, yes I do pronounce it "data" ;)
I’m just gonna say it because everyone is already thinking it… that door handle is too high.
But in all seriousness, this is fantastic advice for anyone beginning to code regardless of reason. When you have bad breath, you don’t need to understand the chemicals in toothpaste, how a toothbrush works, or why you need to brush for roughly two minutes. You just need to begin by brushing your teeth.
Great approach, 100% agree,
I do remember when I was working as a management controller, with Excel functions for example, you could know by heart all the sophisticated functions in there, but if you don't have a good grasp of your data, what needs to be done, map the path and visualize the results, you won't make it far with those functions.
Max.I really loved the point you stressed on Data Handling.
But I request you to give depth on topics like.
1) What to learn in SQL apart from Crud operations & Data types.What to do with demons like " Store procedures".
2) Which is the best platform to bring all data from various platform to one place .Is it Excel power pivot Data model or any other thing.
3) What topics to learn in Python?
Hi Divya,
As a data analyst, you need to know this SQL:
1. Joining data sources together
2. Summarising data into summary numbers (i.e. from a list of customers to a number of customers, or a list of ages to an average age) and summarising by variables (i.e. to get a sense of what is driving differences in your summary numbersr).
3. Do 1 and 2 together, solving a range of problems, over and over again. You can look up the rest of the syntax you need along the way.
Good luck
This has to be the best starting advice for any data analyst out there. Subsribed.
Thank you so much for this piece of advice because I was so hyper focused on the Syntax and remembering them all. I have downloaded your free course to follow with a real life example. Thank you so much
Thanks for this perspective, I'm on my 2nd day learning SQL, yesterday I felt like I was doing great with some basic syntax, today I feel extremely overwhelmed trying retain it all.
Watching your video was just a reminder not to beat myself up too much, studying because I have an opportunity for a data integration analyst position pending acquiring the certifications required.
I will look for your Udemy courses as well, thanks for the content
A year later how’s it going for you?
It's a really good advice, couldn't agree more with everything said in the video. Could you possibly give any directions to how and where one could be learning SQL/data-handling based on the real tasks? Especially more intermediate and advanced stuff since the basics are quite easy to learn and comprehend even if not put into a very specific context. Thanks!
Hi Ruslan thanks for the feedback.
Unfortunately I haven't yet 'surveyed' the entire market (it's difficult as there are lots of courses and most cost money).
I'd suggest to only consider courses that promise substantial problem solving.
Here is one by a data science who has worked at a very reputable Australian company. Perhaps you couuld reach out to him with your concerns and hear what he has to say about his course www.datawithdanny.com/courses/serious-sql
This is got to be the best advice ever doing this
Thank you so much, I need to learn sql now and I'll try to follow your advice
I have started a course on Udemy about SQL & Power BI as I want a career shift to Business Intelligence. It started with SQL from beginner to intermediate level and I am facing the same problem - I am learning the syntax/language, but I do not know how to apply it on datasets to gain benefit from it so that I can make visualizations. I keep on learning new syntax but it doesn't seem very beneficial. I also forget syntax again n again.
Loving the channel, I'm currently in a bootcamp and this is great content for me
I like this approach. I've been using Khan Academy and I like them for this reason
This is fantastic! I really hope that you come back and start making more videos, and offer courses on your website. I could really use that
You earned yourself a subcriber
Nice content.
This is precisely the problem I have had with learning SQL, what are we using it for and what problems are we solving. How do you suggest going about learning it?
well said
A good book suggestion for this kind of learning is SQL Queries for Mere Mortals.
Data Launch pad is showing up "Coming Soon" as I scrolled down was excited to see 3 imp courses, Analyse, handle and visualize .. very appealing and I see reviews but I get message "Coming Soon"
Thanks Max, great advice! Looking forward to your continuation course in SQL on Udemy. When should we expect it? Thanks
This is very true. Thank you sir
okay this is good advice, but can you also make a little video showing how to practise in the way you showed us. Where to get problems from
Hello, this is amazing advice! I've been learning SQL for the past couple of months now and have had this predicament. I have good understanding of the syntax but haven't yet applied it towards data handling. Have you got any resources you could recommend to shift my approach?
I have a free course on Udemy that covers the very basics and puts them in the context of a retail bank.
www.udemy.com/course/sql-for-real-world-data-analysis/
Note free courses on udemy only allow 2h so this course only scratches the surface. For more advanced sql try to find a similar style course that promises "real business context"
@@datalaunchpad8974 Thank you so much! Ill definitely check out your course and then look for others :)
@@datalaunchpad8974 do you have a paid version which goes into depth????
Are there any websites where I can practice SQL questions(Scenario based)?
Knowing the context of the SQL concept is important:
* Change from learning SQL syntax to "Data Handling". (How data work - what to do in each situation).
* SQL skill: Transfer to other tools and languages.
That's an approach, thank u
Many thanks for the advice. It was to the point.
So, what course is provided to learn how to handle data using SQL?
Can you elaborate on how and where can learn data handling?
I’m not a DA yet, but it helped me learning the syntax first because it exposed me to what I can do with each command/combinations. Because now when I’m looking to implement some sort of query in a project I know how I can formulate it and then tighten up my syntax with each subsequent query. Similarly if you need to do something you’ll realize “ohhh that’s what that was for”, but it might just be me🤷♂️🤷♂️. I think really what I’m getting at is you don’t know what you don’t know lol
Best advice ever
Amazing tips 👌
Interesting. I think I've been a little bit focused on the Syntax.
How would you recommend going about learning data handling with SQL? Courses? videos? Chat GPT? If courses or videos, any specific ones?
Awesome,thank you!
you are very well spoken, pleasing cadence and rhythm. the music takes away from it.
Hi Max, new subscriber here *round of applause*. Could you suggest where one could learn data handling?
I'm glad I clicked on this video✌
Thanks Yash
Nice advice bro, but i thing i have more douds, could you please recommend me books or techniques to start understand data handle? 😅😊
Max thanks for the videos.
Quick question. When do you think your Udemy course titled ‘SQL for Data Analysis’ will be complete?
I’ve finished the first part.
Appreciate it.
How are people creating context / gathering feedback in this initial phase? How will companies give their data to do this real practice (especially for new folks)?
Any course recommendations specifically for data handling??
Are there many data analyst type roles in Qld? Specifically the GC/BNE regions? I'm starting to think about potentially making a lateral from accounting into an analyst type role sometime in the near future, but I don't know where to start! What's really holding me back though, is how stable accounting is as a career. I personally love the puzzle solving technical type of work there is in accounting, but it's not the most fulfilling type of work as it's a very backwards looking type of role, whereas I like to think I'm more future oriented. I don't know, maybe I just want someone to talk me into making the jump lol!
Thanks
how to Write a query to display EMPLOYEES having ID 101,102,103 as per the
below order: 1. 101, 2. 103, 3. 102 (Hint: Union Operator / Case Statement)
Checking your videos, great content!
I've been trying to learn sql for the past month and I can totally relate to what you say. I will ceirtanly check your Udemy course, but would like to ask for some other examples or resources that you know of, that could help clarify this point to a begginer as myself.
I also would like to ask for your opinion on how viable do you think it is for someone over 40 to get an entry level data analyst position. Thank you! 👍🏼
Hi Domenico,
Age is unlikely to be a barrier per se. The question is 1) whether you meet the requirements for an entry level role in terms of your skills, and 2) whether you are the best person applying for the job.
So how do you know if you have or can develop the skills?
1) Does your job history relate in any way to data, analysis, logical thinking?
2) Are you stronger than the average person in mathemathical thinking?
3) Try learning SQL and practice solving SQL problems (A good resource for practicing SQL problems by difficulty is sqlpad.io/)
Then if you think you can do it, then invest the time to apply!
you are awesome boss.
Arden university berlin studying logistics and supply chain management
You told us the problem, they gave us a way through.. but how can we learn data handling.. can you recommend any channel.. I would have told you to upload video since you have been inactive since past 8 months so please tell me what are the free resources for learning it.
I just tried to buy your product in your website and it was unavailable.
This is what i don’t like about smart people. Have the product operational first then create a distribution strategy. Doing vise versa is not as effective. 😔
So what should I do? Because I was thinking to look up some SQL RUclips videos .but how do you direct me to learn in context? Any SQL courses you can recommend?
syntax can be learned, but understand the data!
So where do we get thise tasks from for practice? Any practice place like w3schools where the dataset is available and yiu run queries to oractise sql
WHERE ARE U?
What do you mean by data handling?
Currently doing a project on T-SQL, I have a question if you do not mind. How are these Information schema tables designed so I can do joins, internet is full of helpful scripts like joining sys. objects to views and joining on on object ID but where I can learn how these tables are designed and so i can actually use joins to ensure I do not get data type errors on joining or no data
which SQL is better, MySQL or PostgreSQL?
I'm a bit confused...the takeaway wasn't super clear from this video? Can someone enlighten me, please?
Hello nice video. Can you recommend me a SQL certification please?
what sql functions are most commonly used then?
How can i find this bootcamp???Do you have a link?
Good evening
Sir i know sql for data analysis .. I know bits of python programming thats it .. I dont know python lib gor data science as an entry what should i do to get job.. Because i dont want to learn anything further before getting a job as an analyst .. Where to pick projects..?
Hey Max, what is the name of your sql course on udemy?
resource?
guys I'm confused... which daughter are we analysing?
I downloaded your Udemy course, and I’m trying to install it, but I keep getting the error message “no compatible servers were found. You’ll need to cancel this wizard and install one.” I don’t know how to do that or even what that means. Please help! 🙏🏻
Also, it asked for a user name and password. Next to user name it says “credentials provided in server configuration.” Help!
The music is distracting, too busy..let me find a video with no music!
True... in other word... Go shopping before cooking.. :D :P
It's spelled "R" not SQL :)
Is this Harry Kane?
Too vague
Thanks for the feedback.
WHY HARRY KANE
Shame you paused your online presence
Music is unnecessary.
didnt ask
"Learn Data handling Instead Focussing On Learning SQL"
Harry Kane
If you can't write better code than AI, give up.😊
L
damn his accent is hard to hear