Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
Last updated: Apr 5, 2022

SQL Databases

SQL Databases covers the databases that are based on the programming language called SQL. This category will start with MySQL, and how to install and set it up. It further explains various MySQL features and functions including the representations of various data types and variables. Further, it introduces PostgreSQL and explains its features and how to install and set it. It introduces Oracle and Microsoft SQL. It also shows how SQL differs from MySQL and how MySQL differs from PostgreSQL.
Pros and Cons of Using SQL vs NoSQL Databases EASY
In this article, we will discuss various pros and cons of using SQL and NoSQL databases in detail.
What Is MYSQLDUMP?
In this blog, we will learn about MySQL dump. We will also how to use MySQL dump and MYSQLDUMP in Action. .
Codd’s rules in DBMS EASY
Codd's Rules, developed by Edgar F. Codd, outline a set of guidelines for relational database management systems (RDBMS) to ensure their integrity, flexibility, and efficiency. Learn about Codd’s rules in DBM in this comprehensive guide.
Integrity Constraint Violation EASY
Integrity Constraint Violation occurs when a database rule is broken. It leads to inconsistent or invalid data. We will learn how to handle and prevent these violations.
Author Arya27
0 upvotes
MySQL REGEXP operator EASY
In this blog, we will learn about the MySQL regex operator.
Offset-Fetch in MS SQL Server EASY
This article will discuss how Offset-Fetch in MS SQL Server works. We will even discuss different aspects related to Offset-Fetch in MS SQL Server.
Reset MySQL Root Password
In this blog, we will learn about how to reset MySQL root password. We will also understand MySQL Root Password and its importance.
Difference between SQL and NoSQL EASY
In this article, we will focus on understanding a brief introduction on SQL and NoSQL, their advantages, and a few major difference between sql and nosql.
Materialized View in SQL MEDIUM
SQL views and materialized views are two powerful tools that help manage and retrieve data effectively.
Savepoint in SQL EASY
In this blog, we will learn about Savepoint in SQL. We will understand its core concepts, its usage, and much more for better understanding.
cte in sql server EASY
A Common Table Expression, abbreviated as CTE, is a named temporary result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement.
SQL vs Pandas EASY
In this article, we will learn about the difference between SQL and Pandas.
Operations on Table in Cassandra EASY
Apache Cassandra, better known as Cassandra, is a scalable NoSQL database. It is a column-oriented database providing high availability without any failure.
Author Nitika
0 upvotes
Data Independence in DBMS EASY
In this post, wet will cover the concept of Data Independence. With the assistance of various examples, we will learn about the ACID properties, what they stand for, and what each property is used for.
Understanding NVL Function in SQL MEDIUM
In this article, we will discuss an NVL function in SQL. We Will also discuss use cases, other functions similar to NVL, etc.
SQL vs MYSQL
In this blog, we'll define SQL and MySQL, as well as investigate the distinctions between them, also we will discuss relational databases.
Data Manipulation Language EASY
This article will cover the data manipulation language in SQL. This will also cover the different types of DML commands and importance of it.
Author Shiva
0 upvotes
Difference Between JOIN and UNION in SQL MEDIUM
In this article, we will learn about the difference between UNION and JOIN in SQL. We will also see an example of union and join operations.
Author jay_03
0 upvotes
Difference between File System and DBMS EASY
Learn what is file system and DBMS. In this article will also cover the key differences between file system vs dbms.
Difference between UNION and UNION ALL EASY
Difference between UNION and UNION ALL in SQL: In SQL, both UNION and UNION ALL are employed for fetching data from multiple tables. The UNION operation retrieves unique records from each table, whereas UNION ALL includes all records from both tables.
Difference between GROUP BY and ORDER BY EASY
The ORDER BY clause sorts the data in ascending or descending order. Whereas the GROUP BY clause groups the tuples(rows) based on the similarities of columns.
Difference Between DELETE and TRUNCATE EASY
In this article, we will discuss about the difference between DELETE and TRUNCATE statements, their syntax, properties, and usage.
Difference between DELETE, DROP and TRUNCATE EASY
In SQL, the DROP command removes a table from the database, DELETE removes records from a table, and TRUNCATE removes all rows from a table.
Difference between Oracle and SQL Server
In this article, we will discuss the difference between Oracle and SQL Server in detail.
MySQL vs PostgreSQL
In this article, we will learn about MySQL and PostgreSQL and the usage of both of these databases. Also, we will learn about the major differences between these two databases.
What is PARTITION BY in SQL? EASY
PARTITION BY is a clause in SQL that is used to divide a result into partitions for the computations. It has analytical functions such as RANK(), DENSE_RANK(), and ROW_RANK().
Understanding the Difference Between PostgreSQL vs MSSQL Server
In this article, we will discuss the difference between PostgreSQL and MSSQL server.
A guide to TimescaleDB
This blog explains the details of TimescaleDB in which we talk about when we use timescaleDB, its architecture and installing Timescale cloud.

