SQL – More queries

Resources

Read or watch:

• How To Create a New User and Grant Permissions in MySQL
• How To Use MySQL GRANT Statement To Grant Privileges To a User
• MySQL constraints
• SQL technique: subqueries
• Basic query operation: the join
• SQL technique: multiple joins and the distinct keyword
• SQL technique: join types
• SQL technique: union and minus
• MySQL Cheat Sheet
• The Seven Types of SQL Joins
• MySQL Tutorial
• SQL Style Guide
• MySQL 8.0 SQL Statement Syntax

Extra resources around relational database model design:

• Design
• Normalization
• ER Modeling

Learning Objectives

At the end of this project, you are expected to be able to explain to anyone, without the help of Google:

General

• How to create a new MySQL user
• How to manage privileges for a user to a database or table
• What’s a PRIMARY KEY
• What’s a FOREIGN KEY
• How to use NOT NULL and UNIQUE constraints
• How to retrieve datas from multiple tables in one request
• What are subqueries
• What are JOIN and UNION