Skip to content
/ SQL-Query Public

This project highlights my ability to write complex SQL queries for retrieving and manipulating data from databases. The queries demonstrate my expertise in database management, data analysis, and the use of SQL for various cybersecurity tasks.

0 stars 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

owlSignal/SQL-Query

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
README.md
README.md
 
 
SQL Joins.md
SQL Joins.md
 
 

Repository files navigation

BOOKSTORE Database Structure and SQL Queries

Database Schema

Tables and Columns

  1. Author

    • authorid
    • authorname

  2. Customer

    • customerid
    • customername
    • address
    • city

  3. Employees

    • employeeid
    • firstname
    • lastname
    • employeerole

  4. Item

    • itemid
    • booktitle
    • authorid

  5. Orderinfo

    • id
    • itemid
    • customerid

  6. Supplier

    • supplierid
    • suppliername
    • city

SQL Queries

Table of Contents

  1. INNER JOIN
  2. LEFT JOIN
  3. RIGHT JOIN
  4. SELF JOIN and CROSS JOIN
  5. UNION and UNION ALL

About

This project highlights my ability to write complex SQL queries for retrieving and manipulating data from databases. The queries demonstrate my expertise in database management, data analysis, and the use of SQL for various cybersecurity tasks.

Topics

sql sql-query

Resources

Readme
Activity

Stars

0 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published