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.
SQL vs MYSQL
By Divyansh Jain
● Published At Mar 2022
In this blog, we'll define SQL and MySQL, as well as investigate the distinctions between them, also we will discuss relational databases.... Keep reading ..
MySQL vs PostgreSQL
By Divyansh Jain
● Published At Mar 2022
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.... Keep reading ..
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.
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,
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 ex
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 My
MySQL Introduction
By Sanjana Yadav
● Published At Jan 2022
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. ... Keep reading ..
MySQL Installation
By Sanjana Yadav
● Published At Jan 2022
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. ... Keep reading ..
MySQL Features
By Alisha Chhabra
● Published At Mar 2022
This article discusses the main MySQL features that are needed to know to every MySQL user. ... Keep reading ..
MySQL Data Types
By Divyansh Jain
● Published At Mar 2022
 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.... Keep reading ..
MySQL Variables
By Divyansh Jain
● Published At Mar 2022
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.... Keep reading ..
MySQL Connection
By Divyansh Jain
● Published At Mar 2022
 In this blog, we are going to learn various methods using which a user can establish a connection with the database server.... Keep reading ..
MySQL Backup And Restore
By Ankit Kumar
● Published At Mar 2022
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.... Keep reading ..
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
By PRASHANT SINGH
● Published At Jan 2022
This blog covers the introduction of Oracle Database. This blog introduces the Oracle database's advantages (or features) and disadvantages.... Keep reading ..
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.
Microsoft SQL
By Ankit Kumar
● Published At Jan 2022
This article will discuss a particular SQL server developed by Microsoft. It will be followed by some of the FAQs related to the topic... Keep reading ..
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
By Pakhi Garg
● Published At Mar 2022
This article will cover different data types present in PostgreSQL.... Keep reading ..
PostgreSQL Create Database
By Pakhi Garg
● Published At Feb 2022
This article includes how to create databases in PostgreSQL along with examples.... Keep reading ..
PostgreSQL Drop Database
By Pakhi Garg
● Published At Mar 2022
This article includes how to drop databases in PostgreSQL along with examples.... Keep reading ..