This course will introduce you to SQL Server Core 2016. You’ll tour its features, including SQL Server Management Studio (SSMS) and data tools. SQL Server Management Studio is an integrated development environment for administering SQL Server and writing Transact-SQL code. You’ll get an overview of the dashboard and explore sample databases.
Then, you’ll explore database objects, including programing, security, persistent queries, and more. All of these objects, when properly configured and programmed, come together to implement the robust relational database features that can support a wide variety of application types.
SQL Server Data Tools nicely complements SSMS in ways that are useful to both developers and administrators who need to write code. We’ll discuss installation and the different ways you can use the tools.
As a developer, a lot of the work you do is with tables, queries, and views. You’ll get an overview of basic features in SSMS to make working with data easy.
Whether you’re preparing your first installation or upgrading to this new version, we’ll give you helpful instruction on your options. Then we’ll move on to configuration.
Lastly, we’ll discuss writing and executing queries in the query editor, scripting with SSMS, and Debugging T-SQL.