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.
I’m an instructor on many SQL Server and Visual Studio courses. I’m a nationally recognized author, instructor, and consultant specializing in Microsoft technologies. With many years of teaching experience, I’m the author or co-author of several programming books, and have spoken at many industry conferences and user groups. In addition, I’m a consultant for a variety of companies that develop distributed applications for public and private organizations.