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.
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 😊.
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 🎉
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.
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.
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.
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😊😊😊
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?
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.
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?
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.
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.
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.
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.🌴
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?
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.
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.
![SQL Course for Beginners [Full Course]](http://i.ytimg.com/vi/7S_tz1z_5bA/mqdefault.jpg)
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!
❤
As a fresher who want to start her career in Data Analytics, this video is really recommended instead of SQL crash course
This course is GOLD. As simple as that. Thank You so much
❤
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! :)
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 ❤
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 is the best tutorial ever.
I was not able to stop myself from commenting. Thank you so much :)
❤
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! ♥
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!!!!!!!!!!!!!!!!!
❤
Vlad explains stuff so well
finally a proper tutorial and not a show off with comments
❤
oh wow, some teachers are just so clear.. i was thinking about brushing up and this magically appeared! Vlad you rock!
Thank you! 😊
I adore SQL. posing simple queries to get direct responses. Select * where [Result] = 'Happyness'
Yep, SQL is pretty great
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 😊.
❤
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 ❤
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.
❤
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 :)
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!
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 truly the best SQL course I have ever taken.
❤
One of the best tutorials on the internet for sql.
❤
Taught in the simplest way, loved it.
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!
❤
A BIG ROUND OF APPLAUSEE FROM MY SIDE THIS IS AMAZINGGG😮😮😮😮😮😮❤🔥❤🔥❤🔥❤🔥❤🔥❤🔥❤🔥
♥
Thank you so much for this work. This is so valuable to me.
♥
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
❤
did u forget about bookmark 2
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.
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 for equipping us with such knowledge for free 🙏. This is so cool.
Glad you liked it!
thanks bro - excellent course, exactly what I need for my job!
will money be refund after prepayment for google cloud?
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! 😊
I have watched 6 hours yet!
And really loved the way vlad teaches,
he covered everything important in a structured approach!
Thanks! ❤🔥
❤
Thanks for this course.
It's very clear and useful.
❤
were you able to make an account without paying ?
Good course! Thanks for providing it for free!!!
it so crystal clear and it also work on PgAdmin
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
1:00: 26 the logic order graph is so helpful. thx
Thank you so much outstanding course!!
awesome awesome course. i reserved my weekend only for this!
Great explanation. Thanks
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?
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.
@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 ❤
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
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.
Fantastic course!!!
♥
Thank you thank you thank for this amazing video
Thank you vlad 😊
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
Thanks, great course
❤
Enjoying it, thanks
Lots of Love
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! 😊
6:30:30 shouldnt row 20 be 1444?
This is exactly what I needed.
Awesome to hear!
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,
@vladdata741 Will you make more advanced courses?
Working on it. Subscribe to my channel or LinkedIn for updates.
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 😊
The explanation is succint. Thanks
Can you make an end to end data analysis bootcamp intended for beginners?
I'd love to!
please how can I access the dataset you uploaded into bigquery for the tutorial.
I'm trying to learn from the tutorial but I don't know where to access the dataset you uploaded into bigquery
Luckily, Vlad has 1440p version on his channel..
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
@23.46 afterselecting bigquery i cant able to see sqlworkspace in my screen . i stuck here plz chk
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! Thank you!
Excellent. Thanks.
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!
SQL for GA4 data :)?
Thanks for this.
My pleasure, hope you like it! Vlad
is this course is also for data engineers ???
Yes!
@@vladdata741 thanks brother
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!
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?
SQL Joins visualizer is cool any link?
sql-joins.leopard.in.ua/
How do I identify which table is on the left on bigquery?
Can you elaborate the question?
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 :)
Lucid way of teaching
♥
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.
from where do i get the data set?
Resources page in description: miniature-icon-2cc.notion.site/Intuitive-SQL-For-Analytics-65241f69e06446d5bb0a7de272fb5dab
CASTING 2:18:00 not done
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.
unable to access the assignment links
Link works for me: miniature-icon-2cc.notion.site/Intuitive-SQL-For-Analytics-65241f69e06446d5bb0a7de272fb5dab
What do you see?
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 😅
Salutare Vladut😂
hi can you please share the dataset ?
You can find on the course page miniature-icon-2cc.notion.site/Intuitive-SQL-For-Analytics-65241f69e06446d5bb0a7de272fb5dab
Thank you.
My pleasure!
1:00:01 - is the gold mine
🪙
Anyone have issues with the BROWSE button not working when trying to upload a table from your local machine?
i wan thinking about this today only
Nice!
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.
This would be good for data analyst role? What in trying to study…
Yes!
is there a 1080p version ?
This is the best I have now. I'm still learning the ropes on video making!
@@vladdata741 This is perfectly fine. Good enough Video & Audio. Thank you.
Blowing into pieces a fourth of Hell. Let it be!
start 7:10:10