MySQL

In MySQL, we will be introducing what it is and how to install it. As in DBMS, MYSQL is one of the most popular platforms to implement SQL databases, we will be explaining its features and other such things in detail and with examples. In this, we will explain different data types such as integer, varchar, strings, etc, and their notations in MYSQL. There are other data types such as date and time, numeric. One by one we will look into all of the different data types and how we can represent them in MYSQL. Then we will take up variables and with the help of examples depict how in MYSQL we can write them. Later, how to connect databases in MySQL? We will show to create, drop and account manipulation such as changing the password, lock user account and unlock a user account, providing the grants, revoking and manging the roles. We will also learn how to backup and restore MySQL.
10 Best SQL Books for Beginners & Advanced
Author
0 upvotes
Difference Between Mariadb and Mysql
Author
0 upvotes
MySQL Introduction
In this post, we will learn what MySQL is and why it is utilized. Benefits and features such as data security, high availability, and cloud service will be discussed.
MySQL Installation
We will learn how to install and configure MySQL in this tutorial. MySQL may be installed in a variety of methods. We'll use the MySQL installer to install MySQL in the easiest way possible.
Create Schema MySQL EASY
In this blog, we will learn about Create Schema MySQL. We will learn how to use schema in MySQL.
Author Rashmi
0 upvotes
MySQL Features
This article discusses the main MySQL features that are needed to know to every MySQL user.
Author Alisha
0 upvotes
MySQL Data Types
 In this article, we are going to learn about the data types involved in the MySQL database, and also we are going to learn about their properties.
MySQL ERROR 1819
In this blog, we will learn about MySQL error 1819. We will further in the blog learn about the password policies in mysql.
mul mean in mysql EASY
In this blog, we will learn about mul mean in mysql. We will also create table and write queries for better understanding.
Mysql Create Database EASY
In this blog, we will learn about Mysql Create Database. We will how to create a database in MySQL command line and MySQL workbench.
MySQL TRIM() Function EASY
In this blog, we will learn about MySQL TRIM() Function. We will explore how to use syntax and apply the trim() function in our table.
MySQL STR_TO_DATE() Function EASY
In this blog we will learn about MySQL STR_TO_DATE() Function. We will also create table and write queries for better understanding.
MySQL UNIX_TIMESTAMP() Function EASY
This article will discuss MySQL UNIX_TIMESTAMP() Function with examples and detailed explanations.
MySQL UNIX TIMESTAMP Function
This article will discuss MySQL UNIX_TIMESTAMP() Function with examples and detailed explanations.
Correlated Subquery MEDIUM
A correlated subquery is a subquery that uses values from the outer query to complete its execution.
MySQL CONCAT() Function EASY
This article covers the concept of MySQL CONCAT() function along with its implementation.
Collation In MySQL EASY
In this article, we will learn about collations in MySQL and how to set it at different levels.
MySQL ROWCOUNT EASY
In this blog, we will discuss finding the total number of rows present in a specific table.
Alter Command in Mysql EASY
In this blog, we will learn about Alter Command in Mysql. We will understand its core concepts, its usage, and much more for better understanding.
MySQL Variables
In this blog, we are going to learn about the three types of MySQL variables. Also, we would be learning about their properties and uses with examples.
Rollup MySQL MEDIUM
This article will provide a comprehensive guide to Rollup MySQL and explain its syntax, usage scenarios, performance considerations and limitations.
MySQL ORDER BY Keyword EASY
In this blog, we will discuss how to use MySQL ORDER BY Keyword, including the ways to use it in MySQL.
Primary Key in MySQL EASY
In this blog, we will learn about Primary Key in MySQL. We will also create a table using primary key in mysql.
FLUSH PRIVILEGES Statement in MySQL EASY
This article will discuss the FLUSH PRIVILEGES Statement in MySQL in detail.
MINUTE(), MICROSECOND() and HOUR() Functions in MySQL EASY
In this blog, we will learn about MINUTE(), MICROSECOND(), and HOUR() functions in MySQL. We will also understand its syntax with the help of some examples.
How to Change Time Zone on MySQL Server? EASY
In this article, we will check out different ways to change the time zone on MySQL Server along with some faqs
What is View in SQL EASY
In this blog, we will discuss what is View in SQL, including its usage, creating and updating them with its advantages.
Update Query in MySQL EASY
This article will discuss update query in MySQL with the help of examples.
MySQL Connection
 In this blog, we are going to learn various methods using which a user can establish a connection with the database server.
