This is the example project used for the Mike.Works SQL Fundamentals course.

What are we building?

We'll be working with several flavors of the Northwind Database, which Microsoft uses to demonstrate a wide range of features across their MS Access and MS SQL Server product lines. You'll be writing some application code in a small Node.js web application (built with Express) to view and make changes to this data.

Here's what it looks like (and here is a live demo):

This app is not in a good state at the beginning of the workshop. Features are missing, there are major performances, and quite a few database-related bugs. We'll fix all these problems and learn as we go!

License

While the general license for this project is the BSD 3-clause, the exercises themselves are proprietary and are licensed on a per-individual basis, usually as a result of purchasing a ticket to a public workshop, or being a participant in a private training.

Here are some guidelines for things that are OK and NOT OK, based on our understanding of how these licenses work:

OK

• Using everything in this project other than the exercises (or accompanying tests) to build a project used for your own free or commercial training material
• Copying code from build scripts, configuration files, tests and development harnesses that are not part of the exercises specifically, for your own projects
• As an owner of an individual license, using code from tests, exercises, or exercise solutions for your own non-training-related project.

NOT OK (without express written consent)

• Using this project, or any subset of exercises contained within this project to run your own workshops
• Writing a book that uses the code for these exercises
• Recording a screencast that contains one or more of this project's exercises

Copyright

© 2018 Mike.Works, All Rights Reserved

This material may not be used for workshops, training, or any other form of instructing or teaching developers, without express written consent