Most job descriptions for data analyst roles at Indian startups and MNCs list SQL as a non-negotiable skill. You do not need a computer science degree to start — you need a laptop, an internet connection, and a structured practice plan. This guide walks you through exactly what to learn, which tools Indian companies actually use, common mistakes that waste weeks of practice, and how to build a portfolio that impresses recruiters. By the end, you will have a realistic 12-week roadmap tailored to Indian placement timelines.
E
v
e
r
y
b
u
s
i
n
e
s
s
s
t
o
r
e
s
i
t
s
t
r
a
n
s
a
c
t
i
o
n
s
,
u
s
e
r
a
c
t
i
v
i
t
y
,
a
n
d
i
n
v
e
n
t
o
r
y
i
n
r
e
l
a
t
i
o
n
a
l
d
a
t
a
b
a
s
e
s
.
A
n
a
l
y
s
t
s
m
u
s
t
p
u
l
l
i
n
s
i
g
h
t
s
f
r
o
m
t
h
e
s
e
d
a
t
a
b
a
s
e
s
b
e
f
o
r
e
a
n
y
v
i
s
u
a
l
i
z
a
t
i
o
n
o
r
m
a
c
h
i
n
e
l
e
a
r
n
i
n
g
h
a
p
p
e
n
s
.
I
n
I
n
d
i
a
,
c
o
m
p
a
n
i
e
s
l
i
k
e
I
n
f
o
s
y
s
,
W
i
p
r
o
,
a
n
d
f
i
n
t
e
c
h
f
i
r
m
s
s
u
c
h
a
s
P
h
o
n
e
P
e
u
s
e
P
o
s
t
g
r
e
S
Q
L
a
n
d
M
y
S
Q
L
f
o
r
d
a
i
l
y
r
e
p
o
r
t
i
n
g
.
A
2
0
2
5
N
A
S
S
C
O
M
r
e
p
o
r
t
n
o
t
e
d
t
h
a
t
o
v
e
r
7
0
p
e
r
c
e
n
t
o
f
e
n
t
r
y
-
l
e
v
e
l
a
n
a
l
y
t
i
c
s
r
o
l
e
s
r
e
q
u
i
r
e
b
a
s
i
c
q
u
e
r
y
f
l
u
e
n
c
y
.
L
e
a
r
n
i
n
g
S
E
L
E
C
T
,
W
H
E
R
E
,
a
n
d
J
O
I
N
o
p
e
r
a
t
i
o
n
s
f
i
r
s
t
l
e
t
s
y
o
u
a
n
s
w
e
r
r
e
a
l
b
u
s
i
n
e
s
s
q
u
e
s
t
i
o
n
s
w
i
t
h
i
n
t
w
o
w
e
e
k
s
,
m
a
k
i
n
g
y
o
u
p
r
o
d
u
c
t
i
v
e
f
a
s
t
e
r
t
h
a
n
l
e
a
r
n
i
n
g
P
y
t
h
o
n
o
r
R
f
r
o
m
s
c
r
a
t
c
h
.
S
t
a
r
t
w
i
t
h
K
h
a
n
A
c
a
d
e
m
y
'
s
f
r
e
e
S
Q
L
c
o
u
r
s
e
,
t
h
e
n
m
o
v
e
t
o
S
Q
L
Z
o
o
a
n
d
M
o
d
e
A
n
a
l
y
t
i
c
s
'
i
n
t
e
r
a
c
t
i
v
e
t
u
t
o
r
i
a
l
s
.
F
o
r
s
t
r
u
c
t
u
r
e
d
p
r
a
c
t
i
c
e
,
u
s
e
H
a
c
k
e
r
R
a
n
k
'
s
S
Q
L
t
r
a
c
k
w
h
i
c
h
m
a
n
y
I
n
d
i
a
n
p
l
a
c
e
m
e
n
t
c
e
l
l
s
r
e
c
o
m
m
e
n
d
.
B
u
d
g
e
t
c
o
n
s
t
r
a
i
n
t
i
s
r
e
a
l
f
o
r
m
o
s
t
I
n
d
i
a
n
s
t
u
d
e
n
t
s
,
s
o
a
v
o
i
d
p
a
i
d
p
l
a
t
f
o
r
m
s
i
n
i
t
i
a
l
l
y
.
P
r
a
c
t
i
c
e
o
n
p
u
b
l
i
c
l
y
a
v
a
i
l
a
b
l
e
d
a
t
a
s
e
t
s
f
r
o
m
d
a
t
a
.
g
o
v
.
i
n
—
t
h
e
I
n
d
i
a
n
g
o
v
e
r
n
m
e
n
t
o
p
e
n
-
d
a
t
a
p
o
r
t
a
l
.
D
e
d
i
c
a
t
e
o
n
e
h
o
u
r
d
a
i
l
y
f
o
r
1
2
w
e
e
k
s
.
W
e
e
k
o
n
e
c
o
v
e
r
s
S
E
L
E
C
T
a
n
d
W
H
E
R
E
.
W
e
e
k
s
t
w
o
t
h
r
o
u
g
h
f
o
u
r
t
a
c
k
l
e
J
O
I
N
s
a
c
r
o
s
s
m
u
l
t
i
p
l
e
t
a
b
l
e
s
.
W
e
e
k
s
f
i
v
e
t
h
r
o
u
g
h
s
e
v
e
n
i
n
t
r
o
d
u
c
e
G
R
O
U
P
B
Y
a
n
d
a
g
g
r
e
g
a
t
e
f
u
n
c
t
i
o
n
s
.
W
e
e
k
s
e
i
g
h
t
t
h
r
o
u
g
h
t
w
e
l
v
e
c
o
v
e
r
s
u
b
q
u
e
r
i
e
s
,
w
i
n
d
o
w
f
u
n
c
t
i
o
n
s
,
a
n
d
p
e
r
f
o
r
m
a
n
c
e
b
a
s
i
c
s
.
T
h
e
b
i
g
g
e
s
t
m
i
s
t
a
k
e
i
s
w
a
t
c
h
i
n
g
t
u
t
o
r
i
a
l
s
w
i
t
h
o
u
t
w
r
i
t
i
n
g
q
u
e
r
i
e
s
.
T
y
p
e
e
v
e
r
y
c
o
m
m
a
n
d
y
o
u
r
s
e
l
f
.
T
h
e
s
e
c
o
n
d
e
r
r
o
r
i
s
s
k
i
p
p
i
n
g
s
u
b
q
u
e
r
i
e
s
a
n
d
C
T
E
s
—
t
h
e
s
e
a
p
p
e
a
r
i
n
a
l
m
o
s
t
e
v
e
r
y
I
n
d
i
a
n
a
n
a
l
y
t
i
c
s
i
n
t
e
r
v
i
e
w
a
t
c
o
m
p
a
n
i
e
s
l
i
k
e
T
a
t
a
D
i
g
i
t
a
l
a
n
d
M
e
e
s
h
o
.
T
h
i
r
d
,
s
t
u
d
e
n
t
s
i
g
n
o
r
e
d
a
t
a
c
l
e
a
n
i
n
g
s
t
e
p
s
.
R
e
a
l
I
n
d
i
a
n
d
a
t
a
s
e
t
s
h
a
v
e
m
e
s
s
y
p
h
o
n
e
n
u
m
b
e
r
s
,
i
n
c
o
n
s
i
s
t
e
n
t
s
t
a
t
e
n
a
m
e
s
,
a
n
d
d
u
p
l
i
c
a
t
e
r
o
w
s
.
P
r
a
c
t
i
c
e
w
r
i
t
i
n
g
T
R
I
M
,
R
E
P
L
A
C
E
,
a
n
d
C
A
S
E
s
t
a
t
e
m
e
n
t
s
e
a
r
l
y
.
F
o
u
r
t
h
,
n
o
t
r
e
a
d
i
n
g
e
x
e
c
u
t
i
o
n
p
l
a
n
s
.
W
h
e
n
q
u
e
r
i
e
s
s
l
o
w
d
o
w
n
o
n
l
a
r
g
e
t
a
b
l
e
s
,
E
X
P
L
A
I
N
A
N
A
L
Y
Z
E
b
e
c
o
m
e
s
e
s
s
e
n
t
i
a
l
.
F
i
n
a
l
l
y
,
m
e
m
o
r
i
z
i
n
g
s
y
n
t
a
x
w
i
t
h
o
u
t
u
n
d
e
r
s
t
a
n
d
i
n
g
b
u
s
i
n
e
s
s
c
o
n
t
e
x
t
m
a
k
e
s
y
o
u
f
a
i
l
p
r
a
c
t
i
c
a
l
a
s
s
e
s
s
m
e
n
t
s
.
C
r
e
a
t
e
t
h
r
e
e
t
o
f
i
v
e
p
r
o
j
e
c
t
s
o
n
G
i
t
H
u
b
.
F
i
r
s
t
p
r
o
j
e
c
t
:
a
n
a
l
y
z
e
I
n
d
i
a
n
e
-
c
o
m
m
e
r
c
e
s
a
l
e
s
d
a
t
a
u
s
i
n
g
M
y
S
Q
L
,
w
r
i
t
e
a
R
E
A
D
M
E
w
i
t
h
b
u
s
i
n
e
s
s
i
n
s
i
g
h
t
s
.
S
e
c
o
n
d
:
b
u
i
l
d
a
Z
o
m
a
t
o
r
e
s
t
a
u
r
a
n
t
r
a
t
i
n
g
s
d
a
s
h
b
o
a
r
d
u
s
i
n
g
P
o
s
t
g
r
e
S
Q
L
.
T
h
i
r
d
:
u
s
e
t
h
e
I
P
L
d
a
t
a
s
e
t
f
r
o
m
K
a
g
g
l
e
a
n
d
w
r
i
t
e
q
u
e
r
i
e
s
t
h
a
t
a
n
s
w
e
r
q
u
e
s
t
i
o
n
s
l
i
k
e
t
o
p
r
u
n
-
s
c
o
r
e
r
s
b
y
v
e
n
u
e
.
H
o
s
t
e
a
c
h
p
r
o
j
e
c
t
w
i
t
h
a
o
n
e
-
p
a
g
e
P
D
F
s
u
m
m
a
r
y
.
S
h
a
r
e
o
n
L
i
n
k
e
d
I
n
w
i
t
h
h
a
s
h
t
a
g
s
l
i
k
e
#
D
a
t
a
A
n
a
l
y
s
t
I
n
d
i
a
a
n
d
#
S
Q
L
P
r
o
j
e
c
t
s
.
M
a
n
y
I
n
d
i
a
n
r
e
c
r
u
i
t
e
r
s
c
h
e
c
k
G
i
t
H
u
b
a
c
t
i
v
i
t
y
d
u
r
i
n
g
s
h
o
r
t
l
i
s
t
i
n
g
—
c
o
n
s
i
s
t
e
n
t
c
o
m
m
i
t
s
s
i
g
n
a
l
r
e
l
i
a
b
i
l
i
t
y
m
o
r
e
t
h
a
n
c
e
r
t
i
f
i
c
a
t
e
s
a
l
o
n
e
.
SQL alone qualifies you for junior analyst and reporting roles at mid-size Indian firms. Pairing it with Excel, basic Python, and one visualization tool like Power BI or Tableau significantly expands your options and starting salary range.
With one hour of daily focused practice, most students reach interview readiness in 10 to 12 weeks. Consistency matters more than marathon sessions — Indian placement seasons reward steady daily progress over last-minute cramming.
Start with MySQL since most Indian companies use it. After building confidence, learn PostgreSQL syntax — it powers analytics teams at Flipkart and Razorpay. Both are free and run locally with Docker or directly on Ubuntu.
Yes. Companies like TCS, Cognizant, and fintech startups give timed SQL assessments during campus placement rounds. Expect questions on JOINs, GROUP BY, subqueries, and one scenario-based optimization problem on a realistic dataset.
Entry-level data analyst roles in Tier 1 Indian cities typically offer 4 to 7 LPA depending on the company, your internship experience, and additional skills like Python or Power BI. Remote roles at startups sometimes offer comparable packages.
Absolutely. AI tools help write faster, but understanding query logic lets you validate results, optimize performance on large tables, and debug errors. Interviewers test your reasoning, not just the final query output.
Free to start · 100% online · Verified certificates