Dual Learn | SQL & Python Part #1 | Fundamental Actions

preview_player
Показать описание
Learning these two languages is complementary. It will help you quickly add multiple data analysis and data science skills to your toolkit in the most efficient way possible.

You can find the dataset here:

A great way to practice for any FANG practical or other Python/SQL interviews is to answer interview questions. Don't hesitate to dive into the mini-case studies and questions and create your own answers. Learn by doing!
______________________________________________________________________
______________________________________________________________________

You will learn in SQL :
Selecting data 3:08
Filtering (WHERE ) 4:32
Grouping 5:46
Creating conditional columns (CASE) 9:10
Common Table Expression( Temp Table) 10:26
Top Results 14:10
Unpivot 17:13
Merging 20:30
Subquery 24:02

28:28 Python version starts.

#python
#sql
#dataanalysis
  1. Absent Data
  2. advanced sql tutorial
  3. data analysis course
  4. data analysis tutorial
  5. data analysis tutorial for beginners
  6. data analysis using numpy
Рекомендации по теме
Dual Learn | 0:54:49

Dual Learn | SQL & Python Part #1 | Fundamental Actions

Dual Learn | 0:15:00

Dual Learn | SQL & Python Part #2 | Intermediate

6 SQL Joins 0:09:47

6 SQL Joins you MUST know! (Animated + Practice)

Data Analysis SQL 0:01:00

Data Analysis SQL Interview Questions | Running SUM | Who Hit the Sales Target First

you need to 0:24:25

you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)

Hacking into the 0:00:16

Hacking into the Bank with SQL Map

Oracle SQL Developer 0:01:41

Oracle SQL Developer Tutorial For Beginners 87 Dual

SQL Query to 0:00:23

SQL Query to Calculate The Difference Between Two Dates? SQL Interview Questions And Answers #SQL

Learn PySpark on 0:18:07

Learn PySpark on Databricks l Compute Sales & Percentage of Sales using GroupBy and WithColumn

SQL Double Ampersand 0:05:38

SQL Double Ampersand Substitution | Oracle SQL fundamentals

Advanced SQL Tutorial 0:08:37

Advanced SQL Tutorial | Subqueries

Dual Table in 0:02:47

Dual Table in SQL and PLSQL

Learn 12 Basic 0:16:48

Learn 12 Basic SQL Concepts in 15 Minutes (project files included!)

SQL vs MySQL 0:00:57

SQL vs MySQL | 3 Key Differences #shorts

How to use 0:08:34

How to use Dual, Rownum & Operators in SQL | SQL Tutorial for Beginners in Hindi

HOW TO JOIN 0:04:05

HOW TO JOIN 3 OR MORE TABLES IN SQL | TWO WAYS

How to Learn 0:08:54

How to Learn SQL FAST with ChatGPT

SQL For Beginners 4:22:53

SQL For Beginners Tutorial | Learn SQL in 4.2 Hours | 2021

SQL DUAL - 0:05:23

SQL DUAL - 1

Oracle SQL Developer 0:00:58

Oracle SQL Developer Tutorial For Beginners 88 Dual Examples

81 Find second 0:00:18

81 Find second highest salary from employee table using SQL? #interviewquestions #javaprogramming

MySQL - The 0:17:17

MySQL - The Basics // Learn SQL in 23 Easy Steps

#SQL How to 0:01:00

#SQL How to Remove Duplicates Using Group By? #datascience #programming #coding #sqltutorial

SQL Join 3 0:04:06

SQL Join 3 Tables: How-To with Example

Комментарии
Автор

Yes I tried python queries first I got straight solution after reading about it, but not in case of sql which seems easy at first but not until you have practical exposure

zodiacoffshore
Автор

Love this! I'm in the process of learning both SQL and Python towards my career in Data Analytics. Do you reccomend learning a certain one first or trying to learn both at the same time?

hithereitisme
Автор

so happy i found this channel! i've moved on to the python portion. i downloaded jupyter notebook; where do i get the pandas function? thanks!

johndiba
Автор

Hello sir, I am currently working on a sales forecast project, I have used Holt Winters method in Jupiter notebook. I wanna know which is the best way to build a web app with actual data and predictions that I have. thank you!

hatemhamdi
Автор

I would like to know if we can do the Step of data clearing with only SQL. If we can do it with only SQL why we need python (it is just for machine learning right ?)

Bakura
Автор

Which language do you think is harder to learn?

absentdata