SQL Server Management Studio - Tips & Tricks

Focused View

Raushan Jha

2:02:52

81 View

1 - Introduction to SSMS

1 - Introduction.mp4

03:22

2 - SSMS installation.mp4

08:52

3 - Connection to SQL server.mp4

05:34

4 - Sample database.mp4

07:06

2 - SQL Object explorer walkthrough

5 - Object explorer.mp4

07:44

6 - Menu items Toolbar.mp4

11:50

7 - Query window.mp4

09:33

8 - Database node expansion different DBObjects.mp4

05:41

9 - Start Stop Restart the SQL Services.mp4

05:40

3 - Query Windows

10 - Query Windows Shortcuts 1.mp4

09:30

10 - Query-Windows-shortcuts-1.mp4

09:30

11 - Query Windows Shortcuts 2.mp4

06:18

12 - Query Windows Shortcuts 3.mp4

04:13

13 - Full screen Close query window.mp4

03:01

14 - Multiple query window.mp4

04:31

15 - Squiggly underlines.mp4

01:31

16 - Saving the query result.mp4

03:37

4 - Fun facts

17 - Result save to Grid Text File.mp4

04:04

18 - Code snipped.mp4

03:01

19 - Line number.mp4

01:08

20 - Connection color.mp4

02:10

21 - Bookmarks.mp4

04:56

22 - Upcoming videos.html

Description

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

Who is this for?

SQL beginner, professional or DBA

More details

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.
Who this course is for:
SQL beginner, professional or DBA

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Raushan Jha

Instructor's Courses

Experienced software developer with a demonstrated history of working in the software industry. Skilled in databases, cloud technology (primarily Azure), high performing web applications. Strong engineering professional with a B. Tech. a degree focused on Information Technology. I'm mostly working on Microsoft tech stack. In my free time I try to help college pass outs and new developers.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.