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

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

Installing Oracle Database 11g Express

The first step in installing Oracle Database Express and download the latest version from Oracle’s website. Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) Larry Ellison and his two friends and former co-workers, Bob Miner and Ed Oates, started a consultancy called Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software. The name Oracle comes from the code-name of a CIA-funded project Ellison had worked on while formerly employed by Ampex.   Download Oracle Database 11g Accept License Agreement and Download…

Read More