This course will introduce you to SQL Server Core 2016. You’ll tour it’s 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 a tour 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 programed come together to implement the robust relational database features that can support a wide variety of application types.
SQL Server Data Tools is a nice compliment to SSMS that is useful to both developers and administrators who need to write code. We’ll discuss installation and 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 are preparing your first installation or upgrading to this 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.