SQL Month() Function EASY
In this blog, we will learn about sql month() function. We will also explore and learn about this function through tables and query.
Second Highest Salary in SQL MEDIUM
In this blog, we will learn about Second Highest Salary in SQL. We will understand its core concepts, its usage, and much more for better understanding.
MySQL Cursor EASY
This article discusses MySQL cursor, its usage, and steps to use MySQL cursor, along with examples.
What is a Delimiter In MySQL MEDIUM
In this blog, we will discuss delimiter in MySQL. We also will cover its examples, along with its advantages and disadvantages.
MySQL Backup And Restore
You'll learn to use the MySQL tool to restore a SQL dump file and back up one or more databases in a MySQL Server using the mysqldump command.
MySQL: Case Statement EASY
In this article, we will learn about the MySQL case statement. We will discuss the topics like loops in MySQL, why we need a Case when we have a where clause, Where we can use a case statement, and how to use a case statement.
MySQL vs Oracle EASY
This blog will discuss MySQL vs. Oracle with a detailed explanation of both MySQL and Oracle along with their differences and some frequently asked questions.
MySQL vs MS SQL
This blog will discuss MySQL vs MS SQL with a detailed explanation of both MySQL and MS SQL along with their differences and some frequently asked questions.
MySQL vs. SQLite
This article will learn about MySQL and SQLite and compare the differences between MySQL and SQLite, also showing different features of each.
Author Arya27
0 upvotes

Microsoft SQL

