Python & SQL Essentials for Data, AI/ML

Python & SQL for Data Engineers, ML Engineers & AI Engineers

Which are the top programming languages that comes to your mind when you think of Data, AI/ML. I think you know the answer.

1. Python - Python has come a long way from being a backbencher in the programming world to a topper in today's emerging Data and AI world. Python has lion's share of footprint in Data Engineering and AI/ML. Any AI or ML library that you can think of is from Python. Same is the case with Data Engineering also. Python has taken so much of centerstage that PySpark is the top focus for Spark workloads, so much so that Spark community is trying to make Spark run faster on PySpark than Scala.

2. SQL - SQL is the language that deals with everything that is data. Spark, which is the numero uno distributed data processing framework, uses SQL construct for batch and stream processing.

In this course, I will teach Python and SQL that is needed for you to be ready for Data and AI/ML workloads.

You will get to from Python basics like data types, functions to advanced topics like Memory Management, Multi-threading, Object Oriented Programming (as much needed for Data Engineering and AI/ML).

In SQL you will get to know CASE, COALESCE, CTE (Common Table Expression), MERGE, WINDOW functions etc. These are very essential to work on Data Engineering (Spark - both Batch & Streaming).

I will be adding Python NumPy and Pandas in future.