Introduction Video – Navigating SSMS
Introduction Video – Navigating SSMS
Beginning SQL Server TSQL Programming
Module 1 - Introduction
Module 1 - Introduction
Module 2 – Navigating SSMS
Module 2 – Navigating SSMS
Module 3 – DML, the Data Manipulation Language
Module 3 – DML, the Data Manipulation Language
Module 4 – DDL, the Data Declaration Language
Module 4 – DDL, the Data Declaration Language
Module 5 – DCL, the Data Control Language
Module 5 – DCL, the Data Control Language
Module 6 – Using JOINS in Queries
Module 6 – Using JOINS in Queries
Module 7 – The ORDER BY clause
Module 7 – The ORDER BY clause
Module 8 – The GROUP BY clause
Module 8 – The GROUP BY clause
Module 9 – Aggregate Functions
Module 9 – Aggregate Functions
Module 10 – UNION and UNION ALL
Module 10 – UNION and UNION ALL
Module 11 – String Functions
Module 11 – String Functions
Module 12 – Date Functions
Module 12 – Date Functions
Module 13 – TSQL Deep Dive
Module 13 – TSQL Deep Dive
Module 14 – Wrap Up
Module 14 – Wrap Up
Lesson Homework Assignments
Lesson Homework Assignments
Lesson Homework Templates
Lesson Homework Templates
Lesson Homework Solutions
Lesson Homework Solutions
Create Databases DDL
Create Databases DDL
Create Database Tables
Create Database Tables
Welcome to our introductory online Microsoft SQL Server Management Studio (SSMS) course! Before we begin, it's important to note that this course requires a basic understanding of database concepts. This course, led by an experienced SQL Server professional with over ten years of industry experience, will equip you with practical skills as we explore the powerful SSMS tool and its vital role in database management. By the end of this course, you'll be able to navigate the SSMS interface, execute queries, design databases, manage security, and more. Whether you're a beginner or looking to refresh your skills, we'll guide you through the essentials of SSMS functionality. Hands-on exercises and practical examples will give you the confidence and skills to handle database tasks efficiently. Join us and unlock the full potential of SQL Server Management Studio!
Each lesson includes several examples and demos plus a homework assignment to reinforce your learning, and all example code is available in the lesson folder.