Welcome To
SQL PROJECTS PAGE

This page contains all projects that were done in SQL.

What is SQL and why it is important for data analysts?

SQL (Structured Query Language) is a Database Management language. It has been around since the 1970s and is still the most popular way to access data in Databases today. SQL provides a number of operations that enable users to read, manipulate, and alter data. SQL is widely used by engineers in software development, but it is also widely utilized by data analysts for a variety of reasons:

It's simple to grasp and learn from a semantic standpoint.
Analysts don't have to copy data into other programs because they can access enormous amounts of data immediately where it' kept.

1.Design and Query a Company Database

In this project, a company database was created. The database consists of five tables namely Employee Table, Company Branch Table, Client Table ,Works_With Table and Branch Supplier Table.

View Project

2.JOINS

In this project, SQL joins were used to combine data or rows from two or more tables based on a common field between them. We demostrated the power of INNER JOIN, LEFT JOIN,RIGHT JOIN and FULL JOIN.

View Project

3. UNION

In this project , we demostrate how Union can be used to combine multiple records or rows of different tables into one table.

View Project

4.Nested Queries

In this project we demostrate the power of nested queries in retriving information from multiple tables.

View Project

© Portfolio
Design: Khulekani Matsebula