Topics to Cover in SQL cont.

892o...qf72
10 Oct 2022
3


SQL is a fundamental form a foundational part of data analysis, because it allows us to extract data from a database. This topics will enlighten you on how to retrieve and filter data using basic SQL Syntax, Transform data with the use of numerical,date and text functions, also you understand essential terminology related to SQL, databases and data warehouses. 


Cont.: Topics to Cover in SQL

Basics of Select Statements 

Select 
 Aliases 
 Where 
 And 
 Or 
 Like-Not Like 
 Between-And 
 Is null-Is Not Null 
 Distinct 
 Order By 
 Limit Exists-Not Exists 
Subqueries 
If
 Case


Aggregations

Group By 
 Having 
 Count
Sum 
 Min & Max 
 Avg 
 Round 
 If null
Coalesce


Joins 

Inner Join
Left Join 
 Right Join 
 Cross Join 
 Self Join 
 Union 
 Union All


Window Functions 

Row number 
Partition 
Rank & Dense Rank 
Lag & Lead



Other Topics

Stored Procedures 
User-defined Function 
Triggers


Learning this topics will ensure your confident in conversations and in interviews talking about this concept, and even when working or manipulating your data.









References 

[1] BULB, 'Write to Earn. Read to Earn' (online, 2022) <https://www.bulbapp.io/>

Write & Read to Earn with BULB

Learn More

Enjoy this blog? Subscribe to Orthodox 🔶

0 Comments

B
No comments yet.