DBMS SQL & NoSQL CRUD

Prerequisite: Basic computer knowledge

What you'll learn

• Understand relational and NoSQL database concepts
• Design simple databases and relationships
• Perform CRUD operations using SQL
• Work with MongoDB collections and documents
• Build database-driven applications
• Use professional database management tools

This course includes:

• 1 Final Database Project
• 12–16 Hours Live Classes
• Online / Onsite (Physical)
• Practice Databases & Exercises
• CRUD Activities & Assignments
• Certificate of Completion

Course Content

Relational Database Fundamentals

• Introduction to databases
• Understanding:

• Tables
• Rows
• Columns
• Records
  • Relational database concepts
  • Database normalization basics
  • Primary keys and unique identifiers
  • Foreign keys and table relationships

SQL Basics & CRUD Operations

• SQL syntax fundamentals
• Creating and managing tables
• CRUD operations:

• SELECT
• INSERT
• UPDATE
• DELETE
  • Filtering data using:
• WHERE
• ORDER BY
• LIMIT
  • Working with conditions and sorting

Table Relationships & Joins

• One-to-one relationships
• One-to-many relationships
• Many-to-many relationships
• SQL JOIN operations:

• INNER JOIN
• LEFT JOIN
  • Understanding relational data structures

Introduction to NoSQL (MongoDB)

• What is NoSQL?
• Relational vs document databases
• MongoDB concepts:

• Collections
• Documents
• BSON
  • Basic MongoDB CRUD operations:
• insertOne()
• find()
• updateOne()
• deleteOne()

Using:
• MongoDB Compass

Real-World CRUD Project

• Designing a simple database project:

• Student Management System
• Product Inventory
• Task Manager
  • Connecting frontend forms to database logic
  • Managing records efficiently

Database Tools & Environment

• Using:

• MySQL Workbench
• MongoDB Compass
  • Database import/export basics
  • Backup and restore fundamentals

Final Project

Project: Database CRUD Management System

Features:

• Relational database structure
• CRUD functionality
• SQL queries and relationships
• MongoDB document operations
• Database management interface

Requirements

• No prior database experience needed
• Laptop/PC recommended

Description

This course introduces students to database management using SQL and NoSQL technologies. Students will learn relational database concepts, CRUD operations, MongoDB fundamentals, and real-world database workflows used in software and web development.By the end of this program, learners will be able to design, manage, and interact with databases professionally.

Why Choose This Course?

• Beginner-friendly database learning path
• Covers both SQL and NoSQL fundamentals
• Practical CRUD-focused approach
• Real-world database project experience

Activities During Class

• Writing SQL queries
• Creating database tables
• Building relationships between tables
• Performing MongoDB operations
• Developing CRUD applications

Who Is This Course For?

• Beginners in programming and databases
• Web and software development students
• Aspiring backend developers
• IT and computer science learners

Course Highlights

• Relational Database Design
• SQL CRUD Operations
• Table Relationships & Joins
• MongoDB Fundamentals
• Real-World Database Projects
• Database Management Tools