I believe this is the highest quality lecture for DB design beginners, regardless of whether you're a major or non-major. I can say with certainty that as someone who has experience solving concurrency and transaction issues in practice, you could listen to just this one lecture and move straight to advanced topics.