Intoduction

PostgreSQL is the open-source relational database software that runs on the Linux platform and functions with objects as a relational component in the database management system. It uses Structured Query Language (SQL) for accessing the data in the tables of the database, and hence it is also called Postgres. Some of this database’s prominent features are that it is highly robust and reliable, the recovering process is effortless, and maintenance costs less cost and manual efforts. It is developed and maintained by the PostgreSQL Global Development Group, which is a group of PostgreSQL developers.

This Repository Contain All the Required Files related to SQL like Cheat-sheet,SQL Questions,Theory and Resources.

Aims

The main Aim of this Repo. is to fill the gap between Resource and Good Resource to Practice PostgreSQL .

Dataset

In this repo i am using the data which in the format of dump file , .tar or .sql for which is available on click here

Requirements

1. Basic Knowledge Of SQL
   
2. PostgreSQL Tools like pgadmin4 or Dbeaver
   
3. patience and Practice

Table Of Content

1. Theory

All the theory,SQL Questions and solutions .

2. Resource

For the resource you can follow the link which contain all the resource in .pdf file which is based on oracle as well as postgresSQL Database.

3. Restore Files (SQL Data Dump File)

Restore the dump,.tar,.sql file according to your need.

4. Assignment

These are the Questions Which i got during my training ,this folder contain.

i. Questions

ii. Solutions

5. SQL Basic Practice

It contain Some of the Basic PostgresSQL or any other RDBMS Practice .

6. Important SQL Concept

In this section it contains some of the advance concept of SQL .

    i.   Window Function
    ii.  Sequence 
    iii. Trigger
    iv.  Views
    v.   Postgres Unique Features
    vi.  Partition
    vii. Function / Procedure

7. SQl Practice Form W3resource

This Section Contain all the Questions and Solutions from w3resource .

A. SQL Exercise

    i.SQL Exercises, Practice, Solution
            a. SQL Retrieve data from tables [33 Exercises]
            b. SQL Boolean and Relational operators [12 Exercises]
            c. SQL Wildcard and Special operators [22 Exercises]
            d. SQL Aggregate Functions [25 Exercises]
            e. SQL Formatting query output [10 Exercises]
            f. SQL Quering on Multiple Tables [8 Exercises]
            g. FILTERING and SORTING on HR Database [38 Exercises]
    ii. SQL JOINS
            a. SQL JOINS [29 Exercises]
    iii. SQL SUBQUERIES
            a. SQL SUBQUERIES [39 Exercises]
    iv. SQL Union
    v.  SQL View
    vi. SQL User Account Management [16 Exercise]
    vii. Movie Database
            a. BASIC queries on movie Database [10 Exercises]
            b. SUBQUERIES on movie Database [16 Exercises]
            c. JOINS on movie Database [24 Exercises]
    viii. Soccer Database
            a. BASIC queries on soccer Database [29 Exercises]
            b. SUBQUERIES on soccer Database [33 Exercises]
            c. JOINS queries on soccer Database [61 Exercises]
    ix.   Hospital Database
            a. BASIC, SUBQUERIES, and JOINS [39 Exercises]
    x.    Employee Database
            a. BASIC queries on employee Database [115 Exercises]
            b. SUBQUERIES on employee Database [77 Exercises]

B. PostgreSQL Exercises

    i.   PostgreSQL Create Table statement [19 Exercises]
    ii.  PostgreSQL Alter Table statement [13 Exercises]
    iii. PostgreSQL Update Table statement [8 Exercises]
    iv.  PostgreSQL Insert Into statement [13 Exercises]
    v.   PostgreSQL Basic SELECT statement [19 Exercises]
    vi.  PostgreSQL Restricting and Sorting Data [11 Exercises with Solutions] 
    vii. PostgreSQL Aggregate Functions and Group by [14 Exercises with Solutions]
    ix.  PostgreSQL String Functions [14 Exercises with Solution]
    x.   PostgreSQL JOINS [13 Exercises with Solution]
    xi.  PostgreSQL Subqueries [21 Exercises with Solution ]

8. SQL Challange

For this i pick the questions from w3SQLchallange which contain 40+ questions .

Feedback

If you have any feedback, please reach out to me at cu.18bcs6728@gmail.com