Which Database Engine and to Work with Relational Database with the Environment we work in


Our today's topic of discussion is Database Engine and to Work with Relational Database with the Environment we work in, we are working in different environments we have, in our last discussion in the Post DBMS vs RDBMS or Database Management System Vs Relational Database Management System.

Let's start with some of the Database Engines mostly used today in different professional and learning environments.

List of Database Engines

1.       Oracle

2.       MySQL

3.       Microsoft SQL Server

4.       PostgreSQL

5.       MongoDB

6.       Microsoft Access

7.       Microsoft Azure SQL Database

These are some most commonly used and most listened know Databases name that we are aware with. Any how it is more important that to work with all database is not a professional go through. I suggest you to go with a database engine which is most relavent to your running envoirnemnt. It is more important.

With the above listed database engines, you must have a knowledge to know. So here in this script you can have some basic knowledge of the same.

Oracle

The official website of oracle is http://www.oracle.com/­databaseand a detail technical documentation can be found on https://docs.oracle.com/­en/­database. Hence oracle supports different development languages like

Programming Languages Support C,C#,C++,Clojure,Cobol,Delphi,Eiffel,Erlang,Fortran,Groovy,Haskell,Java,JavaScript,Lisp,Objective C,OCaml,Perl,PHP,Python,R,Ruby,Scala,Tcl,Visual Basic

MYSQL

Just l Oracle, MySQL is another famous and most used Database Engine among the industry some of the basic details are as under for your review.

Official Website www.mysql.com detail documentation details https://dev.mysql.com/­doc supporting programming Languages

Programming Languages Support

Ada,C,C#,C++,D,Delphi,Eiffel,Erlang,Haskell,Java,JavaScript (Node.js),Objective-C,OCaml,Perl,PHP,Python,Ruby,Scheme,Tcl

 Microsoft SQL Server

MS SQL Server is also a most famous and most used database engine in professional environments, SQL Server Management studio is the IDE to support multiple database Engines with MS SQL Server to create and work with the databases.

The Official Website of MS SQL Server is www.microsoft.com/­en-us/­sql-server a details and updated documentation details can be clicked on https://docs.microsoft.com/en-US/sql/sql-server/ . Multiple Programming Languages supports MS SQL Server with different versions.

Programming Languages Support

C#,C++,Delphi,Go,Java,JavaScript (Node.js),PHP,Python,R,Ruby,Visual Basic

 

So the concept behind writing the above script is, most of the users are not aware to the database engines and how they can use with their own to start development or administration with Databases.

Hope these above details explains some basic information related to the Database Engines. It will be clear and easy for you to use a one. I am using MS SQL Server with my professional work.