0x00. MySQL advanced

📂 Specializations ― Back-end Engineer 👤 by Guillaume Plessis, Senior Cloud & System Engineer at WeWork and Guillaume, CTO at Holberton school
©️ Holberton School
🔖

Resources

Read or watch:

• MySQL cheatsheet
• MySQL Performance: How To Leverage MySQL Database Indexing
• Stored Procedure
• Triggers
• Views
• Functions and Operators
• Trigger Syntax and Examples
• CREATE TABLE Statement
• CREATE PROCEDURE and CREATE FUNCTION Statements
• CREATE INDEX Statement
• CREATE VIEW Statement
• Calculate-Weighted-Average

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 tables with constraints
• How to optimize queries by adding indexes
• What is and how to implement stored procedures and functions in MySQL
• What is and how to implement views in MySQL
• What is and how to implement triggers in MySQL

Requirements

• A README.md file.

Tasks

• 0. We are all unique!
• 1. In and not out
• 2. Best band ever!
• 3. Old school band
• 4. Buy buy buy
• 5. Email validation to sent
• 6. Add bonus
• 7. Average score
• 8. Optimize simple search
• 9. Optimize search and score
• 10. Safe divide
• 11. No table for a meeting
• 12. Average weighted score
• 13. Average weighted score for all!

Software Engineer

Rotimi Adebowale Owolabi :octocat: GitHub