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.
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.
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".
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
![SQL Course for Beginners [Full Course]](/img/1.gif)
very fine.prof a.paramasivam,sivaganga,india
I appreciate the video's rawness and live realistic examples. Superb and enthusiastic teaching with real querying creations. Thank you!
This is great video. Precise and content. But this is more of a basics of sql.
This was really well put together. Lots to work on. Thanks for making it simple to follow and easily relatable.
Really good and informative
Any possible to provide data
Very useful... Thank you
What a great tutorial! Thank you, sir!
Thank you for sharing this video. However I was expecting something more advanced. This is kind of introductory queries.
Great Video. Thank you for posting.
This was SO helpful for me. Thank you so much!!
nice video
this is very helpful,it helps my job, thank you
U know what ....that is great...
Thanks for making this video. Is there anywhere that I can get the data?
Would it be possible to get a copy of the database you used?
where can I find the databases used in this video ?
where i can get the database? any link to download
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.
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.
Thank you very much
is this MySQL compatible?
Nice
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.
This is an advanced video?
Some of these statements with subselect will take A LOT OF TIME to execute when DBSize > 10m+- records
Then how to go about it?
He sounds like dan from roseanna
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".
Did you find a video which has more advanced queries. Can you please share?
@@ghr6518 ruclips.net/video/vE8UcS8U_xE/видео.html
Never knew between clause was advanced sql...
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
sir £ sir$ sor
Riazul Mriddu h la y
College classes on this topic are boring as hell and useless.
"Advanced"? C'mon, click bait..