You must Sign In to post a response.
  • Category: SQL Server

    Advanced sql queries

    I want to practice complex sql queries. Please suggest some websites/web portals where I can find good examples along with the database (db download) for practicing it on my pc.
  • #761529
    Hi
    You can go through Below links

    http://www.dotnetspider.com/tutorials/
    w3schools.com
    asp.net

    http://www.programmerinterview.com/index.php/database-sql/advanced-sql-interview-questions-continued-part-2/

    http://www.programmerinterview.com/index.php/database-sql/practice-interview-question-1/


    http://stackoverflow.com/questions/2413471/where-can-i-find-exercises-to-practice-sql-statements

    Name : Dotnet Developer-2015
    Email Id :kumaraspcode2009@gmail.com

    'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

  • #761535
    Hi,

    The best way to practice is Install SQL server software in your system and practice it on daily, If you are interested to prepare projects then try to create complex project obviously you get some challenging work on that.

    Hope this will helpful to you...

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/

  • #761537
    Hi

    First try to understand what are complex queries in sql server.
    What makes the query complex?
    Here are the good examples of maximum of complex queries, go through below references.

    https://curah.microsoft.com/183409/sql-server-interview-queries-questions-answers-with-example-pdf

    www.bullraider.com/database/sql-tutorial/7-complex-queries-in-sql

    www.codeproject.com/Articles/690340/Querying-SQL-Server-Part-I

    Regards

    Thota Sridhar.
    If you learn from defeat..
    You haven't really lost..

    Sridhar Thota.
    Editor: DNS Forum.

  • #761540
    Hello Jayesh,

    Go through the below links and be powerful in SQL :

    http://www.w3schools.com/sql/

    http://www.tutorialspoint.com/sql/

    http://www.javatpoint.com/sql-tutorial

    http://beginner-sql-tutorial.com/sql.htm

    This link has thousands of records :

    https://msdn.microsoft.com/en-us/library/aa992075.aspx

    Hope this will help you.

    Regards,
    Nirav Lalan
    DNS Gold Member
    "Failure is the path of least persistence"

  • #761553
    I am recommending the following website for your studies

    http://blog.sqlauthority.com/

    By Nathan
    Direction is important than speed

  • #761603
    There are many complex queries available in dotnetspider.

    Please go through the below links and try to solve on your own;

    http://www.dotnetspider.com/forum/331199-Forming-equation-finding-result-through-Query.aspx

    http://www.dotnetspider.com/forum/327337-how-write-Query-without-using-top-function.aspx

    http://www.dotnetspider.com/forum/321764-Query-gte-row-number-based-column-data.aspx


    http://www.dotnetspider.com/forum/305704-Query-calculate-tax-against-product-wise.aspx

    Please mark this as Answer, if this helps

    Regards,
    Alwyn Duraisingh.M 
    << Database Administrator >>
    Jesus saves! The rest of us better make backups...


Sign In to post your comments