Bijay 
In this Oracle tutorial, we will learn how to use the datatype in oracle database 21c. Moreover, we will take a look at multiple tables where the Oracle data types, including character, NUMBER, DATE, binary (LOB, RAW, and LONG RAW), ROWID and UNROWID, and XML data types, will be briefly discussed. Oracle Database Datatypes are utilized … Read more >>
As part of this SQL Server tutorial, we will learn and understand how to use the SQL Server SELECT TOP 1 statement with the INNER JOIN clause. This will enable us to retrieve data from a table. Recently, I got an update from the client while working on the Country’s Geography project. The SQL Server … Read more >>
SQL Server is a powerful and widely-used relational database management system (RDBMS) that is used to store and manage data in a structured format. One of the most important operations that you can perform in an SQL Server is joining data from multiple tables. Joining tables allows you to combine data from multiple tables based … Read more >>
MariaDB is a powerful open-source relational database management system that is widely used in various applications. It is known for its stability, performance, and scalability, making it an ideal choice for data storage, management, and retrieval. However, as with any complex software, there can be issues that arise when working with MariaDB. One common issue … Read more >>
Adding a foreign key constraint to a table in MariaDB is a simple process that involves using the ALTER TABLE statement with the ADD FOREIGN KEY clause. In this MariaDB tutorial, we will explore the various options that you can use when adding a foreign key constraint to a table in MariaDB, such as the … Read more >>
In this MariaDB tutorial, we will discuss what compound primary keys are, how they differ from regular primary keys, and how to add and modify compound primary keys in MariaDB. We will also provide examples to illustrate each of these concepts. These topics are important for database administrators and developers who need to manage their … Read more >>
In this SQL Server tutorial, we will learn and understand how to use the SQL Server INNER JOIN clause on multiple tables. We have already discussed how to use the SQL Server Inner Join on 2 tables in SQL Server. However, there are many cases when we need to apply Inner join on more than … Read more >>
In MariaDB, the SHOW TABLES and SHOW TABLE STATUS statements are used to retrieve information about the tables in a database. The SHOW TABLES statement lists the names of the tables in a database, while the SHOW TABLE STATUS statement returns detailed information about the tables, such as the engine, row format, and data size. … Read more >>
In this MariaDB tutorial, we will understand how to add the indexes to the existing table to speed up the search of the records in the database. While I was searching for the detail of the customers in my database, it was very time-consuming because the table of the database wasn’t indexed properly or the … Read more >>
In this SQL Server tutorial, we will learn and understand how to use the SQL Server LEFT OUTER JOIN with the WHERE clause on tables by the query. Recently, I got a requirement to join multiple tables and even filter records based on the condition for the resultset in the SQL Server. So, I came … Read more >>
Download A 40 pages PDF And Learn Now.