For Learning

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » For Learning

For Learning

Rate Topic

Display Mode

Topic Options

Could you tell me how can i improve my Query knowledge in MS-SQL,and Oracle

Poll Results

Votes

I want to improve my DB Knowledge , i have experience in MS-SQL and ORACLE.

100%

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

Member Votes: 1, Anonymous Votes: 0. You don't have permission to vote within this poll.

Author

Message

saravanan.kuttyy

Posted Monday, March 18, 2013 7:00 AM

Forum 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

Sean Lange

Posted Monday, March 18, 2013 7:54 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 1:17 PM
Points: 8,641, Visits: 8,273

saravanan.kuttyy (3/18/2013)

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

Post #1432193

opc.three

Posted Tuesday, March 19, 2013 12:27 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:46 PM
Points: 6,730, Visits: 11,783

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1432485

saravanan.kuttyy

Posted Tuesday, March 19, 2013 8:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 8:41 AM
Points: 3, Visits: 5

thank you

Post #1432670

saravanan.kuttyy

Posted Tuesday, March 19, 2013 8:09 AM

Forum 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 »

Permissions