Topic 5 – SSMS
Topic 5 – 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
In this lesson, we'll explore one of the most essential tools for database professionals: SQL Server Management Studio. It is your gateway to managing and interacting effectively with SQL Server databases.
Throughout this lesson, we'll explore the various features and functionalities of SSMS, providing you with the knowledge and skills needed to navigate the tool confidently. Whether you're a beginner or an experienced SQL Server user, this lesson will equip you with the necessary insights to leverage SSMS to its fullest potential.
SSMS offers a comprehensive suite of tools to streamline your database management tasks, from executing queries and designing databases to monitoring server activity and managing security. By the end of this lesson, you'll be well-equipped to harness the power of SQL Server Management Studio to enhance your productivity and efficiency in database administration. Let's dive in and unlock the full potential of SSMS together!