Skip to content

Learn

All CoursesBrowse the full catalog of expert-led courses
WorkshopsDeep-dive workshops from industry experts

AI-Powered

Learning PathsNewA personal path to your goal, built by AI
AI AgentLearn with an AI agent on every lesson
MCP ServerBring Dometrain into your AI coding tools
Mock InterviewsNewPractice real interviews with an AI interviewer

Trending now

Dometrain ProAll courses. One subscription.Every course and workshop replay, plus the AI-powered tools.Explore Pro

Community

LeaderboardSee how you rank against fellow learners
ReviewsWhat developers say about our courses
Customer StoriesHow real teams level up with Dometrain
ChangelogSee what's new and improved at Dometrain

Content

BlogsArticles and deep dives from our authors
AuthorsMeet the engineers behind the courses

Partners

AffiliatesEarn by sharing Dometrain with your audience
Dometrain for BusinessTraining and team management for companies

SkillScoreNew Dometrain Pro

Shopping Basket

Your basket is empty

Business Portal

SQL Server

3h 5m

Getting Started

Progress0%

0 / 34 lessons3h 4m left

Course overview(0/1)

Course overviewFree Preview2m 27s

Getting Started(0/6)

Getting Started13m 56s Setting up SQL Server Locally6m 21s SQL Server Management Studio Installation2m 12s Using SSMS11m 54s Running Scripts8m 2s General Rules3m 17s

Building in SQL Server(0/7)

Creating Databases5m 56s SQL Server Data Types8m 7s Creating a Demo Database6m 0s Creating Tables9m 28s Tables and Relationships11m 37s Database Diagrams3m 53s Data Normalization3m 37s

Data Manipulation Language(0/5)

Insert6m 59s Select3m 10s Where Clause3m 59s Variables5m 8s Updates and Deletes5m 9s

Programming Basics(0/9)

Requirements2m 12s RAND Function1m 55s Case Statements2m 24s User-Defined Functions and Stored Procedures8m 10s Alternative to Case Statements (Cartesian Product)3m 0s Conditions6m 23s Loops3m 29s Try/Catch and Transactions2m 43s Building Our Script16m 25s

Relationships and Views(0/4)

Inner Join5m 48s Left Outer Join1m 55s Right Outer Join1m 25s Views and Basic Data Aggregation5m 33s

Course conclusion(0/2)

Conclusion2m 9s Rate this course

0 matches found

Loading transcript

No transcript available for this lesson.

Sign in to take notes

Timestamped notes are saved to your account and grouped by lesson here, so you can jump back to any moment of the course.

Get Your Certificate

Right Outer Join

Relationships and Views

Watch 50% of the video to earn XP

Sign in to watch this course

Already a Dometrain Member?

or

New to Dometrain?

Next Lesson

Views and Basic Data Aggregation

Complete to earn+100 XP

+0 XP

+20 to next Gem

1 day streak!

Level up!

Streak saved!

Lesson Complete!

+0 XP

+20 to next Gem

Streak started!

Level 1!

Freeze earned!

Up next:Views and Basic Data Aggregation

Lesson Notes

Read this lesson

Loading content...

Unable to load content. Please try again.

Upgrade to Dometrain Pro

Get unlimited access to this video and all other courses on Dometrain with a Pro subscription.

Unlimited access to all courses
New courses added regularly
Certificates of completion

Get Dometrain Pro

Where today's experts teach tomorrow's

Learn

Courses Learning Paths Workshops

Community

Blog Authors Reviews Customer Stories Changelog

Business

Dometrain Pro Business Portal Affiliates

Support

Contact Terms of Use Privacy Policy

© 2026 Dometrain. All rights reserved.

What's New