Practice It: Advanced SQL

سرفصل های دوره

Are you looking to broaden your SQL abilities while gaining practical experience? Want to master advanced SQL querying techniques beyond the basics? In this course, data scientist and data career coach Kedeisha Bryan teaches advanced SQL concepts through walkthrough exercises and real-world applications. Kedeisha shows you how to think in SQL code and not just memorize syntax. Learn advanced topics such as window functions, CTEs, subqueries, date time manipulation, and more.

This course is integrated with GitHub Codespaces, an instant cloud developer environment that offers all the functionality of your favorite IDE without the need for any local machine setup. With GitHub Codespaces, you can get hands-on practice from any machine, at any time—all while using a tool that you’ll likely encounter in the workplace. Check out the “Using GitHub Codespaces with this course” video to learn how to get started.

01 - Introduction

01 - SQL querying techniques

02 - What you should know

03 - Using GitHub Codespaces with this course

02 - 1. Window Functions

01 - Anatomy of a Window Function

02 - Try it Ranking functions

03 - Check it Ranking functions

04 - Try it Aggregations

05 - Check it Aggregations

03 - 2. Subqueries

01 - Introduction to subqueries

02 - Try it Subquery with aggregations

03 - Check it Subquery with aggregations

04 - Try it Subquery with conditional logic

05 - Check it Subquery with conditional logic

04 - 3. Common Table Expressions

01 - Anatomy of a CTE

02 - Try it Implement CTE

03 - Check it Implement CTE

04 - Try it Build a query that implements CTE

05 - Check it Build a query that implements CTE

05 - 4. Date and Time Manipulation

01 - Introduction to datetime manipulation

02 - Try it Difference between dates

03 - Check it Difference between dates

04 - Try it Extracting the year and month

05 - Check it Extracting the year and month

06 - Conclusion

01 - Next steps

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LinkedIn Learning (Lynda)