SQL for advanced
In this course we will dive deeper into how to run complicated queries such as sequential based queries, functions and more.
Syllabus
4 chapters13 lessonsIntrodcution
2 lessons- 01Introduction
- 02Simplify queries, WITH keyword
Window Functions part 1
6 lessons- 01ROW_NUMBER function
- 02ORDER BY criterion
- 03PARTITION BY criterion
- 04LEAD & LAG functions
- 05Recap challenge #1
- 06Recap challenge #2
Window Functions part 2
4 lessons- 01RANK & DENSE_RANK functions
- 02NTILE function
- 03Aggregation functions
- 04ROWS & RANGE criterion
Summary
1 lesson- 01Final challenge #1
More like this
Pandas Analytics
In this course you will learn how to handle tables in python using pandas
Certificate on completion
- 19
Numpy Fundamentals
Learn to master powerful numerical computations in Python for data science with this concise, hands-on course.
- 18
- 34
Binary Tree - Data Structures Series #3
In this course, you will learn about the Binary Tree data structure, create a Binary Tree from zero using your preferred language, and practice coding challenges with it!
- 13
- 5
- 1
Recursion Challenges - Master The Recursive Thinking
Recursion is an important concept in computer science and a very powerful tool in writing algorithms. In this course, you will use recursion to solve challenges from beginner to advanced. In the end, you will ace this topic.
Certificate on completion
- 15
- 15
Queue - Data Structures Series #2
In this course, you will learn about the Queue data structure, create a Queue from zero using your preferred language, and practice coding challenges with it!
- 12
- 5
- 1
Frequently asked questions
How many lessons does SQL for advanced have?
What does SQL for advanced cover?
Is SQL for advanced free?
