Normal Forms in DATABASE
MukeshJuly 08, 2023
FIRST Normal Form Every value in a cell of an Attribute should be an ATOMIC, which means that an attribute cell can contain only single data...
0 Comments
Read
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
.jpeg)
DATABASE KEYS in SQL Server
MukeshJune 19, 2023
SUPER KEY Super Key is an Attribute or a Set of Attributes that can uniquely define a row in a table. In the below Query, we have created Em...
Read
TOP 200 SQL SERVER Interview Questions
MukeshJune 15, 2023
VIEWS in SQL Server A View is a method of Encapsulating a Complex query into a simple form, For example, your Client has no idea how ...
Read
FUNCTIONS in SQL Server
MukeshJune 15, 2023
FUNCTIONS in SQL Server A function is a set of codes that returns a value, the value can be Scalar or in the form of a table. There are two ...
Read
CTE in SQL Server
MukeshJanuary 11, 2023
What are CTE & why should we use them ? CTE or Common Table Expressions are very similar to Views or Derived tables, They were first Int...
Read
Errors Handling in SQL Server
MukeshJanuary 02, 2023
List of System-Defined Error Messages We can use sys. messages Table to look for the specific errors with their respective error numbers. se...
Read
ISOLATION LEVEL IN SQL Server
MukeshOctober 25, 2022
LOST UPDATE A lost Update happens when one transaction updates a record and the same record is accidentally updated by another transaction. ...
Read
Transaction Modes in SQL Server
MukeshOctober 25, 2022
TYPES Of Transactions in SQL Server Autocommit Transaction This is the default mode of transaction in SQL Server, Every command we issue in ...
Read
Subscribe to:
Posts
(
Atom
)
