How to build a database?

Question

What tools required? What necessary knowledge needed?

- do i need to sign up?
- pay money?
- or register for an account stuff etc..?

- sql, mysql, sql server etc..

Answer 1

Yes. You need lots of training, and a good amount of intelligence.



You list SQL stuff. That will be needed to administer any database. The design bit is the most difficult, though.

Answer 2

The microsoft site has some free courses you can take regarding SQL Server. Anything else you would need to buy although I think you can get MYSQL for free somewhere. You don't say what you will be using it for. With Access you can create a simple database that can be used to store information. You can get really complex with other databases such as Oracle, SQL Server etc. A simple database can be build with very little training but when you get into something complex that will have updates done via some type of front-end (forms, web forms etc.) you would need training.

Answer 3

MySQL and Postgresql are free downloads (MySQL like you to register before you download, but there is no money involved).



You can load either on Windows or Linux. I like both, my own personal prefference is Postgresql but I will recomend MySQL because it tends to be easier to get into for new users.



You would need one of the clients too such as Navicat (there is a version for MySQL and Postgresql). Navicat is the Bee's Knee's for administrating either, but it is charged for.



There are some very good free administrators available, from the mysql link below look at 'GUI Tools'.



Right something I always recommend, bookmark a link to the MySQL documentation, it is massive, but it is also very good. Work through it from the start, then after a time the remainder of the manual becomes your primary source of reference.



Even when working in Postgresql I flip through the MySQL manual, it is just suce a good reference for SQL.

Answer 4

You'll need MySQL installed on a server, and I'd recommend PHP with phpmyadmin (Helps you maintain the database much easier than plain MySQL). You can host a server off your home computer and run it, xamp will help you setup and configure everything. Otherwise you would need to pay for an online web host.

Answer 5

It depends on your preference as to the database engine (DBMS). If you're a beginner, no DBMS is going to have outstanding advantages over the other. Several DBMSs have free community or express editions.



I prefer SQL Server because it's easier for me to configure and use with Windows and .NET programming.



*Edited to add Oracle Express.

Answer 6

is your database for a website.





Most hosting will have mysql or phpmyadmin.



Were yo can create the database, and then just add the appropiate fields.





if you looking for free hosting loads of sites offer it with domain.

The best free hosting company on the internet



No other host offers all these features and services at no cost to you. Below are just some of the many things that come with your free hosting account.



ASP.NET, PHP, MySQL, CGI, Python, Perl, Website Builders, cPanel, Fantastico, Templates, Contests, Prizes, 4 years of experience...























100% free mp3's www.mp3-dash.com

Answer 7

howdy J, own residing house web page is an open-source (free and community pushed) language for coding dynamic web content. Dreamweaver has the potential to paintings in those languages (document->New->Dynamic web page->own residing house web page). own residing house web page is used for dynamic good factors although the purely proper web page structure and layout is done in HTML and CSS. as an get jointly, you would possibly want to write a information superhighway website in HTML that contains 10 or extra pages. In each and every of those pages there is an undemanding merchandise, which features a navigation bar or footer. rather of creating variations to the code on each and every web page you would possibly want to set the position on your HTML the position the nav is to 'call' the navigation or footer document. The code might want to be some thing like: "" without the rates. this may positioned regardless of code is placed on the document 'nav.own residing house web page' anyplace you prefer to positioned that line. MySQL is a database administration device. own residing house web page and MySQL are pronounced in tandem because they paintings properly in connecting to one yet another. own residing house web page can deliver and receive archives and MySQL can understand this and keep it. there are thousands of substances accessible on the web which could help you on your way. Oh, and also, receive wampServer and TortoiseSVN so that you may run a own residing house web page server on your community device.

Answer 8

Oracle Tutorials

http://oracletutorial.info/

Answer 9

Hey,

If you are searching for PHPmyadmin you can download it for free here http://j.mp/1no5DFZ

It's the best software of its kind.

Answer 10

If you're only just starting in MySQL then I would opt for doing it locally on your PC. I still use Xampp even today, for development - it's an excellent tool and free to use. More details can be found below.



Have fun! :-)

Answer 11

There are programs like Access that you can build data bases with. If you go to an electronic store that sells computers and programs and stuff, they can sell you stuff to download that program on your computer.