foundations-and-queries.md - Acoder
esp32-coursework.mdpic-projects.mdcontrol-analysis.mdiot-labs.mddata-science-notebooks.mdsampling-and-pandas.mdml-pipeline.mdsearch-and-optimization.mdbasics-and-modules.mdcontrol-flow-and-loops.mdcpp-exercises.mdclassic-projects.mdspring-backend.mdfoundations-and-queries.mdjoins-and-analytics.mdt-sql-and-triggers.mdweb-fundamentals.mdandroid-kotlin.mdreact-native-apps.mdnetwork-defense.mdsecurity-principles.mdcloud-foundations.mdlists-and-stacks.mdtrees-and-search.md
foundations-and-queries.md

Guide

foundations-and-queries.md

Database I exercises covering DDL, DML, DQL, and relational query basics.

markdown

SQL Fundamentals

This topic collects Nicolas Pereira’s Database I work across schema definition, data manipulation, and querying.

Repository

Main Sections

  • DDL - Table creation and alteration
  • DML - Inserts and data manipulation
  • DQL - Query practice across client, city, and dependent datasets

Representative Queries

Technical Focus

  • SQL syntax fundamentals
  • CRUD-oriented exercises
  • Relational querying
  • First-step database coursework