Advanced SQL Tutorial | Lag and Lead Window Functions in SQL Server скачать в хорошем качестве

Advanced SQL Tutorial | Lag and Lead Window Functions in SQL Server

Advanced SQL Tutorial | Lag and Lead Window Functions in SQL Server Partner with us as a channel member to get access to exclusive perks:    / @valuedrivenanalytics   In this training video, we highlight the lag and lead windows functions available in SQL Server (and other SQL platforms), which allows a column to be created based on prior row and next row values. Toward the end, I show how duplicate rows can be handled with an advanced use case. If you'd like to learn more about SQL data manipulation, you can check out our intro to SQL training here, which covers selecting data from a data table, creating new columns, joining tables together, and aggregating and grouping data:    • SQL Tutorial for Beginners | Stock Market ...   Learn more about joins and unions in SQL here:    • Join and Union Tables in SQL and Pandas   Learn more about subqueries and CTEs in SQL here:    • Mastering Advanced SQL Techniques | Subque...   Learn more about the rank statement in SQL here:    • Intermediate SQL | Using Rank and Partitio...   Learn more about the having clause in SQL here:    • Advanced SQL Tutorial | Having Clause   Learn more about the coalesce function in SQL here:    • Coalesce Function in SQL Server: An Interm...   Learn more about date functions in SQL Server here:    • Intermediate SQL Tutorial | Date Functions...   ______________________________________________ CHAPTERS: 0:00 What are the lag and lead functions in SQL? 1:06 How to create a schema in SQL server? 1:15 How to create a table in SQL server? 1:35 How to manually insert rows into a table in SQL Server 1:45 How to view all rows and columns in a table in SQL Server 3:25 How to create a lag variable in SQL 4:18 What is a partition by statement in SQL? 4:55 What does an order by statement do in a lag function? 6:05 Why is value null in a lag column? 7:30 How to order by multiple variables in lag function 8:35 lag function doesn’t have to have a partition by statement 9:18 How to create a lag based on order in table 9:55 How to reference %%physloc%% to get the order of the rows in a table in sql server 11:03 How to get lag more than 1 period back 11:42 How to make a lag function act as a lead function in sql 12:26 How to create a lead variable in SQL 12:43 Why is value null in lead column 13:07 How to filter on a window function in SQL 14:15 How to format a subquery in SQL 14:38 How to avoid filtering out null values in a where clause 15:34 How to use multiple SQL techniques together 16:34 How to deduplicate in SQL with distinct 17:15 What is an inner query in SQL? 18:25 How to join a subquery back to the original table in SQL 19:45 How to join on multiple fields in SQL ______________________________________________ ADDITIONAL VIDEOS YOU MAY LIKE: Please subscribe to get updates on the latest analytics training videos available! Whether you’re looking for training on technical skills or soft skills, whether you’re an aspiring analyst or an analytics executive, we have the perfect analytics training video for you! Check out our free training videos at https://valuedrivenanalytics.com/comp... ______________________________________________ ABOUT VALUE DRIVEN ANALYTICS: Value Driven Analytics is your source of rigorous, affordable, and fast analytics consulting and transformation. If you need an interactive dashboard, analysis, data science model build, automated data process, analytics or leadership training, analytics team management, analytics transformation, or 1-hour analytics consultation (troubleshooting, project advice, career advice), give us a call at 1-877-VAL-DRVN (1-877-825-3786) or learn more about our services at https://valuedrivenanalytics.com/serv... Stay connected with us! LinkedIn:   / value-driven-analytics   Twitter:   / vda_consulting   Facebook:   / 61550273999898   If you need help troubleshooting code, project advice, or personalized career advice, consider booking a 1-hour analytics consultation with me. You'll be amazed by what we can accomplish in just 1 hour! https://valuedrivenanalytics.com/hour... If your organization would like customized and more advanced analytics training, you can read more about the Value Driven Analytics analytics & leadership trainings offered here: https://valuedrivenanalytics.com/anal... ______________________________________________ KEYWORDS: lead, lag, functions, window functions, window functions in sql, sql, windowed functions, lead function, lag function, sql lead, sql lag, lead sql, lag sql, lag function, lead function sql, sql server examples, partition by, order by, over, sql window function, sql window functions, window functions in sql, sql analytic function, sql analytic functions, analytic function, over clause, sql partition by, sql query tutorial, sql tutorial