×
Create CV Books Summaries Online Courses Blog Communities

Login

Sign up
MindLuster Logo
Categories
Recent

SQL Server for beginners

Programming

Register in this Course

Install SQL Server 2019 Step by Step | Developer Edition | Free Software | Install SSMS

Connecting to SQL Server using SSMS Part 1

Creating altering and dropping a database Part 2

Creating and working with tables Part 3

Adding a default constraint Part 4

Cascading referential integrity constraint Part 5

Adding a check constraint Part 6

Identity Column in SQL Server Part 7

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

Unique key constraint Part 9

Select statement in sql server Part 10

Group by in sql server Part 11

Joins in sql server Part 12

Advanced or intelligent joins in sql server Part 13

Self join in sql server Part 14

Different ways to replace NULL in sql server Part 15

Coalesce function in sql server Part 16

Union and union all in sql server Part 17

Stored procedures in sql server Part 18

Stored procedures with output parameters Part 19

Stored procedure output parameters or return values Part 20

Advantages of stored procedures Part 21

Built in string functions in sql server 2008 Part 22

LEFT RIGHT CHARINDEX and SUBSTRING functions in sql server Part 23

Replicate Space Patindex Replace and Stuff string functions in sql server 2008 Part 24

DateTime functions in SQL Server Part 25

IsDate Day Month Year and DateName DateTime functions in SQL Server Part 26

DatePart DateAdd and DateDiff functions in SQL Server Part 27

Cast and Convert functions in SQL Server Part 28

Mathematical functions in sql server Part 29

Scalar user defined functions in sql server Part 30

Inline table valued functions in sql server Part 31

Multi statement table valued functions in sql server Part 32

Important concepts related to functions in sql server Part 33

Temporary tables in SQL Server Part 34

Indexes in sql server Part 35

Clustered and nonclustered indexes in sql server Part 36

Unique and Non Unique Indexes in sql server Part 37

Advantages and disadvantages of indexes in sql server Part 38

Views in sql server Part 39

Updatable views in sql server Part 40

Indexed views in sql server Part 41

View limitations in sql server Part 42

DML triggers in sql server Part 43

After update trigger Part 44

Instead of insert trigger Part 45

Instead of update triggers in sql server Part 46 avi

Instead of delete triggers in sql server Part 47 avi

Derived tables and common table expressions in sql server Part 48

CTE in sql server Part 49

Updatable common table expressions in sql server Part 50

Recursive CTE in sql server Part 51

Database normalization Part 52

Second normal form and third normal form Part 53

Pivot in sql server 2008 Part 54

Error handling in sql server 2000 Part 55

Error handling in sql server Part 56

Transactions in sql server Part 57

Transactions in sql server and ACID Tests Part 58

Subqueries in sql Part 59

Correlated subquery in sql Part 60

Creating a large table with random data for performance testing Part 61

What to choose for performance SubQuery or Joins Part 62

Cursors in sql server Part 63

Replacing cursors using joins in sql server Part 64

List all tables in a sql server database using a query Part 65

Writing re runnable sql server scripts Part 66

Alter database table columns without dropping table Part 67

Optional parameters in sql server stored procedures Part 68

Part 69 Merge in SQL Server

sql server concurrent transactions

sql server dirty read example

sql server lost update problem

Non repeatable read example in sql server

Phantom reads example in sql server

Snapshot isolation level in sql server

Read committed snapshot isolation level in sql server

Difference between snapshot isolation and read committed snapshot

SQL Server deadlock example

SQL Server deadlock victim selection

Logging deadlocks in sql server

SQL Server deadlock analysis and prevention

Capturing deadlocks in sql profiler

SQL Server deadlock error handling

Handling deadlocks in ado net

Retry logic for deadlock exceptions

How to find blocking queries in sql server

SQL Server except operator

Difference between except and not in sql server

Intersect operator in sql server

Difference between union intersect and except in sql server

