MOC: Database Queries

Executable query reference across three databases — SQL Server (T-SQL), BigQuery (GoogleSQL), and Firestore (NoSQL). Each notebook preserves cell outputs so you see both the query and its result.

mindmap
  ((SQL Server))
    (fundamentals)
    (advanced patterns)
    (engineering)

SQL Server

domain-sql-server

T-SQL query reference across fundamentals, advanced patterns, and engineering — from schema exploration through partitioning strategies.

mindmap
  ((BigQuery))
    (fundamentals)
    (advanced patterns)
    (engineering)

BigQuery

domain-bigquery

GoogleSQL query reference across fundamentals, advanced patterns, and engineering — from schema exploration through partitioning strategies.

mindmap
  ((Firestore))
    (document CRUD)
    (queries, filters)
    (transactions)

Firestore

domain-firestore

NoSQL document database queries in Python and C# — CRUD, filtering, subcollections, batch operations, and collection group queries.

Database Queries Cross-References

  • SQL Server — Administration, performance, and pipeline patterns beyond queries
  • GCP — BigQuery service configuration and data loading
  • Programming Languages — Python and C# database access notebooks