BOM Archives - Essential SQL

Tag Archive

Tag Archives for " BOM "

Work with the AdventureWorks Bill of Materials using Subqueries

In this puzzle, we’re going to learn how to work with the AdventureWorks Bill of Materials table. Companies use a BOM (Bill of Materials) to itemize the products that are used or contained in another product. Solving puzzles is a great way to learn SQL. Nothing beats practicing what you’ve learned. Once you have figured […]

The information, you got on your website is amazing. I was struggling with CHARINDEX function for a few months, I was able to get the moment I saw your example. -- Jaswanth.

Your articles are the best on the internet. The way you explain is really great. Thanks! - Mohit

Way to boil down some pretty complex thoughts into concepts most people can understand - Bethany

Its bloody brilliant! I wish I had this when I first started in uni. I just couldn't work it out. Then it clicked - Trevor

You’re a natural teacher; you make what seems intimidating understandable – Ericka

Thanks for such a detailed and easy to understand explanation of the normalization technique.. The way u elaborated the whole process is just stupendous…I visited a number of sites for better understanding of normalization, but no one matched your caliber seriously… Great job indeed, keep up the good work.. Thanks…. !!!! - Adnan

What a great beginning tutorial, Kris. Looking forward to the next one!

Most of the time, when someone on a techie forum says that they're about to explain something in plain English, the exact opposite happens. Not so here, that's a really nice explanation which I'm sure that I'd have understood with no prior knowledge. Nice work, Kris - Peejay