Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How can I start to create, delete, etc., a table in Fedora 13? How can I initiate to create a basic table in Linux, what are the commands? Will I have to install firstly a database like ORACLE in my Fedora environment or is it already installed?

share|improve this question
    
What's the end game? Are you learning about databases? Do you want to create some database-oriented software or do you have a specific application you want to use? –  Linker3000 Apr 26 '11 at 19:43

1 Answer 1

Operating Systems typically don't come with database server software pre-installed because each one meets different needs/requirements. The vast majority of database servers use SQL, and there is a wide range of choices both in commercial (e.g., Oracle, DB2, etc.) and free (e.g., open source, freeware, etc.) offerings.

For my projects, I find that PostgreSQL is an excellent SQL server that more than meets my needs, without wasting resources. It's free, and open source, and is fairly straight-forward to install in Linux and many other Operating Systems. I suggest you start with PostgreSQL if you don't have something else in mind:

enter image description here
  PostgreSQL
  http://www.postgresql.org/

Your first step will be to install a database engine (whichever one you choose, which may or may not be PostgreSQL depending on what meets your needs), then learn how to use its administration tools. The most basic tool is the "SQL command-line utility" which seems to be named differently by each project/vendor.

Once you learn the basics of the administration tools, you'll be able to create your tables (which will also require at least a basic understanding of the different data types so that you can design your database in a manner that will be useful to you).

The command you'll need to use, for which you'll want to refer to the documentation for the database you choose to use, is: CREATE TABLE

There are a variety of parameters, such as the name of the table, column [data] types, various constraints, and many other things. The documentation can be found here: http://www.postgresql.org/docs/9.0/interactive/sql-createtable.html

share|improve this answer
    
One shall not forget MySQL and SQLite too. –  grawity Apr 26 '11 at 21:41
    
@grawity: Thanks -- in particular, those two are very well-known and commonly used as well. There are so many excellent "better-than-commercial-grade" SQL servers to choose from in the world of open source software right now that I sometimes wonder how worried the commercial vendors really are about the future of their products. –  Randolf Richardson Apr 28 '11 at 14:39

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.