SQL More Queries

Resources

Read or watch:

• SQL-Commands-Cheat-Sheet

• SQL technique: subqueries

• MySQL constraints

• 7 types of SQL JOINs

• Derek Banas Tutorial 😋

• 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

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
• Copyright - Plagiarism
• You are tasked to come up with solutions for the tasks below yourself to meet with the above learning objectives.
• You will not be able to meet the objectives of this or any following project by copying and pasting someone else’s work.
• You are not allowed to publish any content of this project.
• Any form of plagiarism is strictly forbidden and will result in removal from the program.

Requirements

General

• Allowed editors: vi, vim, emacs
• All your files will be executed on Ubuntu 20.04 LTS using MySQL 8.0 (version 8.0.25)
• All your files should end with a new line
• All your SQL queries should have a comment just before (i.e. syntax above)
• All your files should start by a comment describing the task
• All SQL keywords should be in uppercase (SELECT, WHERE…)
• A README.md file, at the root of the folder of the project, is mandatory
• The length of your files will be tested using wc

Author

@ UDO INNOCENT CHARLES