SQL Manipulation exercises on VMart ?

Moderator: NorbertKrupa

Post Reply
Benjamin_e
Newbie
Newbie
Posts: 15
Joined: Tue Aug 26, 2014 1:43 pm

SQL Manipulation exercises on VMart ?

Post by Benjamin_e » Wed Aug 27, 2014 7:51 am

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.

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: SQL Manipulation exercises on VMart ?

Post by NorbertKrupa » Wed Aug 27, 2014 3:36 pm

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.
Checkout vertica.tips for more Vertica resources.

Benjamin_e
Newbie
Newbie
Posts: 15
Joined: Tue Aug 26, 2014 1:43 pm

Re: SQL Manipulation exercises on VMart ?

Post by Benjamin_e » Wed Aug 27, 2014 9:45 pm

Thanks.

Post Reply

Return to “New to Vertica SQL”