SAURABH SKILLS BLOG

 SQL

SKILL : SQL

SQL Links:

Complete Sql Roadmap 2023 : SQLROADMAPLINK

SQL BASE : 

1. Intro to SQL
2. Integrity Constraints
3. Functions
4. Where Clause
5. Joins 
6. Case-When Statement
7. Group by
8. Order by
9. Sub Queries
10. Union, Union All
11. Views
12. Common Table Expression
13. Windows Functions
14. Pivot Table
15. Bonus Topics

_____________________________________________________________________

---------------------------- # Morning : 8- 9am and Evening : 9-10pm # ---------------------------

Ankit Bansal Playlist : Youtube

Video 4 : SQL Top 10 Interview Questions 

Question 1 : How to Find duplicate in given table ?

Question 2 : How to delete duplicates ?

Question 3 : Difference between Union and Union All ?

Question 4 : Difference between  RANK,DENSE_RANK,ROW_NUMBER

Numbering Functions Rank Dense Rank Row Number

-- RANK() => is Skipped (Skips Numbers)

-- DENSE_Rank is not Skipped (Not Skips Numbers)

 -- ROW_NUMBER=> (Running Number)

Query=> 

select emp_id, emp_name, department_id,salary,

RANK() over (order by salary desc) as rnk,

DENSE_RANK() over (order by salary desc) as dense_rnk,

ROW_NUMBER() over (order by salary desc) as rn  

from emp

_____________________________________________________________________________\

Python Language for Data Engineer

 Python till date :

Python Base from where I got knowledge

1. Python Basic : Amol Bhavsar Sir
2. Celebal training
3. Course: Data with darshil i.e python for de
4. Python FBS : nilesh sir
5. Celebal Bootcamp

____________________________________________________________________________________

Python Notes Plannings:

 Python For Data Engineering => Preparing Python Structured Notes 

(Plannings=> 

•  Bootcamp Notes (Rishab pandey ) [Class Dates: 3,4,5,6 September] 
•  Darshil Parmar Python Course for Data engineer
•  Celebal Python COE Course Notes by Naval Yemul
•  Fuel Python Course by Nilesh Somkule
•  Mix and make structured Blog for Python Data Engineering [1,2,3,4]
•  Post on Linked In  

)

Estimate Data to Complete this Course and Notes by => 7 September 2024 , Sunday .

Steps to Complete This Python Notes:

PLATFORM => Databricks

1. Python Fuel Notes
2. Python From Darshil Parmar
3. Python From Bootcamp
4. Python From Amol Bhavsar Notes

# Technical Skills

Tech Skills:

• python
• sql  : Daily 2 hours (morning: 7:45 - 9:00=> Update Knowledge) (Evening:9:00-10:00 => Basic and Revison)
• AI
• DE

New Skill to Learn :

• GitHub
• Power BI

Celebal :

• Pyspark
• Databricks

SQL:

 Morning [1 Hour]: Update Knowledge,Practice

Complete Sql Roadmap : SQLROADMAPLINK

SQl Till Date :

Base from where I got knowledge :

1. Sql basic : Amol Bhavsar sir
2. Celebal training: naval yemul

Evening [ 1 Hour] : Revise and Basics 

•  w3 School=> Refer
• Notes : Make your own in SQL Learning All About SQL

   

Links:

Sql Imp ques video

Sql 5 free resources (best >3,5)

SQL W3 Schools :---->>> Link  

PySpark: 

 Best Playlist 1:50 hour

Pyspark  📒 : Pyspark

DataBricks

1: Start New >> Try Databricks free  : Link

2: Data Bricks Login : Link

3: Best Youtube Playlist  : Youtube_playlist

(simple+ hindi+ laymans language) 

    

     Azure databricks intro :Playlist