Keep Coding Keep Cheering!
What is Carry Forward? The word “carry forward” does not refer to a specific idea in data structures and algorithms. However, “carry forward” in the context of arrays often refers to the process of relocating entries in an array to fill in empty spaces left by deleted or removed elements. This is also referred to […]
April 12, 2023 | Data Structure | No comments
What is Prefix Sum? Prefix Sum is a method for dealing with array manipulation challenges. It entails establishing an auxiliary array in which each element keeps the sum of all the components preceding it(including the current element). A prefix sum array is another name for this auxiliary array. Sample example to understand the concept: Explanation: […]
April 10, 2023 | Data Structure | No comments
A group of related data elements stored at adjacent memory locations is referred to as an array. One of the most basic data structures, it allows for random access to each data element by its index number. Properties of an Array: Arrays contain a number of crucial characteristics that make them helpful in a wide […]
April 9, 2023 | Data Structure | No comments
What is Time Complexity? Time complexity is a key concept in computer science, particularly in data structures and algorithms(DSA). It measures how long it takes to run an algorithm or complete a task, and it is usually expressed in terms of the input size. What Is Space Complexity? Space complexity is a measure of the […]
April 9, 2023 | Data Structure | No comments
What are SQL Views? Views are virtual tables in SQL. A view, like every other table in the database, has rows and columns. We can create a view by selecting fields from one or more tables in the database. A View can contain all of the rows of a table or particular rows based on […]
April 7, 2023 | DBMS | No comments
What is an SQL Sequence? Database systems offer sequence to produce unique numeric values in a series according to defined standards. In SQL, a sequence is a user-defined schema-bound entity that generates a set or sequence of numbers with important ordering. Some database applications may demand that each table row include unique values. In many […]
April 6, 2023 | DBMS | No comments
SQL set operations combine the output of two or more SELECT statements into a single result set. The set operators appear to be similar to SQL joins, but there is a significant difference. SQL joins combine the columns from different tables, whereas SQL operators combine rows from different queries. Types of Set Operation: Union Union […]
April 6, 2023 | DBMS | No comments
What is an SQL Join? The SQL Join clause is used to combine rows from two or more related tables into a single result set based on a common column or columns, which is typically established through foreign key constraints. The “on” keyword is used to specify the join condition, which specifies the relationship between […]
April 6, 2023 | DBMS | No comments
What is an Alias? An SQL alias is simply an alternative name that can be used to refer to a table or column within a SQL query. This is especially useful for large or complex queries. Alias is primarily used to provide a short alias name for a complexly named column or table. The AS […]
April 3, 2023 | DBMS | No comments
In the previous section we saw Aggregate Functions, in this section let us discuss Scalar Functions. Scalar Function: A scalar function is a type of function that returns a single value based on the input parameters. In SQL queries, scalar functions can manipulate data, perform calculations, and retrieve specific values from a database. Following are […]
April 3, 2023 | DBMS | No comments