Free Java Support in SQL Server 2019

Java is one of the most important open source projects in the world today and was introduced almost 25 years ago with Microsoft SQL Server and has since been used by millions of developers around the world and is reportedly the most popular programming language. Became known in the world. SQL Server has a long history with Java, and even more recently the relationship between the two has deepened. It all started over 20 years ago, when early versions of the Java Database Connection Driver (JDBC) were released to enable Java…

Read More

What is NoSQL?

NoSQL comprises a vast array of different database technologies developed in response to the increasing – very fast – volume of data stored on users, objects and products, as well as the frequency of data access and implementation and processing needs. And. Relational databases, on the other hand, were not designed to meet the challenges of scale and agility that modern applications face, as well as to take advantage of the cheap storage and high processing power of today’s world. Dynamic Schema Communication databases require that you must be defined before…

Read More

What is SQL?

SQL stands for Structured Query Language is a built-in language for querying a database. With SQL, you can change the data you have in your database the way you want it to be retrieved if you want it to. To practice with SQL you need a database such as SQL – server and Access or Oracle or any other database. Although SQL is a language under the ANSI (American National Standards Institute) standard, each database uses its own version, so some commands in one database may be based on a version…

Read More

Compare PostgreSQL database with MySQL

In this article we will briefly compare Postgresql database with MySQL. These databases are widely used in open source applications or are used in web applications due to their low space and lightweight, and are also optimized for proprietary applications. The MySQL database is a bit faster but has fewer features, but Postgresql takes advantage of it, especially when used for open source applications. MySQL is more popular among developers for its speed and ease of use, but Postgresql is more convenient for developers working with oracle or Microsoft SQL and…

Read More

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