Getting Started: SQL Server

Get started with RDBMSs using Microsoft SQL Server.

About This Course

SQL Server is the foundation of Relational Database Management Systems (RDBMSs), and since its inception, it has revolutionised the software engineering world. Millions of developers are choosing SQL Server as their go-to solution for storing important business data, and for excellent reasons. It's battle-tested, reliable, resilient and guarantees that your data will be retrievable when you need it. It is an essential skill that every developer needs to have, whether they use an ORM that abstracts the technology away from them or work with T-SQL directly. In this course, veteran Alex Tushinsky will teach you everything you need to know to get started with SQL Server and establish a solid foundation for the technology. From licensing to installation, data manipulation, programming basics and relationships, this course has it all, and it will set you up for success with SQL Server.

Course Curriculum

3h 04m 7 sections

Course overview

02:27 Free preview

Getting Started

13:56

Setting up SQL Server Locally

06:21

SQL Server Management Studio Installation

02:12

Using SSMS

11:54

Running Scripts

08:02

General Rules

03:17

Creating Databases

05:56

SQL Server Data Types

08:07

Creating a Demo Database

06:00

Creating Tables

09:28

Tables and Relationships

11:37

Database Diagrams

03:53

Data Normalization

03:37

Insert

06:59

Select

03:10

Where Clause

03:59

Variables

05:08

Updates and Deletes

05:09

Requirements

02:12

RAND Function

01:55

Case Statements

02:24

User-Defined Functions and Stored Procedures

08:10

Alternative to Case Statements (Cartesian Product)

03:00

Conditions

06:23

Loops

03:29

Try/Catch and Transactions

02:43

Building Our Script

16:25

Inner Join

05:48

Left Outer Join

01:55

Right Outer Join

01:25

Views and Basic Data Aggregation

05:33

Conclusion

02:09

Meet Your Instructor

Alex Tushinsky

Alex Tushinsky

Alex has spent the past 30+ years working as a software developer, application architect, cybersecurity professional, and technical trainer. He is a lifelong learner and holds over 20 active certifications in IT. Alex is a Microsoft Certified Trainer and enjoys sharing his knowledge with others. He has taught at Rutgers University, Bergen Community College, County College of Morris, College of Southern Nevada, and UNLV. He holds a BS in Software Development and a Masters in Cybersecurity from Western Governors University. As a developer, Alex works with Java, C#, and Python helping small businesses and entrepreneurs achieve their vision from a technical perspective. He also works as a virtual CISO, performs penetration testing, and educates businesses and individuals on the importance of cybersecurity. When not working, Alex spends his time with his beautiful wife, and many pets, including two cats, and three Boston Terriers. He is an active runner and cyclist and is an ethical and health-conscious vegan.

View all courses by Alex Tushinsky

© 2025 Dometrain. All rights reserved.