topic Re: Which SQL should I learn? in QlikView

Which SQL should I learn?

Wed, 25 Nov 2020 16:16:04 GMT

Hi, I am new to qlikview and am learning it from the tutorials. I heard that I need to learn SQL as well to use it in advanced stage. Please let me know which SQL I should learn, I mean MS SQL or Oracle SQL or may be some other. Thanks.

Re: Which SQL should I learn?

lakshmikandh — Wed, 28 Sep 2016 18:45:11 GMT

Hi,

MS/Oracle depends on the project you work for, in general learn ANSI SQL which will be same in all the databases.

SQL Tutorial

Thanks,

Lakshmikandh

Re: Which SQL should I learn?

ramasaisaksoft — Thu, 29 Sep 2016 06:54:28 GMT

Hi Susanta Pardhan,

Pre-requisites to learn QV

----> Database Concepts (any flavor of data base like MS sql server,Oracle,My Sql,...etc.it will depends on Project you need to work at real time Up to Joins)

---->Data ware house concepts (basics of schema)

---->Qlikview Full(Development,Design)

----> Qlikview server (Optional)

For any other queries feel free to reach me 8376964364 / ramasaiqvw@gmail.com

All the best for your better future.

Re: Which SQL should I learn?

sushil353 — Thu, 29 Sep 2016 07:01:18 GMT

hi spradhan‌,

It is totally depend on the database that your are going to connect with qlikview.

Other wise if you know the basic sql concept then you are good to go ..

I would recommend to go through sql learning from W3school..

HTH

sushil

Re: Which SQL should I learn?

Anil_Babu_Samineni — Thu, 29 Sep 2016 07:05:07 GMT

How do we know which project they are using which database. Because, my database is db2, sap, mysql, sql server, mongodb, oracle

If client want to user oracle then you need to learn oracle via Qlikview. Best practice w3schools

If client required different resource then you need to learn that part as well. Bit help if you know basics of sql suck as joins, concatenate, group by, having.

Anyway, welcome to Qlikview. Hope you will rocking.

Don't forget to put helpful or correct answer from actions of the reply the bottom of left.

Good luck

Re: Which SQL should I learn?

jagan — Thu, 29 Sep 2016 08:26:53 GMT

You can learn any database like Oracle, SQL Server, MY SQL etc. You should should all the flavors of SELECT Query like GROUP BY, WHERE, JOINS etc.

Regards,

jagan.

Re: Which SQL should I learn?

varshavig12 — Thu, 29 Sep 2016 08:43:06 GMT

Learn anything,

Only the concept is important.

Also, you can learn it from anywhere, like w3 school, tutorials point.

Just keep you concepts clear!

All the best!!

Re: Which SQL should I learn?

nagarjuna_kotha — Thu, 29 Sep 2016 08:44:16 GMT

Mostly you ll get chance use below one's:

1.Left Join and Keep

2.Right Join and Keep

3.Inner Join and Keep

4.Join and Keep

5. Select Statement

6.where clause

7.Order By

8 Like

Etc...

I hope this may helps you...

-Nagarjun

Re: Which SQL should I learn?

Thu, 29 Sep 2016 18:22:33 GMT

select

where

order by

group by

having

sub query

date manipulation

find duplication

join with vendaigram

Re: Which SQL should I learn?

Peter_Cammaert — Thu, 29 Sep 2016 21:11:14 GMT

You could restrict yourself to learning ANSI SQL. Oracle adheres pretty well to the ANSI standard, MS not so much. But in the end, it will be a good foundation for when you finally start your first project and learn about the actual DB to use. Then you can pick up the various extensions/differences.