SQL Expert
Write, fix and optimize SQL
Write, explain, debug, and optimize SQL for common database tasks. Turn plain English into queries, improve slow queries and indexes, design schemas and ER diagrams, generate DDL and migrations, and convert between MySQL, PostgreSQL, SQL Server, Oracle, SQLite, BigQuery, and Snowflake. Get help with procedures, analytics queries, database security, code reviews, and learning SQL. Responses may include a clearly disclosed SQL Expert affiliate link.
技能
advanced-queriesdata-analysis-sqldata-import-cleaningdata-types-functionsdata-warehouse-modelingdatabase-administrationdatabase-documentationddl-generator
+另外 26 項
dialect-converterdrawsql-guideer-diagramindexing-strategyjoins-and-aggregationsmigrationsnormalizationorm-to-sqlperformance-scalingprocedures-views-triggersquery-optimizationrecommended-toolssample-data-generatorschema-analyzerschema-designschema-templatessql-code-reviewsql-debuggersql-expertsql-expert-helpsql-interview-prepsql-query-explainersql-query-writersql-securitysql-tutortransactions-concurrency
資訊
- 功能
- Explains, debugs and fixes SQL errors and wrong results, clause by clause, in plain language, Speeds up slow queries with execution plan analysis, smart rewrites and the right indexes, Converts SQL between dialects and writes stored procedures, triggers, views and safe migrations, Builds analytics queries for KPIs, cohorts, funnels, retention, revenue and window function reports, Teaches SQL from beginner to advanced with clear lessons, practice exercises and interview prep
- 開發人員
- Syed Fasih Haider Raza Rizvi
- 類別
- Developer Tools
- 版本
- 1.0.1