Click here to Skip to main content
15,565,601 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I need help regarding ways to sharp my sql skills. I am kinna lost in sql.

What I have tried:

I learnt all the syntax, statements and every keywords. I have been practicing querries.
But still I feel like I dnt know anything.
Posted
Updated 5-May-20 3:51am
Comments
Richard MacCutchan 5-May-20 3:25am    
Google will find you many samples of SQL. You can also create your own database(s) and practice adding information and producing reports.
Anurag Gandhi 5-May-20 3:55am    
Just search SQL interview questions and you will get loads of topics/ideas/questiosn to cover. Then, practice those queries/concepts.
F-ES Sitecore 5-May-20 6:30am    
Look through SQL-based problems on here and try to solve them.

As per @Richard-MacCutchan I would advise taking to your favourite search engine and look for ideas from the internet. I would avoid "interview questions" articles - but that is a very personal view - you might be able to answer all of the questions at the end of your research but you will be no further forward in mastering the topic.

For example: There are a lot of ideas on this site - latest SQL Database project topics and ideas with source code for final year projects - kashipara[^] - but avoid downloading their solutions - work it out for yourself.

Same with this one Top 18 Database Projects Ideas for Students | Lovelycoding.org - We love Coding![^]

You could have a look at http://www.databaseanswers.org/data_models/[^] - which is a great source for database schemas - but have a go at designing your own and use that site to "verify" your decisions.

Try to think of a topic that you are interested in or could expand on as your knowledge grows - e.g. your music / photo / book collection(s).

And be prepared to throw away your first attempts :-) Never be downhearted about mistakes - it's how we learn.

Finally - when you get comfortable with your knowledge be prepared to go over it all again - keep on top of the latest developments and techniques. Come to CodeProject often and try to answer for yourself some of the questions asked (if they are old posts though please don't resurrect them by posting your attempts).

I also use SQLServerCentral – The #1 SQL Server community[^] and SQL Server Blog - Official News from Microsoft’s Information Platform - Microsoft[^]
 
Share this answer
 
v4
Just start creating sample Project and create one sample form and try to insert in database >
insert < update and delete operations on that form >so that you can get some idea>
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900