How do I practice SQL like real time project simulation at home>

Question

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 4-May-20 21:10pm

Aroonn

Updated 5-May-20 2:51am

Add a Solution

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.

2 solutions

Solution 2

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>

Posted 5-May-20 2:52am

Chinnu2020

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

CHill60 · Accepted Answer · 2020-05-05T00:28:00

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[^]