5 answers
2
Questions
Asked
551 views
As a Database Administrator, what software's do you recommend?
A Database Administrator uses safe and reliable software to ensure the companies data to be safe. But is there any specific software that someone with this profession would recommend?
#databaseadmin
#professional
Login to comment
5 answers
Updated
Suresh’s Answer
There are so many softwares for Database Administrator like Oracle, Mysql, MongoDB, MSSQL etc and each software has its own Admin tool and you need to pick which software you want to.
Good to have RDBMS knowledge so that you can grow you career.
Good to have RDBMS knowledge so that you can grow you career.
Updated
M’s Answer
There are tools for querying databases like TOAD, SQLDeveloper or DBeaver. Some support multiple different RDBMS (database engines). These use SQL for querying and manipulating the data.
There are also tools for managing a database e.g. taking backups. These tend to be quite specific to a product.
Oracle has free version you can try at https://www.oracle.com/database/technologies/appdev/xe.html
There are also tools for managing a database e.g. taking backups. These tend to be quite specific to a product.
Oracle has free version you can try at https://www.oracle.com/database/technologies/appdev/xe.html
Updated
Yehuda (Jeferson)’s Answer
If you are asking about the DataBase Engine (DBE), there are many options.
But let's start a little before this :)
First of all, DBE is by definition the underlying software component that a DataBase Management System (DBMS) uses to Create, Read, Update and Delete (CRUD) data from a database.
Most database management systems include their own application programming interface (API) that allows the user to interact with their underlying engine without going through the user interface of the DBMS.
But anyway, since we are talking about DB's, the bigger part of the global market, there are two different types of DB's that are adopted Relational and Non-Relational (aka big data) ones.
They can co-exist in the same company, or not. But this only depends on the IT Director Plan. and\or intention of usage \ purpose of the application connected to it.
I'm DBA for about 20 years, and I strongly recommend MS SQL Server, for some reasons:
1) MS SQL Server Relational Engine is Free for Developers, not to use on company final products;
2) It's easy to install, and start using, for non-commercial purposes;
3) The MS SQL Management Studio, the interface to the engine is also free for developers, and is very intuitive for first users;
4) * T-SQL it's **ANSI 92 International DB pattern compatible. And once you learn, can help to understand other DB’s;
5) Have a lot of additional services for free, like SSIS, SSAS, SSRS and a lot of integration options with other DB’s;
I can talk about it endlessly, let me know if you want to know more.
And recently Microsoft started with Big Data Cluster (BDC), a solution for Non-Relational DB’s, but on this, You’ll need a special environment.
https://docs.microsoft.com/en-us/sql/big-data-cluster/deploy-get-started?view=sql-server-ver15
There is a DBE ranking, just to see the trending and names:
Relational
https://db-engines.com/en/ranking/relational+dbms
Non-Relational
https://db-engines.com/en/ranking
*Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases. T-SQL expands on the SQL standard to include procedural programming, local variables, various support functions for string processing, data processing, mathematics, etc., and changes to the DELETE and UPDATE statements.
https://en.wikipedia.org/wiki/Transact-SQL
**ANSI 92 or SQL-92 was the third revision of the SQL database query language. Unlike SQL-89, it was a major revision of the standard. Aside from a few minor incompatibilities, the SQL-89 standard is forward-compatible with SQL-92.
SQL-92 was the third revision of the SQL database query language. Unlike SQL-89, it was a major revision of the standard. Aside from a few minor incompatibilities, the SQL-89 standard is forward-compatible with SQL-92.
https://en.wikipedia.org/wiki/SQL-92
SSIS - https://en.wikipedia.org/wiki/SQL_Server_Integration_Services
SSAS - https://en.wikipedia.org/wiki/Microsoft_Analysis_Services
SSRS - https://en.wikipedia.org/wiki/SQL_Server_Reporting_Services
You can download from:
https://www.microsoft.com/en-us/sql-server/sql-server-downloads
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
But let's start a little before this :)
First of all, DBE is by definition the underlying software component that a DataBase Management System (DBMS) uses to Create, Read, Update and Delete (CRUD) data from a database.
Most database management systems include their own application programming interface (API) that allows the user to interact with their underlying engine without going through the user interface of the DBMS.
But anyway, since we are talking about DB's, the bigger part of the global market, there are two different types of DB's that are adopted Relational and Non-Relational (aka big data) ones.
They can co-exist in the same company, or not. But this only depends on the IT Director Plan. and\or intention of usage \ purpose of the application connected to it.
I'm DBA for about 20 years, and I strongly recommend MS SQL Server, for some reasons:
1) MS SQL Server Relational Engine is Free for Developers, not to use on company final products;
2) It's easy to install, and start using, for non-commercial purposes;
3) The MS SQL Management Studio, the interface to the engine is also free for developers, and is very intuitive for first users;
4) * T-SQL it's **ANSI 92 International DB pattern compatible. And once you learn, can help to understand other DB’s;
5) Have a lot of additional services for free, like SSIS, SSAS, SSRS and a lot of integration options with other DB’s;
I can talk about it endlessly, let me know if you want to know more.
And recently Microsoft started with Big Data Cluster (BDC), a solution for Non-Relational DB’s, but on this, You’ll need a special environment.
https://docs.microsoft.com/en-us/sql/big-data-cluster/deploy-get-started?view=sql-server-ver15
There is a DBE ranking, just to see the trending and names:
Relational
https://db-engines.com/en/ranking/relational+dbms
Non-Relational
https://db-engines.com/en/ranking
*Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases. T-SQL expands on the SQL standard to include procedural programming, local variables, various support functions for string processing, data processing, mathematics, etc., and changes to the DELETE and UPDATE statements.
https://en.wikipedia.org/wiki/Transact-SQL
**ANSI 92 or SQL-92 was the third revision of the SQL database query language. Unlike SQL-89, it was a major revision of the standard. Aside from a few minor incompatibilities, the SQL-89 standard is forward-compatible with SQL-92.
SQL-92 was the third revision of the SQL database query language. Unlike SQL-89, it was a major revision of the standard. Aside from a few minor incompatibilities, the SQL-89 standard is forward-compatible with SQL-92.
https://en.wikipedia.org/wiki/SQL-92
SSIS - https://en.wikipedia.org/wiki/SQL_Server_Integration_Services
SSAS - https://en.wikipedia.org/wiki/Microsoft_Analysis_Services
SSRS - https://en.wikipedia.org/wiki/SQL_Server_Reporting_Services
You can download from:
https://www.microsoft.com/en-us/sql-server/sql-server-downloads
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
Updated
Sambhav’s Answer
For a database Administrators, There are multiple tools available in the Market for doing their jobs/ business done such as SQL Server, oracle, mysql, mongodb etc. Client tools are basically used to connect to these database for admin's mainly. Mostly these Databases are licensed for use. however, community editions available for few DB's can be used for learning purpose. Specific Database can be used based on the business use case and requirements. For beginners Learning RDMS concepts and DB's like SQL server, mysql is good one to go first and then expand further to other No SQL Db's like MongoDB etc.
Updated
Brijesh’s Answer
There are many databases available in the market. Most of databases are very secure and you can find the information on their website. Just like any software, the database vendors release patch upgrade to fix bugs, security issues (if any) on regular basis. They do release a thorough release notes with each upgrade. Here is what you can do to find out more information.This example is specific to Oracle database but the steps should be almost same for any vendor.
1. Go through the database documentation. For e.g. if you are looking for Oracle then visit https://docs.oracle.com/en/database/oracle/oracle-database/
2. You can refer to tool the company recommend. You can find this information on their website. Keep in mind there can be multiple software available in the market. In this case one of the tool can be SQL Developer. Here is the link: https://www.oracle.com/database/technologies/appdev/sqldeveloper-landing.html
3. You can also get the information on security patches or upgrades
In general I recommend "Oracle SQL Developer". This tool is free to use and supports open source databases and a lot of other JDBC databases.
I also like Toad for oracle database. Again, different tool supports different features so based on what database you use, the tool may vary.
I hope this is helpful.
1. Go through the database documentation. For e.g. if you are looking for Oracle then visit https://docs.oracle.com/en/database/oracle/oracle-database/
2. You can refer to tool the company recommend. You can find this information on their website. Keep in mind there can be multiple software available in the market. In this case one of the tool can be SQL Developer. Here is the link: https://www.oracle.com/database/technologies/appdev/sqldeveloper-landing.html
3. You can also get the information on security patches or upgrades
In general I recommend "Oracle SQL Developer". This tool is free to use and supports open source databases and a lot of other JDBC databases.
I also like Toad for oracle database. Again, different tool supports different features so based on what database you use, the tool may vary.
I hope this is helpful.