This lecture is used in my ANSI SQL course for Software Developers. It will cover some new statements: Between, In, Like, Case (TSQL) as well as Views and Spin-Off tables. I also introduce the View Designer and Query Builder.
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.
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".
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.
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