🛢️ NoSQL: Building Databases in Practice

Not Only SQL

About No-SQL Repo

Developed during the 3rd semester of the Data Science and Humanistic Artificial Intelligence undergraduate program at PUC-SP (2025)

Under the guidance of Professor Doctor Daniel Gatti.

Online Tools

➢➣ Oracle SQL LIVE

➣➢ BRM Model Web

➣➢ Redis Database

➣➢ Kepler Geolocation

➣➢ Mermaid FlowChart and Diagrams

Dowloaded Tools

➣➢ PostgreSQL

➣➢ MongoDB

Books

➢ Get the Book Database Systems – Navathe, 6th Edition

➣ Get the Book Database System Concepts (5th ed.) - Abraham Silberschatz, Henry F. Korth, S. Sudarshan

📖 Overview

This project explores the fundamentals and practical applications of NoSQL (Not Only SQL) databases, showcasing the construction and management of databases using various database systems, including:

➢ MySQL - Certificate
➢ SQL Server - Certificate
➢ T-SQL - Certificate
➢ Redis MongoDB - Certificate
➢ SQL on Linux - Certificate
➢ Oracle - Certificate

Through this comprehensive guide, you will understand how to define, manipulate, and query data using SQL and NoSQL techniques, alongside practical examples.

Entity Relationship Conceptual Modeling

➢ WorKClass Example

🗄️ SQL Language Breakdown

The SQL language is divided into three main components:

1. Data Definition Language (DDL)
   • Defines database schema and structures.
   • Examples: CREATE TABLE, ALTER TABLE, DROP TABLE.

2. Data Manipulation Language (DML)
   • Manages data within schema objects.
   • Examples: INSERT, UPDATE, DELETE.

3. Data Query Language (DQL)
   • Retrieves data from databases.
   • Example: SELECT.

✍️ Practical Examples

📋 DDL – Data Definition Language

Select Commands using Oracle

select*from HR. COUNTRIES
select COUNTRY_NAME from HR.COUNTRIES 
select COUNTRY_ID from HR.COUNTRIES 
select REGION_ID from HR.COUNTRIES 
select*from hr.REGIONS

SELECT country_id, country_name, region_name
FROM HR.COUNTRIES, HR.REGIONS
Where hr.COUNTRIES.region_id = HR.regions.REGION_ID

Create Table

CREATE TABLE Person (
    ID INT PRIMARY KEY,
    Name VARCHAR(100) NOT NULL,
    Age INT,
    Email VARCHAR(150) UNIQUE
);

ALTER TABLE

ALTER TABLE Person ADD Telefone VARCHAR(15);

Drop Table

DROP TABLE Person;

🛠️ DML – Data Manipulation Language

Insert Data

INSERT INTO Person (ID, Name, Age, Email)
VALUES (1, 'Maria Silva', 30, '[email protected]');

Update Data

UPDATE Person
SET Age = 31
WHERE ID = 1;

🔍 DQL – Data Query Language

Select Data

SELECT Name, Email
FROM Person
WHERE Age > 25;

⚙️ Advanced SQL Concepts

🔑 Primary Key Example

CREATE TABLE Sale (
NumCliente INT NOT NULL IDENTITY(1,1),
CPF INT NOT NULL,
CONSTRAINT pkClient PRIMARY KEY (NumClient))

✅ Check Constraint Example

ALTER TABLE Person
ADD CONSTRAINT ckIdade CHECK (Age <= 100);

🔄 Identity Property (SQL Server)

CREATE TABLE Produtos (
    ProdutoID INT IDENTITY(1,1) PRIMARY KEY,
    NomeProduto VARCHAR(100) NOT NULL
);

🍃 NoSQL – MongoDB Example

📦 Creating a Collection and Inserting Documents

// Inserting a single document
db.usuarios.insertOne({
    name: "João Silva",
    age: 28,
    email: "[email protected]"
});

// Inserting multiple documents
db.usuarios.insertMany([
    { name: "Ana Souza", age: 24, email: "[email protected]" },
    { name: "Carlos Lima", age: 35, email: "[email protected]" }
]);

🔍 Querying Documents

// Find users older than 25
db.usuarios.find({ age: { $gt: 25 } });

// Find user by email
db.usuarios.findOne({ email: "[email protected]" });

⚡ Updating and Deleting Documents

// Update user age
db.usuarios.updateOne(
    { name: "João Silva" },
    { $set: { idade: 29 } }
);

// Delete user
db.usuarios.deleteOne({ name: "Carlos Lima" });

🙌 Acknowledgements

Special thanks to Professor Daniel Gatti for guidance throughout this project.

Feel Free to Reach Out:

💌 Email Me

🛸๋ My Contacts Hub

────────────── ⊹🔭๋ ──────────────

➣➢➤ Back to Top

Copyright 2025 Mindful-AI-Assistants. Code released under the MIT license.