This is my first ever comment that ive written in youtube. I'm thankful to you for explaining so clearly without skipping anything , im in the half way of the course but im loving every bit of it , thank you thank you so much
This is an incredibly well made course on SQL! I'm a beginner to SQL and I've been trying a bunch of different courses including paid courses from Coursera but none explains the concepts as well as this one.
This was awesome. I have been using SQL for 10 years and I played this all the way through just to see if I would learn something new. And I certainly did. I am still trying to have a really strong problem-solving mindset for SQL employment tests. This helped me a lot. I am going off to watch him solve more PG problems.
Completed 7:16:00 finally, Its exercise time now! I just loved the explanations, weekend well spent! thank you so much for just pouring pure knowledge.
You are so brillaint. There are more teachers who know how to teach but very few have the knowledge about how to make them understanding the concepts. You are so good at explaining the concepts with the best accuracy and its truely awesome to learn from you. Thanks to the God (or Universe or whatever you believe) for giving you this much of clarity in teaching. All the very best to all your upcoming works.
I loved it there are granular details which have been covered so well and explained so beautifully, which is hard to find in any other SQL crash course or lecture over the internet. Thanks Vlad!
I m in my halfway finished this course..i really enjoyed it ..one of the best course..very very clear very well explained ..not even paid versions clear the concepts i got from this course ..thank you so much sir 🎉
Fantastic, thorough, and yet interesting course. I especially like the notion of "Order of Operations" which I don't think I've heard about anywhere else, even though I've been playing with learning SQL for awhile. Big thanks. Well done.
The way this Master is explaining is forcing me to comment on this video.. Best SQL Course that I have ever seen. This gonna be one of the best ways of investing my time which gonna give best returns 😊.
very valued courses for those r not english as native language.simplest explanation helps us to understand from basic to full SQL course. Thanks alot😊😊😊
Combining something you are interested in (sql) and combining it with something you are passionate about (rpg/fantasy) just makes it 10 times as fun and motivated to stick with it.
4:49:04 You said the power level is equal or greater than the character's experience divided by 100. But, what you did as an example is equal or less than. Am I right?
Hello Vlad, just finished the tutorial, really well done with a clear and concise explanation. Could you please help me understand the difference between these two queries in terms of computation and storage, especially when we consider the SQL execution order? SELECT * FROM EMPLOYEE; SELECT * FROM EMPLOYEE LIMIT 10;"
Hey there! The LIMIT *typically* does not save computation because it simply cuts rows at the end of the query. (There are some special cases where the engine uses LIMIT to reduce the query e.g. if there are clustering fields but I would not worry about that). In terms of storage, the first query will store all the data from the employee table, while the second query will only store 10 rows.
Great course! I have one question - I know you said Alias and Select occur at the same time but doesn't Alias occur after Select since you need something to already exist in order to change it?
Hi Vlad. I have been trying to register for Google Cloud nut i can't get past the "Add Payment Method". I don't know if the problem is the types of cards I'm using or perhaps Google Clouds doesn't accept application from my location. Is it possible to follow along the tutorial using MS Servers, MySQL or any other DBMS?
Hi, unfortunately that can happen, and it's not always clear why. You can definitely follow along. You can create a local SQLite DB with Python and then run queries on top with a free RDBMS like DBeaver. Most of the code will be identical but if it doesn't work you can ask AI.
Hello Vlad, i am very keen in learning SQL aand I want to switch my career to IT/BA domain, i have started this video and currently 1.5 hrs into the video, a question is poping in my head as you are expalianing the logical order. Can you tell me as where clause is executed after from then why we always write SELECT at the begining. I undersatnd that it executes logically as per logical order, still for rest w ar writing below except for select clause.
Thanks for this and all that you do on this channel. I am dedicated to life long learning and courses like this is simply outstanding. Wow - what valuable information shared and done in a way that encourage learning. 😊❤💯💥💅 East Coast Sr.🌴
great video!!! I came to me a question ?What is the correct way to proceed (analyze the data) when dealing with a 10 GB database? Should I perform an analysis on only a representative part of the DF or should I run the query on all the data? This considering that due to the size it is not possible to extract it and just perform the queries with SQL. I have to do a data analysis but the data frame is huge. I don't know how to proceed when there is so much data since I cannot download the entire database as CSV. Regards
Hey! The answer is always 'it depends'. How fast are the database responses? What questions do you need to answer? In general, I would first try on all the data and if it's too slow, reassess.
@@vladdata741 I need to answer some question as : monthly Transaction Count per merchant, Find the 10 districts in the country(Chile), etc but I never manage a huge dataset like this before and im not sure. I'm not sure what good practices are for answering. I'm asked to submit a python file with the answers and perform the statistical analysis that I discovered as Findings. I must use SQL ALchemy and python in addition to SQL queries.Should I perform an analysis on only a representative part of the DF or should I run the query on all the data? what good practices for those ?
1:57 Don't use CREATE OR REPLACE! It is dangerous. Use DROP CASCADING and then CREATE. For that reason many DBMS doesn't even support OR REPLACE for tables. For tutorials you should stick to SQL that is supported by the main players like Oracle and SQL Server! Thanks!
Hey there. BigQuery doesn't have DROP CASCADING because it has no concept of table dependencies. If you dropped a table by mistake, most tables support time travel, i.e. you can go back in time to a previous state within 7 days. Finally, if you want to work in analytics, it's more likely that you will work with BigQuery rather than Oracle or SQL Server.
I'm trying to use the link from previous replies to access the file but after the registration the feedback is " no access to this page. you can access this page if someone approves your request" your teaching is excellent but please why is it difficult to even access the materials for the study
Hey, please check this link: miniature-icon-2cc.notion.site/Intuitive-SQL-For-Analytics-65241f69e06446d5bb0a7de272fb5dab. I put it at the top (Where do I find the dataset?) as well as under resources.
i understand this is googlesql which is close to the OG sql but looking for a data analyst role they will most likely use postgres or mysql so not sure what to do? i do know they are all alike but to start i wanted to kinda focus on a specific dialect
@@vladdata741 thank you i really lie tis course so i was scared i could apply it o postgres which is close to ANSI standard more than mysql :)) After using bigquery would it matter if i started using postgres with this knowledge inside pgadmin after the course for more personal projects?
You can use whatever you want to follow along. I thought bigquery would be easiest for people who never touched programming. And it has a nice interface.
Hope you enjoy the course. Subscribe to my channel and let me know what I should cover next!
You rock. Thank you, Subscribing right away.
@@teachersdelight6996 ❤
Already subscribed sir ..if possible pls power bi 🙏
This is exactly what I needed! Thank you 🙏
I really liked the way you describe every concept in detail making it easier to understand and remember. 🫡👌🏿
Doesn't matter if you are begginer or advanced in SQL language, this course is very clear and useful.
Thank you!
❤
This is my first ever comment that ive written in youtube. I'm thankful to you for explaining so clearly without skipping anything , im in the half way of the course but im loving every bit of it , thank you thank you so much
Amazing, thank you ❤
Tysm for this vlad; I'm a noob at SQL; I will surely use this as a way to skill myself in SQL.
Book mark: 48:00
Book mark 2: 1:14:00
You won't be a noob for long! :)
oh wow, some teachers are just so clear.. i was thinking about brushing up and this magically appeared! Vlad you rock!
Thank you! 😊
This is the best tutorial ever.
I was not able to stop myself from commenting. Thank you so much :)
❤
This is an incredibly well made course on SQL! I'm a beginner to SQL and I've been trying a bunch of different courses including paid courses from Coursera but none explains the concepts as well as this one.
❤
I've seen so many vids on SQL ...I'd say this is the best that covers all models of topics and the most understandable vid on youtube!!!!!!!!!!!!!!!!!
❤
As a fresher who want to start her career in Data Analytics, this video is really recommended instead of SQL crash course
This was awesome. I have been using SQL for 10 years and I played this all the way through just to see if I would learn something new. And I certainly did. I am still trying to have a really strong problem-solving mindset for SQL employment tests. This helped me a lot. I am going off to watch him solve more PG problems.
Glad it helped! ♥
Completed 7:16:00 finally, Its exercise time now! I just loved the explanations, weekend well spent! thank you so much for just pouring pure knowledge.
♥
@@vladdata741 u know, i used oracle autonomous databases, almost eveything was same.
@@giveaway4002 Good thing about SQL, it's a universal language :)
You are so brillaint. There are more teachers who know how to teach but very few have the knowledge about how to make them understanding the concepts. You are so good at explaining the concepts with the best accuracy and its truely awesome to learn from you. Thanks to the God (or Universe or whatever you believe) for giving you this much of clarity in teaching. All the very best to all your upcoming works.
❤
I loved it there are granular details which have been covered so well and explained so beautifully, which is hard to find in any other SQL crash course or lecture over the internet.
Thanks Vlad!
❤
I m in my halfway finished this course..i really enjoyed it ..one of the best course..very very clear very well explained ..not even paid versions clear the concepts i got from this course ..thank you so much sir 🎉
That's awesome. Comments like this make my day ❤
Vlad explains stuff so well
finally a proper tutorial and not a show off with comments
❤
Fantastic, thorough, and yet interesting course. I especially like the notion of "Order of Operations" which I don't think I've heard about anywhere else, even though I've been playing with learning SQL for awhile. Big thanks. Well done.
♥
This course is GOLD. As simple as that. Thank You so much
❤
I adore SQL. posing simple queries to get direct responses. Select * where [Result] = 'Happyness'
Yep, SQL is pretty great
The way this Master is explaining is forcing me to comment on this video..
Best SQL Course that I have ever seen. This gonna be one of the best ways of investing my time which gonna give best returns 😊.
❤
Taught in the simplest way, loved it.
This video seems to be exactly what I was looking for, so far. A comprehensive guide to learning SQL, thank you for your video!
Bookmark 1- 54:30
❤
very valued courses for those r not english as native language.simplest explanation helps us to understand from basic to full SQL course. Thanks alot😊😊😊
❤
This is the best SQL course ever . Thank you
A very clear and acurate course on SQL! I'm a beginner to SQL and I had the luck to find this course which explains the concepts so well. Many thanks!
❤
One of the best tutorials on the internet for sql.
❤
wonderful! clear and precise. Power BI next
THANKS FOR YOUR OUTSTANDING EFFORT IN TRYING TO EXPLAIN IN THE BEST AND EASIEST POSSIBLE WAY, I APPRECIATE.
Thank you so much for this work. This is so valuable to me.
♥
I need it as a remember and I need to use BigQuery too. That's the course I really need. Let's start.
Good luck!
This is truly the best SQL course I have ever taken.
❤
Thank you Vlad. This is a great tutorial. I've taken a course before on Udemy, and this one introduces a lot of new concepts.
Combining something you are interested in (sql) and combining it with something you are passionate about (rpg/fantasy) just makes it 10 times as fun and motivated to stick with it.
Nice!
thanks bro - excellent course, exactly what I need for my job!
will money be refund after prepayment for google cloud?
Thank you for equipping us with such knowledge for free 🙏. This is so cool.
Glad you liked it!
A BIG ROUND OF APPLAUSEE FROM MY SIDE THIS IS AMAZINGGG😮😮😮😮😮😮❤🔥❤🔥❤🔥❤🔥❤🔥❤🔥❤🔥
♥
Good course! Thanks for providing it for free!!!
awesome awesome course. i reserved my weekend only for this!
it's been at least 3 month since I wrote sql query. Plan to brushing up with this video for couple of days. wish me luck
Good luck! 😊
Thanks for this course.
It's very clear and useful.
❤
were you able to make an account without paying ?
Great explanation. Thanks
1:00: 26 the logic order graph is so helpful. thx
Thank you so much outstanding course!!
Enjoying it, thanks
Lots of Love
it so crystal clear and it also work on PgAdmin
Fantastic course!!!
♥
Excellent explanations! Thank you so much
Awesome! Thanks a lot! Is it enough to start work or get an internship with the knowledge from this course??
You're welcome! It's hard to say, depends on your work requirements. For a data analyst internship it might be enough
6:38:59 Why is 'cumulative power by type' not cumulative instead adds 200 instead of 100 to cell G19(827) and results in G20(1027)
Well spotted, seems to be an error with my google sheet formula. The SQL results should be correct
IS case just like if statement in Python?
Yes! They are both conditional statements
4:49:04 You said the power level is equal or greater than the character's experience divided by 100. But, what you did as an example is equal or less than. Am I right?
Thanks, great course
❤
Thank you thank you thank for this amazing video
This is exactly what I needed.
Awesome to hear!
Thank you vlad 😊
The explanation is succint. Thanks
Hope you will open a free data engineering course (from A to Z) Vlad soon since you're DE yourself
I'd love to do that 😊
Hello Vlad, just finished the tutorial, really well done with a clear and concise explanation. Could you please help me understand the difference between these two queries in terms of computation and storage, especially when we consider the SQL execution order?
SELECT * FROM EMPLOYEE;
SELECT * FROM EMPLOYEE LIMIT 10;"
Hey there! The LIMIT *typically* does not save computation because it simply cuts rows at the end of the query. (There are some special cases where the engine uses LIMIT to reduce the query e.g. if there are clustering fields but I would not worry about that). In terms of storage, the first query will store all the data from the employee table, while the second query will only store 10 rows.
Thanks! 😊
This is a google bigQuery tutorial? Nice thanks x100.
Hey there! It's an intro to BigQuery but mainly focused on SQL fundamentals. I chose BigQuery because it's easy to use.
@@vladdata741 thanks. I also wanted to use BigQuery but this looks like a good starter point. Thanks again.
Great course! I have one question - I know you said Alias and Select occur at the same time but doesn't Alias occur after Select since you need something to already exist in order to change it?
Yes, but I see alias as more of a component of select rather than a separate step
please how can I access the dataset you uploaded into bigquery for the tutorial.
I have watched 6 hours yet!
And really loved the way vlad teaches,
he covered everything important in a structured approach!
Thanks! ❤🔥
❤
Hi Vlad. I have been trying to register for Google Cloud nut i can't get past the "Add Payment Method". I don't know if the problem is the types of cards I'm using or perhaps Google Clouds doesn't accept application from my location. Is it possible to follow along the tutorial using MS Servers, MySQL or any other DBMS?
Hi, unfortunately that can happen, and it's not always clear why. You can definitely follow along. You can create a local SQLite DB with Python and then run queries on top with a free RDBMS like DBeaver. Most of the code will be identical but if it doesn't work you can ask AI.
@58:00 why have you used LIMIT ? i mean what is use of it?
It just "cuts" the result to only display 5 rows. It's explained in detail at 02:28:52.
best tutorial ever
normally i never comment on anything but this tutorial was too good and i cant stop my self from commenting
@@Conqueror1-b8n Thank you I'm glad you liked it ❤
big query can be use in angular react vue python and jetbrains app?
Sure you can, but BigQuery is typically used for analytical use cases and not as a production database. Google the distinction between OLAP and OLTP.
Excellent. Thanks.
@vladdata741 Will you make more advanced courses?
Working on it. Subscribe to my channel or LinkedIn for updates.
Hello Vlad, i am very keen in learning SQL aand I want to switch my career to IT/BA domain, i have started this video and currently 1.5 hrs into the video, a question is poping in my head as you are expalianing the logical order. Can you tell me as where clause is executed after from then why we always write SELECT at the begining. I undersatnd that it executes logically as per logical order, still for rest w ar writing below except for select clause.
It's written this way because that's the convention created for the language. I don't have a deeper answer for that!
@@vladdata741 thanks, I am really learning and enjoying the series, will comment in case of queries,
Great! Thank you!
Can you make an end to end data analysis bootcamp intended for beginners?
I'd love to!
Thanks for this.
My pleasure, hope you like it! Vlad
Thanks for this and all that you do on this channel. I am dedicated to life long learning and courses like this is simply outstanding.
Wow - what valuable information shared and done in a way that encourage learning. 😊❤💯💥💅 East Coast Sr.🌴
Nice, keep on learning!
start 7:10:10
Luckily, Vlad has 1440p version on his channel..
is this course is also for data engineers ???
Yes!
@@vladdata741 thanks brother
CASTING 2:18:00 not done
great video!!! I came to me a question ?What is the correct way to proceed (analyze the data) when dealing with a 10 GB database? Should I perform an analysis on only a representative part of the DF or should I run the query on all the data? This considering that due to the size it is not possible to extract it and just perform the queries with SQL. I have to do a data analysis but the data frame is huge. I don't know how to proceed when there is so much data since I cannot download the entire database as CSV. Regards
Hey! The answer is always 'it depends'. How fast are the database responses? What questions do you need to answer? In general, I would first try on all the data and if it's too slow, reassess.
@@vladdata741 I need to answer some question as : monthly Transaction Count per merchant, Find the 10 districts in the country(Chile), etc but I never manage a huge dataset like this before and im not sure. I'm not sure what good practices are for answering. I'm asked to submit a python file with the answers and perform the statistical analysis that I discovered as Findings. I must use SQL ALchemy and python in addition to SQL queries.Should I perform an analysis on only a representative part of the DF or should I run the query on all the data? what good practices for those ?
What way you find@@FIBONACCIVEGA
1:57 Don't use CREATE OR REPLACE! It is dangerous. Use DROP CASCADING and then CREATE. For that reason many DBMS doesn't even support OR REPLACE for tables. For tutorials you should stick to SQL that is supported by the main players like Oracle and SQL Server! Thanks!
Hey there. BigQuery doesn't have DROP CASCADING because it has no concept of table dependencies. If you dropped a table by mistake, most tables support time travel, i.e. you can go back in time to a previous state within 7 days. Finally, if you want to work in analytics, it's more likely that you will work with BigQuery rather than Oracle or SQL Server.
@@vladdata741 Ok. Thanks!
I'm trying to learn from the tutorial but I don't know where to access the dataset you uploaded into bigquery
Nice just what I was looking for🎉
Sure...
X2
Awesome, hope you like the course!
Hi, I'm from São Paulo! Yeah excellent! ABRAÇO!
Tomara que você curta o curso! Vlad
Eu de Florianópolis. Assistindo de Auckland, New Zealand. When I heard your accent I was sure you were from Brazil 😅. Thank you very much ❤🎉❤🎉
@@lettileiteI'm Romanian, sometimes we sound weirdly similar to Portuguese! 😀
😂 Sorry about that. Just got to the sing in part 😁. Subscribed to your channel. Thank you again 🎉
@@vladdata741 Amazing tutorial, man. Greetings from Brazil.
I'm trying to use the link from previous replies to access the file but after the registration the feedback is " no access to this page. you can access this page if someone approves your request"
your teaching is excellent but please why is it difficult to even access the materials for the study
Hey, please check this link: miniature-icon-2cc.notion.site/Intuitive-SQL-For-Analytics-65241f69e06446d5bb0a7de272fb5dab. I put it at the top (Where do I find the dataset?) as well as under resources.
6:30:30 shouldnt row 20 be 1444?
Salutare Vladut😂
SQL Joins visualizer is cool any link?
sql-joins.leopard.in.ua/
1:00:01 - is the gold mine
🪙
Lucid way of teaching
♥
SQL for GA4 data :)?
i understand this is googlesql which is close to the OG sql but looking for a data analyst role they will most likely use postgres or mysql so not sure what to do? i do know they are all alike but to start i wanted to kinda focus on a specific dialect
BigQuery uses ANSI SQL which is as general as it gets. Don't worry about it and just start!
@@vladdata741 thank you i really lie tis course so i was scared i could apply it o postgres which is close to ANSI standard more than mysql :)) After using bigquery would it matter if i started using postgres with this knowledge inside pgadmin after the course for more personal projects?
@@kawaiihikari0 No matter. In fact the exercises at the end of this course are in postgres :)
@23.46 afterselecting bigquery i cant able to see sqlworkspace in my screen . i stuck here plz chk
This would be good for data analyst role? What in trying to study…
Yes!
is there any certifications?
No, unfortunately. But I'll probably do it for my next course!
@@vladdata741 I hope, that I will complete in 1 month 😅
Thank you.
My pleasure!
i wan thinking about this today only
Nice!
Blowing into pieces a fourth of Hell. Let it be!
The course resources URL isn't working for me, is it still live?
Link works for me: miniature-icon-2cc.notion.site/Intuitive-SQL-For-Analytics-65241f69e06446d5bb0a7de272fb5dab
What do you see?
nice course
Thank you, hope it helps!
Why not using DuckDB directly in Python or in browser?
You can use whatever you want to follow along. I thought bigquery would be easiest for people who never touched programming. And it has a nice interface.
And if you want to work in analytics, having knowledge of a data warehouse like BigQuery is a bonus. Two birds with one stone.
BigQuery is actually used by companies, 60% of the time.
How do I identify which table is on the left on bigquery?
Can you elaborate the question?
2:30:30 自分用