SQL Server 2016 Core, Part 3: Interface and Querying

with expert Don Kiely

SQL Server Management Studio (SSMS) is an integrated development environment for writing ransact-SQL and other types of SQL Server code and commands. It is the principal tool that you can use to administer SQL Server and write code, and is hosted in the Visual Studio shell. Management Studio, which integrates capabilities that previously were available in a umber of separate tools, provides a huge number of tools that touch nearly every nook and cranny of all of the features of SQL Server, most certainly including the core database engine.In this course, you'll learn how to connect to an instance of SQL Server with Management Studio, and explore the rich user interface and development environment, so that you can customize it to look how you like and support the way you like to work. One size doesn't fit all, but with all the configuration options you can really personalize Management Studio! One of the core features of Management Studio is Object Explorer, a treeview that exposes pretty much every database and server object in SQL Server. You'll learn how to navigate the hierarchy to find what you need, and how to access the many tools, editors, and designers packed into Management Studio. When you write code using Management Studio, you're likely to do it using the Query Editor. This is a rich environment that understands both SQL Server and Transact-SQL code, with many features to help you write clean, maintainable code that performs efficiently. We'll explore the Query Editor and use it to perform many common tasks with SQL Server.

Course Outline