Skip to content

Repository files navigation

My Learning in SQL

This repository contains my SQL practice notes and example scripts, focused on Data Definition Language (DDL) basics.

Topics covered

  • Creating and dropping databases
  • Creating tables
  • Table cleanup and removal (TRUNCATE, DROP TABLE)
  • Table alterations (ADD, DROP, MODIFY columns)
  • Common SQL constraints:
    • NOT NULL
    • UNIQUE
    • PRIMARY KEY
    • AUTO_INCREMENT
    • CHECK
    • DEFAULT
    • FOREIGN KEY

Repository structure

  • /Data Defination Language (DDL)/Create And Drop Database in SQL.sql
  • /Data Defination Language (DDL)/Table Command For DDL.sql
  • /Data Defination Language (DDL)/ALTER use in SQL.sql
  • /Data Defination Language (DDL)/Constraints For SQL.sql

Purpose

The goal of this repo is to track my SQL learning journey with beginner-friendly examples that can be quickly referenced and practiced.

About

End-to-end SQL mastery for Data Analytics: from database setup and multi-table joins to window functions and extracting business insights from messy datasets.

Topics

Resources

Stars

3 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors