Skip to content

Latest commit

 

History

History
19 lines (16 loc) · 1.06 KB

README.md

File metadata and controls

19 lines (16 loc) · 1.06 KB

Company Database Querying with MySQL

Motivation

SQL Topics Covered

  • SELECT/SELECT DISTINCT, ALIAS
  • Filtering: WHERE, AND, OR, NOT, HAVING, BETWEEN, IN, LIKE, Wildcards, ANY, ALL
  • Grouping: GROUP BY
  • Sorting: ORDER BY
  • Modifying Tables: CREATE TABLE, INSERT INTO, UPDATE, DELETE
  • Aggregations: MAX, MIN, AVG, SUM, COUNT, COUNT DISTINCT
  • Joining: INNER JOIN, SELF JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, UNION

Contact