3 of 3 - SQL Joins, INNER JOIN, RIGHT JOIN, LEFT JOIN - WHERE LIKE and ORDER BY
Series about basic SQL commands with examples. Showing how to use Mockaroo.com to create SQL scripts and adding them to your database.
Playlist:
• SQL Language Basics
Examples in T-SQL in a MSSQL(Microsoft SQL) server using Azure Data Studio.
Mock data from:
https://www.mockaroo.com/
Microsoft Azure Data Studio (free):
https://docs.microsoft.com/en-us/sql/...
1 of 3 - SQL Language CREATE, DROP, ALTER
• 1 of 3 - SQL Language CREATE, DROP, ALTER
Shows the basics of working with meta-data or "data about data". That is :
column names
data types
constraints
keys
foreign keys
auto-increment keys
2 of 3 - SQL Language SELECT, INSERT, UPDATE, DELETE, WHERE
• 2 of 3 - SQL Language SELECT, INSERT, UPDA...
The basics of manipulating the data itself. That is:
SELECT (reading data)
INSERT (adding data)
UPDATE (changing existing data)
DELETE (removing data)
Also showing simple WHERE clauses to limit the amount of rows selected.
3 of 3 - SQL Joins, INNER JOIN, RIGHT JOIN, LEFT JOIN - WHERE LIKE and ORDER BY
• 3 of 3 - SQL Joins, INNER JOIN, RIGHT JOIN...
How to join multiple tables on a common value. Explaining the difference between INNER, LEFT and RIGHT Joins.
Short description of usage of WHERE clauses with AND/OR and LIKE with single and multiple wildcard search.