Learn SQL Server with SSMS

Understand the basics of SQL Server and its architecture. Navigate and utilize SQL Server Management Studio (SSMS) effectively. Create, modify, and manage databases and tables. Write and execute SQL queries to retrieve and manipulate data. Implement data integrity and constraints. Perform data import/export operations. Understand and use stored procedures, functions, and triggers. Optimize and troubleshoot SQL queries for performance.

Instructors:

SJ Sushmitha J

Start Learning

12 Enrolled

90 Lessons

This course is designed to provide a comprehensive introduction to SQL Server using SQL Server Management Studio (SSMS). Whether you’re a beginner or looking to enhance your database management skills, this course covers essential concepts and practical techniques. You’ll learn how to set up and configure SQL Server, create and manage databases, and write efficient SQL queries. Through hands-on exercises and real-world examples, you’ll gain the skills needed to manage data effectively and optimize database performance. By the end of the course, you’ll be proficient in using SSMS to handle various database tasks and ready to tackle more advanced SQL Server topics.

Course Content

Introduction

Intro

Note

Create Database and Table

Connecting to SQL Server using SSMS

Creating altering and dropping a database

Creating and working with tables

Constraint

Default Constraint

Cascading referential integrity constraint

Check Constraint

Identity Column

How to get the last generated identity column value in SQL Server

Unique Key Constraint

Select and Join

Select statement in sql server

Group by in sql server

Joins in sql server

Advanced or intelligent joins in sql server

Self join in sql server

Different ways to replace NULL in sql server

Coalesce function in sql server

Union and union all in sql server

Difference between where and having

Select

Stored Procedures

Stored procedures in sql server

Stored procedures with output parameters

Stored procedure output parameters or return values

Advantages of stored procedures

Cursors

Replacing cursors using joins

Functions

String Functions

LEFT, RIGHT, CHARINDEX and SUBSTRING

Replicate, Space, Patindex, Replace and Stuff string functions

DateTime functions

IsDate, Day, Month, Year and DateName DateTime functions

DatePart, DateAdd and DateDiff functions

Cast and Convert functions

Mathematical functions

Scalar user defined functions

Inline table valued functions

Multi statement table valued functions

Important concepts related to functions

Index and View

Temporary tables

Indexes

Clustered and nonclustered indexes

Unique and Non Unique Indexes

Advantages and disadvantages of indexes

Views

Updatable views

Indexed views

View limitations

Triggers

DML triggers

Update Trigger

Instead of insert trigger

Instead of update triggers

Instead of delete triggers

DDL Triggers

Server scoped ddl triggers

Trigger Execution Order

Logon Triggers

Derived Table and CTE

Derived tables and common table expressions

CTE

Updatable common table expressions

Recursive CTE

Normalization and Subqueries

Database normalization

2NF and 3NF

Transactions

Transactions and ACID Tests

Subqueries

Correlated subquery

Operators

Pivot

Except Operator

Difference between except and not

Intersect operator

Difference between union intersect and except

Some More Functions

Grouping function

GROUPING ID function

Over clause

Row Number function

Rank and Dense Rank

Difference between rank dense rank and row number

Lead and Lag functions

FIRST VALUE function

Window functions

Difference between rows and range

LAST VALUE function

UNPIVOT

Reverse PIVOT table

Choose function

IIF function

TRY PARSE function

TRY CONVERT function

Assessment for Learn SQL Server with SSMS

Reviews

Review the course

Help us improve our course material.

Write a review