In the previous chapter, you learned how to create a learning environment and started writing some serious SQL code. However, our database lacks data and complexity, which we need in order to practice and test all the cool SQL language features on SQL Server on Linux. This chapter will guide you through some of the best sample databases which can be used to test almost any SQL Server feature and prepare yourself for the production environment. Before beginning with the samples, I will briefly explain the basics about relational database concepts and the process of normalization.
We will cover the following topics:
- Relational database concepts
- Normalization
- Northwind database
- Pubs database
- AdventureWorks database
- WideWorldImporters database
