We don’t allow questions seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. You can edit the question so it can be answered with facts and citations. Closed 3 years ago. ... Recently, I started learning SQL, and I am looking for ways to practice ... More on stackoverflow.com

Since getting SQL skills require study and practice, I found a couple of extra websites to practice SQL. I wanted to find graded exercises (or a way to know if my queries were well written). Here are my findings: Exercise v3.0 Graded exercises and theory in case you need it. More on forum.codewithmosh.com

It's been mentioned a lot recently, but Data lemur is really good. I'm hoping they keep adding more questions because the design is REALLY clean and intuitive. More on reddit.com

Here is a real world example that I worked on a few years back. First, build a database with the following tables and write scripts to randomly generate data to insert into them. Practice using loops and generating fake data either from reading from text files (ie generate random number between 1 and 50, read that line, insert into table). Being able to properly mock up data is important - you don't always get to test on real applications. Location (id, description) -- 3 locations, HQ, Store1, and Store2 User (id, login_name, description) -- 10 random users Stage (id, description) --3 stages, new, submitted, and authorized PurchaseStage (id, contract_no, stageid, datestarted, datecompleted, completed_by_id) --Assign 1 to 3 stages per purchase. All Purchases have NEW but not all purchases have reached the authorized step. Purchase (contract_no, description, user_id, location_id, timestamp) --make about 1000 of these PurchaseDetail (contract_no, line_no, quantity, price, item_id) --make between 3 and 10 per purchase Item (id, description, price) --make 30 Questions to answer once you have built this: Why did I tell you to list price twice (PurchaseDetail and Item)? Get me a list of all purchases made between two dates (arbitrary) Get me a total of all purchases made between two dates (arbitrary) that were authorized by Bob, grouped by location Get me a list of all purchases that sold at least 5 of something (arbitrary) and have been Submitted or Authorized by Bob. Get me an average of how long it takes each user to Submit and Authorize purchases. More on reddit.com