Databases

MongoDB Training Course Overview

This comprehensive MongoDB training course is designed for students learning NoSQL databases from scratch. The course materials are organized into clear, progressive modules.

MongoDB Quick Reference Guide

A quick reference for common MongoDB operations in both mongosh and Python.

NoSQL Database Training: MongoDB from Scratch

NoSQL stands for "Not Only SQL" or "NonSQL". It refers to a broad class of database management systems that differ from traditional relational database management systems RDBMS in several key ways:

MongoDB Training Materials Setup Guide

This guide will help you set up your environment to follow along with the MongoDB training materials.

MongoDB Training — Detailed Instructor & Student Materials

This file expands the course overview into full, readytoteach training materials: daily lesson plans, lecture notes, demos, labs with stepbystep exercises and solutions, quizzes, project briefs, and assessment rubrics. U

MongoDB Shell mongosh Complete CRUD Operations Guide

This guide provides comprehensive examples of all CRUD Create, Read, Update, Delete operations in MongoDB using the MongoDB Shell mongosh.

Python MongoDB Integration Complete Guide

This directory contains comprehensive Python examples for working with MongoDB using PyMongo.

SQL Learning Course Complete Summary

This comprehensive SQL learning course teaches relational database concepts using MySQL and Python SQLAlchemy, progressing from beginner to advanced levels.

Getting Started with SQL Learning Course

This guide will help you set up your environment and start learning SQL with MySQL and Python SQLAlchemy.

Relational Database Learning Course

This comprehensive course teaches relational database concepts using MySQL and Python SQLAlchemy. Students will learn SQL from beginner to advanced levels, with practical examples and handson exercises.

Lesson 1: Database Setup and Connection

A relational database is a type of database that stores and provides access to data points that are related to one another. It uses tables to organize data into rows and columns, where: Tables represent entities like cus

SQL Updated 2026-03-30

Lesson 2: Creating Databases and Tables

Create database with character set specification CREATE DATABASE schoolmanagement CHARACTER SET utf8mb4 COLLATE utf8mb4unicodeci;

Lesson 3: Data Types and Constraints

SMALLINT: Small integers CREATE TABLE examplesmallint id SMALLINT, 32,768 to 32,767 unsignedid SMALLINT UNSIGNED 0 to 65,535 ;

Lesson 4: Inserting Data

Insert into students table INSERT INTO students firstname, lastname, email, enrollmentdate VALUES 'John', 'Doe', 'john.doe@email.com', '20240115';

SQL Updated 2026-05-25

Lesson 5: Querying Data SELECT

Select all columns from multiple tables SELECT FROM students, courses;

SQL Updated 2026-05-16

Lesson 6: Updating and Deleting Data

Learn how to update existing data in tables Understand how to delete records from tables Practice safe data modification techniques Learn about transaction management

Lesson 7: Joins and Relationships

1. OnetoOne: Each record in Table A relates to exactly one record in Table B 2. OnetoMany: Each record in Table A can relate to many records in Table B 3. ManytoMany: Records in Table A can relate to many records in Tabl

Lesson 8: Database Design Principles and Normalization

Database design is the process of creating a detailed data model of a database. It involves: Analyzing requirements and understanding business rules Identifying entities and their relationships Designing tables with appr

Lesson 9: MySQL Database Functions with SQLAlchemy

Database functions are builtin operations that perform specific tasks on data. They can: Transform data format, convert, calculate Extract information dates, substrings, patterns Perform calculations mathematical operati

Lesson 10: Aggregation Functions

By the end of this lesson, you will be able to: Use basic aggregation functions COUNT, SUM, AVG, MIN, MAX Group data using GROUP BY clauses Filter grouped data with HAVING Understand the difference between WHERE and HAVI

Lesson 11: Stored Procedures and Functions

Stored procedures are precompiled SQL statements stored in the database that can be executed with a simple call. They offer several advantages:

Lesson 12: Views and Indexes

By the end of this lesson, you will be able to: Create and manage database views Understand different types of indexes Implement appropriate indexing strategies Use views for security and data abstraction Optimize query

Lesson 13: Stored Procedures and Functions

By the end of this lesson, you will be able to: Create and execute stored procedures Define userdefined functions Use parameters in procedures and functions Handle errors and exceptions Understand security implications O

Lesson 14: Triggers

By the end of this lesson, you will be able to: Create and manage database triggers Understand BEFORE and AFTER trigger types Implement INSERT, UPDATE, and DELETE triggers Use triggers for data validation and auditing Ha