Advanced SQL Statements

[@arumugamparamasivam7181]

very fine.prof a.paramasivam,sivaganga,india

[@christianlira1259]

I appreciate the video's rawness and live realistic examples. Superb and enthusiastic teaching with real querying creations. Thank you!

[@sakshock]

This is great video. Precise and content. But this is more of a basics of sql.

[@JeffStrommen]

This was really well put together. Lots to work on. Thanks for making it simple to follow and easily relatable.

[@MrTejasreddy]

Really good and informative Any possible to provide data

[@gulhermepereira249]

What a great tutorial! Thank you, sir!

[@simplycurlyac]

This was SO helpful for me. Thank you so much!!

[@Sonny0276]

Great Video. Thank you for posting.

[@generalsight4595]

Thank you for sharing this video. However I was expecting something more advanced. This is kind of introductory queries.

[@RalphNgOfficial]

this is very helpful,it helps my job, thank you

[@2012Santorum]

Thanks for making this video. Is there anywhere that I can get the data?

[@naderreda2020]

Very useful... Thank you

[@kombokenedy4750]

U know what ....that is great...

[@sharonjonesDRF]

Would it be possible to get a copy of the database you used?

[@ashkanjavadzadegan96]

where can I find the databases used in this video ?

[@dangputerz]

is this MySQL compatible?

[@ardimamo]

where i can get the database? any link to download

[@masterprattu]

nice video

[@aikids24]

No for the date "between" keyword does not include last day, if the date is 12-31-1969 it will get records till 12-30-1969. Please confirm.

[@mikefenn00]

I've encountered this issue, but it was because the column included the date AND time. For example, in the UPDATE_DATE column a row in my table has the value 1969-12-31 07:01:39. If I search BETWEEN 1969-01-01 and 1969-12-31 it's really searching 1969-01-01 00:00:00 and 1969-12-31 00:00:00. Since my data occurred AFTER 1969-12-31 00:00:00 it will not be returned. If that is actually the case then you would want to query BETWEEN 1969-01-01 00:00:00 and 1969-12-31 23:59:59. I hope that helps.

[@bezualemfisseha2119]

Thank you very much

[@olgazimnyakova9638]

43:19 “spin-odd” or “spin-off”? I found this video is useful with some tips. The level is beginner-intermediate, I think. In general, I like this course but the lecturer always makes errors (“typo”) and for a code/programmer/developer it is a not good trait; those ppl have to be Perfectionists! Please answer re. “Spin-odd”. I hope it is an error and not a new term. Thank you.

[@MithunDas-yf2fu]

This is an advanced video?

[@leelakumarkadali6181]

Nice

[@LeCoolCroco]

Some of these statements with subselect will take A LOT OF TIME to execute when DBSize > 10m+- records

[@ShrutiKar]

Then how to go about it?

[@patrickjane276]

how could you possibly call this advanced. this is like "hi I know sql basics, now I'd like to see what else it can do.. but not too much b/c I'm not an engineer an thus I obviously give up quick".

[@ghr6518]

Did you find a video which has more advanced queries. Can you please share?

[@chrislaw4189]

@@ghr6518 kzbin.info/www/bejne/rHabhpaJbbqSrqc

[@aaronmorber1943]

He sounds like dan from roseanna

[@ubaidimran7102]

Never knew between clause was advanced sql...

[@Music4Cats]

Please study cyber-security and modern database implementation, at least for a few minutes. I worry about the vulnerability surface your students are going to bring to their companies

[@riazulmriddu394]

sir £ sir$ sor

[@thephenom4650]

Riazul Mriddu h la y

[@jb6167]

College classes on this topic are boring as hell and useless.

[@zezeandjr4110]

"Advanced"? C'mon, click bait..