SQL Server Management Studio (SSMS) - Tutorial for Beginners

Опубликовано: 24 Февраль 2025
на канале: The SQL Guy
864
13

Here we have a complete tutorial on using SQL Server Management Studio (SSMS). This provides everything from using SSMS for the beginner and tips and tricks for those more advanced users.

Content

00:00 Downloading SQL Server Management Studio
01:22 Connecting to SQL Server
03:20 Object Explorer Overview
06:23 Object Explorer Details
08:36 SQL Server Security (logins vs users)
09:25 Granting Access to databases
11:00 Querying SQL Server
11:58 Schemas and Tables
12:26 Intellisense
13:02 SSMS Query Summary
13:40 Changing database
14:45 Advanced Execution Settings config
17:17 SQL Server Agent
19:29 SSMS Dark Mode
21:03 SSMS Show line numbers
22:29 Implicit Transactions overview
24:38 Activity Monitor - Monitoring Blocks
26:21 Scripting Objects to Code
27:54 Scripting Tasks to SQL Agent
29:34 Registered Servers
30:15 Creating Server Group Connections
32:14 Template Explorer
34:42 Updating Data