SQL 101.4 Arrays, window functions, LAG, LEAD

preview_player
Показать описание
Hey there!

Unlock the power of arrays and window functions in SQL for data analysis. In this tutorial, you will learn how to work with arrays and perform complex data manipulations in SQL. Discover the basics of window functions, and how they can help you analyze your data effectively. This video is perfect for beginners and intermediate users who want to expand their SQL skills and tackle more complex data analysis challenges.

Hope you enjoy and good luck on your SQL journey!
  1. Anastasia K
  2. data analysis
  3. sql
  4. sql 101
  5. sql interview questions and answers
  6. basic sql
Рекомендации по теме
SQL 101.4 Arrays, 0:21:28

SQL 101.4 Arrays, window functions, LAG, LEAD

Data Analysis SQL 0:01:00

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

Advanced SQL Tutorial 0:03:44

Advanced SQL Tutorial | CTE (Common Table Expression)

SQL Trick Using 0:00:29

SQL Trick Using COALESCE function #sqltricks #sqltips

POSTGRESQL TUTORIAL #88 0:10:52

POSTGRESQL TUTORIAL #88 WINDOWS FUNCTION

SQL for Data 0:19:12

SQL for Data Analysis 101.3 Date and time manipulations, working with strings.

SQL Window Functions: 0:23:30

SQL Window Functions: LEAD, LAG, Running Total, DENSE RANK - #dataengineering #sql #dataanalytics

It’s literally perfect 0:00:13

It’s literally perfect 🫠 #coding #java #programmer #computer #python

SQL Interview Question: 0:00:33

SQL Interview Question: Retrieve the total sales amount for each product category | SQL Scenarios

Coding for 1 0:00:24

Coding for 1 Month Versus 1 Year #shorts #coding

What programming language 0:00:32

What programming language you should learn👩‍💻(based off your interests) #programming #technology...

SQL 14: NULL 0:08:18

SQL 14: NULL Functions in SQL || How to deal with NULL value for calculation in SQL

Comment yes for 0:00:22

Comment yes for more body language videos! #selfhelp #personaldevelopment #selfimprovement

Most Asked SQL 0:05:37

Most Asked SQL Problem in Data Analyst Interview Question | Data Analytics SQL Server Task

PostgreSQL in 100 0:02:37

PostgreSQL in 100 Seconds

SQL Course for 3:10:19

SQL Course for Beginners [Full Course]

Window Functions In 0:21:01

Window Functions In SQL 🚀 2024 | Most Asked SQL Question 😮 | RANK, DENSE_RANK ROW_NUMBER | Part-1...

VLOOKUP in Excel 0:05:43

VLOOKUP in Excel | Step-by-Step Tutorial for Beginners

Extract Minimum GPA 0:06:52

Extract Minimum GPA scored in each Department | SQL Interview Problem for Data Science

1st yr. Vs 0:00:20

1st yr. Vs Final yr. MBBS student 🔥🤯#shorts #neet

Mastering Inspect Element: 0:00:20

Mastering Inspect Element: Tips and Tricks for Web Development and Debugging

Amazon SQL Interview 0:10:27

Amazon SQL Interview Question || Data Analyst SQL Interview Question || Intermediate SQL

SQL : SQL: 0:01:32

SQL : SQL: Explode an array

How to make 0:00:34

How to make a Pivot Table in 3 Steps‼️ #excel

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

Such an insightful video, Anastasia and the rest of your SQL videos as well. I have been doing a lot of analysis work using SQL lately and it's definitely not my strongest suit but this was such a great refresher. These functions are basically what we need and use on a daily basis. Really appreaciate the time and effort you have invested. :)

dikshyakasaju
Автор

This is super helpful Anastasia! Thanks for preparing the tutorial and sharing your knowledge with us🌺💚

Kristina_Tsoy
Автор

Hi there! I recently found an open role in Spotify for a Trainee Program in a Machine Learning and Personalization project, however idk to apply or not since I've never had an approach to Scala or SQL, just worked with Python but not with data, only the basics. What would you recommend me? The application period ends on February 9th. 🥺

pauu_bequ
Автор

I read that ChatGPT writes really good SQL queries. Those skills will be of little value soon.

bralis
welcome to shbcf.ru