Skip to content

Latest commit

 

History

396 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Here is where I document SQL journey. This is where I upload exercises from different sources such as Job Ready SQL, W3, and others.

natural join, using, Subquery, add data to script, cd, mysqldump

Some important commands to review:

SELECT, INSERT, UPDATE, DELETE, JOIN GRANT, REVOKE, transaction controls

Basics to review:

Query a Database: FROM, ORDER BY, SELECT

Apply Filters: AND, OR, BETWEEN, =, >, >=, <=, LIKE, NOT, <>, !=, % (wildcard), _ (wildcard), WHERE

Join tables: FULL OUTER JOIN, INNER JOIN, LEFT JOIN, RIGHT JOIN

Perform Calculations: AVG, COUNT, SUM

About

No description, website, or topics provided.

Resources

Stars

0 stars

Watchers

1 watching

Forks

Releases

Packages

Contributors