SQL Server Management Studio – Tips & Tricks

SQL Server Management Studio – Tips & Tricks, available at $69.99, has an average rating of 4, with 22 lectures, 3 quizzes, based on 3 reviews, and has 8 subscribers.

You will learn about 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 This course is ideal for individuals who are SQL beginner, professional or DBA It is particularly useful for SQL beginner, professional or DBA.

Enroll now: SQL Server Management Studio – Tips & Tricks

Summary

Title: SQL Server Management Studio – Tips & Tricks

Price: $69.99

Average Rating: 4

Number of Lectures: 22

Number of Quizzes: 3

Number of Published Lectures: 22

Number of Published Quizzes: 3

Number of Curriculum Items: 25

Number of Published Curriculum Objects: 25

Original Price: €19.99

Quality Status: approved

Status: Live

What You Will 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 Should Attend

SQL beginner, professional or DBA

Target Audiences

SQL beginner, professional or DBA

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.

Course Curriculum

Chapter 1: Introduction to SSMS

Lecture 1: Introduction

Lecture 2: SSMS installation

Lecture 3: Connection to SQL server

Lecture 4: Sample database

Chapter 2: SQL Object explorer walkthrough

Lecture 1: Object explorer

Lecture 2: Menu items & Toolbar

Lecture 3: Query window

Lecture 4: Database node expansion & different DB-Objects

Lecture 5: Start / Stop / Restart the SQL Services

Chapter 3: Query Windows

Lecture 1: Query Windows – Shortcuts – 1

Lecture 2: Query Windows – Shortcuts – 2

Lecture 3: Query Windows – Shortcuts – 3

Lecture 4: Full screen + Close query window

Lecture 5: Multiple query window

Lecture 6: Squiggly underlines

Lecture 7: Saving the query result

Chapter 4: Fun facts

Lecture 1: Result save to Grid, Text & File

Lecture 2: Code snipped

Lecture 3: Line number

Lecture 4: Connection color

Lecture 5: Bookmarks

Lecture 6: Upcoming videos…

Instructors

Raushan Jha
SDE 2

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 0 votes
4 stars: 0 votes
5 stars: 2 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu