SQLGate

[SQL Basic] Let’s learn some advanced JOIN queries!

[SQL Basic] Let’s learn some advanced CASE queries!

[SQL Basic] Let’s use some Numeric SQL functions — TRUNCATE, ROUND, MOD

[SQL BASIC] How to work with String Functions in SQL —My SQL CONCAT, LENGTH, SUBSTR

[SQL BASIC] How to work with Date Functions in SQL — SQL DATE_FORMAT, DATEDIFF

[SQL Basic] Let’s find customers that have rented movies priced $9.99! — SQL Subquery

[SQL Basic] Let’s check movie rentals by the inventory list! — SQL LEFT / RIGHT JOIN

[SQL Basic] Let’s find out the movie genres by joining tables! — SQL INNER JOIN