Some Useful Database Links.

Darasen

Aug 7 2008, 04:49 AM

I thought I would take a moment to point the users here to some of the database resources available for reference and learning.

First I will start with actually designing the database. This site by R937 covers the basics of database design. The author is professional database guru and a frequent helper at the at DB forums listed below.

The Library of Free Data Models is an excellent resource for finding data models for projects you may have or as examples of well put together data models. With around 500 data models the chances are you find something at least close to what you may need.

Additionally I like This article on Database Design Mistakes.

On to the next step looking at some SQL help. As a side note I find it interesting, to say nothing of a bit telling, that it is easier to find SQL information than it is data modeling help. This is especially interesting given that SQL is designed around the principle of good DB design. I can not begin to tel you how many times I have people unable to make thier query work the way they needed because the the data model was goofy. So be certain you have a good design.

Please note that there are differnt "flavors" of SQL from various relational database management system (RDBMS) vendors. However, any RDBMS worth using accept standard SQL commands with out a problem.

W3 Schools is always a great place to look for any information or tutorial you need that anything to do with web technologies. Given that W3 schools is ran by the W3C you can oretty much consider data there to be cannon concerning web standards.

SQL Zoo has their "Gentle introduction to SQL" which, in truth, I can not recommend enough. IF you know nothing about SQL or simply want to learn more this is a great web site to visit. It features the ability to actually write and execute SQL queries on the website and see some of the differences between SQL implementations.

Need more SQL information? This site covers a lot of SQL syntax as well as offering tutorials on basic SQL and some more advanced SQL features such as sub queries.

Whith a name like SQL Course you probably have a good idea what to expect here.

Where to go when you need help! DB forums simply rocks. The people there are amazingly smart database professionals to say nothing of very helpful. There is one caveat. The people there will always help, they will not always simply do your thinking for you. Many of the users will point and guide in the right direction to let the person asking learn the answer instead of having of spoon fed to them. Also, if you have school work questions you want answered you will never be given a straight answer.

Hope some of these links help. I am not associated with any of these sites in any way (other than being a poster at dbforums) but, used these sites in the past. I hope they help you.

sparkx

Aug 7 2008, 04:07 PM

You have some nice links up there. You may want to add a link or to about installing MySQL but other then that this is a pretty good informational post. Personally I found MySQL fairly easy to learn because it is just English with syntax (I’m not sure of SQL is the same). I like the idea of DB forums because you don't need to go step by step just to tell someone something simple. But it sound like it is only for people that already have basic knowledge of SQL (because they guild you rather then telling you).

Thanks,
Sparkx

Side Notes: You may want to fix your title, at the moment it says "Databse".

TavoxPeru

Aug 10 2008, 08:38 AM

Thanks Darasen for the links, there are very useful, the first one is a must because it covers all the fundamental database theory in a very simple way that everybody would undestand and follow, also, this site under it's sql links section contains a lot of other useful links.

Another good one is The Library of Free Data Models, it helps me some time ago to develop a database for one of my clients.

sparkx at the MySql.com website you can find all information needed to correctly install it, but honestly, if you will install it on a windows machine you even don't need to visit the site, because the installation procedure of it is extremely easy.

Best regards,

#13

Aug 11 2008, 09:36 PM

Hey, I'd say that's pretty good advice.

Darasen

Aug 11 2008, 10:24 PM

I went into edit but did not see where I could edit the title. My pinky finger does not always respond like I want it to hence, the missing A. Thanks Carpal!

I did not put anything about installing MySQL or any specific RDBMS intentionally.

QUOTE

Personally I found MySQL fairly easy to learn because it is just English with syntax (I’m not sure of SQL is the same).

Sparkx, it sounds like you have SQL and RDBMS's a bit confused. SQL is an acronym for Structured Query Language. It is the language used to form queries to run on a database. SQL holds no data it simply is a means of defining data and manipulating data from a Relational Database Management System (RDBMS).

The RDBMS is the engine that actually holds the data and its relationships. MySQL is is an RDBMS, as is MS-SQL Server. Personally, I think there be a punishment for putting SQL in the name of a RDMS product. I have been to interviews where alleged professionals IT managers do not know the difference between SQL ans SQL server.

