SQL Server 2016 Core, Part 3 of 3: Interface and Querying

Course description

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.

Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.

Prerequisites

This course does not require any prior experience with Microsoft SQL Server or with database programming.

Meet the expert

Don Kiely

Don Kiely is a featured instructor on many of our SQL Server and Visual Studio courses. He is a nationally recognized author, instructor, and consultant specializing in Microsoft technologies. Don has many years of teaching experience, is the author or co-author of several programming books, and has spoken at many industry conferences and user groups. In addition, Don is a consultant for a variety of companies that develop distributed applications for public and private organizations.

Video Runtime

148 Minutes

Time to complete

262 Minutes

Course Outline

Using Management Studio

SQL Server Management Studio (31:16)

• Introduction (00:40)
• Getting Started with Management Studio (01:59)
• Demo: Connect to Server (04:55)
• Demo: Connection Options (06:00)
• Demo: Connect to Multiple Instances (03:01)
• Demo: The Options Dialog Box (03:34)
• Demo: Options, Keyboard Section (03:47)
• Demo: Options Specific to SQL (05:27)
• Demo: Tool Bars (01:14)
• Summary (00:34)

SSMS Options (14:22)

• Introduction (00:40)
• Demo: SQL Options and Menu Tabs (04:45)
• Demo: Design Query in Editor (03:16)
• Demo: SQL Options, Menu Tabs Continued (04:55)
• Summary (00:44)

Configure SSMS Windows (05:11)

• Introduction (00:33)
• Demo: Configure SSMS Windows (02:04)
• Demo: Docking Windows (01:59)
• Summary (00:34)

Object Explorer (17:00)

• Introduction (01:05)
• Demo: Object Explorer Window (05:18)
• Demo: Management, Agent, and Diagrams (05:12)
• Demo: Views, Synonyms, and Programmability (02:21)
• Demo: Filtering (02:24)
• Summary (00:36)

Edit Objects in Designer (10:45)

• Introduction (00:48)
• Demo: Modify Table Structure (05:59)
• Demo: Edit Code (03:24)
• Summary (00:33)

Writing and Executing Queries

Working with the Query Editor (21:18)

• Introduction (00:54)
• Demo: Open the Query Editor (03:59)
• Demo: Tab Groups (04:46)
• Demo: Comments and Whitespace (03:48)
• Demo: Writing Code (03:32)
• Demo: Intellisense and Searching (03:18)
• Summary (00:57)

Scripting with Management Studio (18:07)

• Introduction (00:52)
• Demo: Create Stored Procedure (05:19)
• Demo: INSERT Statement (04:50)
• Demo: Execute Stored Procedure (06:16)
• Summary (00:49)

Debugging TSQL Code (08:08)

• Introduction (00:35)
• Demo: Breakpoints (02:49)
• Demo: Debugging Tools (04:11)
• Summary (00:31)

Executing Queries (22:22)

• Introduction (00:28)
• Demo: Executing Queries (04:06)
• Demo: Multiple Statements (06:08)
• Demo: Query Options (05:16)
• Demo: Execution Plan and Client Statistics (05:37)
• Summary (00:44)