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.

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.

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!

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.

@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.

tosh_acer


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

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

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

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.

tolubonnke:

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.

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

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

joyblinks:
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.

Lol...I don laugh taya

These are the elementary stages of SQL. When you go deeper, you'll discover that there's more to it.

But for me, I prefer using Python for writing my programming codes, and SQL for importing Data.

I don't feel comfortable writing programming codes on SQL.

joyblinks:
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.

madam there is way more to it and it is very deep so just learn as u go or maybe take an in-depth course on udemy on SQL examples of other tins I will learn pls don't be scared are(triggers, transactions, sub queries, cte, stored procedures, stored functions,views,windows functions, indexing, recursive queries etc) please don't be scared tins to learn plenty 4 SQL but as get more challenging task during your it u will learn and c the need to use the rest gracias

Wow I just say the date this post was made meen time fly's I know by now you would have been a SQL wizard