Company Database Querying with MySQL

Motivation

• Practice SQL skills and provide practice questions for those interested in practicing as well.
• Part 1 practice questions (without answers) can be found here: https://docs.google.com/document/d/1wHtlfSbibD5bSNZhXw0ew0O5rjB6QuzH/edit?usp=sharing&ouid=117052082356687062065&rtpof=true&sd=true
• Part 2 practice questions (without answers) can be found here: https://docs.google.com/document/d/1jIazdzfGXyFCBDHa4134EUQRvczSQK5g/edit?usp=sharing&ouid=117052082356687062065&rtpof=true&sd=true

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

• Email: cityofbrittany@gmail.com
• LinkedIn: linkedin.com/in/brittanycity