yordan

Aug 19 2008, 12:26 PM

QUOTE(Darasen @ Aug 12 2008, 12:24 AM)

I went into edit but did not see where I could edit the title. My pinky finger does not always respond like I want it to hence, the missing A.

No problem, I added the missing A.

Yordan

Arbitrary

Aug 23 2008, 05:10 AM

Those links are very nice ones, Darasen. I especially like the first three (the first one being most important), because they cover aspects that are extremely practical once you start working with databases. The second one is a nice reference if you happen to be teeter-tottering on the design of a database. You could consult the second one for some pointers, I guess.

In fact, I think some of the "gentle introductions to SQL" tend to miss the important aspects of relational database design. This then causes the person to mess up and create a poorly designed database. I've found that a lot of people don't take advantage (or understand) the actual "relational" part of relational databases because they stick to reading the simplified tutorials that neglect to explain the most important part of a RDB.

QUOTE

The RDBMS is the engine that actually holds the data and its relationships. MySQL is is an RDBMS, as is MS-SQL Server. Personally, I think there be a punishment for putting SQL in the name of a RDMS product. I have been to interviews where alleged professionals IT managers do not know the difference between SQL ans SQL server.

Hmm, I wouldn't say there's anything wrong with putting SQL in the product's name---the whole purpose of the product is to point out what it uses and does, and calling it blah-blah-blah-SQL is a descriptive way of summing things up. If someone gave it a random name, it may well be pointless.

At the same time, I will agree that SQL as syntax is very easy to learn--it is very similar to spoken English, except that it has a slightly modified style.

QUOTE

Well, installation isn't as bad as you think. The MySQL site is pretty clear at explaining how to install things, so if you follow the directions there, you should be fine. Moreover, if you wanted to simplify the process even more, you could just install WAMP (if you're on a windows machine), and that would take care of Apache, PHP, MySQL and PostgreSQL all for you. Quite nice, if you want it that way.

jlhaslip

Aug 24 2008, 02:04 PM

Not meaning to be critical, but this statement is not correct:

QUOTE

Given that W3 schools is ran by the W3C you can oretty much consider data there to be cannon concerning web standards.

The w3schools.com site is independent of the w3c. And is a fairly good site with lots of Beginner's tutorials and some advanced users in its Forums.

Recent Queries:-

useful database? - 55.17 hr back. (1)
using dblink to connect to rdb examples - 235.76 hr back. (1)
useful database - 317.90 hr back. (2)
oracle chain of dblinks - 549.58 hr back. (1)

Similar Topics

Keywords : Database Links

Free Or Opensource Database/schema Browser? - Alternatives to TOAD or PL/SQL Developer (6)
Best Database - (13)
What is the best free database if some one trying built a social networking website? And how to
operate it with dreamweaver 8?...

How To Understand A Database Schema - A very nice and simple tutorial (4)

Yesterday while i'm seaching for a data model and database schema at the Library of Free Data
Models for a new project of a friend of mine i found there this nice and simple tutorial on How to
Understand a Database Schema . As its name says, this tutorial will help you to better understand a
Database Schema and covers the following basics topics that every Database Schema must define:
QUOTE Primary and Foreign Keys. One-to-Many and Many-to-Many Relationships. Inheritance.
"Rabbit's Ears", (Recursive relationships). The Scope of this tutorial is ...

MySQL Output Database Question - (18)

I am new to MySql and have just created a database after using a script. My problem is not the
script, but what it says about putting it into the output file. I cant figure out the right terms
to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
please help me out?...

Accessing Ms Access Database From A Centralized Location? - (5)

