Page 1 of 1

SQL Manipulation exercises on VMart ?

Posted: Wed Aug 27, 2014 7:51 am
by Benjamin_e
It's awesome we got an VMart data example but there is 1 missing thing. exercieses and practice.
any site offer something like this?
lets for example:

query:
-------
1) sum (cost_dollar_amount) from online sales
per week day per product package size
for last month.

I need more queries in-order to get the concept.

Re: SQL Manipulation exercises on VMart ?

Posted: Wed Aug 27, 2014 3:36 pm
by NorbertKrupa
If you look under /opt/vertica/examples/VMart_Schema, there is a file called vmart_queries.sql which provides 10 sample queries for querying the sample database. If you're looking for general resources on SQL, there are millions one click away from a Google search.

Re: SQL Manipulation exercises on VMart ?

Posted: Wed Aug 27, 2014 9:45 pm
by Benjamin_e
Thanks.