If you are trying to transition into the data analytics domain and getting started with SQL, focus on the most useful concept that will help you solve the majority of the problems, and then try to learn the rest of the topics:

👉🏻 Basic Aggregation function:
1️⃣ AVG
2️⃣ COUNT
3️⃣ SUM
4️⃣ MIN
5️⃣ MAX

👉🏻 JOINS
1️⃣ Left
2️⃣ Inner
3️⃣ Self (Important, Practice questions on self join)

👉🏻 Windows Function (Important)
1️⃣ Learn how partitioning works
2️⃣ Learn the different use cases where Ranking/Numbering Functions are used? ( ROW_NUMBER,RANK, DENSE_RANK, NTILE)
3️⃣ Use Cases of LEAD & LAG functions
4️⃣ Use cases of Aggregate window functions

👉🏻 GROUP BY
👉🏻 WHERE vs HAVING
👉🏻 CASE STATEMENT
👉🏻 UNION vs Union ALL
👉🏻 LOGICAL OPERATORS

Other Commonly used functions:
👉🏻 IFNULL
👉🏻 COALESCE
👉🏻 ROUND
👉🏻 Working with Date Functions
1️⃣ EXTRACTING YEAR/MONTH/WEEK/DAY
2️⃣ Calculating date differences

👉🏻CTE
👉🏻Views & Triggers (optional)


✅Share with credits: https://t.me/codingdidi

❤️Hope it helps :) 😃

Hi all,

Here's the link for pandas day-4 video.


English :- https://youtu.be/UaoseR5HnUY?si=7jz5SRkaoNzrIb1U


Hindi:-
https://youtu.be/jQTKaqRjVos?si=9k9XGnv7nobEDQZT


I'm waiting for you all in the comment section.


✅Share it with your fellow learners.


Follow @codingdidi

American Express is hiring for a Data Analyst!

https://aexp.eightfold.ai/careers?pid=21324925

Paytm is hiring for a Data Scientist (Product Analytics)!

https://jobs.lever.co/paytm/4850b2c2-0045-458b-9c43-3b50cc4bb4cc

Like for more ❤️

All the best 👍👍

Hi, all
here's the roadmap for learning EXCEL with free resources.


INSTAGRAM:- https://www.instagram.com/reel/C6X8J-yLNSW/?igsh=MWwxZHI1Z3pzbWJvZw==



✅FOLLOW @CODINGDIDI

👉Freshers jobs opportunity:

https://www.linkedin.com/feed/update/urn:li:share:7190925456852815872/

✅Follow @codingdidi

HI, all


Pandas day-5 video is live..!



👉Looking for your love and comments on videos...!


Go check out the video 📸



Hindi:- https://youtu.be/4NTWYUeuSWM?si=M6WYYY5K_azhjYk2


English :-

https://youtu.be/CrvY0QIURyg?si=TQDzMXCl8QLnANWY




✅Follow @Codingdidi

NTT DATA is hiring!
Position: Data Analyst
Experience: Entry Level
Location: Hyderabad, India

https://nttdata.eightfold.ai/careers?pid=563327918064034&domain=nttdata.com


✅Follow @Codingdidi

Make your journey easier by accelerating your learning.


Learn these libraries of python.

Follow @codingdidi.

:-More likes👍 more posts 😀-:

Hi, all

Here's the python roadmap !


https://www.instagram.com/reel/C6agoDarrij/?igsh=bHV6b3Awem4wenJ4


Follow @codingdidi

Hi, all


Another pandas long video is out on my yt channel.

Here are the link.


English:-

https://youtu.be/DYSAc3Pmzwo?si=-zz7PM46j6PsUDVt



Hindi:- https://youtu.be/r9H6ybaLWv4?si=gjIm3xD1NTWkitzD

Go and check out the video.


Don't forget to subscribe and hit the 🔔 bell icon ☺️.


Follow @codingdidi

Hi all, I need your help.

I'm looking for a free tool using which I can automate the comments. 😅 As it's getting really difficult to revert back on each comment. Instagram is also restricting the commenting.


If anyone of you can help that would be really appreciated. 😇

THIS IS WHAT POPS UP.

Hi all here's the roadmap for learning pandas in 2024 for data analyst and data scientist role.


Follow @codingdidi.

Marsh McLennan Off Campus Hiring Fresher For Analyst
Location : Pune
Qualification : B.E/B.Tech/M.E/M.Tech/MCA
Work Experience : Fresher - 1 year
CTC : 4 - 5 LPA

Apply Link : https://careers.marshmclennan.com/global/en/job/R_266528/Analyst-Implementation-Services


✅Follow @codingdidi

Hi, all


Here's how you can learn pandas for data analysis for free using the video tutorials.



English:- https://youtube.com/playlist?list=PLEt4gT_dNBREyKgqdj0o-W5FHXHPOPu6m&si=3HD68egMdtE412tU


Hindi
https://youtube.com/playlist?list=PL94h_jWyE-kBtP40nxsYnXNTEu8pjKQZX&si=IiDfPDChtYAxT8sd


Don't forget to add your views in the comment section.

🎯 Hit like, and subscribe button for more videos on yt.


Note:- This week I'm posting regular videos on YT about pandas.

✅Follow @codingdidi

Access the GitHub repo for the codes

https://github.com/Akansha-yadav24/Learn-python-pandas-in-2024.git

Here you go with pandas 1 min concepts(which I share on insta reel)


https://github.com/Akansha-yadav24/Pandas-1-min-concepts.git



🫵More likes😍 more posts and resources 😇