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.
SQL Manipulation exercises on VMart ?
Moderator: NorbertKrupa
-
- Newbie
- Posts: 15
- Joined: Tue Aug 26, 2014 1:43 pm
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: SQL Manipulation exercises on VMart ?
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.
-
- Newbie
- Posts: 15
- Joined: Tue Aug 26, 2014 1:43 pm