SQL Server Management Studio (SSMS) | Full Course

In this comprehensive video you will learn the features of SQL Server Management Studio (SSMS). You will start with connecting SSMS to SQL Server and then start navigating and writing SQL queries. You will learn about the many feature of SQL Server Management Studio.

Install SQL Server Developer Edition:

Install SQL Server Management Studio (SSMS)

SQL Server Management Studio (SSMS) | Full Course

TABLE OF CONTENTS
0:00 - Intro
0:26 - Installing SSMS
0:09 - Introduction and Prerequisites
1:19 - Connecting to SQL Server
3:15 - Multiple Connections
4:12 - Different Types of Connections
6:08 - Object Explorer
8:51 - Opening a Query Window
9:33 - Exploring the Query Window
10:54 - Executing SQL
12:43 - Executing SQL with F5
13:18 - SQL Intellisense/Autocomplete
14:30 - Multiple SQL Statements
16:04 - RowCount
16:49 - Multiple Query Windows
17:17 - Database Objects in the Object Explorer
18:10 - Dragging a Table into SQL
18:31 - Back to Rowcount
19:13 - Scripting a Table to a New Window
20:54 - Scripting a View to the Clipboard
22:07 - Errors and Red Squiggly Underlines
22:23 - Intellisense - Refresh Local Cache
24:14 - Altering a View
24:45 - Saving Files
25:41 - Opening a File
26:24 - Docking a Window
27:12 - Previewing Records
27:29 - Editing Rows
29:23 - Creating a New Table
29:51 - Properties Window
30:44 - Refreshing the Object Explorer
31:18 - Scripting from an Object Window
32:07 - Script Table as Insert
33:01 - Dragging Columns into Query
33:52 - View Dependencies
34:24 - Table Properties
35:00 - View Designer
35:52 - View Dependencies
36:44 - Script a Stored Procedure
37:36 - Script the Execute of a Stored Procedure
38:14 - Scripting a Function
39:01 - Database Security
40:06 - Server Security
41:50 - Other Server Folders
42:30 - Job Activity Monitor
43:48 - Job Activity Monitor - Auto Refresh
44:32 - Actual Execution Plan
45:52 - Live Statistics
46:14 - Include Client Statistics
47:01 - Parse Query
47:50 - Estimated Execution Plan
48:36 - Query Options
49:23 - Results to Grid, Text, and File
50:12 - Copy Results to Excel
51:38 - Code Snippets
53:41 - Surround With
54:22 - Other Right Click Options
55:58 - Pinning Windows
56:21 - Template Browser
1:00:12 - Adding Custom Templates
1:01:19 - SQL Profiler
1:04:34 - Azure Data Studio
1:05:27 - Increasing Grid Fonts
1:07:27 - Line Numbers and Line Wrap
1:09:16 - Query Shortcuts
1:10:02 - SP_Help
1:10:54 - Projects and Solutions
1:12:34 - Vertical Editing
1:14:04 - Help Documentation - F1
1:14:52 - Splitting the Query Editor
1:15:51 - Object Explorer Details
1:17:31 - Registered Servers
1:19:40 - Database Reports
1:20:23 - Color Coded Connections
1:21:39 - Conclusion

YOUTUBE NEWS UPDATES

VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS

SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!

SUBSCRIBE TO OUR EMAIL LIST!

LET'S CONNECT!

[joeyblue]

