Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Different statements in SQL query

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 14-12-2010
Member
 
Join Date: Dec 2010
Posts: 11
Different statements in SQL query
  

I am a student of Computer Science, right now I am pursuing a degree course. I am looking forward to a Data base Administrator , so I want to make my my query knowledge thorough , but I am very weak at it and I do not have much idea about the basic query as well, so I would appreciate if you could get some hint about the statements being used in the SQL queries.

Reply With Quote
  #2  
Old 14-12-2010
Member
 
Join Date: May 2009
Posts: 523
Re: Different statements in SQL query

SQL is a structured Query language that is used for fetching for the data that is stored in a database, the data base is a relational database which as a designed schema , schema in the sense the database is in the tabular format and is identified by an entity name. And these queries can be used to fetch the data from the relational data . The most basic statement in the SQL language is Select statement.
Reply With Quote
  #3  
Old 14-12-2010
Member
 
Join Date: May 2009
Posts: 532
Re: Different statements in SQL query

Select statement is used to fetch the result for the query being made in the select statement , as these table contain different columns and one of the column contains unique data called as the primary key of the table. So you can fetch the record by specifying the name of the column next to the select statement.
Reply With Quote
  #4  
Old 14-12-2010
Member
 
Join Date: May 2009
Posts: 525
Re: Different statements in SQL query

Apart from the Select statement, there are a few basic statements such as Where and From as well. Suppose you want to fetch a data of a student whose marks exceed more than 60 from the student table, then you can give the query and in the Select statement you will write the you will write the column name student name and marks in the from clause there will be the table name as student and in the Where clause you will specify the condtition as marks should be greater than 60.
Reply With Quote
  #5  
Old 09-03-2011
Member
 
Join Date: Mar 2011
Posts: 3
SQL query

Hi all,

I have done degree course in electronics but now i want to be a database administrator, so i'd really appreciate if i get some online free downloadable books for sql server.

thanks in advance
Reply With Quote
  #6  
Old 09-03-2011
Member
 
Join Date: May 2008
Posts: 620
Re: Different statements in SQL query

If you are wanted to go with the Database Administrator then you have to complete the DBA courses offered by Oracle university. There are lots of institute who are offering then traning program fro DBA after that you can appear for the direct exam of DBA. There are three exam you have to complete first one is for SQL then to Workshop 1 and finally Workshop 2. After completing all these exam you will get two certificate one for OCP and another for OCA. Which is nothing but complete DBA. If you will let me know about your location then i can help you with good institution for same.
Reply With Quote
  #7  
Old 09-03-2011
ismail12
 
Posts: n/a
Re: Different statements in SQL query

SQL stands for Structured Query Language, Its powerful and diverse language used to create and query databases.Mainly used for storing large amount of data and also fetching data from database.
Reply With Quote
  #8  
Old 11-03-2011
Member
 
Join Date: Mar 2011
Posts: 3
Re: Different statements in SQL query

Quote:
Originally Posted by Educated View Post
If you are wanted to go with the Database Administrator then you have to complete the DBA courses offered by Oracle university. There are lots of institute who are offering then traning program fro DBA after that you can appear for the direct exam of DBA. There are three exam you have to complete first one is for SQL then to Workshop 1 and finally Workshop 2. After completing all these exam you will get two certificate one for OCP and another for OCA. Which is nothing but complete DBA. If you will let me know about your location then i can help you with good institution for same.


India(Delhi)

thanks in advance
Reply With Quote
  #9  
Old 11-03-2011
Member
 
Join Date: May 2008
Posts: 620
Re: Different statements in SQL query

IF you are in Delhi then i will advise you to get the training from the SQL Star International Limited which is very well know institution in India for DBA courses. Its 2 months course if you are joining for regular batch and if you wanted to complete the course as part time then it will take 3 to 4 month for completion. If you want you can visit the below given address for same.

Address:
SQL Star International Limited
201, 2nd floor,
Tower-A, Pitampura
Delhi, 110034
011 43068000
Reply With Quote
  #10  
Old 12-03-2011
Member
 
Join Date: Mar 2011
Posts: 3
Re: Different statements in SQL query

Thanks!

Could u please also tell me about some good institute for asp.net training..
Reply With Quote
  #11  
Old 12-03-2011
Member
 
Join Date: May 2008
Posts: 620
Re: Different statements in SQL query

For ASP.Net training i am not much sure but i know NIIT which is offering the ASP.NET Certification Courses. If you are joining any of the institution then it is better to first ask the existing student of the institution about the faculty. If the faculty is good and if you are serious about studies then institution does not matter. Even you can get better education from small institution.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Different statements in SQL query"
Thread Thread Starter Forum Replies Last Post
How to Inject SQL Statements in PHP? DANIEL 602 Software Development 5 05-03-2010 03:46 AM
Difference between DML statements and DDL statements Prashobh Mallu Software Development 5 11-01-2010 01:07 PM
Problem with my IF ELSE IF statements in C++ KACY5 Software Development 2 04-09-2009 05:12 PM
Turn on MySQL query cache to speed up query performance DMA2Superman Software Development 3 07-07-2009 10:26 AM
SQL statements with JSP blindsleeper Software Development 2 16-05-2009 09:54 PM


All times are GMT +5.5. The time now is 05:36 PM.