Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,200,694 members, 7,975,689 topics. Date: Tuesday, 15 October 2024 at 10:33 AM |
Nairaland Forum / Science/Technology / Programming / SQL (1331 Views)
Help!!! Login Failed For User in SQL Server / How To Connect Vb.net Windows Application To Php And My Sql Database / Oracle Vs Sql Server (2) (3) (4)
SQL by joyblinks(f): 8:01am On Nov 02, 2009 |
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. |
Re: SQL by toshacer: 8:26am On Nov 02, 2009 |
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. |
Re: SQL by yawatide(f): 9:30am On Nov 02, 2009 |
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! |
Re: SQL by fastchange: 9:45am On Nov 02, 2009 |
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. |
Re: SQL by Kobojunkie: 3:48pm On Nov 02, 2009 |
@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. |
Re: SQL by joyblinks(f): 7:45pm On Nov 02, 2009 |
tosh_acer dont they ask questions in ur village? I too sabi (sighs) thanks you all. i will sure do as u've said. |
Re: SQL by arohcs(m): 9:19am On Nov 07, 2009 |
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 |
Re: SQL by tolubonnke: 4:25am On Nov 20, 2009 |
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. |
Re: SQL by Nobody: 11:44pm On Nov 20, 2009 |
tolubonnke: 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 |
Re: SQL by dotzok: 12:11am On Nov 22, 2009 |
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 |
Re: SQL by Nazgul: 2:24pm On Apr 17 |
joyblinks: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. |
Re: SQL by peterincredible: 4:01pm On Apr 17 |
joyblinks: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 1 Like |
Re: SQL by peterincredible: 4:07pm On Apr 17 |
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 1 Like |
Re: SQL by joyblinks(f): 8:51pm On May 10 |
peterincredible: Lol. I wish. When and how did I type this? Hahahhaaaa who even resurrected this post? |
(1) (Reply)
Debugging Someone Else's Code: Is There Anything More Painful? / Is Nairaland Becoming A Search Engine? / Help Debug This Java Code
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 21 |