Cơ sở dữ liệu
Thiết kế cơ sở dữ liệu SQL và NoSQL, truy vấn, tối ưu hóa và bài tập thực hành.
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.
Đọc bài viết →MongoDB Quick Reference Guide
A quick reference for common MongoDB operations in both mongosh and Python.
Đọc bài viết →NoSQL Database Training: MongoDB from Scratch
NoSQL stands for "Not Only SQL" or "Non-SQL". It refers to a broad class of database management systems that differ from traditional relational database management systems (RDBMS) in several key ways
Đọc bài viết →MongoDB Training Materials - Setup Guide
This guide will help you set up your environment to follow along with the MongoDB training materials.
Đọc bài viết →MongoDB Training — Detailed Instructor & Student Materials
This file expands the course overview into full, ready-to-teach training materials: daily lesson plans, lecture notes, demos, labs with step-by-step exercises and solutions, quizzes, project briefs, and assessment rubric
Đọc bài viết →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).
Đọc bài viết →Python MongoDB Integration - Complete Guide
This directory contains comprehensive Python examples for working with MongoDB using PyMongo.
Đọc bài viết →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.
Đọc bài viết →Getting Started with SQL Learning Course
This guide will help you set up your environment and start learning SQL with MySQL and Python SQLAlchemy.
Đọc bài viết →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 hands-on exercises.
Đọc bài viết →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 cu
Đọc bài viết →Lesson 2: Creating Databases and Tables
Create a database and tables for a library management system with the following entities
Đọc bài viết →Lesson 3: Data Types and Constraints
Create tables for a blog system with the following requirements: Users table: id, username (unique), email (unique), password_hash, first_name, last_name, bio (TEXT), avatar_url, created_at, updated_at Categories table:
Đọc bài viết →Lesson 4: Inserting Data
Using the e-commerce database from Lesson 3, insert sample data: Categories: Electronics, Clothing, Books, Home & Garden, Sports Products: At least 10 products across different categories Customers: At least 5 customers
Đọc bài viết →Lesson 5: Querying Data (SELECT)
Write queries to: Find all active students with GPA above 3.5 Find students whose last name starts with 'S' or 'D' Find students enrolled in 2023, sorted by GPA (highest first) Find the top 5 students by GPA Count studen
Đọc bài viết →Lesson 6: Updating and Deleting Data
Write UPDATE statements to: Change student ID 1's GPA to 3.8 Update all active students' status to 'graduated' if GPA >= 3.5 Set phone numbers to NULL for students with email '@test.com' Update course descriptions to inc
Đọc bài viết →Lesson 7: Joins and Relationships
Write queries to: Show all students with their enrolled courses Show all courses with their department names Find students who haven't enrolled in any courses Find courses with no enrollments
Đọc bài viết →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
Đọc bài viết →Lesson 9: MySQL Database Functions with SQLAlchemy
Database functions are built-in operations that perform specific tasks on data. They can: Transform data (format, convert, calculate) Extract information (dates, substrings, patterns) Perform calculations (mathematical o
Đọc bài viết →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 HA
Đọc bài viết →Lesson 13 Supplement: Stored Procedures Practice (Loops, Management, Worked Examples)
This file is the hands-on companion to Lesson 13: Stored Procedures and Functions. Lesson 13 explains the concepts; this supplement adds loop constructs, procedure management commands, longer worked examples and practice
Đọc bài viết →Lesson 11: Subqueries
By the end of this lesson, you will be able to: Explain what a subquery is and where one can appear (SELECT list, FROM, WHERE, HAVING) Write scalar, row, column and table subqueries Choose between IN, EXISTS, ANY/SOME an
Đọc bài viết →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
Đọc bài viết →Lesson 13: Stored Procedures and Functions
By the end of this lesson, you will be able to: Create and execute stored procedures Define user-defined functions Use parameters in procedures and functions Handle errors and exceptions Understand security implications
Đọc bài viết →