While SQL is a powerful language for managing data, it also has many intermediate concepts that can be used to create more complex and nuanced queries. Example of such include Joins, Subqueries , Aggregate Functions Window Functions, Views and Stored Procedures Lets explore the most common of them in this project.
- How to create a new user and assing permission in MySQL
- How to use MySQL GRANT statement to assign permissions to users
- MySQL constraits
- SQL techniques: subqueries
- SQL techniques: join
- SQL techniqes: multiple joins and the disctint keyword
- SQL techniques: join types
- SQL techniques: unions and minus
- MySQL cheatsheet
- Seven Join types
- MySQL tutorial
- SQL style guide
- MySQL 8.0 statement syntax
Extra resources around relational database model design
By the end of this project, you are expected to be able to explain to anyone without the help of Google
- How to create a new MySQL user
- How to manage privileges for a user to a database or table
- What is a
PRIMARY KEY - What’s a
FOREIGN KEY - How to use
NOT NULLandUNIQUEconstraints - How to retrieve datas from multiple tables in one request
- What are subqueries
- What are JOIN and UNION
$ echo "CREATE DATABASE hbtn_0d_tvshows;" | mysql -uroot -p
Enter password:
$ curl "https://s3.amazonaws.com/intranet-projects-files/holbertonschool-higher-level_programming+/274/hbtn_0d_tvshows.sql" -s | mysql -uroot -p hbtn_0d_tvshows
Enter password:
$ echo "SELECT * FROM tv_genres" | mysql -uroot -p hbtn_0d_tvshows
Enter password:
id name
1 Drama
2 Mystery
3 Adventure
4 Fantasy
5 Comedy
6 Crime
7 Suspense
8 Thriller
$
