I am just a kid of 17, a GNIITian . Help me about this?

Question

I hav learnt of SQL. I hav been thought that every system has an inbuilt server in it. How can i start creating a database and use SQL language to query it.
I hav been thought of client-server architecture also in SQL wherein different client systems can be connected to a single server. Is it possible to modify the database from a client system. Or only the server can?

Answer 1

First of all, the answer changes wildly depending on what type of SQL server you are using. If you're using MSSQL, MySQL, PostgreSQL, or any of the other SQL server types, then the commands change (albeit slightly). In any event, I'll try to answer your question as best I can.

You create a database in SQL with a command, just like every SQL command. Once you've created a database, you use SQL commands to insert data into the database, and you use SQL to retrieve that information.

In a client-server architecture, you specify what hostnames/IP addresses can connect to the server based on the username, and what that username connecting from that machine has privilege to do. It is technically possible to allow user accounts to modify databases when you grant them permission, but for security reasons, this is not always advisable.

Answer 2

This may be of some help:

http://www.w3schools.com/sql/sql_intro.asp

But the best way to get to know SQL is to start playing. Search the net for tutorials, examples, and resources. Read everything going, and play with it!

Rawlyn.

p.s. What does age have to do with anything?