Sep 1, 2016 #1 I icor1031 [H]ard|Gawd Joined May 29, 2010 Messages 1,295 Is there a database I can download that's already filled with data and useful for learning to do more-complex queries?
Is there a database I can download that's already filled with data and useful for learning to do more-complex queries?
Sep 2, 2016 #2 T tazeat [H]ard|Gawd Joined Jul 3, 2007 Messages 1,268 Sure, they have a few on their site. Here's one: MySQL :: Employees Sample Database MS SQL so has a lot of examples too, see adventureworks Microsoft SQL Server Product Samples: Database - Home
Sure, they have a few on their site. Here's one: MySQL :: Employees Sample Database MS SQL so has a lot of examples too, see adventureworks Microsoft SQL Server Product Samples: Database - Home
Sep 4, 2016 #3 MGCJerry Limp Gawd Joined Sep 18, 2005 Messages 144 Here's a copy of my "pageviews" database (from Jun 9, 2002 - Sept 4, 2016). 7,965 records; 872KiB. Fun using queries to find the busiest hour, day, page, etc in whatever combination but yet still readable inside the database without querying it. http://2thextreme.org/forum_images/pageviews.sql Edited: This will make use of a table called "prefix_pageviews". Running this SQL file will drop that table if one exists. Edit as needed.
Here's a copy of my "pageviews" database (from Jun 9, 2002 - Sept 4, 2016). 7,965 records; 872KiB. Fun using queries to find the busiest hour, day, page, etc in whatever combination but yet still readable inside the database without querying it. http://2thextreme.org/forum_images/pageviews.sql Edited: This will make use of a table called "prefix_pageviews". Running this SQL file will drop that table if one exists. Edit as needed.