Use SQL to Reveal Customer Spending Trends
Analyzing Customer Behavior for Telecom Company Using SQL Continue reading on Medium » Analyzing Customer Behavior for Telecom Company Using SQLContinue reading on Medium » Read More Sql on Medium…
Transaction、ACID與隔離層級(Isolation Leve)
Transaction，大陸有人翻譯為交易或事務，但都同一個意思。 它是資料庫執行過程中的一個邏輯單位。比方說SELECT、INSERT、UPDATE，一個交易當中也可能包含多個行為，比方說查詢後更新。 Continue reading on Medium » Transaction，大陸有人翻譯為交易或事務，但都同一個意思。 它是資料庫執行過程中的一個邏輯單位。比方說SELECT、INSERT、UPDATE，一個交易當中也可能包含多個行為，比方說查詢後更新。Continue reading on Medium » Read More Sql on Medium #sql
How to Reset the MySQL Root Password on Kali Linux (6.6.15)
Hello Guys My name is Vivek Dhok , Security Researcher & Bug Bounty Hunter Continue reading on Medium » Hello Guys My name is Vivek Dhok , Security Researcher &…
Algorithm Performance
This question is from stratascratch.com Continue reading on Medium » This question is from stratascratch.comContinue reading on Medium » Read More Sql on Medium #sql
Distances Traveled
This is medium level question from stratascratch.com There is 2 table: lyft_rides_log, lyft_users Continue reading on Medium » This is medium level question from stratascratch.com There is 2 table: lyft_rides_log,…
Migração de um Workload rodando em um Data Center Corporativo para a AWS utilizando o serviço do…
Neste projeto, baseado em um cenário do mundo real, iremos atuar como Especialistas em Cloud na migração de workloads de um Data Center… Continue reading on Medium » Neste projeto,…
SQLite and JOINS
Recently I had a need to refresh my knowledge of joins, it was rustic ancient knowledge. Continue reading on Medium » Recently I had a need to refresh my knowledge…
DAX DATE AND TIME FUNCTION
Date and time functions are used to calculate the date and periods in the DateTime format. Many of the functions in DAX are similar to the… Continue reading on Medium…
The Hidden Duties of Data Engineers: Beyond Building Pipelines
The Unsung Duties of Data Engineers: Beyond Building Pipelines Continue reading on Medium » The Unsung Duties of Data Engineers: Beyond Building PipelinesContinue reading on Medium » Read More Sql…
MySQL / Veritabanı Güvenliği ve Savunma Algoritmaları
DDL (Data Definition Language) Continue reading on Medium » DDL (Data Definition Language)Continue reading on Medium » Read More MySQL on Medium #sql
5 SQL Queries with Bugs- Find and Fix it
Is it easy to write a sql from scratch or it is easy to debug a existing SQL ? Continue reading on Medium » Is it easy to write a…
Would a world with AI-powered database creation tools make learning SQL obsolete? Why or why not?
From Code Whisperer to Data Maestro: Why AI and SQL Will Duet, Not Duel Continue reading on Medium » From Code Whisperer to Data Maestro: Why AI and SQL Will…
Mastering SQL Window Functions and the OVER Clause: A Comprehensive Guide
In the world of SQL, the ability to perform complex calculations across a set of rows related to the current row can greatly enhance your… Continue reading on Medium »…
Portfolio : Salaries of Jobs in The Data Analyst
SQL (Structured Query Language) is a structured programming language designed to manipulate and access database management systems. SQL is… Continue reading on Medium » SQL (Structured Query Language) is a…
[Ace the Data Science Interview Day #4] Tesla SQL Interview Question
Interested for more brain teasers? Look here 👀 Continue reading on Medium » Interested for more brain teasers? Look here 👀Continue reading on Medium » Read More Sql on Medium…
Integrating Kafka Data Stream with a Data Lake: A Comprehensive Guide
Using Postgres, Debezium, Kafka, MinIO and Trino Continue reading on Dev Genius » Using Postgres, Debezium, Kafka, MinIO and TrinoContinue reading on Dev Genius » Read More Sql on Medium…
Understanding Table Formats in Data Lakes: A Comprehensive Guide
In today’s data-driven world, businesses generate vast amounts of data every day. Continue reading on Medium » In today’s data-driven world, businesses generate vast amounts of data every day.Continue reading…
What if I have a unused CTE in Snowflake
My Query had couple of CTE’s which are not used at all, and cleared after a long review. Continue reading on Medium » My Query had couple of CTE’s which…
Structured Query Language (SQL)
Revealing SQL: Strengthening Database Administration Continue reading on Medium » Revealing SQL: Strengthening Database AdministrationContinue reading on Medium » Read More Sql on Medium #sql
Why NULL is the Silent Killer in Your Code
Few problems are as ubiquitous and harmful in the field of software development as the NULL value. This harmless-looking placeholder might… Continue reading on Medium » Few problems are as…