Skip to content

Latest commit

 

History

History
10 lines (10 loc) · 453 Bytes

File metadata and controls

10 lines (10 loc) · 453 Bytes

0x0E. SQL - More queries

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

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