SQL Server Management Studio - Tips & Tricks
Date: 21 January 2023 | Posted by: voska89
Published 1/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 771.90 MB | Duration: 1h 53m
SSMS short cuts to become power SQL developer
What you'll learn
Learn to run, debug, save the sql-query
Different menu options and how to use them effectively
Database object exploration
Managing DB, User, Login through SSMS
Requirements
SQL server 2005 onward (2008, 2008 R2, 2012, 2016, 2017, 2019) or Azure SQL
Sql server management studio (better to use the latest one 18.x)
Description
When a developer or new professional trying start looking into SQL server, it take time to use the SSMS effectively. Like when I started using database in late 2010 it was quite challenging back then we didn't have this much online resources to grab the concepts & tips. Based on my knowledge & experience I have tried to create short videos to help you to know SSMS better with frequently used short-cuts and few queries. I tried to make short videos but long enough to digest the concepts :)These are lot's of tip & tricks which comes out by default in SSMS but here I mainly focused on Database engine. After going through this couse you will be more equipped with SSMS shortcuts which helps you to write T-SQL effectively. Slowly I'll add few more videos to make this a one place video tutorial for any aspiring SQL server developer. In between while going through the tutorial, if you find any concept not clear or bit lengthy or any suggestion to improve feel free to send me a message. Also you've any question or want me to create video for any of your favorite SSMS feature or related to SQL server queries do send me a message and I'll try my best. Happy coding & welcome to SQL server world.
Overview
Section 1: Introduction to SSMS
Lecture 1 Introduction
Lecture 2 SSMS installation
Lecture 3 Connection to SQL server
Lecture 4 Sample database
Section 2: SQL Object explorer walkthrough
Lecture 5 Object explorer
Lecture 6 Menu items & Toolbar
Lecture 7 Query window
Lecture 8 Database node expansion & different DB-Objects
Lecture 9 Start / Stop / Restart the SQL Services
Section 3: Query Windows
Lecture 10 Query Windows - Shortcuts - 1
Lecture 11 Query Windows - Shortcuts - 2
Lecture 12 Query Windows - Shortcuts - 3
Lecture 13 Full screen + Close query window
Lecture 14 Multiple query window
Lecture 15 Squiggly underlines
Lecture 16 Saving the query result
Section 4: Fun facts
Lecture 17 Result save to Grid, Text & File
Lecture 18 Code snipped
Lecture 19 Line number
Lecture 20 Connection color
Lecture 21 Bookmarks
Lecture 22 Upcoming videos...
SQL beginner, professional or DBA
Homepage
https://www.udemy.com/course/sql-server-management-studio-tips-tricks/DOWNLOAD LINK
Links are Interchangeable - No Password - Single Extraction
See full article