Microsoft SQL Server is a relational database management system that Microsoft has created. It is a database server, which is a software product whose principal role is to store and retrieve data as required by other software programs, which may operate on the same computer or on a networked computer (including the Internet). Microsoft SQL Server is available in at least a dozen distinct versions, each aimed at a particular audience and designed for varied workloads ranging from simple single-machine applications to huge Internet-facing systems with many concurrent users.
How to install the Microsoft SQL server?
This article walks you through installing Microsoft SQL Server on Windows step-by-step. Additionally, we'll demonstrate how to set up Microsoft SQL Server Management Studio.
Architecture of Microsoft SQL
This article will discuss the architecture of Microsoft SQL and its key elements.
What is Microsoft SQL Management Studio?
In this article, we have discussed Microsoft Server SQL Management Studio(SSMS). We have also discussed the components and benefits of SSMS.
SQL Server Basics
In this blog, We will see the basics of SQL Server
Views in SQL Server
This article will teach you about views in SQL Server, which are essentially virtual tables in SQL. and the different kinds of views, as well as how to make views.
SQL Server Indexes
Our purpose in this article is to learn about SQL Server Indexes and the benefits associated with using them. We will also learn about its different types.
Sql Server Stored Procedures
Our purpose in this article is to demonstrate how to create SQL server stored procedures using different examples.
SQL Server User-Defined Functions MEDIUM
In this tutorial, we learn about SQL Server User-Defined Functions and their different types.
MS SQL Server Triggers MEDIUM
In this article, we will discuss Microsoft SQL Server Triggers, in detail.
SQL Server Aggregate Functions
This blog will discuss SQL server date functions.
SQL Server Date Functions
This blog will discuss SQL server date functions and what are the various functions that can be used to display them.
MS SQL Server String Functions EASY
This blog will discuss MS SQL server string functions.
MS SQL Server System Function
In this blog, we will learn about System functions in MS SQL Server and the different in-built system functions provided by MS SQL.
MS SQL Server Window Functions EASY
This article will discuss the topic of MS SQL server window functions in detail, along with some of its functionality.
Creating Users on Microsoft SQL Server
This article will teach us how to create a new user on MS SQL Server using two different methods.
To Assign Permissions to the Microsoft SQL Server
This article will explain different methods to assign permissions to the Microsoft SQL Server.
Monitor Databases in Microsoft SQL Server
In this article, we will discuss how to monitor databases in the Microsoft SQL Server. We will also discuss the benefits of Monitoring Databases and some common mistakes during monitoring.
Services of Microsoft Database SQL Server
In this article, we are going to discuss the services of Microsoft Database SQL Server.
HA technologies- Microsoft SQL
In this article, we will discuss HA Technologies of Microsoft SQL, in detail.
Integration Services in Microsoft Services
In this article, we will discuss integration services in Microsoft services.
Analysis Services in Microsoft SQL server
In this article, we will discuss Analysis Services in Microsoft SQL Server, in detail.

PostgreSQL

PostgreSQL is an open-source object-relational database system that focuses on flexibility and SQL compliance. Transactions with Atomicity, Consistency, Isolation, and Durability (ACID) qualities, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures are all available in PostgreSQL. It can manage a wide range of workloads, from single computers to data warehouses or Web services with a large number of concurrent users. It's the default database for macOS Server, as well as Windows, Linux, FreeBSD, and OpenBSD.
PostgreSQL - Data types
This article will cover different data types present in PostgreSQL.
PostgreSQL Create Database
This article includes how to create databases in PostgreSQL along with examples.
PostgreSQL Drop Database
This article includes how to drop databases in PostgreSQL along with examples.
Getting started with Postgresql
In this article, we have discussed the Postgresql database.
Postgresql Coalesce MEDIUM
In this blog, we will be discussing about postgresql coalesce with examples.
Elasticsearch vs Postgresql EASY
This article will present a comparative study of these two technologies, shedding light on their features, strengths, and potential applications.
PostgreSQL Tutorial EASY
This article will help you learn about PostgreSQL Tutorial, its installation, its features, and how PostgreSQL differs from SQL.
Explain the Architecture Fundamentals in PostgreSQL
In this article, we will learn about the architecture fundamentals of PostgreSQL. Also, we will see how to create and access a database in brief.
Author Rashi
0 upvotes
More on Window Functions with PostgreSQL EASY
This blog explains the details of Window Functions with PostgreSQL.
Concept of Inheritance with PostgreSQL EASY
  This blog explains the Concept of Inheritance with PostgreSQL.
Select where group by order by in postgresql EASY
This article will discuss where, group by and order by in PostgreSQL.
Conditionals and Control Flow in PostgreSQL EASY
This blog explains the details of Conditionals and Control Flow in PostgreSQL.
What are Dollar Quoted String Constants and Block Structure in Postgresql? EASY
In this article, we will learn what dollar-quoted string constants and block structures are in Postgresql.
How to Create Stored Procedures In PostgreSQL?
In this article, we will learn about stored procedures in PostgreSQL and how to create them using some examples.
Working With Triggers In PostgreSQL MEDIUM
In this article, we are going to understand triggers in PostgreSQL. We will learn to create and use triggers with examples.
Working With Views And Indexes In PostgreSQL MEDIUM
This article will discuss views and indexes in PostgreSQL. We will understand the syntax as well as the various components of indexes.
Error Handling in Postgresql EASY
This article discusses Error Handling in Postgresql, along with numerous examples. It also discusses various types of exceptions and how to handle them in PostgreSQL.
Author Alisha
0 upvotes