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.

Author Urwashi27

0 upvotes

What Is MYSQLDUMP?

In this blog, we will learn about MySQL dump. We will also how to use MySQL dump and MYSQLDUMP in Action. .

Author Harsh Singh

0 upvotes

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.

0 upvotes

MySQL REGEXP operator EASY

In this blog, we will learn about the MySQL regex operator.

Author Rahul Singh

0 upvotes

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.

Author Gunjan Batra

0 upvotes

Materialized View in SQL MEDIUM

SQL views and materialized views are two powerful tools that help manage and retrieve data effectively.

Author Riya Singh

0 upvotes

MERGE Statement in SQL EASY

In this article, we will discuss the MERGE statement in detail, understanding its syntax, usage, & important points to keep in mind while working with it.

Author Ravi Khorwal

0 upvotes

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.

Author Sanjana kumari

0 upvotes

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.

Author Pallavi singh

0 upvotes

SQL vs Pandas EASY

In this article, we will learn about the difference between SQL and Pandas.

Author Sinki Kumari

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.

Author Ravi Khorwal

0 upvotes

In this blog, we'll define SQL and MySQL, as well as investigate the distinctions between them, also we will discuss relational databases.

Author Divyansh Jain

0 upvotes

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.

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.

Author Akshay Parashar

0 upvotes

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.

Author 3053_Jatin

1 upvote

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.

Author shruti_f97c

1 upvote

Difference between Oracle and SQL Server

In this article, we will discuss the difference between Oracle and SQL Server in detail.

Author pranjal pratyush

0 upvotes

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.

Author Divyansh Jain

0 upvotes

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().

Author lakshayhere

0 upvotes

Understanding the Difference Between PostgreSQL vs MSSQL Server

In this article, we will discuss the difference between PostgreSQL and MSSQL server.

Author Urwashi27

0 upvotes

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.

Author Kumari Chandni

1 upvote

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

0 upvotes

Difference Between Mariadb and Mysql

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.

Author Sanjana Yadav

1 upvote

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.

Author Sanjana Yadav

0 upvotes

Create Schema MySQL EASY

In this blog, we will learn about Create Schema MySQL. We will learn how to use schema in MySQL.

0 upvotes

This article discusses the main MySQL features that are needed to know to every MySQL user.

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.

Author Divyansh_4bb5

0 upvotes

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.

Author Gunjan Batra

0 upvotes

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.

Author Gunjan Batra

0 upvotes

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.

Author Rahul Singh

0 upvotes

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.

Author Pallavi singh

0 upvotes

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.

Author Gunjan Batra

0 upvotes

MySQL UNIX_TIMESTAMP() Function EASY

This article will discuss MySQL UNIX_TIMESTAMP() Function with examples and detailed explanations.

Author yuvatimankar

0 upvotes

MySQL UNIX TIMESTAMP Function

This article will discuss MySQL UNIX_TIMESTAMP() Function with examples and detailed explanations.

Author Akshay Parashar

0 upvotes

Correlated Subquery MEDIUM

A correlated subquery is a subquery that uses values from the outer query to complete its execution.

Author Rinki Deka

0 upvotes

MySQL CONCAT() Function EASY

This article covers the concept of MySQL CONCAT() function along with its implementation.

Author 3053_Jatin

0 upvotes

Collation In MySQL EASY

In this article, we will learn about collations in MySQL and how to set it at different levels.

Author Gazal Arora

0 upvotes

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.

Author Gaurav Gandhi

0 upvotes

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.

Author Divyansh_4bb5

0 upvotes

Rollup MySQL MEDIUM

This article will provide a comprehensive guide to Rollup MySQL and explain its syntax, usage scenarios, performance considerations and limitations.

Author yesdhruv

0 upvotes

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.

Author Gunjan Batra

0 upvotes

FLUSH PRIVILEGES Statement in MySQL EASY

This article will discuss the FLUSH PRIVILEGES Statement in MySQL in detail.

Author yuvatimankar

0 upvotes

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.

Author kanishk11

0 upvotes

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

Author yesdhruv

0 upvotes

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.

Author Aditya Gupta

1 upvote

Update Query in MySQL EASY

This article will discuss update query in MySQL with the help of examples.

Author yuvatimankar

0 upvotes

MySQL Connection

In this blog, we are going to learn various methods using which a user can establish a connection with the database server.

Author Divyansh_4bb5

0 upvotes

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.

Author Gunjan Batra

0 upvotes

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.

Author Ravi Khorwal

0 upvotes

MySQL Cursor EASY

This article discusses MySQL cursor, its usage, and steps to use MySQL cursor, along with examples.

Author Aditya Gupta

0 upvotes

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.

Author Ankit Kumar

1 upvote

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.

Author Shubham Agarwal

0 upvotes

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.

Author Aayush Sharma

0 upvotes

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.

0 upvotes

User User explains basic functions that the user performs or seeks on MySQL. These functions are explained under user. The functions such as Create, drop, and show. These three functions are used to create, drop and show the tables, and databases. Other such functions such as account manipulation which involved how to change the password and unlocking the account. It also includes how to provide certain privileges to the user which includes grants, revoke, and how to manage the roles. These features are explained in-depth with examples.

