Results for “aql”

Explains syntax differences for common SQL operations across PostgreSQL, MySQL, SQL Server, and Oracle, including auto-increment keys, string concatenation, date functions, pagination, booleans, JSON, case sensitivity, and recursive CTEs.

Write correct, efficient Kusto Query Language queries with coverage of syntax, joins, dynamic types, datetime pitfalls, regex, serialization, memory management, and advanced functions.

Optimize SQL queries, indexes, and database performance across MySQL, PostgreSQL, SQL Server, and Oracle with execution plan analysis and universal tuning techniques.

Execute KQL queries and manage Azure Data Explorer resources for fast, scalable big data analytics on log, telemetry, and time series data.

Manages AlloyDB for PostgreSQL clusters, instances, and backups using gcloud CLI commands.

Perform CRUD operations, queries, bulk operations, and container management on Azure Cosmos DB NoSQL API using the @azure/cosmos TypeScript/JavaScript SDK.

Compare identical tables across two SQL Server instances using Python with mssql-python and Apache Arrow, detecting missing rows, column mismatches, schema drift, and generating a reconciliation report.

Manage datasets, tables, and jobs in BigQuery. Run SQL queries, manage BigQuery resources, and perform basic data ingestion and analysis.

Manages and analyzes Azure SQL databases via Azure CLI, covering DTU/vCore performance, elastic pools, geo-replication, and health monitoring.

Generate optimized SQL queries from natural language descriptions across multiple database platforms including BigQuery, PostgreSQL, MySQL, and Snowflake. Reads database schemas from uploaded files or diagrams to produce accurate, production-ready queries.

Provides expert guidance on modern SQL, cloud-native databases, and query optimization, covering performance tuning, data modeling, and hybrid analytical systems.

Write and debug SOQL queries covering SELECT syntax, filters, sorting, pagination, relationship traversal, and aggregate functions.

Analiza datos en bases de datos relacionales con consultas SQL eficientes y legibles, incluyendo joins, window functions, CTEs y subqueries, para extraer insights directamente de la base de datos.

Write SOQL queries that group or filter records by date periods using the 13 SOQL date functions, with rules for WHERE vs GROUP BY placement, date-literal comparisons, and fiscal-year restrictions.

Analyze SQLite databases using the better-sqlite3 Node.js library, including querying, inserting, and iterating over rows.

Provides expert guidance on modern SQL, cloud-native databases, query optimization, performance tuning, and data modeling for OLTP/OLAP workloads.

Enforces SQL quality gates after every implementation: lint with SQLFluff, validate migrations with Flyway or Liquibase, and run database tests with pgTAP or equivalents.

Runs SQL queries and data conversions on CSV, Parquet, and JSON files using the DuckDB command-line interface, including schema inspection and output formatting.

Connect to PostgreSQL, MySQL, SQLite, and SQL Server databases using SQLAlchemy, Pandas, and DuckDB. Read and write tables, manage sessions, and handle connection strings securely.

Provides expert guidance on modern SQL, cloud-native databases, and query optimization, covering performance tuning, data modeling, and hybrid analytical systems.

Collects Chinese A-share stock data, fetching stock lists and daily, weekly, and monthly K-line history into a local SQLite database for quantitative analysis.