May 20, 2015 at 10:34 am
Hello...
I am currently looking for job as sql developer company gives sql query to solve so can you help me where I can find real time scenario query and if you guys know any query then let me know plzz
May 20, 2015 at 10:38 am
meerack11 (5/20/2015)
Hello...I am currently looking for job as sql developer company gives sql query to solve so can you help me where I can find real time scenario query and if you guys know any query then let me know plzz
What real time scenario would you like to learn?
There are many many many real time scenarios.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2015 at 10:38 am
If you want a database environment to practice, download and install SQL Server in your local computer and then install Adventureworks databases. Many sites use them for examples (the main being BOL).
May 20, 2015 at 10:58 am
meerack11 (5/20/2015)
Hello...I am currently looking for job as sql developer company gives sql query to solve so can you help me where I can find real time scenario query and if you guys know any query then let me know plzz
Just remember that the expert answer to 90% of all SQL Server related questions is:
"It depends"
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 20, 2015 at 11:09 am
Eric M Russell (5/20/2015)
meerack11 (5/20/2015)
Hello...I am currently looking for job as sql developer company gives sql query to solve so can you help me where I can find real time scenario query and if you guys know any query then let me know plzz
Just remember that the expert answer to 90% of all SQL Server related questions is:
"It depends"
True, but be ready to explain why it depends.
May 20, 2015 at 11:13 am
Can you clarify at all what you mean by "real time"?
That doesn't define much in general within SQL Server. All the SELECT queries are run "in real time" in that issuing the command starts the query so you get results back when it's done. An INSERT query is run in "real time" in that when you commit the transaction everything gets written out to disk permanently. So if you have some specific meaning for "real time" that would sure help us to help you.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 20, 2015 at 11:27 am
If you want to practice SQL, I'd suggest you take a few questions on this site, like this one: http://www.sqlservercentral.com/Forums/Topic1687195-3077-1.aspx
Only read the first post and try to solve it. If it's confusing, you might go through other posts to see if things are clarified, but learn how to write and re-write your own queries.
May 20, 2015 at 6:50 pm
meerack11 (5/20/2015)
Hello...I am currently looking for job as sql developer company gives sql query to solve so can you help me where I can find real time scenario query and if you guys know any query then let me know plzz
Apologies for the absolute honesty but if you have to ask on a forum for practice queries, then you're probably not ready for the job, yet. You need to learn more about Google and T-SQL.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply