SQL - Nairaland

Nairaland Forum | Technology | Programming | SQL

Pages: (1)

Author

Topic: SQL (Read 172 views)

joyblinks (f)

SQL

« on: November 02, 2009, 08:01 AM »

Please i wan to ask.

Am an IT student. was thought S.Q.L.

i just want to know if SQL is all about the

SELECT
FROM
ORDER BY
GROUP BY

or is there more to it.

tosh_acer

Re: Sql

« #1 on: November 02, 2009, 08:26 AM »

why do you have the internet and google if you have to come to nairaland to ask this question? log on to google and search sql and you will find solution to what you seek.

yawa-ti-de (f)

Re: Sql

« #2 on: November 02, 2009, 09:30 AM »

Yes there is more to it. For example, among others, there is:
UPDATE, INSERT, WHERE, CASCADE, DELETE and DESC.

Where did you go to school if I might add? If all they taught you is the above, not to defend them but chances are that they figured those are probably the most common keywords used and they expect you as the student to be on a constant journey of learning which means you should know the rest. This could be true especially if you are taking the beginner course. In other words, consider taking a more advanced course.

Also try:
http://w3schools.com/sql/default.asp

Good luck!

fastchange

Re: Sql

« #3 on: November 02, 2009, 09:45 AM »

There are lots more to it. There are also Procedures and Functions, Views, Joins, Unions etc.
Most of the time u would rearly need to use 'em but they are quite handy and useful tools in complex situations.
I think the best for you is to take the journey yourself and make the internet and google your best pals.

Kobojunkie

Re: Sql

« #4 on: November 02, 2009, 03:48 PM »

@Joyblinks, if you are truly an SQL Student, I suggest you get A BOOK on the Language. SQL is a Programming Language( to be specific a query language) and If you really want to learn it, you have to have at least 3 solid books(Beginners, Intermediate, Advanced) on the topic. If google is the next best thing for you then please start on that.

joyblinks (f)

Re: Sql

« #5 on: November 02, 2009, 07:45 PM »

tosh_acer

dont they ask questions in your village? I too sabi (sighs)

thanks you all. i will sure do as u've said.

arohcs (m)

Re: SQL

« #6 on: November 07, 2009, 09:19 AM »

you most learn to take things very lightly if you want to learn and don't attack back.

well i got some videos that can help.

enjoy

tolubonnke

Re: SQL

« #7 on: November 20, 2009, 04:25 AM »

i have been sending this request for some time now but i've really not got any reply.
i use access for my vb right from time and i need some one to bring me up on using mysql and microsoft sql/
the most difficult part has been the connection with vb6 and making it work on networking
pls help me i am counting on u guys.
a simple application as an illustration will be very alright.
thanks.

webdezzi (m)

Re: SQL

« #8 on: November 20, 2009, 11:44 PM »

Quote from: tolubonnke on November 20, 2009, 04:25 AM

tolubonnke, while i dont use VB, i may be able to contribute based on my experience with other languages,
to connect over a network, you will need to use the ip address of the computer hosting the database as servername

like someone help you on the other thread (i want to assume the code is correct)

Using ADODB

dim cn as new adodb.connection
dim rs as new adodb.recordset

Sub ConnectToSQLDatabase()
cn.connctionstring="Provider=SQLOLEDB.1;Password=mypassword;Persist Security Info=True;User ID=username;Initial Catalog=mydatabase;Data Source=MyServer"
cn.open

End Sub

change MyServer to the ip address running the database

dotzok

Re: SQL

« #9 on: Today at 12:11:07 AM »

Joyblinks never mind some tongue-lashes; take it as fun. I once ran to chat-room to get a help, eventually i met a saucy guy and we ended up arguing and exchanged words, at last i was right.
Enough of story.

No school in this Nigeria would've thought you in-depths of anything. SQL is 1 of the most intersting and very-easy-to-learn development tool. The first set of clauses any good teacher would teach you in SQL are the DMLs (Data Manipulation Language), which are basically INSERT, SELECT, UPDATE, DELETE, then the DDLs (Data Definition Language); CREATE, DROP, ALTER etc.

However, as simple as they sound, they are too powerful to be ignored in ANY non-trivial application.

Meanwhile you can write 90% of your codes in SQL using Stored Procedures. If you're further interested I'll send you simple samples and materials.

Whatever your journey , Keep walking

Php And Mysql Teacher In Abuja The Arrival Of Revolutionary It Magazine In Nigeria Help On Short Code Sms Service Page 2

Pages: (1)