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.

I am a total databases noob, hence please be gentle.

I am looking for tutorials how to create a SQL table, how to start a SQL server, and what software to use on fedora. Would anyone share links to good tutorials?

Also, what software should I use to create SQL table and to start the server? I am on fedora 9.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

There are a few popular SQL database management systems shipped with Fedora. Here are some how-tos for the most popular:

MySQL: http://www.howtoforge.com/perfect-server-fedora9 (skip to the MySQL part)

PostgreSQL: http://www.cyberciti.biz/faq/howto-fedora-linux-install-postgresql-server/

After you have installed the software, you can create your databases manually using the shell (each database system ships with a set of commands which allow running SQL statements), or you can install a web-based tool. These show the structure of your databases graphically.

For MySQL: http://www.phpmyadmin.net/home_page/index.php

For PostgreSQL: http://phppgadmin.sourceforge.net/

I should also point out that in order to create a table you need to create database to contain it. Take a look at SQLzoo for a basic introduction into how it works.

share|improve this answer

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.