Optimizing MySQL: Database queries following Software design patterns
Well once in your software development career, you might end up optimizing and scaling up those initial SQL queries which you have written… Continue reading on Medium » Well once…
Optimizing MySQL: Database queries following Software Design Patterns
Well once in your software development career, you might end up optimizing and scaling up those initial SQL queries which you have written… Continue reading on Medium » Well once…
TSQL: find the highest paid employee per location and find min, max, and avg salary per location
Continue reading on Medium » Continue reading on Medium » Read More Sql on Medium #sql
Entity Framework Didn’t Load Related Entities Data
Overview Continue reading on Medium » OverviewContinue reading on Medium » Read More Sql on Medium #sql
BigQuery: COALESCE and STRUCT
I will briefly explain why COALESCE and STRUCT is very useful in BigQuery SQL and how it provides benefits in data handling scenarios. Continue reading on Medium » I will…
Resolving Data Chaos: A Step-by-Step Guide to Data Cleaning Using Excel and SQL
Tidy datasets are all alike, but every messy dataset is messy in its own way –Hadley Wickham Continue reading on Medium » Tidy datasets are all alike, but every messy…
Caso de Estudio Usando SQL
Empresa de licores va a lanzar campaña de marketing dirigida a aumentar ventas en el próximo año y necesita entender los datos historicos. Continue reading on Medium » Empresa de…
SQL Data Query Language
Continue reading on Medium » Continue reading on Medium » Read More Sql on Medium #sql
Sensitive Data Governance Design Patterns in DBSQL
Authors: Heeren Sharma, Solutions Architect @ Databricks Sebastian Kollmann, Solutions Architect @ Databricks Continue reading on DBSQL SME Engineering » Authors: Heeren Sharma, Solutions Architect @ Databricks Sebastian Kollmann, Solutions…
Understanding ETL (Extract, Transform, Load) Processes in Data Engineering
In the present time of digitalization, data has arisen as the cornerstone of navigation and development across businesses. Each snap… Continue reading on Medium » In the present time of…
Predicting Visitor Purchases with a Classification Model in BigQuery ML
Creating a classification model with an e-commerce dataset to forecast customer purchases. Continue reading on Medium » Creating a classification model with an e-commerce dataset to forecast customer purchases.Continue reading…
SQL Data Definition Language
Continue reading on Medium » Continue reading on Medium » Read More Sql on Medium #sql
How to Transition from a Data Analyst to a Data Engineer: A Comprehensive Guide
After graduating college with a computer science degree, the first role I landed was a data analyst-type role in the public policy space… Continue reading on Medium » After graduating…
WordPress under scrutiny for cyber security flaw.
A significant security flaw has been uncovered, putting over 1 million WordPress sites at risk of SQL injection. This vulnerability… Continue reading on Medium » A significant security flaw has…
Resume Project Challenge #9 : Analyse Promotions and Provide Tangible Insights to Sales Director
AtliQ Mart is a retail giant with over 50 supermarkets in the southern region of India. All their 50 stores ran a massive promotion during… Continue reading on Medium »…
Análise da Atividade Econômica do Estado do Rio de Janeiro e da influência da capital
Explorando dados da RAIS para analisar as principais atividades econômicas do estado e sua relação com a capital Continue reading on basedosdados » Explorando dados da RAIS para analisar as…
SQL : Formate Date
Sering kali dalam programming terutama dalam pengolahan database kita di sibukkan dengan format tanggal atau waktu yang selalu berubah-ubah seiring dengan kompleksitas system yang ada, berikut ini catatan saya…
SQL : Agar Table di MSSQL 2008 Bisa di Alter atau di Edit / Design Ulang
Rupa rupanya ada feature baru di MSSQL 2008, yaitu adanya table yang tidak bisa langsung di alter alias di edit, beberapa saya alami ketika mau merubah beberapa table, yang ternyata…
SQL: Query System Table
Barangkali ini query yang simple tetapi sangat sering dipakai oleh developer maupun Database Administrator(DBA), contohnya mencari nama kolom, mencari table, mencari user dan lain sebagainya. Contohnya : SELECT name FROM…
Menggunakan Fungsi Pivot di SQL
Ternyata tidak hanya excel saja yg bisa di di gunakan untuk melakukan pivot table yang biasanya untuk me summarize data. Tetapi future pivot ini baru ada di versi 2005 ke…