It’s no secret that Oracle is the Rolls Royce of relational database management systems. It is the most popular and feature rich database platform on the planet. It just is. A casual internet search using DuckDuckGo (of course) will tell you that.
It’s also no secret that Oracle is relatively expensive to run and a challenge to manage and maintain. It just is. If that weren’t the case there wouldn’t be so much competition in the database market. That said, not every data storage and retrieval challenge needs a Rolls Royce solution. In this series, we’ll take a look at the next three most popular database management systems after Oracle. They being, in no specific order, SQL Server, PostgreSQL and MySQL.
If you’re an Oracle DBA and are suddenly faced with the prospect of administering these other database platforms, then this series is for you. We’ll cover my top 10 things you’ll likely need to know about these other databases. The table below will hopefully help you find what you need quickly. The links will be added as I find time to post the material:
|01. Installation||SQL Server||PostgreSQL||MySQL|
|02. Architecture||SQL Server||PostgreSQL||MySQL|
|03. Connectivity||SQL Server||PostgreSQL||MySQL|
|04. Create Databases||SQL Server||PostgreSQL||MySQL|
|05. Security||SQL Server||PostgreSQL||MySQL|
|06. Create Objects||SQL Server||PostgreSQL||MySQL|
|07. Backup & Recovery||SQL Server||PostgreSQL||MySQL|
|08. Data Dictionary||SQL Server||PostgreSQL||MySQL|
|09. Troubleshooting & Support||SQL Server||PostgreSQL||MySQL|
|10. Common DBA Tasks||SQL Server||PostgreSQL||MySQL|
Links to the specific database platforms:
You’re welcome! 😀