SQL Server Core 2016

Category
Programming
Level
Beginner
Lessons
81
Duration
7h 12m 24s
Last Updated: 2018-07-17
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.
Category
Programming
Level
Beginner
Lessons
81
Duration
7h 12m 24s
SQL Server Core 2016 - Chapter 01 - Getting Started
SQL Server Core 2016 - Chapter 02 - SSMS and Data Tools
SQL Server Core 2016 - Chapter 03 - Installation
SQL Server Core 2016 - Chapter 04 - Server Configuration
SQL Server Core 2016 - Chapter 05 - Using Management Studio
SQL Server Core 2016 - Chapter 06 - Writing and Executing Queries
Don Kiely
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.
Don KielyInstructor and Curriculum Developer
Other Courses by Don Kiely