<<< PBS

.Net Core Concepts

• Composite key e.g. In SQL, a composite key, also known as a compound key or composite primary key, is a key that consists of two or more columns in a database table. Unlike a simple key, which is made up of a single column, a composite key uses multiple columns to uniquely identify a row in a table. This means that the combination of values in the composite key columns must be unique for each row in the table.

• Cursor: In SQL, a cursor is a database object that is used to retrieve and manipulate data from a result set, typically within a stored procedure or a block of code. Cursors are especially useful when you need to process rows of data one at a time, rather than fetching the entire result set at once. Cursors are often used in procedural SQL languages like PL/SQL (used in Oracle databases) or T-SQL (used in Microsoft SQL Server). There are 2 types of Cursors: Implicit Cursors, and Explicit Cursors.

• Query Concepts click >>>

• OOP Concepts click >>>

• CRUD Operations

#AbdurRahimRatulAliKhan #ARRAK #Code #Programming #Panjeree #PBS #Viva

>>>