Skip to content

Latest commit

 

History

History

0x0E-SQL_more_queries

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

0x0E. SQL - More Queries

This project explores SQL querying further. It covers concepts on:

  • 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