Scribd
Upload
2 views15 pages

SQL Workshop: Joins and Table Management

The document outlines a series of tasks related to database management, including creating tables, inserting records, and executing various SELECT commands. It emphasizes the use of JOIN operations such as INNER JOIN, LEFT JOIN, and RIGHT JOIN to manage and query data from multiple tables. The tasks are structured to enhance understanding of SQL commands and database interactions.

Uploaded by

madhukar.in.oxford
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
2 views15 pages

SQL Workshop: Joins and Table Management

The document outlines a series of tasks related to database management, including creating tables, inserting records, and executing various SELECT commands. It emphasizes the use of JOIN operations such as INNER JOIN, LEFT JOIN, and RIGHT JOIN to manage and query data from multiple tables. The tasks are structured to enhance understanding of SQL commands and database interactions.

Uploaded by

madhukar.in.oxford
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

p

TASK # 85 – Worksho
Create the following table with fields.
p
TASK # 86 – Worksho
Insert the following records.
Insert some more grocery items as you wish. Keep it varied. Make
sure to enter the variety of values for item price and current
quantity
p
TASK # 87 – Using SELECT Worksho
Execute the following commands  discuss
p
TASK # 88 – Selecting from Multiple tables. Worksho
Create the following two tables  Id int.
p
TASK # 89 – Selecting from Multiple tables. Worksho
Execute the following commands

Notice the error


p
TASK # 90 – Using JOINS - INNER JOIN Worksho
p
TASK # 91 – Using JOINS - LEFT JOIN Worksho
Create the following two tables and execute the
Select command to get the names that don’t have
Any emails for them
p
TASK # 92 – Using JOINS - RIGHT JOIN Worksho
Execute the following SELECT with RIGHT JOIN to get
Only those names that have emails for them.

You might also like