Open in app

Sign In

Write

Sign In

Data Engineering Academy
Data Engineering Academy

429 Followers

Home

About

Pinned

SQL Fundamentals: Logical Query Processing

SQL is a declarative English-like language. This means you specify the result set you want returned and it’s up to the SQL query engine to figure out how best to retrieve the result set from the database. …

Sql Fundamentals

4 min read

SQL Fundamentals: Logical Query Processing
SQL Fundamentals: Logical Query Processing
Sql Fundamentals

4 min read


Pinned

Cloud Technology — Why you should upgrade your skills now!

Organizations are increasingly using cloud computing for new initiatives or to replace legacy systems. What this means is that the spending that previously went to building and maintaining traditional IT solutions is being diverted to the cloud. The growing preference for cloud first and cloud smart services means that cloud…

Cloud Computing

3 min read

Why you should upgrade your cloud game!
Why you should upgrade your cloud game!
Cloud Computing

3 min read


Mar 13, 2021

5 SQL queries every Data Engineer & Scientist should know!

Over the years, I’ve worked on dozens of data engineering projects and these 5 queries have queries have gotten me out of few jams! Hope you find them useful 1. Using the APPLY Operator Ever find yourself trying to find the last transaction, a set of customers made? Struggled with trying to use combinations of…

Top 5 Sql

6 min read

5 SQL queries every Data Engineer & Scientist should know!
5 SQL queries every Data Engineer & Scientist should know!
Top 5 Sql

6 min read


Dec 29, 2020

How to Query PostgreSQL with Athena

Amazon Athena makes it easy to analyze semi-structured and non-structured data like json, csv & xml directly in Amazon S3 using SQL. However, it also allows you to easily query a number of relational databases hosted in AWS such as mySQL and PostgreSQL. …

AWS

5 min read

How to Query PostgreSQL with Athena
How to Query PostgreSQL with Athena
AWS

5 min read


Oct 17, 2020

Installing SSDT

SQL Server data tools (SSDT) for those that don’t know is an IDE for building SQL server content (Relational DBs, SSIS, SSRS or SSAS projects and packages). It’s gone by a few different names over the years (and versions) but broadly speaking, no matter the name, they all have the…

Bids

3 min read

Installing SSDT
Installing SSDT
Bids

3 min read

Data Engineering Academy

Data Engineering Academy

429 Followers
Following
  • Danny Teok

    Danny Teok

  • Divyesh Bhatt

    Divyesh Bhatt

  • Soumak Das

    Soumak Das

  • Mayur_Surani

    Mayur_Surani

  • Andrew Notohamiprodjo

    Andrew Notohamiprodjo

See all (232)

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech

Teams