Common Oracle Errors

In this article we will try to briefly describe some of the common errors in Oracle. ORA-12154: TNS: could not resolve specified connect identifier This is one of the common errors in Oracle Server which means that it is not possible to communicate with the server. The main reason is the server connection definitions, which makes Oracle unable to understand the service name and addresses. To resolve this problem, check the definitions for communicating in the tnsname.ora file and the words and parentheses (generally syntaxes). The addresses and ports of the server…

Read More

MySQL Tutorial – Part 5 – Nested Tables – Foreign Key in MySQL

MySQL Tutorial – Part 5 – Nested Tables with Foreign Key As mentioned in the previous lessons, building optimal tables is very important in database design. Nested tables are very effective in reducing database size. For this reason, in this talk we will teach you how to build a foreign key in MySQL.     Nested Tables Definition In the example in Lesson 2 we created the following two tables to store information about our friends.   Row name last name Age Date of birth Profile code 1 Tofique Ahmed Soomro 40…

Read More

MySQL Tutorial – Part Four – Flags in MySQL

In this lesson we are going to talk about Flags in MySQL. In the previous lesson we learned how to add a table to the database. If you remember when creating the tables in the section below, check the expressions PK, NN and UQ as shown.     Now, because of the importance of this section, we will briefly explain the functional flags.   PK – Primary Key When you create a table you must define a key for each row of the database. This means that we render each database row with…

Read More

MySQL Tutorial – Part Three – MySQL Workbench

Creating a Table in MySQL Workbench In this lesson, we are going to build our first database table with the MySQL Workbench tool. First we need to create our new schema in MySQL. To practice the tables we will build the previous lesson together.   Open MySQL Workbench To open the program go to the Start menu in your Windows and click the MySQL Workbench option in the MySQL folder. You can also open the program by going to the Notification Area in your Windows by clicking on the MySQL form like…

Read More

MySQL Tutorial – Part Two – Schema and Table

In this section of MySQL tutorial we will briefly introduce Tables. In general, each database consists of structures called Schema. Schemes have different sizes and sections on which different processes or views can be defined. MySQL tutorial MySQL Tutorial – Part 1 – Installation MySQL Tutorial – Part 2 – Schema and Table MySQL Tutorial – Part 3 – MySQL Workbench MySQL Tutorial – Part 4 – Flags in MySQL MySQL Tutorial – Part 5 – Nested Tables with Foreign Key Each Schema can have different tables or tables to store information.…

Read More

MySQL Tutorial – Part 1 – Installation

Data storage, processing and easy use of information stored in the computer world is of paramount importance. Today, the use of RDBMS (Relational Database System) has become an integral part of the software world. So we’re trying to get stronger and tighter by training MySQL and installing it in the software world. You must first download the latest version of MySQL Installer from http://dev.mysql.com/downloads/installer/ . Note that this Setup page is listed either as an online installation called “mysql-installer-web-community.msi” or as an Offline installation called “mysql-installer-community.msi”, We recommend downloading the second file because it is…

Read More

Insert and delete instructions on SQL Server

 Today we intend to familiarize you with Insert and Delete on SQL server. Sql server commands You know that the database is purely for storing data on the server and in order to be able to store and then manage the data you need commands like insert, delete and so on. You can manage In future sessions you will learn more from the SQL server Insert command in SQL server The insert in the SQL server is simply used to insert a record into a table. Each database has multiple tables created by the database…

Read More

Compare In-Memory Technology in Oracle, IBM and SQL Server – Part Three (Final)

By increasing the amount of data as well as the need for faster processing, database providers also have capabilities in their products. The In-Memory feature is one of these, and in the first and second parts of this series, we compared In-Memory to SQL Server and Oracle. In this article, which is the third part (final), we will examine this technology in IBM DB2 10.5 and compare it with SQL Server. Data Analysis with BLU Acceleration in IBM DB2 10.5 The IBM DB2 BLU Acceleration feature is available as an integrated In-Memory integration solution with IBM DB2 10.5 . This solution has several optimization processes, but…

Read More

Comparing In-Memory Technology in Oracle, IBM and SQL Server – Part II

comparison of In-Memory technology in a variety of databases examined the technology in Oracle’s databases and also compared it with SQL Server. Here are some other features we’ll look at. In-Memory Columnstore feature in Oracle 12c Oracle Corporation offers In-Memory Columnstore technology as an optional add-on with Oracle Database 12c for users. If this option is enabled for tables or table spaces, Oracle generates a copy of the subset of the data in the caching format as columnar storage. Thus, database administrators can only select the In-Memory data, which is very important in operational terms, and accelerate the analysis…

Read More

Comparison of In-Memory technology in Oracle, IBM and SQL Server – Part I

Currently, some organizations provide in-memory databases for a wide range of activities. This paper examines In-Memory technology in Oracle and IBM and SQL. The concept of In-Memory technology in the Oracle database In-Memory technology in the Oracle database is considered as a new option for the Oracle 12c database. In fact, this technology is considered as an Add-On option for the Oracle 12c database, and allows the company to provide its main interface software as an in-memory database. Oracle Database In-Memory can run on all platforms running on Oracle 12c. Oracle needs a separate product such as Oracle…

Read More