Cross apply and outer apply in sql server

DDL Triggers in sql server

Server scoped ddl triggers

sql server trigger execution order

Audit table changes in sql server

Logon Triggers in SQL Server

Select into in sql server

Difference between where and having in sql server

Table valued parameters in SQL Server

Send datatable as parameter to stored procedure

Grouping Sets in SQL Server

Rollup in SQL Server

Cube in SQL Server

Difference between cube and rollup in SQL Server

Grouping function in SQL Server

GROUPING ID function in SQL Server

Debugging sql server stored procedures

Over clause in SQL Server

Row Number function in SQL Server

Rank and Dense Rank in SQL Server

Difference between rank dense rank and row number in SQL

Calculate running total in SQL Server 2012

NTILE function in SQL Server

Lead and Lag functions in SQL Server 2012

FIRST VALUE function in SQL Server

Window functions in SQL Server

Difference between rows and range

LAST VALUE function in SQL Server

UNPIVOT in SQL Server

Reverse PIVOT table in SQL Server

Choose function in SQL Server

IIF function in SQL Server

TRY PARSE function in SQL Server 2012

TRY CONVERT function in SQL Server 2012

EOMONTH function in SQL Server 2012

DATEFROMPARTS function in SQL Server

Difference between DateTime and SmallDateTime in SQL Server

DateTime2FromParts function in SQL Server 2012

Difference between DateTime and DateTime2 in SQL Server

Offset fetch next in SQL Server 2012

Identifying object dependencies in SQL Server

sys dm sql referencing entities in SQL Server

sp depends in SQL Server

Sequence object in SQL Server 2012

Difference between sequence and identity in SQL Server

Guid in SQL Server

How to check GUID is null or empty in SQL Server

Dynamic SQL in SQL Server

Implement search web page using ASP NET and Stored Procedure

Implement search web page using ASP NET and Dynamic SQL

Prevent sql injection with dynamic sql

Dynamic SQL in Stored Procedure

Sql server query plan cache

exec vs sp executesql in sql server

Dynamic sql table name variable

Quotename function in SQL Server

Dynamic SQL vs Stored Procedure

Dynamic sql output parameter

Temp tables in dynamic sql

We Appreciate Your Feedback

Excellent
3 Reviews
Good
6 Reviews
medium
1 Reviews
Acceptable
1 Reviews
Not Good
0 Reviews
4
11 Reviews
Yvonne Langat 

I'm new , hoping to learn more
2026-03-08

Shraddha Jadhav 

Good
2026-02-24

Sharanya Pagidipally 

very
2026-01-18

Dhiraj Yadav 

good
2025-11-19

srikanth reddy 

GOOD
2025-05-17

NOORUDDIN ABDULLAH IBRAHIM 

Excellent
2025-04-29

Okello David 

great
2025-04-23

Osmah Mabike 

They are good
2025-04-18

omara derrick 

good
2025-04-17

ARINAITWE DOMINIC 

Excellent
2025-04-17

OMARA DERRICK 

Good lectures
2025-04-17

Show More Reviews

Another Programming Courses

React Projects Workshops
33 Lessons

React Projects Workshops

Node js back end JavaScript
34 Lessons

Node js back end JavaScript

Python programming language
15 Lessons

Python programming language

Social Network Theme UI With Sass
4 Lessons

Social Network Theme UI With Sass

Full Stack React Django
7 Lessons

Full Stack React Django

Build a Node js App With Sequelize
3 Lessons

Build a Node js App With Sequelize

GraphQL With React Apollo
4 Lessons

GraphQL With React Apollo

Node js REST API With Restify Mongoose JWT
2 Lessons

Node js REST API With Restify Mongoose JWT

Show More Course for Programming

The SQL Server is a relational database management system from Microsoft. The system is designed and built is to manage and store information. The system supports various business intelligence operations, analytics operations, and transaction processing.

Trends
Recent
Web Design Using HTML CSS