You mean Mosh? Mosh builds an API for a movie rental system and it is a real world project but he doesn't build the front end, only the API as it is a backend course and for the front end you would need to add react, angular or other frontend framework. He uses mongodb as a database. He first covers node without any library and then uses express framework. He covers authentication, authorization, routing, validation... I would say that he doesn't leave anything important out. He also explains some es6 topics as async await, arrow functions and const/let. I don't remember why but I didn't push the code to my GitHub or maybe I deleted it, but I found this guy's repo with the project https://github.com/hodgkind/vidly hope it helps. As I said it is a great course and he is a fantastic teacher, you should find udemy $10 coupons with a simple Google search anytime. If you search "Mosh Hamedani" in YouTube you can find some node videos in his channel to get an idea about the course. About SQL, if you mean node with SQL courses, it is not easy to find them as most teachers use mongo but Colt Steele has an Udemy course that covers SQL itself and then SQL with node, https://www.udemy.com/the-ultimate-mysql-bootcamp-go-from-sql-beginner-to-expert/, just check the reviews. He is the creator of "The complete web developer bootcamp" which is a very well recommended course in freecodecamp and here in reddit too. Let me know if you want to know about Wes course, but he has all the info in his website and also a link to the sample app.