SQL Server Management Studio (SSMS) | Complete course

Channel	Publish Date	Thumbnail & View Count	Download Video
	Publish Date not found	0 Views	View on YouTube Download Video

In this comprehensive video, you will learn the features of SQL Server Management Studio (SSMS). You start by connecting SSMS to SQL Server and then start navigating and writing SQL queries. You will be introduced to the many possibilities of SQL Server Management Studio.

Install SQL Server Developer Edition:
https://www.youtube.com/watch?v=05ZivSteGJg

Install SQL Server Management Studio (SSMS)
https://www.youtube.com/watch?v=CqpURYqK_wU

SQL Server Management Studio (SSMS) | Complete course

TABLE OF CONTENTS
0:00 – Introduction
0:26 – Install SSMS
0:09 – Introduction and requirements
1:19 – Connecting to SQL Server
3:15 – Multiple connections
4:12 – Different types of connections
6:08 – Object explorer
8:51 – Open a query window
9:33 – Exploring the query panel
10:54 – Running SQL
12:43 – Run SQL with F5
13:18 – SQL Intellisense/AutoComplete
2:30 PM – Multiple SQL statements
16:04 – Row count
16:49 – Multiple query windows
17:17 – Database objects in the Object Explorer
18:10 – Dragging a table into SQL
6:31 PM – Back to Row Count
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 – Local cache refresh
24:14 – Change a view
24:45 – Save files
25:41 – Opening a file
26:24 – Fixing a window
27:12 – View records
27:29 – Edit rows
29:23 – Create a new table
29:51 – Properties window
30:44 – Refresh the object explorer
31:18 – Scripting from an object window
32:07 – Script table as insert
33:01 – Drag columns to query
33:52 – View dependencies
34:24 – Table properties
35:00 – View designer
35:52 – View dependencies
36:44 – Write a stored procedure
37:36 – Script for executing a stored procedure
38:14 – Scripting a function
39:01 – Database security
40:06 – Server security
41:50 – Other server directories
42:30 – Monitor for task activity
43:48 – Monitor task activity – Auto refresh
44:32 – Actual implementation plan
45:52 – Live stats
46:14 – Includes customer statistics
47:01 – Query parsing
47:50 – Estimated execution plan
48:36 – Search options
49:23 – Results to raster, text and file
50:12 – Copy results to Excel
51:38 – Code snippets
53:41 – Surround yourself with
54:22 – Other right-click options
55:58 – Freezing Windows
56:21 – Template browser
1:00:12 – Add custom templates
1:01:19 – SQL profiler
1:04:34 – Azure Data Studio
1:05:27 – Enlarge raster fonts
1:07:27 – Line numbers and line wrapping
1:09:16 – Search 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