Skip to content

krSandip/dbms-coursework

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

10 Commits
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

πŸ“˜ DBMS Coursework – MySQL Practice

This repository contains hands-on SQL practice files covering core concepts of Database Management Systems (DBMS) using MySQL. The goal of this project is to learn by doing – to build a strong foundation in SQL through structured tutorials, assignments, and real-world examples.


πŸš€ Topics Covered

  • DDL – Data Definition Language
  • DML – Data Manipulation Language
  • DRL – Data Retrieval Language
  • Joins & Set Operations
  • advanced SQL
  • Triggers
  • Stored Procedures
  • Views
  • Error Handling & Transactions
  • Window Functions (Ranking)

πŸ› οΈ Technologies Used

  • MySQL – Relational Database Management System
  • SQL – Querying and managing relational data
  • MySQL Workbench – Database design and query execution
  • VS Code / Any Text Editor – Writing and editing SQL scripts
  • Git & GitHub – Version control and project hosting

πŸ“œ Certification

Completed DBMS & SQL Certification Course from Intellipaat πŸŽ“

lecture39 quize5 quize6

Focused on:

  • Relational Database Design
  • SQL Queries & Optimization
  • Joins, Views, Stored Procedures
  • Triggers, Transactions & Error Handling
  • Real-world database problem solving

Certificate : https://intellipaat.com/academy/certificate-link/?Yz02MTkmdT0yNjMyNDkmZXh0PTE=

certificate

πŸ“– Resources


πŸ“Œ Author

About

πŸ’Ύ Hands-on SQL practice learning using MySQL & SQL Server from Intellipaat.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages