Awesome tutorial. The concept is intuitivo, running a query usong previous result, as chaining. In the example given, it is clear how you get the aggregate min and max of all data set by collapsing the table. Well done
@pr-rb6jl4 ай бұрын
Very well Explained ....Thanks you
@ameneh212 Жыл бұрын
Very well explained... Thanks again!
@umairmir84563 жыл бұрын
Waiting for your next two videos! Really helpful!
@datatomi3 жыл бұрын
Very soon!
@srsr60993 жыл бұрын
Much needed concepts. Super.
@datatomi3 жыл бұрын
Thanks! : )
@naveenkalyan4700 Жыл бұрын
Tons of thanks brother! Can I get flights table dataset?
@altareq24953 Жыл бұрын
You explain complex things in very easy way. I appriciate your effort. You were setting self assessment questions, but unfortunately I did not find any link downloading the Dataset and without that it was impossible practicing on your self test questions rather than just watching the video.
@pveeranjireddy89593 жыл бұрын
Great content Explained very wel........Thank you.........
@thecodenerd49593 жыл бұрын
Did anyone tell you that look very similar to Paul Rudd? Btw great video and explanation of concepts
@datatomi3 жыл бұрын
Yes, I'm Ant-man (as a side gig). Thanks, btw!
@lindseyhristov7770 Жыл бұрын
Where can the dataset be accessed to enable me to practice your question
@majdzatar19672 жыл бұрын
i am using google cloud how can i get the table you are working with so i can practice
@elfridhasman41812 жыл бұрын
Thank You Very Much :)
@akansha_bhatt283 жыл бұрын
Hi Tomi, I loved your SQL playlist. Can you make a playlist too on Python for Data Science?
@datatomi3 жыл бұрын
Thanks -- yes, I've already started to draft it. I'm not sure when I'll record it but hopefully in the near future.
@chimaokoro47262 жыл бұрын
Where can I get the data for This tutorial?
@shovonchowdhury8343 жыл бұрын
Great video. Would be great if you had a diagram of the database schema with all the tables with their rows and columns.
@datatomi3 жыл бұрын
Thanks! ✌️ Not a schema per se, but many database info is available in SQL Workbench under the *Database Explorer* menu. Sample data, table structure, CREATE TABLE command, etc, etc. everything you need
@davidbarnwellutech46632 жыл бұрын
Do you have anything on Machine Learning in say, MATLAB?
@camo1711 Жыл бұрын
Hello, is it possible to group many rows into one output row? example, print 'early', 'late' and 'ontime' on one output row.
@osoriomatucurane95112 ай бұрын
Good question, from that result, you compute the percentage. The answer to your question is pivoting ( columns to rows) . Reshaping, long to wide. It is a good use case of cte With cte_reshaping as ( The result of this query Select count(*) as count, is_it_late) Select sum(case when is_it_late = 'late' then count end ) as late, Repeat for other two categories (Early and ontime) From cte_reshaping Hoping this helps
@subhanbasha88133 жыл бұрын
Hello Tomi, Is it recommend to code all the machine learning algorithms from scratch so that I can learn math behind it or just understand and start to code?
@datatomi3 жыл бұрын
Yeah, it makes sense... I mean definitely not all of them, but you can go ahead and try the simpler ones (and validation methods, too). That will give a solid understanding of the basics. Then later on, when you get more advanced, you can just dig deeper into the specific model that you'll use for your given project. Then most probably it won't be necessary to code it from scratch to understand it well enough to apply it correctly. Smart question, btw.
@oscarmartuasinaga5208 Жыл бұрын
i think problem number 1 can be solved easily by just write *Limit 1* at the bottom of your query.