HBHarsh Bhosaleinharshb21.hashnode.dev·Apr 23, 2023 · 1 min readDBMS And SQL ConclusionIn conclusion, DBMS and SQL are essential tools for managing and manipulating large amounts of data in a structured and efficient manner. A well-designed database can improve data accuracy, consistency, and security, and can make it easier to retriev...00
HBHarsh Bhosaleinharshb21.hashnode.dev·Apr 23, 2023 · 2 min readSQL Like: Understanding Like operator and its usesThe SQL LIKE operator is used to search for a specified pattern in a column of a table. It is used in the WHERE clause of a SELECT statement to retrieve all rows where the specified column matches a pattern. In this blog, we will discuss the syntax a...00
HBHarsh Bhosaleinharshb21.hashnode.dev·Apr 23, 2023 · 2 min readSQL Functions: Commonly used SQL functions and their syntaxSQL functions are built-in operations that are used to perform various tasks on the data in a database. In this blog, we will discuss commonly used SQL functions and their syntax. COUNT Function The COUNT function is used to count the number of rows...00
HBHarsh Bhosaleinharshb21.hashnode.dev·Apr 23, 2023 · 2 min readSQL Views: Understanding Views and their usesSQL views are virtual tables that are based on the result set of a SELECT statement. Views provide a way to simplify complex queries and hide the underlying complexity of the database schema. In this blog, we will discuss SQL views and their uses. Wh...00
HBHarsh Bhosaleinharshb21.hashnode.dev·Apr 23, 2023 · 2 min readSQL Subqueries: Understanding Subqueries and their typesIn SQL, a subquery is a query within a query. It allows you to nest one query within another, which can help you to retrieve complex data from a database. In this blog, we will discuss subqueries and their types in SQL. What is a Subquery? A subquery...00
