Which SQL should I learn?

[#1]

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.

[lakshmikandh]

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

[ramasaisaksoft]

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.

[sushil353]

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

[Anil_Babu_Samineni]

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

[jagan]

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.

[varshavig12]

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!!

[nagarjuna_kotha]

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

[#9]

select

where

order by

group by

having

sub query

date manipulation

find duplication

join with vendaigram

[Peter_Cammaert]

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.