Get started with RDBMSs using Microsoft SQL Server.
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.
Curriculum
Course overview (02:27)
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)
Course Info
Level:
Getting Started Duration:
3h 04m Rating (New):
Lifetime access
Add to CartAbout the Author
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.
More courses by Alex Tushinsky© 2025 Dometrain. All rights reserved.