Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

For Learning Expand / Collapse
Could you tell me how can i improve my Query knowledge in MS-SQL,and Oracle
Poll ResultsVotes
I want to improve my DB Knowledge , i have experience in MS-SQL and ORACLE.
 
100%
1
My Problem is when i face any interview i couldn't write query very fast .i have taken very long time to finished that query .please help me
0%
0
Member Votes: 1, Anonymous Votes: 0. You don't have permission to vote within this poll.
Author
Message
Posted Monday, March 18, 2013 7:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 8:41 AM
Points: 3, Visits: 5
I want to improve my DB Knowledge , i have experience in MS-SQL and ORACLE.
My Problem is when i face any interview i couldn't write query very fast .i have taken very long time to finished that query .please help me
Post #1432179
Posted Monday, March 18, 2013 7:54 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:23 PM
Points: 13,272, Visits: 12,103
saravanan.kuttyy (3/18/2013)
I want to improve my DB Knowledge , i have experience in MS-SQL and ORACLE.
My Problem is when i face any interview i couldn't write query very fast .i have taken very long time to finished that query .please help me


There is nothing anybody can do in an online forum to help you write queries faster. The only person that can help you write them faster is yourself. Often not being able to write them quickly is due to a lack of knowledge. The only way to gain that knowledge is through practice. Hang out on these forums, try to practice and learn from the answers you see. Then start trying to answer the ones you are comfortable with. Pretty soon you will be able to write more complex queries a lot easier.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1432193
Posted Tuesday, March 19, 2013 12:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:38 PM
Points: 7,097, Visits: 12,598
This book could help you.

http://www.amazon.com/Microsoft-Server-2012-T-SQL-Fundamentals/dp/0735658145/ref=rec_dp_2


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1432485
Posted Tuesday, March 19, 2013 8:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 8:41 AM
Points: 3, Visits: 5
thank you
Post #1432670
Posted Tuesday, March 19, 2013 8:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 8:41 AM
Points: 3, Visits: 5
thank you i will do practice myself
Post #1432671
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse