Jump to content
sdhild99

Suggestion - New Tutorial

Recommended Posts

Hello,W3Schools is great! I know you have a tutorial about SQL, but before you can use SQL you need a database. Databases are often the backend of web sites.I'd really like to see a tutorial about creating/designing databases. It would be nice if the tutorial would discuss the following matters (and more):Flat files vs multi-tablesWhat to concider when designing a database (for instance if you want to extend your database)Keys, indexes, relations, constrainsts, data types ++Unfortunately I don't not have the skills to write it myself, but I could need it :-)Would be great if you could find the time to write a really good tutorial about databasesRegards,Sven from Norway

Share this post


Link to post
Share on other sites

you create / design databases with SQL...SQL is more than just select insert, delete, and updateyou can actually CREATE DATABASE, and setup the configuration of the database through SQL...if you are using a database with an interface like SQL Server the program is doing that for you as you choose the options visually.The Tutorial could go into to the creation side of SQL but there is no need ofr a seperate one.

Share this post


Link to post
Share on other sites

I'm perfectly aware of the things you say about SQL. However, the tutorial present on SQL does not discuss any of the matters I've listed in my 1st post. In my opinion there is no need to know SQL if you don't know why you use it. If you want to learn databases you don't start with SQL. If you do that you start with the technical aspect and skip the basic knowledge that should be present first.When you know why you need a database, how to design it, and when it's normalized, then you can start putting your SQL into action.Putting the requested tutorial next to the SQL-tutorial seems like a good idea, but the database one ought to be Part 1.This is just my humble opinionBest regards,Sven

Share this post


Link to post
Share on other sites

Normally, when people learn, they know that to use and manipulate a database, they need server side scripting. When they get in to the point of the tutorial, where there is SQL manipulation, they realize that SQL is a whole another language and start learning it THEN. This basically means they are aware on how should they set up a database to use with the particular server side script (scince it's explained in the server side script tutorial). It almost never goes the other way around.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...