Database – Our Learning Journey

The Role of a Database Administrator: Key Responsibilities and Skills Needed for Success

As data becomes an invaluable asset for businesses, database administrators (DBAs) play a crucial role in managing, safeguarding, and optimizing data storage. If you’re considering a career as a DBA or are simply curious about what the job entails, this blog will give you an in-depth look at the responsibilities, required skills, and future prospects […]

The Role of a Database Administrator: Key Responsibilities and Skills Needed for Success Read More »

Overview of Microsoft SQL Server (MsSQL) Versions

Database, MSSQL

Microsoft SQL Server (MsSQL) is one of the most popular relational database management systems (RDBMS) used by organizations worldwide for storing, managing, and retrieving data. Over the years, Microsoft has released numerous versions of SQL Server, each introducing new features, improvements, and performance enhancements. Here’s a breakdown of some of the most notable MsSQL versions,

Overview of Microsoft SQL Server (MsSQL) Versions Read More »

What is database management system (DBMS)?

Database

A database management system (DBMS) is a software application that is used to create, maintain, and manage databases. A database is a collection of data that is organized in a specific way and is used to store and retrieve information efficiently. A DBMS is responsible for providing an interface for users and applications to access

What is database management system (DBMS)? Read More »

What is Transaction Control Language (TCL)?

Database

Transaction Control Language (TCL) is a syntax used in database management systems to manage transactions. A transaction is a unit of work that is performed in a database and consists of one or more SQL statements that are executed as a single unit. TCL statements are used to control the transaction process and ensure the

What is Transaction Control Language (TCL)? Read More »

What is Data Manipulation Language (DML)?

Database

In database management systems, Data Manipulation Language (DML) is a syntax used to insert, update, and delete data in a database. DML statements are used to manipulate the data stored in the database and do not affect the structure of the database itself. Some common examples of DML statements include: DML statements are commonly used

What is Data Manipulation Language (DML)? Read More »

About Data Definition Language (DDL)

Database

In database management systems, Data Definition Language (DDL) is a syntax used to create and modify database structures, such as tables and indices. DDL statements are used to define the database schema and are used to create, alter, and delete database objects. Some common examples of DDL statements include: DDL statements are often used by

About Data Definition Language (DDL) Read More »

About Oracle Database

Database, Oracle

Oracle Database is a database management system (DBMS) developed and distributed by Oracle Corporation. It is used to store, retrieve, and manage data in a structured format. Oracle Database is a powerful and feature-rich DBMS that is suitable for a wide variety of applications, including web-based applications, data warehousing, and business intelligence. It is known

About Oracle Database Read More »

MySQL Database

Database, MySQL

MySQL is a popular open-source database management system (DBMS) that is used to store, retrieve, and manage data in a structured format. It is developed, distributed, and supported by Oracle Corporation. MySQL is used to power a wide variety of applications, including web-based applications, data warehousing, and business intelligence. It is known for its reliability,

MySQL Database Read More »

Microsoft SQL Server

Database, MSSQL

Microsoft SQL Server is a database management system (DBMS) developed by Microsoft. It is a software product that is used to store, retrieve, and manage data in a structured format. SQL Server is a popular choice for managing data in a variety of settings, including small businesses, large enterprises, and government agencies. It is used

Microsoft SQL Server Read More »

Resolve Oracle 19 C installation INS-08101 Unexpected Error

Oracle

Encounter INS-08101 when I installed Oracle database 19c on CentOS Stream 8 We can uncomment the line containing the variable #CV_ASSUME_DISTID=OEL5 in the CVU configuration file.

Resolve Oracle 19 C installation INS-08101 Unexpected Error Read More »