SQLGate GlobalinSQLGate[SQL Basic] Let’s learn some advanced JOIN queries!#20. Marketing/Data Analysis for BeginnersNov 5, 2018Nov 5, 2018
SQLGate GlobalinSQLGate[SQL Basic] Let’s learn some advanced CASE queries!#19. Marketing/Data Analysis for BeginnersOct 24, 2018Oct 24, 2018
SQLGate GlobalinSQLGate[SQL Basic] Let’s use some Numeric SQL functions — TRUNCATE, ROUND, MOD#18. Marketing/Data Analysis for BeginnersOct 19, 2018Oct 19, 2018
SQLGate GlobalinSQLGate[SQL BASIC] How to work with String Functions in SQL —My SQL CONCAT, LENGTH, SUBSTR#17. Marketing/Data Analysis for BeginnersOct 11, 2018Oct 11, 2018
SQLGate GlobalinSQLGate[SQL BASIC] How to work with Date Functions in SQL — SQL DATE_FORMAT, DATEDIFF#16. Marketing/Data Analysis for BeginnersOct 10, 2018Oct 10, 2018
SQLGate GlobalinSQLGate[SQL Basic] Let’s find customers that have rented movies priced $9.99! — SQL Subquery#15. Marketing/Data Analysis for BeginnersSep 29, 2018Sep 29, 2018
SQLGate GlobalinSQLGate[SQL Basic] Let’s check movie rentals by the inventory list! — SQL LEFT / RIGHT JOIN#14. Marketing/Data Analysis for BeginnersSep 17, 2018Sep 17, 2018
SQLGate GlobalinSQLGate[SQL Basic] Let’s find out the movie genres by joining tables! — SQL INNER JOIN#13. Marketing/Data Analysis for BeginnersSep 12, 2018Sep 12, 2018
SQLGate GlobalinSQLGate[SQL Basic] Let’s designate a value based on the rental duration. — SQL CASE#12. Marketing/Data Analysis for BeginnersSep 12, 2018Sep 12, 2018
SQLGate GlobalinSQLGate[SQL Basic] How many movies have the same rating?— SQL GROUP BY/HAVING#11. Marketing/Data Analysis for BeginnersSep 5, 2018Sep 5, 2018
![[SQL Basic] Let’s learn some advanced JOIN queries!](https://miro.medium.com/v2/resize:fill:160:106/1*jvD92VNbDD1uc-49WzD-ug.png)
![[SQL Basic] Let’s learn some advanced JOIN queries!](https://miro.medium.com/v2/resize:fill:320:214/1*jvD92VNbDD1uc-49WzD-ug.png)
![[SQL Basic] Let’s learn some advanced CASE queries!](https://miro.medium.com/v2/resize:fill:160:106/1*GywxPKF2KI6DZY9qF_fc_w.png)
![[SQL Basic] Let’s learn some advanced CASE queries!](https://miro.medium.com/v2/resize:fill:320:214/1*GywxPKF2KI6DZY9qF_fc_w.png)
![[SQL Basic] Let’s use some Numeric SQL functions — TRUNCATE, ROUND, MOD](https://miro.medium.com/v2/resize:fill:160:106/1*d_c4r3mhbmlJVLSOILSD0Q.png)
![[SQL Basic] Let’s use some Numeric SQL functions — TRUNCATE, ROUND, MOD](https://miro.medium.com/v2/resize:fill:320:214/1*d_c4r3mhbmlJVLSOILSD0Q.png)
![[SQL BASIC] How to work with String Functions in SQL —My SQL CONCAT, LENGTH, SUBSTR](https://miro.medium.com/v2/resize:fill:160:106/1*HHfgJ_wYyfuGGkW8cbF7Dw.png)
![[SQL BASIC] How to work with String Functions in SQL —My SQL CONCAT, LENGTH, SUBSTR](https://miro.medium.com/v2/resize:fill:320:214/1*HHfgJ_wYyfuGGkW8cbF7Dw.png)
![[SQL BASIC] How to work with Date Functions in SQL — SQL DATE_FORMAT, DATEDIFF](https://miro.medium.com/v2/resize:fill:160:106/1*x7Gj0PTrJ3I8nBDkqqN9DQ.png)
![[SQL BASIC] How to work with Date Functions in SQL — SQL DATE_FORMAT, DATEDIFF](https://miro.medium.com/v2/resize:fill:320:214/1*x7Gj0PTrJ3I8nBDkqqN9DQ.png)
![[SQL Basic] Let’s find customers that have rented movies priced $9.99! — SQL Subquery](https://miro.medium.com/v2/resize:fill:160:106/1*AnFmqqIaWhmxdWA28oOY4A.png)
![[SQL Basic] Let’s find customers that have rented movies priced $9.99! — SQL Subquery](https://miro.medium.com/v2/resize:fill:320:214/1*AnFmqqIaWhmxdWA28oOY4A.png)
![[SQL Basic] Let’s check movie rentals by the inventory list! — SQL LEFT / RIGHT JOIN](https://miro.medium.com/v2/resize:fill:160:106/1*1lK2sjZRKYmIBPHef7lKmQ.png)
![[SQL Basic] Let’s check movie rentals by the inventory list! — SQL LEFT / RIGHT JOIN](https://miro.medium.com/v2/resize:fill:320:214/1*1lK2sjZRKYmIBPHef7lKmQ.png)
![[SQL Basic] Let’s find out the movie genres by joining tables! — SQL INNER JOIN](https://miro.medium.com/v2/resize:fill:160:106/1*o4-dvB4johCbwPLvrj6x0Q.png)
![[SQL Basic] Let’s find out the movie genres by joining tables! — SQL INNER JOIN](https://miro.medium.com/v2/resize:fill:320:214/1*o4-dvB4johCbwPLvrj6x0Q.png)
![[SQL Basic] Let’s designate a value based on the rental duration. — SQL CASE](https://miro.medium.com/v2/resize:fill:160:106/1*SIPhaFDWp6ONDBb6pgX9eA.png)
![[SQL Basic] Let’s designate a value based on the rental duration. — SQL CASE](https://miro.medium.com/v2/resize:fill:320:214/1*SIPhaFDWp6ONDBb6pgX9eA.png)
![[SQL Basic] How many movies have the same rating?— SQL GROUP BY/HAVING](https://miro.medium.com/v2/resize:fill:160:106/1*IRttSs2Vu5YVSnbAktttqA.png)
![[SQL Basic] How many movies have the same rating?— SQL GROUP BY/HAVING](https://miro.medium.com/v2/resize:fill:320:214/1*IRttSs2Vu5YVSnbAktttqA.png)
