Building a Database and T-SQL Fundamentals

Abstract

Now that you have installed SQL Server, the next step in your journey with SQL Server on Linux is to create a database. Then you will want to create tables, insert some data, and learn the fundamentals of the T-SQL language. Although this chapter covers basic T-SQL functionality, I’ve written the chapter from the perspective of a developer. For those of you who are experts with SQL Server and T-SQL, this chapter may seem like a review. But for those new to SQL Server, this chapter is essential, so you can build a foundation of knowledge about the T-SQL language and basic capabilities of SQL Server. To demonstrate SQL Server features in this chapter, I’ve chosen Visual Studio Code as the development tool to execute queries. Armed with this knowledge, you will be able to move to the next chapter to build an application, and learn more advanced T-SQL capabilities and new features of SQL Server 2017.