InArtificial CornerbyGiorgos MyrianthousChatGPT Prompts for SQLUseful prompts to speed up development and improve efficiency of SQL queriesJul 20, 20232Jul 20, 20232
InLevel Up CodingbyGiorgos MyrianthousHackerRank SQL Solution For Interviews ProblemApproaching and solving the ‘Interviews’ challenge on HackerRank with SQLMar 8, 2023Mar 8, 2023
InTDS ArchivebyGiorgos MyrianthousRANK() vs DENSE_RANK() vs ROW_NUMBER() in SQLUnderstanding the difference between these window functions in SQLMar 6, 2023Mar 6, 2023
InLevel Up CodingbyGiorgos MyrianthousHackerRank SQL Solution for Challenges ProblemDiscussing the approach for solving the “Challenges” problem on HackerRank with SQLFeb 20, 20231Feb 20, 20231
InLevel Up CodingbyGiorgos MyrianthousHackerRank SQL Solution For Contest Leaderboard ProblemApproaching and solving HackerRank’s Contest Leaderboard Problem with SQLFeb 21, 2023Feb 21, 2023
InTDS ArchivebyGiorgos MyrianthousStaging vs Intermediate vs Mart Models in dbtUnderstanding the purpose of staging, intermediate and mart models in the context of data build tool (dbt)Dec 2, 2022Dec 2, 2022
InTDS ArchivebyGiorgos MyrianthousWhat are CTEs in SQLUnderstanding Common Table Expression (CTE) in SQLNov 28, 20221Nov 28, 20221
InTDS ArchivebyGiorgos MyrianthousSQL Anti-Patterns for BigQueryBest practices and things to avoid when running SQL on Google Cloud BigQueryNov 22, 2022Nov 22, 2022
InTDS ArchivebyGiorgos MyrianthousHow to Structure Your dbt Projects and Data ModelsEnforcing meaningful structure to dbt data modelsNov 9, 2022Nov 9, 2022
InTDS ArchivebyGiorgos MyrianthousHow to Install dbt (data build tool)Installing data build tool for your specific data warehouseNov 2, 20222Nov 2, 20222
InTDS ArchivebyGiorgos MyrianthousA Visual Explanation of SQL JoinsUnderstanding SQL joins with Venn Diagrams and practical examplesOct 24, 20221Oct 24, 20221
InTDS ArchivebyGiorgos Myrianthous2 Rules To Follow When Using GROUP BY in SQLUnderstanding which columns to include in GROUP BY clause and how to include aggregations in WHERE clausesSep 27, 20222Sep 27, 20222
InTDS ArchivebyGiorgos MyrianthousDISTINCT is not a SQL FunctionHow the use of parentheses when using DISTINCT keyword in SQL could cause confusionSep 9, 20222Sep 9, 20222
InTDS ArchivebyGiorgos MyrianthousStandard vs Legacy SQL in BigQueryUnderstanding the difference between standard and legacy SQL in the context of Google Cloud BigQueryAug 30, 20221Aug 30, 20221
InTDS ArchivebyGiorgos MyrianthousLoad Data From Postgres to BigQuery With AirflowPostgreSQL to BigQuery Data Ingestion with Apache Airflow — a step-by-step guideJul 8, 20222Jul 8, 20222
InTDS ArchivebyGiorgos MyrianthousWhat are DDL and DML?Understanding the difference between DDL and DML in SQLJul 15, 20221Jul 15, 20221