best database software to be familiar with

Why Do I Need Computer Skills on a Resume?.SQL and friends are really just annexes of Microsoft.Īs databases go, ‘Pick’ is Linux’s truest friend, and, as such, warrants at least some recognition if not promotion. (So, if you’re looking for a field where your structured, objective, collaborative programming skills will catapult you to the forefront, here’s a field that’s wide open.) (And the pay’s pretty good, too!) And it is so easy to program that most Pick ‘programmers’ are really little more than advanced users. Pick’s data-structures and file-system, while unusual, are simple to comprehend and use. You’d be surprised, I’m sure, to learn just how much of the world actually runs on one of the many flavours of Pick/Multi-value, and that because they have learned the hard way, rather than by the consensus of observers and mono-theists, what actually works best. Oracle best for mission-critical apps?! Another fine example of how consensus should not be taken for reality. Read more about MS SQL Server at wikipedia.If you are stuck in a company that heavily uses Microsoft products, you might end-up working on MS SQL Server. This is Microsoft’s flagship Database product. Work on most *nix flavors, Mac OS X, windows.Supports database of several TB in size.Complete database is stored in a single disk file.Zero configuration with no setup or admin tasks.Instead, it is a self-contained, server-less SQL database engine. SQLite does not work like a traditional client-server model with standalone process. Flashback Database, Query, Table and Transaction.Advance Queuing, XML DB, Support for Spatial data.Automatic Memory, Storage and Undo Management.Oracle has following four different editions of the database: 1) Enterprise Edition 2) Standard Edition 3) Standard Edition One 4) Express Editionįollowing are few key features of the oracle database. Oracle is the best database for any mission critical commercial application.

Read more about PostgreSQL at wikipedia.

MVCC – Multi-Version Concurrency Control.

This has full support for joins, views, triggers, stored procedures etc., It runs on most *nix flavours, Windows and Mac OS. PotgreSQL is a open source object-relational database system.

Read more about MySQL, Drizzle and MariaDB on Wikipedia.

Support for stored procedures, triggers, views etc.,.

Support for partitioning and replication.

MyISAM storage uses b-tree disk tables with index compression for high performance.

Best database software to be familiar with