MySQL Basic Syntax (billboard_top_100_1956_2013)

This is a tutorial how to use and learn basic syntax in MySQL using Billboard top 100 from the year of 1956 to 2013 dataset. after leaarning this you can perform simple query from a dataset. What you will learn inside this projects are :

• SELECT clause
• WHERE clause
• ALIASING
• LIMIT clause
• Comparison Operators to filter data (=, !=, >, <, >=, <= )
• Logical Operators to filter data (LIKE, IN, BETWEEN, IS NULL, AND, OR, NOT)
• using LIKE and wildcard to filter (%)
• Arithmetic in SQL ( +, -, *, (), / )
• Sorting your query with ORDER BY

INTERMEDIATE SQL

in this section iam exploring some dataset with intermediate use of SQL syntax

Aggregate Functions (aapl_historical_stock_price)

• AVG
• COUNT
• SUM
• MAX
• MIN
• DISTINCT

Grouping Data (aapl_historical_stock_price)

• GROUP BY
• HAVING
• Grouping set using GROUP BY
• WITH ROLLUP

Sorting Data (aapl_historical_stock_price)

• ORDER BY

Conditional Control Flow Functions and Expressions (fifa_20.players_data)

• CASE
• WHEN
• THEN
• ELSE
• PIVOTING technique
• IF
• IFNULL
• NULLIF

Joining Tables (crunchbase_companies & crunchbase_acquisitions)

• FULL OUTER JOIN (gak ada di mysql adanya di postgresql tapi bisa disimulasikan atau mendekati)
• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• LEFT OUTER JOIN
• RIGHT OUTER JOIN
• SQL Joins Using WHERE or ON
• CROSS JOIN
• SELF JOIN
• (ON VS USING clause)

Set Operators (crunchbase_investments_part1 & crunchbase_investments_part2)

• SQL Joins with Comparison Operators
• SQL JOINS ON MULTIPLE KEY
• SQL SELF JOINS
• UNION and UNION ALL
• INTERSECT
• MINUS/EXCEPT