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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2018 Bob Ward
About this chapter
Cite this chapter
Ward, B. (2018). Building a Database and T-SQL Fundamentals. In: Pro SQL Server on Linux. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-4128-8_3
Download citation
DOI: https://doi.org/10.1007/978-1-4842-4128-8_3
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-4127-1
Online ISBN: 978-1-4842-4128-8
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books