• Systems
Training Course

SQL Server Core 2016

Have a question while you're learning?

Get in-depth explanations, tips, further insights, and more from Certified Experts. Our experts are vetted industry professionals eager to help you learn from their experiences.

Course Syllabus(81 Lessons)

Course Description

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.

Course Details

Level:
Beginner
Duration:
7h 13m 45s
Students:
24
Last Updated:
2020-04-09

Instructor

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

Share Course

Ready to get started?

SEE HOW IT WORKS