Fulltext Search Just as the name suggests, this includes the search, types of search, and how to achieve them. In MySQL, there may be MySQL full-text search. It is explained how can we do it. Full-Text search covers other topics such as Natural language Fulltext search and boolean Fulltext search. It introduces other full-text searches such as query expansion and Ngram full-text search. The full-text search introduces these searches as well as explains what it is and how to do them.

Miscellaneous With the name, it covers all the topics that are miscellaneous yet important to cover and are part of Mysql. Such topics are how to add comments in MySQL. Not everywhere we can use Hash and c-comments. Other such topics are check constraint, storage engine and how to export and import the database or import the CSV file into the database or export a table to CSV, Universal Unique Identifier (UUID), lead and lag functions, and Common Table Expression (CTE)

Oracle

Oracle Database is the first database built for corporate grid computing, the most versatile and cost-effective method of managing data and applications. An RDBMS is Oracle Database. An object-relational database management system is an RDBMS that incorporates object-oriented features including user-defined types, inheritance, and polymorphism (ORDBMS). There are logical and physical structures in the database. Because the physical and logical structures are distinct, physical data storage may be controlled without influencing logical storage structure access.

Oracle Database Introduction

This blog covers the introduction of Oracle Database. This blog introduces the Oracle database's advantages (or features) and disadvantages.

Author PRASHANT SINGH

3 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.

Author Palak Mishra

1 upvote

Architecture of Microsoft SQL

This article will discuss the architecture of Microsoft SQL and its key elements.

Author Neha Singh

1 upvote

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.

Author Avinash Pandey

0 upvotes

SQL Server Basics

In this blog, We will see the basics of SQL Server

Author Siddhant_007

0 upvotes

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.

Author Palak Mishra

0 upvotes

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.

Author vishal teotia

0 upvotes

Sql Server Stored Procedures

Our purpose in this article is to demonstrate how to create SQL server stored procedures using different examples.

Author vishal teotia

0 upvotes

SQL Server User-Defined Functions MEDIUM

In this tutorial, we learn about SQL Server User-Defined Functions and their different types.

Author vishal teotia

0 upvotes

MS SQL Server Triggers MEDIUM

In this article, we will discuss Microsoft SQL Server Triggers, in detail.

Author Rupal Saluja

0 upvotes

SQL Server Aggregate Functions

This blog will discuss SQL server date functions.

Author Siddhant_007

0 upvotes

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.

Author Adya_Tiwari

0 upvotes

MS SQL Server String Functions EASY

This blog will discuss MS SQL server string functions.

Author Upendra Prasad Mahto

0 upvotes

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.

0 upvotes

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.

Author Sagar Mishra

2 upvotes

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.

Author Sagar Mishra

0 upvotes

To Assign Permissions to the Microsoft SQL Server

This article will explain different methods to assign permissions to the Microsoft SQL Server.

Author Sagar Mishra

1 upvote

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.

Author Alankrit Srivastava

1 upvote

Services of Microsoft Database SQL Server

In this article, we are going to discuss the services of Microsoft Database SQL Server.

Author Alankrit Srivastava

0 upvotes

HA technologies- Microsoft SQL

In this article, we will discuss HA Technologies of Microsoft SQL, in detail.

Author Rupal Saluja

0 upvotes

Integration Services in Microsoft Services

In this article, we will discuss integration services in Microsoft services.

Author Alankrit Srivastava

0 upvotes

Analysis Services in Microsoft SQL server

In this article, we will discuss Analysis Services in Microsoft SQL Server, in detail.

Author Rupal Saluja

0 upvotes

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.

Author Pakhi Garg

0 upvotes

PostgreSQL Create Database

This article includes how to create databases in PostgreSQL along with examples.

Author Pakhi Garg

0 upvotes

PostgreSQL Drop Database

This article includes how to drop databases in PostgreSQL along with examples.

Author Pakhi Garg

0 upvotes

Getting started with Postgresql

In this article, we have discussed the Postgresql database.

Author Tarnxxvr

0 upvotes

Postgresql Coalesce MEDIUM

In this blog, we will be discussing about postgresql coalesce with examples.

Author Ravi Khorwal

0 upvotes

Elasticsearch vs Postgresql EASY

This article will present a comparative study of these two technologies, shedding light on their features, strengths, and potential applications.

Author Nikunj Goel

0 upvotes

PostgreSQL Tutorial EASY

This article will help you learn about PostgreSQL Tutorial, its installation, its features, and how PostgreSQL differs from SQL.

Author Muskan Sharma

0 upvotes

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.

0 upvotes

More on Window Functions with PostgreSQL EASY

This blog explains the details of Window Functions with PostgreSQL.

Author kittusinghkumar

0 upvotes

Concept of Inheritance with PostgreSQL EASY

This blog explains the Concept of Inheritance with PostgreSQL.

Author kittusinghkumar

0 upvotes

Select where group by order by in postgresql EASY

This article will discuss where, group by and order by in PostgreSQL.

Author Urwashi27

0 upvotes

Conditionals and Control Flow in PostgreSQL EASY

This blog explains the details of Conditionals and Control Flow in PostgreSQL.

Author kittusinghkumar

0 upvotes

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.

Author Nidhi Kumari

1 upvote

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.

0 upvotes