md

MSSQl Questions

• Introduction to SQL Server - SQL Introduction
• What Is Data, Database \& Data Management in SQL
• What Is Database Entity in SQL Server - Entity in SQL - Database Entity in SQL
• Database Management System in SQL - SQL DBMS - RDBMS - SQL Server
• Database Models in SQL Server - Database Models - Relational Data Model - SQL
• RDBMS in SQL - Relational Database Management System in SQL - SQL
• How to Create Database \& Tables in SQL Server - Creating Database \& Tables in SQL
• How to Insert Data in Table in SQL Server - Inserting Data in SQL Table - SQL
• Update Command in SQL Server - Update with Set in SQL - SQL Server
• DELETE and TRUNCATE Command in SQL
• UNIQUE and NOT NULL Constraints in SQL:
• PRIMARY KEY, DEFAULT, and CHECK Constraints in SQL Server:
• SELECT Command in SQL Server:
• Cascading Referential Integrity Constraints in SQL Server:
• ALTER Command in SQL Server:
• Adding \& Dropping SQL Constraints Using ALTER Command:
• ALIAS in SQL Server:
• INNER JOIN in SQL Server:
• LEFT JOIN, RIGHT JOIN \& FULL OUTER JOIN IN SQL SERVER
• SELF JOIN IN SQL SERVER
• IDENTITY OR AUTO INCREMENT IN SQL SERVER
• Union And Union All In SQL Server - SQL Union All Command - Union - Union All
• Intersect And Except In SQL Server - SQL Intersect - SQL Except - Except - Intersect
• Aggregate Functions in SQL Server:
• Group By in SQL Server:
• Having and Where Clause in SQL Server:
• Order By Command in SQL Server:
• Views in SQL Server:
• LIKE Operator in SQL Server:
• Subquery in SQL Server:
• Scalar and Multi-Valued Subquery in SQL:
• Self-Contained and Correlated Subquery in SQL Server:
• BETWEEN, TOP, PERCENT, DISTINCT, and IN Operator in SQL Server:
• Select Into Statement in SQL Server
• Insert Into with Select Statement in SQL Server
• Changing or Renaming Database Name and Table Name in SQL
• Stored Procedure in SQL Server
• Functions in SQL Server
• Inline Table-Valued Functions in SQL Server
• Multi-Statement Table-Valued Functions in SQL Server
• Difference Between Stored Procedures and Functions in SQL Server
• Joining of 3 Tables in SQL Server
• Understanding SQL Triggers: Enhancing Database Functionality
• SQL Server Scoped DDL Triggers:
• Setting Execution Order of Triggers in SQL:
• GUID in SQL (Globally Unique Identifier):
• Composite Key or Composite Primary Key in SQL Server:
• Normalization in SQL:
• Second Normal Form (2NF) - Normalization - Database Normalization
• Third Normal Form (3NF) - Normalization - Database Normalization
• String Functions In SQL Server - SQL String Functions - SQL Server
• Indexes In SQL Server - SQL Index - Index In SQL - SQL Indexes - SQL
• Clustered Index In SQL Server - Indexes In SQL - SQL Clustered Index - SQL Server
• Non-Clustered Index in SQL Server
• B-Tree Structure of Index in SQL Server
• Computed Columns or Calculated Columns in SQL
• Creating Index on Computed Column in SQL
• Cube and Rollup Command in SQL Server:
• ROLLUP Command:
• Grouping Sets in SQL Server:
• MERGE Statement in SQL Server:
• Transactions in SQL , ACID Properties in SQL:
• TRY CATCH or Error Handling in SQL Server:
• TRANSACTIONS WITH TRY CATCH IN SQL SERVER
• TEMPORARY TABLES / LOCAL TEMPORARY TABLE IN SQL SERVER
• GLOBAL TEMPORARY TABLES IN SQL SERVER
• DIFFERENCE BETWEEN LOCAL AND GLOBAL TEMPORARY TABLES IN SQL SERVER
• LESCE FUNCTION IN SQL SERVER
• Coalesce vs. ISNULL Function in SQL Server:
• CAST Function in SQL Server:
• CONVERT Function in SQL Server:
• Difference Between CAST and CONVERT:
• Working With Cursors in SQL Server:
• OVER CLAUSE WITH PARTITION BY IN SQL SERVER
• Retrieving Last Generated Identity Column Value in SQL Server - Scope_Identity VS @@identity
• Row_Number Function In SQL Server - Row_Number With Partition By Clause
• Rank And Dense_Rank Function In SQL Server - Rank VS Dense_Rank In SQL Server
• Cross Apply \& Outer Apply In SQL Server - Apply Operator in SQL Server
• CTE in SQL - Common Table Expression In SQL - SQL CTE - CTE In SQL Server
• Date \& Time Functions In SQL - SQL Date \& Time Functions