Skip to content

About

This repo encompasses a collection of SQL scripts and queries designed to demonstrate various database management concepts and operations.

Resources

Stars

1 star

Watchers

1 watching

Forks

Latest commit

 

History

44 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 

Repository files navigation

Database Management System

Welcome to the Database Management System repository! This project encompasses a collection of SQL scripts and queries designed to demonstrate various database management concepts and operations.


📂 Repository Structure

The repository is organized into the following directories:

  • MySQL/: Contains SQL scripts and queries tailored for MySQL databases.
  • SQL Server/: Includes SQL scripts and queries for SQL Server databases.

🛠️ Technologies Used

  • MySQL: A relational database management system.
  • SQL Server: Microsoft's relational database management system.

📄 Sample Scripts

MySQL

  • 1_DDL.sql: Defines database schema and tables.
  • 2_Trigger_available.sql: Implements triggers for availability checks.
  • 3_Trigger_totalprice.sql: Calculates total price using triggers.
  • 5_DML.sql: Performs data manipulation operations.
  • 6_Proc_VAT.sql: Defines stored procedures for VAT calculations.
  • 7_Func_P_users.sql: Implements functions for user management.
  • 8_Array_Cursor.sql: Demonstrates array cursors.
  • 9_Explicit_Cursor.sql: Shows explicit cursor usage.
  • 10_query.sql: General SQL queries.
  • 11_for_loop.sql: Implements loops in SQL.
  • 12_file_read.sql: Reads data from files.
  • 13_file_write.sql: Writes data to files.

SQL Server

  • 1_DDL.sql: Defines database schema and tables.
  • 2_Trigger_available.sql: Implements triggers for availability checks.
  • 3_Trigger_totalprice.sql: Calculates total price using triggers.
  • 5_DML.sql: Performs data manipulation operations.
  • 6_Proc_VAT.sql: Defines stored procedures for VAT calculations.
  • 7_Func_P_users.sql: Implements functions for user management.
  • 8_Array_Cursor.sql: Demonstrates array cursors.
  • 9_Explicit_Cursor.sql: Shows explicit cursor usage.
  • 10_query.sql: General SQL queries.
  • 11_for_loop.sql: Implements loops in SQL.
  • 12_file_read.sql: Reads data from files.
  • 13_file_write.sql: Writes data to files.

About

This repo encompasses a collection of SQL scripts and queries designed to demonstrate various database management concepts and operations.

Resources

Stars

1 star

Watchers

1 watching

Forks

Releases

Packages

Contributors

Languages