Hi I am a manager at a trading/wholesaling company (and have no programming background). I
customized the Northwind sample access database to make invoices and keep accounts for my company.
We now opening another office at a distant location. So, the order entry will be done at two
points(we plan to use the same Access database). I am not able to figure out how to access the same
MS Access database from two different location(as LAN can't be used). Moreover, we can't
afford to pay huge sums to the software developers. Can intranet or uploading the database t...

Space Needed For Database - (10)

Iam assuming the information in the databases i will create will be stored in the 500 MB space i
get, but since 500MB isn't enough iam wondering if you guys can tell me how much bytes the
following take: Varchar(x),Tinyint,Text,date,smallint,mediumint,bigint,float.... And the rest
present when you add/edit a row in a table. Also what are the ranges of tinyint,smallint,mediumint
and big int...

Database Access On Remote Server W/jsp - (0)

Hello: I am new to JAVA and server-side applications and have a dumb question. I have set up
Tomcat on my machine and created a JSP program to query an Access database using a DSN-Less
connection. If I publish the page to a webserver and include the .MDB file will it work? I'm
not sure exactly what needs to be packaged with my Java application to make it work. Since I
don't have a remote server that supports .jsp I cannot really test it. I'm assuming that
JDBC driver would be bundled with my site but not sure. Thanks!...

Mysql Database Entry By Excel Sheets - (2)

Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to
mysql database. Thanks...

Mysql Database Management - (1)

Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me
to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the
following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE (Store#,
City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed database for a
bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST. Consider that
BOOKS are fragmented by $price amounts into: B1:BOOK1:up to $20. B2:BOOK2:from ...

Mirror My MySQL Database To Another Mysql Server - (4)

Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql
server?or create a small php script to do this? The reason is because, we all know that database is
very improtant if we have dynamic website. I have my forum hosted and i want to automatically
mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid
that i forgot to backup my database..also i have one central backup database. Thanks for the
help..Im looking forward for this posibility....

Integrate Access Database Onto Intranet Site - Looking to integrate access database into my intranet site (5)

Hey guys, im new here and am looking for answers /tongue.gif" style="vertical-align:middle"
emoid=":P" border="0" alt="tongue.gif" /> Firstly, i have designed a database using M$ access, it
consists of multiple forms which i plan to host on an intranet website, i need to be able to add
records directly from the form on the intranet website aswell as being able to edit/review current
entries on forms in the database. My question is, how would i go about integrating these forms onto
the intranet website? i plan on keeping the database and the intranet site on the same d...

Database - prblem with it (1)

i have free script but it is working fine on a lot of sites i tried to use it to my web site ....i
edit its config.php right and but my database name and my user name and password every thing right
and when i try to install it it gives me this error can`t connect to database please choose file
from this mobile.sql can any body help plz coz i tried huderd of times and no thing happend...

Connecting To A Remote Database - (9)

I wondered if anyone here can help. I have a database on a remote server (A). I want to access it
through a php script on a different server C. I have allowed access on (A) in Cpanel - mysql dbases
- Remote Access by putting the IP address of server C The host of server (A) has also whitelisted
the IP of server C. Though I am having trouble connecting from server C which is with a different
webhost. any ideas how to get round this? I have though of SSH forwarding, but I think this can
only be used to connect a client - e.g. my pc to the remote server A. I do not ha...

Permission Problem With Mysql Database Creation - Please Help! (8)

I seem to have a problem with accessing my database with proper permissions. I have set the my
database correctly giving my db username all priviliges yet i seem to be unable to even log on with
this username with a denied access error. Any ideas on resolving this?...

Is It A Good Practice To Store Image Or Other Binary Files Directly In A Mysql Database - (4)

Hello to all of you beautifull people out there, I am new to MySQL, i just wanted to know if its a
good practice to directly store images and other binary files in a MySQL database. Any one with
help? Thanks...

Need Help In Database Auto_increment - (9)

i am creating a game and i set when someone registers than he gets id...in "extra" i have set it to
be "auto_increment" but whenever new player signs up he gets number bigger than 210...(my first id
was 211,next was 212,third was 213,fourth got 214) how to set it to go from 1 to infinite? thnx...

Embedded Database - Embedded Data base at client side, (7)

Hi, Now its the era of Embedded databases, no more db servers, no more host,Because with embedded
db you can get all those options, what you are used to get with DB Servers. Some of Embedded DB Are
1) Cloudscape From IBM (NOW Derby from ASF) 2) HSQLDB (OpenSource) and many more Feel the power of
EDB Cheers Arunkumar.H.G...

Need Advice On Creating Online Music Database - ps - dont know anything about databases! (6)

I need to create a database of around 1000 music albums that I can put on my site, with the ability
to search the database according to several different criteria. Being a complete and total NOOB to
the world of databases, can anyone point me in the direction of some software that will let me
create a good-looking and functional database, but that isn't too complicated for me to use?!
Sounds like a tall order I know, be grateful if anyone can help though. Thanks! Topic edited to
reflect content better. ...

The Best Database - What do you think is the best database? (48)

Ive been planning to create a online application which requires tons of stuff from database. Ive
been using interbase, at first it was good but after a month i find it not user friendly at all...
Its to hard to code in php.. Can any of you guys give me a good database which is easy to use?...

phpBB Database Transfer - Anyone here knows how to? (10)

Hello, i'm a newbie in using phpBB and I still lack knowledge in mySQL database. How do I
transfer the datas(users,configs, all of them) contained in my current forum to another one in
phpBB? I hope someone can help, a short but detailed tutorial would be good. Example is, if I want
to move to a new host and I want to transfer all the accounts on my old forum to the new one. Thanks
in advance, hope anyone here knows how to....

My Sql Database Help? - (3)

Ok, i am new at web design, i dont know too much about it... I was working on a website for about
a month this is what i got, My Web , like i said, i dont know much.. i used FrontPage and did all
of that, my current host is AFMU which uses MySQL, but the way it is set up I dont know how to
acquire the URL of the database or any information i dont know what it means at all.. i just want to
do a simple login feature, i mean this is my first website and i am learning so I think it would be
a great feature to add in and learn. i can create data bases from there but do n...

Database Size? - So how big is everybody's MySQL database? (10)

Well I know that MySQL databases can get rather big, so I was just wondering how big everybodies
databases were? Do you have really big ones, or are they relatively small? Also what do you store in
them? (just text, or binary data as well)...

How Many Concurrent Users For Oracle Database? - This is to analyse and get perfect result for How many concurrent use (1)

Hi friends, How many concurrent users can practically access the oracle database?
they say tht the figure is hundreds of thousands users...is there any exact figure? or does the
number of concurrent users depend on any other factors as wel? I think depend on parameter
1.session 2.processes session Specific connection of a user to an Oracle instance through a user
process. A session lasts from the time the user connects until the time the user disconnects or
exits the database application. Multiple sessions can be created and exist concurrently for ...

Database Programming In Vba 6.0 - (1)

hi , i need some sample program in database.thanks...

Need Info On Database Programming Courses - Oracle Database Programming (2)

I know Database Programming on MS-ACCESS, now i am planning to go for some other Database
Programming courses, People told me to go for Oracle or VisualAge. Can anyone told me to start with
which one and how long is the course period and which one is easy and is it similar to ms access or
somthig different....

Database Program With GUI - (14)

I am looking for a program to create SQL databases through a GUI to simplify it, the only things i
can seem to find are command prompt things and i can't work with them. I like MS access and
would like something similar to that if possible. I am working with windows at the moment can anyone
recommend a program i can use (preferably free) Many thanks...

What Is Maximum Capacity Of Astahost MySQL Database? - (11)

I'm sorry about this topic. I'm a new user and my english is not very good. I want to learn
the max capacity of mysql db....

What Is A Database How Do I Use One? - : Information about Databases and how to get use them efficiently (7)

Hello All Let's start off by talking about what a database is and how it would be efficient
in using it. It wasn't until about a year and half ago now that I was first introduced to this
new age of Database. I discovered a lot of neat things and even learned about databases the very
long way. A database is exactly how it sounds its data that has a base. The base being the place
where you store all your data. If you have ever been to a library perhaps you have used the Index to
search for an author, this is a database of authors. Ever seen a rolodex on someo...

Using pbpBB2 And Mediawiki Common Database - (3)

I want to host phpbb2 forum and one wiki software (not sure whcih one at this point). Can someone
help me how to use a common or shared database for both these applications? The user data, login
could be common on both databases. Any inputs are appreciated. Thanks ...

The Best Database - databases (41)