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…
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…
SQL: mencari record yang double di database
Bagi pengguna database atau programmer, kadang kita di pusingkan data2 yang double di database kita, Kalau datanya cuman 10 record sih tidak masalah, bagaimana kalau data anda mencapai ribuan, ratusan…
SQL Server 2008 Compression on SAP – how to cut your database size from 90Gb to 30Gb
SQL Server 2008 Compression on SAP – how to cut your database size from 90Gb to 30Gb, Gimana caranya ya? Mari kita simak disini http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/19140