Advanced SQL
Take your SQL skills to the next level using the functions and practices used by expert analysts. Gain hands-on to master the SQL language, write efficient and performant code, and contribute to a world-class architecture.
About the Advanced SQL Course
Through our course, you'll learn the advanced SQL functions such as window functions, CTE's, temp tables, statistical summaries, performance, and more! Our on-demand Advanced SQL course is the most comprehensive on the market. Unlike competitors who offer a bunch of slides, our course provides live-coding examples to ensure that you gain a strong understanding of the subject matter. With approximately 30 in-depth lessons, you'll be able to learn at your own pace through self-paced video content.
Skill Level
Advanced
Video Length
2 hrs
Pre-requisites
SQL for Beginners
Certificate of Completion
Advanced SQL: Course Content
01. Course Overview
- 1.01: Course Introduction
- 1.02: About Your Instructor
02. Course Learning Content
- 2.01: Database Setup
- 2.02: Common Table Expressions (CTEs)
- 2.03: Data Params
- 2.04: Aggregate Window Functions
- 2.05: Row Number
- 2.06: Lead & Lag
- 2.07: Dense Rank
- 2.08: Percent Rank
- 2.09: Quartiles
- 2.10: Median / Percentiles
- 2.11: Stastical Summary
- 2.12: Advanced Window Functions
- 2.13: Date Functions
- 2.14: Split Part
- 2.15: Length and Trim
- 2.16: Regular Expressions
- 2.17: Intersect
- 2.18: Update from Select
- 2.19: Insert from Select
- 2.20: Views
- 2.21: Understanding Performance
- 2.22: Indexes
- 2.23: Partitions
- 2.24: Auto Increment Primary Key
- 2.25: Constraints
- 2.26: Functions
- 2.27: Stored Procedures
03. Course Wrap-up
- 4.01: Course Wrap-up
"I feel like I found a goldmine!"
"I remember my tutor trying to teach me C++. Nightmare. Brandon explaining SQL. Crystal clear."
Your Instructor:
Brandon Southern
Sr. Leader - Head of Analytics: US Prime & North America Stores Marketing at Amazon
Meet THE Analytics Expert - Brandon Southern (Sr. Leader at Amazon). Brandon is an expert data analytics and engineering, with over 20 years of experience in software engineering, quality assurance engineering, software release management, data engineering, and analytics. With more than 12 years of leadership experience across these domains, he has interviewed, hired, coached, and elevated professionals like you!
As a Senior Leader of Business Intelligence at Amazon, he leads business analysts and business intelligence engineers. He has a passion for helping others grow and developing world-class analytics solutions and teams, which led him to create Analytics Mentor. In his courses and coaching sessions, he will teach you how to develop the necessary skills to become one of the best professionals in the field of data and analytics. He will also show you how to incorporate the best practices that he has developed after working across multiple engineering roles. With his coaching, you'll develop your resume, prepare for interviews, negotiate for higher salaries, and grow your career. By the end of it, you'll become a world-class analyst and engineer and learn the best practices and skills that almost no other analytics team (even in the top tech companies) are using today!
Frequently Asked Questions
Who is this course designed for?
This course is designed for anyone that is interested in becoming a data analyst, business analyst, data engineer, data scientist, or even a program manager. It's also a prerequisite for becoming a data scientist or data engineer. It's designed for individuals with little or no knowledge of SQL and databases. Also, if you're a little rusty or don't feel that you received a good foundational understanding, this is a recommended course to ensure that you can effectively understand more advanced concepts.
How long is this course and can I complete it at my own pace
This is a self-paced course so you can start and stop as needed and take the course all at once or in small increments. This course will take 2-10 hrs to complete.
Will I need any prior knowledge or experience in data analytics?
Yes, you should have completed SQL for Beginners. You should have basic computer skills such as installing software and a basic understanding of a spreadsheet such as Google Sheets or Microsoft Excel.
What kind of support is available to me while taking this course?
You can get support in the Free Discord group.
What certification will I receive upon completion of this course?
You will receive a certificate of completion for the Advanced SQL course from Analytics Mentor. This is an educational item that you can add to your resume to improve your chances of obtaining a job in the field of analytics.