TABLE OF CONTENTS
0:00​ - Intro
0:26​ - Installing SSMS
0:09​ - Introduction and Prerequisites
1:19​ - Connecting to SQL Server
3:15​ - Multiple Connections
4:12​ - Different Types of Connections
6:08​ - Object Explorer
8:51​ - Opening a Query Window
9:33​ - Exploring the Query Window
10:54​ - Executing SQL
12:43​ - Executing SQL with F5
13:18​ - SQL Intellisense/Autocomplete
14:30​ - Multiple SQL Statements
16:04​ - RowCount
16:49​ - Multiple Query Windows
17:17​ - Database Objects in the Object Explorer
18:10​ - Dragging a Table into SQL
18:31​ - Back to Rowcount
19:13​ - Scripting a Table to a New Window
20:54​ - Scripting a View to the Clipboard
22:07​ - Errors and Red Squiggly Underlines
22:23​ - Intellisense - Refresh Local Cache
24:14​ - Altering a View
24:45​ - Saving Files
25:41​ - Opening a File
26:24​ - Docking a Window
27:12​ - Previewing Records
27:29​ - Editing Rows
29:23​ - Creating a New Table
29:51​ - Properties Window
30:44​ - Refreshing the Object Explorer
31:18​ - Scripting from an Object Window
32:07​ - Script Table as Insert
33:01​ - Dragging Columns into Query
33:52​ - View Dependencies
34:24​ - Table Properties
35:00​ - View Designer
35:52​ - View Dependencies
36:44​ - Script a Stored Procedure
37:36​ - Script the Execute of a Stored Procedure
38:14​ - Scripting a Function
39:01​ - Database Security
40:06​ - Server Security
41:50​ - Other Server Folders
42:30​ - Job Activity Monitor
43:48​ - Job Activity Monitor - Auto Refresh
44:32​ - Actual Execution Plan
45:52​ - Live Statistics
46:14​ - Include Client Statistics
47:01​ - Parse Query
47:50​ - Estimated Execution Plan
48:36​ - Query Options
49:23​ - Results to Grid, Text, and File
50:12​ - Copy Results to Excel
51:38​ - Code Snippets
53:41​ - Surround With
54:22​ - Other Right Click Options
55:58​ - Pinning Windows
56:21​ - Template Browser
1:00:12​ - Adding Custom Templates
1:01:19​ - SQL Profiler
1:04:34​ - Azure Data Studio
1:05:27​ - Increasing Grid Fonts
1:07:27​ - Line Numbers and Line Wrap
1:09:16​ - Query Shortcuts
1:10:02​ - SP_Help
1:10:54​ - Projects and Solutions
1:12:34​ - Vertical Editing
1:14:04​ - Help Documentation - F1
1:14:52​ - Splitting the Query Editor
1:15:51​ - Object Explorer Details
1:17:31​ - Registered Servers
1:19:40​ - Database Reports
1:20:23​ - Color Coded Connections
1:21:39​ - Conclusion

[tim]

My company bought me a subscription to a premium learning service, and I watched their video on SMMS. I think this version here does a lot more in less time. Great video! Thank you for the Table of Contents.

[meghasyam]

This is a great course featuring the basic things which help us navigate through the tool comfortably. Hard to find such quality content and heartfully thank Joey Blue for this.

[yfincbx]

I have been working with SMSS for almost 20 years, but I didn't know some of these features. This was great! thank you Joey.

[jameswalckner]

Best training video I've ever seen - I needed an introduction to SQL and this filled in the blanks for me and more. Thanks for creating this. (This is the first comment I've ever left on YouTube - fantastic content).

[johnthornton]

Excellent tutorial. I'm new to SQL and have been struggling with finding what I need in SMSS. I feel like I know so much more now which will save a lot of time and frustration. Thank you for taking the time to record this tutorial.

[vireshratkal]

I'm beginner to SSMS. It is an excellent training video about SSMS. I learned lots of useful tricks. Keep it up, Mr. Joey.

[paulien]

Dear Joey, thanks for taking the time to walk us through SSMS so extensively. I'm all new to it, so find this really really helpful!

[hierandel]

Fantastic coverage! As someone new to SSMS, this was a great walkthrough, and I'll be watching it again and using it as a desk reference (the timestamps are so helpful!!) You speak well, are concise, and cover the material without getting sidetracked. This felt as polished and meaningful as a class in a tech college course. Cheers!

[workjoy]

This a great breakdown of SSMS!!!
I stumbled on on this when looking for info on adding personal Snippets, I wish I had this a few years ago when I started out.
Totally going to share it with those starting out.

[Scarly]

Thanks so much for this, it is exactly what I was looking for. I've learned SQL through datacamp, but it was so difficult finding content to actually explain the UI and what all the buttons and tools are. I feel much more confident now, in only a couple hours of watching this and playing around accordingly.

[ozansen_ozibaba]

It is an excellent training video about SSMS. I learned lots of useful tricks. Keep it up, Mr. Joey.

[brenthalbach]

Excellent. I am new to this and this was great exposure to the management studio. Well worth the time to watch for anyone interested.

[srdavd]

Thank you for this tutorial. Had to learn how to work with SQL manager for a work project and you really helped me out.

[agustingutierrezcabrera]

Thanks a lot for this course! Found it super useful and easy to follow!

Thank a lot! I am starting with SSMS and SQL in general and I found this video helpful!!

[hassanelasri]

Great and fantastic job done here! especially the timestamps...very useful !

[gregorytaylor]

Very informative tutorial. Thanks Joey!

[kebincui]

Excelent tutorial walking through so many features. Thank you very much

[amartin]

Thank you Joey, this course is great. really appreciate your time and dedication !