Results for “database-views”

Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.

Guides database design, implementation, optimization, migrations, data pipelines, and operations across SQL and NoSQL platforms.

Deploy privileged access management for database systems including Oracle, SQL Server, PostgreSQL, and MySQL, covering session proxy configuration, credential vaulting, query auditing, dynamic credential generation, and least-privilege database roles.

Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.

Administra bases de datos PostgreSQL, MySQL, Redis y SQLite: diseña esquemas, optimiza queries, configura migraciones, replicación y backups.

Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.

Use when running analytical SQL over Parquet/CSV/JSON without a warehouse, replacing pandas for data wrangling, joining S3 data in-place, building local data marts, or embedding OLAP into an app. Triggers: read_parquet/read_csv setup, partitioned dataset queries, hive partitioning, glob patterns for S3, COPY TO export, attach Postgres/MySQL, UDFs in Python/R, MotherDuck cloud sync, columnar performance vs row stores. NOT for OLTP workloads (concurrent writes), distributed analytics at petabyte scale (use Spark/Trino), or vector search (use pgvector/Lance).

Guides database design, implementation, optimization, migration, pipeline development, quality, and operations across SQL and NoSQL platforms.

Creates and manages Cloud SQL instances, databases, and users for MySQL, PostgreSQL, and SQL Server using gcloud CLI commands.

Implements database replication, failover, backups, connection pooling, and monitoring for production PostgreSQL, MySQL, and MongoDB systems.