SQL Server 2014, Part 3 of 9: Working with Management Studio

SQL Server 2014 Management Studio is an excellent tool that is used to code and administer SQL Server 2014. The course will show you Management Studio and how to write code and administer a server. Then the course will explore Management Studios Object Explorer tool. Then see how you can use the Query Editor to write and debug SQL Server code.

Lesson 1:

• Getting Started
• Demo: Management Studio
• Demo: Options
• Demo: Customizing
• Demo: Fonts and Colors
• Demo: Query Execution
• Demo: Query Results
• Demo: Designers
• Demo: Tool Bars
• Demo: Menu Options
• Demo: Query Editor Window
• Demo: View Menu
• Demo: Query Menu
• Demo: Project Menu
• Demo: Debug Menu
• Demo: Tools Menu
• Demo: Code Snippets Manager
• Demo: Window Options
• Demo: Help Menu.

Lesson 2:

• Demo: Right Click Menu
• Demo: Objects
• Demo: Starting Windows Service
• Demo: Filtering Objects
• Demo: Search for Objects
• Demo: Object Details
• Demo: Studio Designers
• Demo: Editing Procedures.

Lesson 3:

• Working with the Query Editor
• Demo: Tab Groups
• Demo: Formatting and Editing
• Demo: Intellsence
• Demo: Syntax Checking
• Demo: Find and Replace
• Demo: Scripting Objects
• Demo: Execute Procedure
• Demo: Debug T-SQL Code
• Demo: Call Stack
• Demo: Step into again
• Demo: Adding Script .

Lesson 4:

• Demo: Execute Queries
• Demo: Results Pane
• Demo: Status Bar
• Demo: Executing Single
• Demo: Query Options
• Demo: Controlling Results
• Demo: Execution Plan
• Demo: SQL Command Mode
• Demo: Create Projects
• Demo: Solution Explorer
• Demo: Query Designer
• Demo: Project Options
• Demo: Work Offline.