This repository contains practical SQL scripts for learning and demonstrating database operations. The examples focus on a student table and include key SQL concepts for beginners and professionals alike.
📋 Table of Contents
Introduction Features SQL Operations Covered Getting Started Usage
🔰 Introduction
The SQL scripts in this repository are designed to:
Demonstrate common database operations like table creation, data insertion, updates, and queries. Help users understand and practice SQL concepts with a hands-on approach.
🌟 Features
Realistic student table with attributes: student_id, student_name, Age, and place. Operations ranging from basic CRUD (Create, Read, Update, Delete) to advanced SQL clauses and table manipulations.
📌 SQL Operations Covered
This example covers:
Table Operations: Create, Copy, Alter, and Drop tables Data Manipulations: Insert, Update, and Delete records Querying Data: Using SELECT, WHERE, DISTINCT, ORDER BY, and LIMIT clauses Advanced Operations: Renaming and modifying columns Using TRUNCATE vs. DROP Random and Conditional Queries: Fetching random and specific records Using AS to rename columns in output