/MySQL-Practice

This repo contains the code and notes that I have created while mastering SQL and MySQL for Web Development.

MySQL Practice

image

Table of contents

General Information

This repo outlines my journey to mastering SQL and MySQL.

Topics Covered

General Topics

  • Relationships ✔
  • Subqueries
  • Natural Joins
  • Cross Joins
  • Unions
  • Column Attributes
  • Inserting a Single Row
  • Inserting Multiple Rows
  • Inserting Hierarchical Rows
  • Creating a Copy of a Table
  • Updating a Single Row
  • Updating Multiple Rows
  • Using Subqueries in Updates
  • Deleting Rows
  • Restoring Course Databases
  • Aggregate Functions
  • Group By
  • Combined With Join
  • Alias Tables
  • Having vs Where